60.1K

Verified Solution

Link Copied!

For the following problems, use Exhibit B. Exhibit B has the balance sheet and Income Statement projections for a specific company. The company is evaluating if it is worth it to have the capital investment as showed in the Capital Investment Table. The EBITDA multiplier of similar companies 7.2%. The debt used has a coupon of 12.5%. The WACC is 20%

Use the graphs and statements to find out the whole statement. FInd the persent value on free cash flows, present value on continuation for the firm. Tax shielf and expansion of the project. All the information provided.

1) What is the present value of the Free cash flows? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

2) What is the present value of the continuation value for the firm? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

3) What is the present value of the Interest Tax Shield? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

4) What is the Firm Value with the expansion of the project? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

\begin{tabular}{|c|l|ll|ll|l|l|} \hline \multicolumn{2}{|c|}{ Capital Investment } \\ \hline 1 & Capital Investment & $ & 2,500.00 & $ & 57,500.00 & $ & 8,500.00 \\ \hline \end{tabular} \begin{tabular}{|lc|} \hline Integrated Financial Statement Template \\ \hline Exhibit B: Free Cash Flow and Valuation \\ \hline 2021 & 2022 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Free Cash Flow (000s) } & & & \\ \hline 1 & Net Income & & & \\ \hline 2 & Plus: After-Tax Interes Expense & & & \\ \cline { 2 - 5 } 3 & Unlevered Net Income & & & \\ \cline { 2 - 5 } & Plus: Depreciation & & & \\ \cline { 2 - 5 } 5 & Less: Increases in NWC & & & \\ \hline & Less: Capital Expenditures & & & \\ \hline & Free Cash Flow of Firm & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|ll|ll|l|l|} \hline \multicolumn{2}{|c|}{ Capital Investment } \\ \hline 1 & Capital Investment & $ & 2,500.00 & $ & 57,500.00 & $ & 8,500.00 \\ \hline \end{tabular} \begin{tabular}{|lc|} \hline Integrated Financial Statement Template \\ \hline Exhibit B: Free Cash Flow and Valuation \\ \hline 2021 & 2022 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Free Cash Flow (000s) } & & & \\ \hline 1 & Net Income & & & \\ \hline 2 & Plus: After-Tax Interes Expense & & & \\ \cline { 2 - 5 } 3 & Unlevered Net Income & & & \\ \cline { 2 - 5 } & Plus: Depreciation & & & \\ \cline { 2 - 5 } 5 & Less: Increases in NWC & & & \\ \hline & Less: Capital Expenditures & & & \\ \hline & Free Cash Flow of Firm & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer