Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a simple Discounted Cash Flow (DCF) valuation model with the attached financial information. *Display the answer in a table and also attached a separate
Create a simple Discounted Cash Flow (DCF) valuation model with the attached financial information.
*Display the answer in a table and also attached a separate picture with just the formulas per cell.
(millions of USD, except per share figures) \begin{tabular}{|c|c|c|c|c|c|} \hline & Actual & Actual & Actual & Forecast & Forecast \\ \hline At Fiscal Year End & 2011 & 2012 & 2013 & 2014 & 2015 \\ \hline Store Growth & 4.0% & 7.7% & 8.1% & 6.9% & 7.4% \\ \hline Sales Growth & 12.2% & 15.7% & 10.4% & 9.9% & 10.7% \\ \hline EBITDA Margin & 8.5% & 9.0% & 9.5% & 9.3% & 9.4% \\ \hline Tax Rate & 38.1% & 38.4% & 38.8% & 39.0% & 39.0% \\ \hline Current Asset Turnover & 7.0 & 5.6 & 6.5 & 6.2 & 6.3 \\ \hline Current Liabilities Turnover & 10.5 & 10.9 & 10.7 & 10.5 & 10.5 \\ \hline Net PP\&E / Store & 6.4 & 6.5 & 6.7 & 6.6 & 6.7 \\ \hline Annual Dep. \& Amort. / Store & 1.00 & 0.93 & 0.94 & 0.94 & 0.94 \\ \hline Stores & 311 & 335 & 362 & 387 & 416 \\ \hline Sales & 10,108 & 11,699 & 12,917 & 14,196 & 15,715 \\ \hline EBITDA & 859 & 1,055 & 1,222 & 1,320 & 1,477 \\ \hline Dep. \& Amort. & 311 & 311 & 339 & 364 & 391 \\ \hline EBIT & 548 & 744 & 883 & 956 & 1,087 \\ \hline Taxes & 209 & 286 & 343 & 373 & 424 \\ \hline Net Income & 339 & 458 & 540 & 583 & 663 \\ \hline Shares Outstanding & 350 & 364 & 372 & 372 & 372 \\ \hline Earnings per Share & 0.97 & 1.26 & 1.45 & 1.57 & 1.78 \\ \hline Current Assets & 1,453 & 2,103 & 1,980 & 2,290 & 2,494 \\ \hline Current Liabilities & 880 & 977 & 1,088 & 1,226 & 1,356 \\ \hline Net Working Capital & 573 & 1,126 & 892 & 1,063 & 1,138 \\ \hline Net PP\&E & 1,997 & 2,193 & 2,428 & 2,554 & 2,785 \\ \hline Return on Capital & 13.2% & 13.8% & 16.3% & 16.1% & 16.9% \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started