Defence Electronics Inc. B Defence Electronics Inc. f information appears to be missing, change the row height to see it.) Based in Winnipeg, Manitoba, Defence Electronics Inc. (DEI) was founded to provide security systems, facilities controls and related services. DEI established a solid reputation for quality and the business grew thanks to strong relationships with large, long-term customers in Canada and the United States. The Research and Innovation Group (RIG) is the development side of the company. They are considering a new contract that will strain resources for not only RIG, but the entire company. With an upfront cost of $9.0 million, managers understand that the cost of capital will be a key part of maintaining and improving Clearview's competitive edge. You have been asked to calculate the company's weighted average cost of capital (WACC), based on the following information. Over the last five years the annual dividends on the firm's common stock have grown at 3.00 percent per year and this growth is expected to continue Question Sheet Answer sheet New CUCKVERE TU WWE YOUR WORK Defence Electronics Inc. B 17 0 Over the last five years the annual dividends on the firm's common stock have grown at 3.00 percent per year and this growth is expected to continue indefinitely. A common share dividend of $1.780 per share was recently paid. Common shares trade at $66.000 per share. The company has authorized 327,000 common shares, with 301,000 common shares issued and outstandin 1 The company has issued 124,000 of the 142,000 preferred shares authorized. The annual preferred share dividend is $1.820 per share. The latest preferred share price is $31.000 per share. DEI has an outstanding bond issue, payable semi-annually, that originally had a 20 year maturity. The initial bond offering was sold 9 years ago, at par and raised $21.40 million dollars. (To be specific 21,400 bonds were sold at $1,000 each.). The yield to maturity, when they were issued, was 5.30 percent. Currently, the nominal yield to maturity on bonds with a similar risk is at 6.24 Currently, the nominal yield to maturity on bonds with a similar risk is at 6.24 percent. 36 7 8 The company will use its current capital structure to set target weights for debt, preferred shares and common shares. Flotation costs are 5.00 percent for preferred shares, 3.00 percent for common shares and 5.00 percent for debt. The company's tax rate is 35.00 percent. After-tax earnings for the year will be $3.00 million and the company has a payout ratio of 35.00 percent. Use this information to answer the questions on the next spreadsheet tab. AN NO Defence Electronics Inc. AN AC AD AE AF AG AH AI Requirements: A. Find market values of outstanding bonds, preferred shares and common shares: 1 Bonds: a. What is the market value of each bond? (Enter your answer to two decimal places, leo S124) b. What is the total market value of bonds at Dec 31, 2020 Round your answer to whole numbers. For example, S1,234,000 not $1 234 million) Support $0 $0 $0 2. Preferred shares: What is the total market value of preferred shares at Dec 31, 2020 (Round your answer to whole numbers. For example, $1,234,000 not $1.234 million) $0 Su 3. Common shares: What is the total market value of common shares at Dec 31, 2020 (Round your answer to whole numbers. For example, S1,234,000 not S1 234 million) B. What weights are assigned to debt, preferred shares and common equity on Dec 31, 2020 (Round all your answers to two decimal places. If you want to enter the number 12.34% for example, enter 12.34 (not 0.1234) and do not enter the percent sign) Debt Preferred Common O percent O percent Opercent C. Calculate the after-tax cost of the various components of WACC: Round all your answers to two decimal places. If you want to enter the number 12.34% 1. Bonds a. What is the nominal yield-to-maturity? b. What is the effective yield-to-maturity? Calculate the after-tax cost of new deht bising the effective vield-to-maturitul, Question Sheet Answer sheet New O percent O percent Olnerrent a. What is the nominal yield to maturity? b. What is the effective yield-to-maturity? Calculate the after-tax cost of new debt (using the effective yield to maturity). Opercent olpercent O percent 2. Preferred shares: Opercen 3. Common equity in the form of retained earnings Opercent Opercent 1. Common equity in the form of new shares: D. What is the weighted Average Cost of Capitalit: (Hound all your answers to two decimal places you want to enter the number 12,34%. 1. the company uses new debt, new preferred shares and just retained earnings? Support After tax Cost Weights Debt Pref percent percent percent Common WACC percent Supp 2. the company uses new debt, new preferred shares and new common shares? After-tax Cost Weights Debt MO Defence Electronics Inc. AC AD Al MI AM AX A AH AG AT AI AR Common A percent percent WACC Supporting inform 2. the company uses new debt, new preferred shares and new common shares? Co Debt Pref Common WACC percent Supporting in E. How much of the new capital projects can be funded without using new shareholders? (Enter your answer in whole numbers. For example. S1.234.000 not $1.234 million) 103 Defence Electronics Inc. B Defence Electronics Inc. f information appears to be missing, change the row height to see it.) Based in Winnipeg, Manitoba, Defence Electronics Inc. (DEI) was founded to provide security systems, facilities controls and related services. DEI established a solid reputation for quality and the business grew thanks to strong relationships with large, long-term customers in Canada and the United States. The Research and Innovation Group (RIG) is the development side of the company. They are considering a new contract that will strain resources for not only RIG, but the entire company. With an upfront cost of $9.0 million, managers understand that the cost of capital will be a key part of maintaining and improving Clearview's competitive edge. You have been asked to calculate the company's weighted average cost of capital (WACC), based on the following information. Over the last five years the annual dividends on the firm's common stock have grown at 3.00 percent per year and this growth is expected to continue Question Sheet Answer sheet New CUCKVERE TU WWE YOUR WORK Defence Electronics Inc. B 17 0 Over the last five years the annual dividends on the firm's common stock have grown at 3.00 percent per year and this growth is expected to continue indefinitely. A common share dividend of $1.780 per share was recently paid. Common shares trade at $66.000 per share. The company has authorized 327,000 common shares, with 301,000 common shares issued and outstandin 1 The company has issued 124,000 of the 142,000 preferred shares authorized. The annual preferred share dividend is $1.820 per share. The latest preferred share price is $31.000 per share. DEI has an outstanding bond issue, payable semi-annually, that originally had a 20 year maturity. The initial bond offering was sold 9 years ago, at par and raised $21.40 million dollars. (To be specific 21,400 bonds were sold at $1,000 each.). The yield to maturity, when they were issued, was 5.30 percent. Currently, the nominal yield to maturity on bonds with a similar risk is at 6.24 Currently, the nominal yield to maturity on bonds with a similar risk is at 6.24 percent. 36 7 8 The company will use its current capital structure to set target weights for debt, preferred shares and common shares. Flotation costs are 5.00 percent for preferred shares, 3.00 percent for common shares and 5.00 percent for debt. The company's tax rate is 35.00 percent. After-tax earnings for the year will be $3.00 million and the company has a payout ratio of 35.00 percent. Use this information to answer the questions on the next spreadsheet tab. AN NO Defence Electronics Inc. AN AC AD AE AF AG AH AI Requirements: A. Find market values of outstanding bonds, preferred shares and common shares: 1 Bonds: a. What is the market value of each bond? (Enter your answer to two decimal places, leo S124) b. What is the total market value of bonds at Dec 31, 2020 Round your answer to whole numbers. For example, S1,234,000 not $1 234 million) Support $0 $0 $0 2. Preferred shares: What is the total market value of preferred shares at Dec 31, 2020 (Round your answer to whole numbers. For example, $1,234,000 not $1.234 million) $0 Su 3. Common shares: What is the total market value of common shares at Dec 31, 2020 (Round your answer to whole numbers. For example, S1,234,000 not S1 234 million) B. What weights are assigned to debt, preferred shares and common equity on Dec 31, 2020 (Round all your answers to two decimal places. If you want to enter the number 12.34% for example, enter 12.34 (not 0.1234) and do not enter the percent sign) Debt Preferred Common O percent O percent Opercent C. Calculate the after-tax cost of the various components of WACC: Round all your answers to two decimal places. If you want to enter the number 12.34% 1. Bonds a. What is the nominal yield-to-maturity? b. What is the effective yield-to-maturity? Calculate the after-tax cost of new deht bising the effective vield-to-maturitul, Question Sheet Answer sheet New O percent O percent Olnerrent a. What is the nominal yield to maturity? b. What is the effective yield-to-maturity? Calculate the after-tax cost of new debt (using the effective yield to maturity). Opercent olpercent O percent 2. Preferred shares: Opercen 3. Common equity in the form of retained earnings Opercent Opercent 1. Common equity in the form of new shares: D. What is the weighted Average Cost of Capitalit: (Hound all your answers to two decimal places you want to enter the number 12,34%. 1. the company uses new debt, new preferred shares and just retained earnings? Support After tax Cost Weights Debt Pref percent percent percent Common WACC percent Supp 2. the company uses new debt, new preferred shares and new common shares? After-tax Cost Weights Debt MO Defence Electronics Inc. AC AD Al MI AM AX A AH AG AT AI AR Common A percent percent WACC Supporting inform 2. the company uses new debt, new preferred shares and new common shares? Co Debt Pref Common WACC percent Supporting in E. How much of the new capital projects can be funded without using new shareholders? (Enter your answer in whole numbers. For example. S1.234.000 not $1.234 million) 103