the dividend payment is 1.5

MEDIAN X Fx -(1+Question 1 Question Discoveritl Company has just paid $1.5 dividend payment. The current stock price is $20 and has 2,500,000 outstanding shares. Calculate the growth rate using the dividend payments in 2 under Dividend Growth Tab of this same Excel Sheet and keep two decimals when you use this growth rate in DM. Calculate cost of equity, based on DGM 3. The company has a beta of 1.2 and return on the market is 6%. Risk free rate is 2.2%. Calculate cost of equity, based on SML The company has 500,000 preferred stock outstanding with selling price of $25 and dividend payment of $3. Discoverit has only one bond outstanding with a maturity period of 10 years. The bond makes semiannual coupon payments and the coupon rates is 10%. The selling price of the bond is 5 $1,050 and face is $1,000. The tax rate is 21% and the company has 2,000 bonds outstanding Calculate before and after-tax cost of debt. 6 Calculate WACC using SML approach to calculate Cost of Equity, 7 Calculate WACC using Dividend Growth Model approach to calculate Cost of Equity 8 Note: All the blue highlighted cells on the WACC worksheet are the numbers that you can just get from the question and enter in your excel sheet. 9 Note: All the range highlighted calls on the WACC worksheet require calculation 10 11 12 13 14 A Question Discoverit Company has just paid $1.5 dividend payment. The current stock price is $20 and has 2,500,000 outstanding shares Calculate the growth rate using the dividend payments giver under Dividend Growth Tab of this same Excel Sheet and keep two decimals when you use this growth rate in DGM. Calculate cost of equity, based on DGM The company has a beta of 1.2 and return on the market is 6%. Risk free rate is 2.2% Calculate cost of equity, based on SML. The company has 500,000 preferred stock outstanding with selling price of $25 and dividend payment of$s. Discoverit has only one bond outstanding with a maturity period of 10 years. The bond makes semiannual coupon payments and the coupon rate is 10%. The selling price at the bond in $1,050 and face la $1,000. The tax rate is 21% and the company has 2,000 bonds outstanding. Calculate before and after-tax cost of debt. Calculate WACC Using SML approach to calculate Cost of Equity Calculate WACC using Dividend Growth Model approach to calculate Cost of Equity Note: All the blue highlighted cells on the WACC worksheet are the numbers that you can just get from the question and enter in your excel sheet Not All the orang lained calls on the WACC Worksheet require calculation B18 K 1 H D E F G A B 1 Year 5 calculate the growth of the dividends year by year. NOWN Dividends 1 1.3 2 1.35 3 1.39 4 1.42 5 1.5 3% 8% 5.00% calculate the average of the growth rates. 8 9 10 dit Viewint Format Tools Det Window Help Sat Jan 23 111 01 PM 2020Winter-FIN325-LN-Exam-Excel Tell me Home Insert Draw Page Layout Formulas Data Review View Share Comments wap General ner Dela 2. 3 S%) CA in Form Forming The SS FR Hess Caibri (Hody 11 - A A B7 U A- G13 Xf COSTO EQUITY 2 Lodendrowth Model Approach DOOL Dacide which dividend in the problem dic Growth SD 30 Endom.com O 2. MLA 2.ION 1.2 EN Shock Bendri Pred WEIGHTS 2000 100 1000 DOT 200 25.5 5000000 PROC VALU OM 112 RI We Weight of Who COST OF PREFERRED STOCK TAN 20 COSTO DEST Odend LDP 11 cent of preferred stock 11 18 14 Coupon 15 IN F Cugnya IT Price TBT 19 20. Radi 21 22 M NALE DI Made Cast of Tauty WACC Cowegtaf Commerd worden uit Fedora WACCIA Is for content IN WACE Sweet ander werdew Nin Coupe LON 1050 1000 Bolechowing 21 14 2 D G WACC 16 MEDIAN X Fx -(1+Question 1 Question Discoveritl Company has just paid $1.5 dividend payment. The current stock price is $20 and has 2,500,000 outstanding shares. Calculate the growth rate using the dividend payments in 2 under Dividend Growth Tab of this same Excel Sheet and keep two decimals when you use this growth rate in DM. Calculate cost of equity, based on DGM 3. The company has a beta of 1.2 and return on the market is 6%. Risk free rate is 2.2%. Calculate cost of equity, based on SML The company has 500,000 preferred stock outstanding with selling price of $25 and dividend payment of $3. Discoverit has only one bond outstanding with a maturity period of 10 years. The bond makes semiannual coupon payments and the coupon rates is 10%. The selling price of the bond is 5 $1,050 and face is $1,000. The tax rate is 21% and the company has 2,000 bonds outstanding Calculate before and after-tax cost of debt. 6 Calculate WACC using SML approach to calculate Cost of Equity, 7 Calculate WACC using Dividend Growth Model approach to calculate Cost of Equity 8 Note: All the blue highlighted cells on the WACC worksheet are the numbers that you can just get from the question and enter in your excel sheet. 9 Note: All the range highlighted calls on the WACC worksheet require calculation 10 11 12 13 14 A Question Discoverit Company has just paid $1.5 dividend payment. The current stock price is $20 and has 2,500,000 outstanding shares Calculate the growth rate using the dividend payments giver under Dividend Growth Tab of this same Excel Sheet and keep two decimals when you use this growth rate in DGM. Calculate cost of equity, based on DGM The company has a beta of 1.2 and return on the market is 6%. Risk free rate is 2.2% Calculate cost of equity, based on SML. The company has 500,000 preferred stock outstanding with selling price of $25 and dividend payment of$s. Discoverit has only one bond outstanding with a maturity period of 10 years. The bond makes semiannual coupon payments and the coupon rate is 10%. The selling price at the bond in $1,050 and face la $1,000. The tax rate is 21% and the company has 2,000 bonds outstanding. Calculate before and after-tax cost of debt. Calculate WACC Using SML approach to calculate Cost of Equity Calculate WACC using Dividend Growth Model approach to calculate Cost of Equity Note: All the blue highlighted cells on the WACC worksheet are the numbers that you can just get from the question and enter in your excel sheet Not All the orang lained calls on the WACC Worksheet require calculation B18 K 1 H D E F G A B 1 Year 5 calculate the growth of the dividends year by year. NOWN Dividends 1 1.3 2 1.35 3 1.39 4 1.42 5 1.5 3% 8% 5.00% calculate the average of the growth rates. 8 9 10 dit Viewint Format Tools Det Window Help Sat Jan 23 111 01 PM 2020Winter-FIN325-LN-Exam-Excel Tell me Home Insert Draw Page Layout Formulas Data Review View Share Comments wap General ner Dela 2. 3 S%) CA in Form Forming The SS FR Hess Caibri (Hody 11 - A A B7 U A- G13 Xf COSTO EQUITY 2 Lodendrowth Model Approach DOOL Dacide which dividend in the problem dic Growth SD 30 Endom.com O 2. MLA 2.ION 1.2 EN Shock Bendri Pred WEIGHTS 2000 100 1000 DOT 200 25.5 5000000 PROC VALU OM 112 RI We Weight of Who COST OF PREFERRED STOCK TAN 20 COSTO DEST Odend LDP 11 cent of preferred stock 11 18 14 Coupon 15 IN F Cugnya IT Price TBT 19 20. Radi 21 22 M NALE DI Made Cast of Tauty WACC Cowegtaf Commerd worden uit Fedora WACCIA Is for content IN WACE Sweet ander werdew Nin Coupe LON 1050 1000 Bolechowing 21 14 2 D G WACC 16