Download Start Excel File: http://ift.tt/2EmtGR5
Download pdf Notes: http://ift.tt/2EXNyLl
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to use Excel Percentage Formulas to estimate next year Net Income Statement, create a Budgeted Forecast for Next Year.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:48) Formula 1: Rate = Part /Base: Expenses As a % of Revenue
3. (04:26) Formula 2: End = Begin*(1+ROC): This Year Revenue
4. (05:15) Formual3: Part = Rate * Base: Expenses As a % of This Year Rev
5. (06:47) Amazon Example all three formulas
6. (08:16) Summary
Next Video: 26 Excel & Business Math