Tax rate 0.2500 Parvalue 1,000 Bond price 962.72 Bond maturity in years 15 Bond coupon rate 0.0813 Bond coupon payment amount 81.25 Number of compounding periods per year 2 Cell for "1" 1 Cell for...

Use data to complet excel chart, please don't only fill in the orange cells with the correct answer, but also show how you got the formula to get the answer!

Extracted text: Tax rate 0.2500 Parvalue 1,000 Bond price 962.72 Bond maturity in years 15 Bond coupon rate 0.0813 Bond coupon payment amount 81.25 Number of compounding periods per year 2 Cell for "1" 1 Cell for "-1" -1 Yield, semi-annual Yield, nominal -- annualized Cost of long-term debt, semi-annual Cost of long-term debt, nominal - annualized Preferred stock par value Preferred stock dilvidend as percentage 100 0.0850 Preferred stock dividend payments per year Preferred stock perpetuity price 112.00 Preferred stock dividend Cost of preferred stock Common stock price 25.00 Do 1.10 Common stock growth rate 0.06 Beta 1.2 Risk-free rate 0.0220 Market risk premium 0.0375 Bond-yield risk premium 0.0400 Cost of equity CAPM Cost of equity DCF Cost of equity Bond-Yield+Risk Premium Average Flotation cost as percentage 0.125 Cost of new common equity Weights 0.35 Costs Target capital debt Target capital preferred 0.10 Target capital common equity 0.55 Weights Costs Target capital debt Target capital preferred 0.35 0.10 Target capital common equity 0.55