Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

complete the spreadsheet with calculations and explanations. and possible questions complete the spreadhseet with calculations Unlevered Free Cash Flow schedule begin{tabular}{|c|c|c|c|c|} hline Unlevered Free Cash

complete the spreadsheet with calculations and explanations. and possible questions
image text in transcribed
complete the spreadhseet with calculations
Unlevered Free Cash Flow schedule \begin{tabular}{|c|c|c|c|c|} \hline Unlevered Free Cash Flow schedule & & 1 & 2 & \\ \hline & & 2022e & 2023e & 2024e \\ \hline EBIT & $ & 787.70$ & 894.07$ & 952.57 \\ \hline Taxes & $ & (165,42)$ & (187.75)$ & (200.04) \\ \hline Depreciation & $ & 276.00$ & 276.00$ & 276.00 \\ \hline Capital expenditures (CAPEX) & $ & $ & .5 & - \\ \hline Change in Net Working Capital & $ & (26.60)$ & (29.26)$ & (16.09) \\ \hline Unlevered Free Cash Flow & $ & 871.68$ & 953.06$ & 1,012,44 \\ \hline WACC & & 12.69% & 13.37% & 14.01% \\ \hline Kd & & 8.00% & 8.00% & 8.00% \\ \hline Ri & & 5.00% & 4.00% & 3.50% \\ \hline Ke & & 13.80% & 14.45% & 15.05% \\ \hline Beta & & 1.10 & 1.10 & 1.10 \\ \hline Market return & & 13.00% & 13.50% & 14.00% \\ \hline D/N & & 14.83% & 13.23% & 11.91% \\ \hlineE/N & & 85.17% & 86.77% & 88.09% \\ \hline \end{tabular} Terminal Value \begin{tabular}{|lr|} \hline Expected UFCF perpetual growth rate & 1% \\ Expected UFCF 2025 & $1,022.56 \\ Expected WACC & 14.01% \\ Terminal value & $7,859.68 \\ \hline \end{tabular} Valuation \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & 2022e & & 2023e & & 2024e \\ \hline Present value of UFCF & & & & $ & 773.52 & $ & 741.46 & $ & 683.18 \\ \hline Present value of TV & 4 & $ & 5,395.85 & & & & & & \\ \hline Enterprise value & & $ & 7,594.01 & & & & & & \\ \hline Debt & & $ & 736.00 & & & & & & \\ \hline Equity & & $ & 6,858,01 & & & & & & \\ \hline \end{tabular} Share value \begin{tabular}{|lcr|} \hline Actual accounting value & $ & 0.33 \\ Capital increase & $ & 0.53 \\ Value per share & $ & 0.86 \\ \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

M: Finance

Authors: Marcia Cornett, Troy Adair, John Nofsinger

5th Edition

1260772357, 9781260772357

More Books

Students also viewed these Finance questions

Question

why you want to attend graduate school in general;

Answered: 1 week ago

Question

Know the components of a position description

Answered: 1 week ago

Question

Explain the value of a true open-door policy

Answered: 1 week ago