I need help with the following excel sheet attached. I need formulas in the cells of the excel sheet. Not manually worked out.

LL Incorporated's currently outstanding 11% coupon bonds have a yield to maturity of 8%. LL believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, what is LL's after-tax cost of debt? Summerdahl Resort's common stock is currently trading at $36 a share. The stock is expected to pay a dividend of $3.00 a share at the end of the year (D1 = $3.00), and the dividend is expected to grow at a constant rate of 5% a year. What is its cost of common equity? Booher Book Stores has a beta of 0.8. The yield on a 3-month T-bill is 4%, and the yield on a 10-year T-bond is 6%. The market risk premium is 5.5%, and the return on an average stock in the market last year was 15%. What is the estimated cost of common equity using the CAPM? David Ortiz Motors has a target capital structure of 40% debt and 60% equity. The yield to maturity on the company's outstanding bonds is 9%, and the company's tax rate is 40%. Ortiz's CFO has calculated the company's WACC as 9.96%. What is the company's cost of equity capital? A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years, and a cost of capital of 11%. What is the project's NPV? (Hint: Begin by constructing a time line.) Refer to Problem 10-1. What is the project's IRR? Refer to Problem 10-1. What is the project's MIRR? Refer to Problem 10-1. What is the project's PI? Refer to Problem 10-1. What is the project's payback period? Refer to Problem 10-1. What is the project's discounted payback period? Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The projects are independent. The cash outlay for the truck is $17,100 and that for the pulley system is $22,430. The firm's cost of capital is 14%. After-tax cash flows, including depreciation, are as follows: Year 1 2 3 4 5 Truck $5,100 5,100 5,100 5,100 5,100 Pulley $7,500 7,500 7,500 7,500 7,500 Calculate the IRR, the NPV, and the MIRR for each project, and indicate the correct accept-reject decision for each