Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show formulas for orange and yellow boxes Financial statement information Shareholders' equity EBITDA Long-term debt (in long-term liabilities) Other current assets Short-term debt Free

image text in transcribed

Please show formulas for orange and yellow boxes

Financial statement information Shareholders' equity EBITDA Long-term debt (in long-term liabilities) Other current assets Short-term debt Free cash flows to the firm Current portion of long-term debt Cash 2021A 128,502 465,853 963,627 40,496 172,779 453,750 50,911 94,926 2022E 155,305 505,416 890,425 38,419 148,550 436,107 0 106,959 2023E 173,373 458,214 1,017,234 43.604 170,013 (135,488) 24,459 127,623 2024E 199,351 661,780 1,070,311 47,416 150,283 615,197 0 129,636 2025E 214,610 528,961 1,092,872 53,693 175,800 (21,704) 14,339 160,475 2026E 253,167 677,592 1,264,284 66,066 224,407 708,737 18,625 154,427 2027E 311,300 590,076 1,359,485 67,497 189,438 250,216 16,556 183,117 2028E 263,483 737,183 1,159,936 62,856 231,078 711,206 16,307 155,516 1 2 2 3 4 Other information End of historical period Expected return of equity Expected return of debt WACC Number of shares of stock Exit EV/EBITDA multiple Terminal growth rate Valuation date 2/17/21 9.08% ?? 5.96% 202,654 14.31 1.26% 11/30/2021 Terminal value (as of end of forecast period) Estimated enterprise value of the firm as of end of historical period Estimated value of the firm's equity as of end of historical period Estimated share price as of end of historical period Estimated share price as of valuation date What is the sum of all the prices estimated from the various combinations of exit EV/EBITDA multiple and WACC noted in the instructions? How many of the prices estimated from the various combinations of exit EV/EBITDA multiple and WACC noted in the instructions are less than $48.88? Financial statement information Shareholders' equity EBITDA Long-term debt (in long-term liabilities) Other current assets Short-term debt Free cash flows to the firm Current portion of long-term debt Cash 2021A 128,502 465,853 963,627 40,496 172,779 453,750 50,911 94,926 2022E 155,305 505,416 890,425 38,419 148,550 436,107 0 106,959 2023E 173,373 458,214 1,017,234 43.604 170,013 (135,488) 24,459 127,623 2024E 199,351 661,780 1,070,311 47,416 150,283 615,197 0 129,636 2025E 214,610 528,961 1,092,872 53,693 175,800 (21,704) 14,339 160,475 2026E 253,167 677,592 1,264,284 66,066 224,407 708,737 18,625 154,427 2027E 311,300 590,076 1,359,485 67,497 189,438 250,216 16,556 183,117 2028E 263,483 737,183 1,159,936 62,856 231,078 711,206 16,307 155,516 1 2 2 3 4 Other information End of historical period Expected return of equity Expected return of debt WACC Number of shares of stock Exit EV/EBITDA multiple Terminal growth rate Valuation date 2/17/21 9.08% ?? 5.96% 202,654 14.31 1.26% 11/30/2021 Terminal value (as of end of forecast period) Estimated enterprise value of the firm as of end of historical period Estimated value of the firm's equity as of end of historical period Estimated share price as of end of historical period Estimated share price as of valuation date What is the sum of all the prices estimated from the various combinations of exit EV/EBITDA multiple and WACC noted in the instructions? How many of the prices estimated from the various combinations of exit EV/EBITDA multiple and WACC noted in the instructions are less than $48.88

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

Short Term Financial Management

Authors: Ned C Hill

1st Edition

0023548207, 978-0023548208

More Books

Students also viewed these Finance questions

Question

Why should MNCs be concerned about auditing issues?

Answered: 1 week ago

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago

Question

Explain the testing process of accounting 2?

Answered: 1 week ago