help me please provide excel spreadsheet i beg u

4 Search B:00 PM Wed Nov 9 3C Corporation is peovided below. The curepary plans to maintain it capital stracture in the future. If the firm has a 5% affer-tax cest of debt, a 10% cost of preferred stock, and a 18% cost of common stock, what is 3C s weighted cost of capital? 1I. Comprehensive Cast of Capital Problem. The Triple Seven Systems, Ine. (TSS), is starting its plaaning process for next year. Jack Tripper, the firm's CFO, calculates the weighted cost of capital each year to be used as a discount rate in the NPV analysis. You have been asked to help Mr. Tipper to coenpute the firm's cost of eapital. You have collected the following data to do the job: a. TSS bends carry a coupon rate of 5% with semi-annual payments, a $1.000 par, a AAA rating, and a maturity of 10 years. The current price of the TSS boeds is $900. b. TSS preferred stock currently pays a 10% dividend rate cn a $100 par value and has a market value of $90 per share. c. TSS common shares paid a dividend of $4 last year. Dividends have grown at a rate of 6% per year and are expected to continue for a foresecable future. The market price of the stock is $50 and there would be a flotation cont of 5% on a new issue. d. TSS' capital structure is as follows: Bonds(3,000boedsoutstanding)Preferredstock(10,000sharesoutstanding)Commonstock(600,000shares)3,000,0001,000,0006,000,000 e. The firm's average tax rate is 35% and its marginal tax rate is 40 h. f. TSS uses five companies for peer-group comparisons. These five firms alkng with their betas after being adjusied foe financial leverage effects are as follows: 49 Telectroics,Inc,PacificUnitedTreasurybondcurrentlyyields3%(no)andtheexpectedmurketreturn(t0)is10%1.321.34EcologicalSystem,line1.28 Assignments: 1. Compute the after-tax cost of bonds. 2. What is the cost of retained earnings, first based on the DCF approach and then based on the CAPM approach using an average beta of peer groups as TSS' beta. Calculate the average of the two approaches. 3. What is TSS' cost of preferred stock? 4. Calculate the cost of new stock according to the DCF approach. 5. Calculate the weighted cost of capital for TSS assuming (a) only internal equity (retained earnings) is used in financing the equity portion of the new investment, and then (b) new common stock is issued to finance the firm's investments