Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/03FractionsDecimalsPercentages/ExcelBusinessMathVideo25Budgeting.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/03FractionsDecimalsPercentages/ExcelBusinessMathVideo25Budgeting.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
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