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:
Year 1 Sales = Units Sold in Prior Year * (Unit Cost / (1 − Margin))
Year 2 Sales (cell C4) = Year 1 Sales * (1 + Annual Sales Growth) * (1 + Annual Price Increase)
- Same formula for rest of the years as in 2
Aucun commentaire:
Enregistrer un commentaire