Please show all the formulas used to solve these questions in excel. Thank you so much.

3) Assume a coupon of 6%. You borrow $10 million from the bank and you make quarterly payments over 8 years. There is a balloon payment of $1,000,000 at the end of year 8. Determine annual interest and principal payment for year 5. (8 points) 4) You are planning a major product expansion. To implement this strategy, you will need to build a new plant in Newark. You estimate that the cost of the plant and equipment is $200 million. You expect annual sales of $75 million for 25 years. Costs are expected to be 60% of sales. Assume straight line depreciation and that the salvage value of the plant at time 25 is zero. Accounts Receivable is 35% of next year sales. Cash is 10% of next year sales. Inventory is 15% of next year's sales. Accounts Payable is 30% of next year's sales. Your tax rate is 34%. Your balance sheet information is as follows: Capital Structure Bonds Debentures Subordinated Debentures Common Stock Retained Earnings Book Value $100 million $200 million $100 million $400 million $600 million Coupon Rate 5% 6% 7% # of units 100,000 200,000 100,000 15 million Price per Unit $1,050 $1,000 $950 $50 Maturity 10 years 11 years 12 years Assume that the beta of the common stock is .8 and the market risk premium is 9%. Assume that the risk free rate is 3%. Assume that all interest payments are made annually. Determine the NPV and IRR of the project. Would you expand? (12 points)