Please show calculations in Excel. Otherwise, do not attempt to answer

Your firm is considering a new three-year project. You know that the unlevered cost of equity for firms with a similar risk as your target is 8%. At the end of the project, all available funds are distributed to equity and debt holders. Use the following financial statements to answer the questions below

1. How large an equity investment does the project require upfront?

2. How much equity is recovered at the end of the project?

3. Show the cash to and from equity holders for the entire project. Dont forget about dividends, initial, and terminal equity flows. Actual cash, not free cash flow!

4. Based on the cash flows in part c, what is the IRR for the equity holders?

5. What is the present value of the tax shield for this three-year project? Remember, this is not a perpetuity, its a three-year project.

6. Is this a good project for shareholders?

Please show calculations in Excel. Otherwise, do not attempt to answer

Year 0 1 2 3 Income statement \begin{tabular}{lrrr} \hline Sales & $175,000 & $175,000 & $175,000 \\ COGS & $26,250 & $26,250 & $26,250 \\ Depreciation & $100,000 & $100,000 & $100,000 \\ EBIT & $48,750 & $48,750 & $48,750 \\ Interest payment on debt & $9,000 & $9,000 & $9,000 \\ Profit Before tax & $39,750 & $39,750 & $39,750 \\ Taxes & $21,863 & $21,863 & $21,863 \\ Profit after tax & $17,888 & $17,888 & $17,888 \\ Dividends & $17,888 & $17,888 & $17,888 \\ Retained earnings & $0 & $0 & $0 \\ \hline \end{tabular} Balance Sheet \begin{tabular}{lrrrr} \hline Cash and Mark. Sec. & $0 & $100,000 & $200,000 & $300,000 \\ Current Assets & $0 & $0 & $0 & $0 \\ Fixed Assets & & & & \\ At cost & $300,000 & $300,000 & $300,000 & $300,000 \\ Acc. Depreciation & $0 & $100,000 & $200,000 & $300,000 \\ Net Fixed Assets & $300,000 & $200,000 & $100,000 & $0 \\ Total Assets & $300,000 & $300,000 & $300,000 & $300,000 \end{tabular} Current liabilities Debt Stock $150,000$150,000$150,000$150,000 Acc. Ret. Earn. Total liab.and equity \begin{tabular}{rrrr} $0 & $0 & $0 & $0 \\ $150,000 & $150,000 & $150,000 & $150,000 \\ $150,000 & $150,000 & $150,000 & $150,000 \\ $0 & $0 & $0 & $0 \\ $300,000 & $300,000 & $300,000 & $300,000 \\ \hline \end{tabular}