samedi 18 avril 2015

Eight-Year Financial Projection

I am making a financial Projection plan, trying to solve a question from a book but can't figure how did the author get the values of sales for year 1 to year 8. I have attached the screen shot of my excel sheet, right now i have harcoded the values of year 1 sales to year 8 sales in order to complete the sheet. But dont know how did the user got these.


Formulas given are:




  1. Year 1 Sales = Units Sold in Prior Year * (Unit Cost / (1 − Margin))




  2. Year 2 Sales (cell C4) = Year 1 Sales * (1 + Annual Sales Growth) * (1 + Annual Price Increase)



  3. Same formula for rest of the years as in 2


enter image description here


enter image description here


Aucun commentaire:

Enregistrer un commentaire