Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

*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

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

Entrepreneurial Finance Venture Capital Deal Structure And Valuation

Authors: Janet Kiholm Smith, Richard L. Smith

2nd Edition

1503603210, 978-1503603219

More Books

Students also viewed these Finance questions

Question

solve this please M/M/1 Queuing system

Answered: 1 week ago

Question

=+15. Did you create a campaign that would create buzz?

Answered: 1 week ago

Question

=+9. Did you answer the consumer's question Why buy?

Answered: 1 week ago