*Can you please explain where the numbers are coming from (and show the formula you are using) and use excel. Thank You in advance

This question was already posted before but I think whoever solved did made an additional problem or didn't show something they did.

Here is the link they used https://www.chegg.com/homework-help/questions-and-answers/firm-xyz-outstanding-project-delta-5-year-project-firm-acquired-land-costs-75-million-hint-q76687020

If you cant do all of the parts can you start at the third step.

Firm XYZ has an outstanding project: Delta. This will be a 5-year project. The firm has acquired the land which costs $7.5 million (Hint: this is the initial cash outflow). The project requires $2.5 million in initial net working capital (This is, again, the initial cash outflow, and we assume that the net working capital is not subject to the floatation cost).

XYZ needs to finance $55 million for the plant and equipment via bond, common stock, and preferred stock issues (Note this is also the initial cost, and the $55 million will be subject to the floatation cost). The following market data on XYZs securities is current:

Debt: 130,000 6.1 percent coupon bond outstanding. 25 years to maturities, selling for 104 percent of par value. The bond has a par value of $2,000, and makes semi-annual payments.

Common stock: 9,900,000 shares outstanding, selling for $68 per share. The beta is 1.20.

Preferred stock: 400,000 shares of 4.20 percent preferred stock outstanding, selling for $87 per share and having a par value of $100.

Market: 7 percent expected market risk premium; 3.1 percent risk-free rate.

Floatation cost: The underwriter charges 6.5 percent on new common stock issues, 4.5 percent on new preferred stock issues, and 3 percent on new debt issues. XYZs marginal tax rate is 25 percent.

Questions:

(1) What are the capital structure weights for debt, common stocks, and preferred stocks?

(2) What is the floatation cost? (in percent)

(3) What are the cost of debt, cost of common stocks, and cost of preferred stocks? What is the WACC?

(4) Given that the cashflows for Project Delta in years 1 through 4 are $21,312,500, and the cashflow in year 5 is $43,543,750 (everything included). Complete the following cashflows by finding out what is the value of A.

Year Flow Cash

0 A

1 21,312,500

2 21,312,500

3 21,312,500

4 21,312,500

5 43,543,750

Hint: A includes the land value, the initial working capital, and the fund raised.

(5) The new project Delta is riskier than a typical project of XYZ. The adjust factor is +2 percent based on the typical WACC. What is the appropriate discount rate to use in this project?

(6) Based on the information above, what are the IRR and NPV of Project Delta? Are you going to accept this Project Delta?