AutoSave O OFF A A @ ?v ... 2 MGMT332_Excel_Template_Final_Exam (2) Q Home Insert Draw Page Layout Formulas Data Review View . Tell me Share Comments A Cut Times New Roman 12 Wrap Text v General Normal Bad Good Neutral X v LG Copy Fill v Paste Format BIUV Merge & Center v $ % " Conditional Format Calculation Check Cell Explanatory T... Input Insert Delete Format Sort & Find & Analyze Formatting as Table Clear v Filter Selec Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No D23 Jx B C D E F G H I K L M N O P Q R S T U V W X Y Z BOAC Airline Supply Yrs. 1-6 Sales growth Cash Flows Costs: 2 3 4 5 Cost of Goods Sold (% of sales) Sales 103.0 Advert., Prom., & Selling Cost of Goods Sold General & Administrative Advert., Prom., & Selling Rates: General & Administrative Tax Net Income before Tax 10 Discount Taxes 1 Inflation Net Income after Tax 12 Results Cash flow adjustments: 13 PV of NCF (incl. TV) Working Capital 4 + Cash Capital Expenditures 15 - Debt Net Cash Flows TV Total Equity (MS) NCF (incl. terminal value) - # of shares outstanding (M) - Price/share ($) Growth rate Price/share ($) for: 3.0% 3.5% 4.0% 20 6.0% 7.0% Disc. Rate 8.0% 38 39 Prob. 1 Prob. 2 Prob. 3 Prob. 4 v. MAR 2021 + Ready 122%