How would you use what-if analysis tools to determine what Annual Sales Growth y

Question

How would you use what-if analysis tools to determine what Annual Sales Growth you would need to achieve in order to keep prices steady over the 8-year projection period and achieve a Net Income of 0 in Year 2?

Microsoft Excel 2013: Complete - Page 202, Lab 1 Concider this question 3. Excel sheet bellow. MUST use microsoft excell 2013 "What-if Tools only", Last sheet has answer just need to know how to use the what-if opperations.

http://pcc-shen-1098.weebly.com/uploads/2/3/4/0/23406512/lab_3-1_adaptive_solutions_online_eight-year_financial_projection.xlsx

Thanks

Explanation / Answer

Answer:

Net income is 0 in year 2

Assumptions Units Sold in Prior Year 242,847 Unit Cost $122.75 Annual Sales Growth 9.73% Annual Price Increase 0.00% Margin 29.90%

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.