Answered step by step
Verified Expert Solution
Question
1 Approved Answer
complete the spreadsheet with calculations and explanations. and possible questions Debt payment schedule begin{tabular}{|c|c|c|c|c|c|c|} hline multirow{3}{*}{begin{tabular}{l} Notes Payable at beginning Payments end{tabular}} & multicolumn{2}{|c|}{2022e}
complete the spreadsheet with calculations and explanations. and possible questions
Debt payment schedule \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} Notes Payable at beginning \\ Payments \end{tabular}} & \multicolumn{2}{|c|}{2022e} & \multicolumn{2}{|r|}{2023e} & \multicolumn{2}{|r|}{2024e} \\ \hline & $ & 196.00 & $ & 136.00 & $ & 136.00 \\ \hline & $ & (60.00) & $ & - & $ & - \\ \hline Notes Payable at end & s & 136.00 & $ & 136.00 & $ & 136.00 \\ \hline Long-Term Debt at beg & $ & 457.00 & $ & 457.00 & $ & 457.00 \\ \hline Payments & $ & - & $ & . & $ & - \\ \hline Long-Term debt at end & $ & 457.00 & $ & 457.00 & $ & 457.00 \\ \hline Total debt at beginning & $ & 653.00 & $ & $93.00 & $ & 593.00 \\ \hline Total debt at end & $ & 593.00 & $ & 593.00 & $ & 593.00 \\ \hline Interest on total debt. & $ & 52.24 & $ & 47.44 & $ & 47.44 \\ \hline \end{tabular} Unlevered Free Cash Flow schedule 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} Debt payment schedule \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} Notes Payable at beginning \\ Payments \end{tabular}} & \multicolumn{2}{|c|}{2022e} & \multicolumn{2}{|r|}{2023e} & \multicolumn{2}{|r|}{2024e} \\ \hline & $ & 196.00 & $ & 136.00 & $ & 136.00 \\ \hline & $ & (60.00) & $ & - & $ & - \\ \hline Notes Payable at end & s & 136.00 & $ & 136.00 & $ & 136.00 \\ \hline Long-Term Debt at beg & $ & 457.00 & $ & 457.00 & $ & 457.00 \\ \hline Payments & $ & - & $ & . & $ & - \\ \hline Long-Term debt at end & $ & 457.00 & $ & 457.00 & $ & 457.00 \\ \hline Total debt at beginning & $ & 653.00 & $ & $93.00 & $ & 593.00 \\ \hline Total debt at end & $ & 593.00 & $ & 593.00 & $ & 593.00 \\ \hline Interest on total debt. & $ & 52.24 & $ & 47.44 & $ & 47.44 \\ \hline \end{tabular} Unlevered Free Cash Flow schedule 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} 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