Question: 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
 complete the spreadsheet with calculations and explanations. and possible questions complete
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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!