Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Click on the following icon in order to copy its contents into a spreadsheet.) Year Earnings & FCF Forecast ($ millions) 0 1 2

image text in transcribed

(Click on the following icon in order to copy its contents into a spreadsheet.) Year Earnings & FCF Forecast ($ millions) 0 1 2 3 4 Sales 2 Growth versus Prior Year 433.0 468.0 516.0 547.0 574.3 Cost of Goods Sold 8.1% (313.6) 10.3% 6.0% 5.0% (345.7) (366.5) (384.8) Gross Profit 154.4 170.3 180.5 189.5 5 Selling, General, and Administrative (93.6) (103.2) (109.4) (114.9) Depreciation (7.0) (7.5) (9.0) (9.5) EBIT 53.8 59.6 62.1 65.2 8 Less: Income tax at 40% (21.5) (23.8) (24.8) (26.1) 9 Plus: Depreciation 7.0 7.5 9.0 9.5 10 Less: Capital Expenditures (7.7) (10.0) (9.9) (10.4) 11 Less: Increases in NWC (6.3) (8.6) (5.6) (4.9) 12 Free Cash Flow 25.3 24.6 30.8 33.3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Valuation Measuring and managing the values of companies

Authors: Mckinsey, Tim Koller, Marc Goedhart, David Wessel

5th edition

978-0470424650, 9780470889930, 470424656, 470889934, 978-047042470

More Books

Students also viewed these Finance questions