WACC+Worksheet

WACC+Worksheet - 0.130 1.32% Total 104,382,000 4.24%...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
file:////home/vdimitrov/11166/00c272839897b3a4a92bf8e5b9aa66597bc2be72.xls MGT 3062 FINANCIAL MANAGEMENT WACC WORKSHEET Debt Market Value Par Value Ki Market Value Bond 1 $850.00 $1,000 5% 4 10.00 25,000 7.1% 4.3% 21,250,000 0.103 0.45% Bond 2 $990.00 $1,000 8% 2 8.00 34,500 8.2% 5.0% 34,155,000 0.166 0.83% Bond 3 $1,100.00 $1,000 6% 1 6.50 26,400 4.2% 2.6% 29,040,000 0.141 0.36% Total 84,445,000 1.64% Common Stock Market Value Par Value growth rate beta Kr Market Value Class A Shares $28.35 $1.00 0.75 5.0% 1.2 2,735,000 7.8% 77,537,250 0.376 2.93% Class B Shares $14.55 $1.00 - 5.1% 1.1 1,845,000 10.1% 26,844,750
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0.130 1.32% Total 104,382,000 4.24% Preferred Stock Market Value Par Value Dividend Kr Market Value Shares $115.00 $100 $8.75 150,000 7.6% 17,250,000 0.084 0.64% Tax Rate 39% Risk Free Rate 3.5% Market Premium 6.0% Total Market Value 206,077,000 WACC (market) 6.51% Risk Adjustment 5.00% RACC 11.51% given values are highlighted Coupon Rate Coupons per year Years to Maturity Bonds Outstanding Kd YTM MV Weight Ki X Weight Last Dividend Shares Outstanding MV Weight Cost X Weight Shares Outstanding MV Weight Cost X Weight...
View Full Document

Ask a homework question - tutors are online