Question Sheet Answer sheet Taunton Corp. (If information appears to be missing, change the row height to see it.) Based in Winnipeg, Manitoba, Taunton Corp. (TC) was founded to provide security systems, facilities controls and related services. TC 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 $10.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 4.00 percent per year and this growth is expected to continue indefinitely. A common share dividend of $2.260 per share was recently paid. Common shares trade at $87.000 per share. The company has authorized 345,000 common shares, with 300,000 common shares issued and outstanding. The company has issued 133,000 of the 158,000 preferred shares authorized. The annual preferred share dividend is $2.240 per share. The latest preferred share price is $50.300 per share. TC has an outstanding bond issue, payable semi-annually, that originally had a 20 year maturity. The initial bond offering was sold 8 years ago, at par and raised $19.40 million dollars. (To be specific 19,400 bonds were sold at $1,000 each.) The yield to maturity, when they were issued, was 6.40 percent. Currently, the nominal yield to maturity on bonds with a similar risk is at 5.71 percent. The company will use its current capital structure to set target weights for debt, preferred shares and common shares. Flotation costs are 3.00 percent for preferred shares, 6.00 percent for common shares and 3.00 percent for debt. The company's tax rate is 45.00 percent. After-tax earnings for the year will be $6.00 million and the company has a payout ratio of 40.00 percent. Use this information to answer the questions on the next spreadsheet tab. Sheet Answer sheet Taunton Corp. Unless directed otherwise, Percentages should be founded to wo decimal place you want to enter the number 12.34% for example, enter 12.34 of 0.1230) and do not enter the percent sign, r Bond prices should he towe decimal places leg. 572.34) r Per share figures should be rounded to three decimal places. 51.234 pershane) Total dollar figures should be rounded to serdecimal places les $1.234) The following table is presented to help you organize the information from the case: (there are no marks associated with the information in this table) Bonds Prer Y 0.00 percent Dp: $ 0.00 Te: 0.0 percent Pp: $ 0.00 F: 0.00 percent F: 0.00 percent DI: PO: Common S 0.00 S 0.00 0.00 percent 0.00 percent F: Supporting information 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 annuer do we decimal places. (es $12.34) b. What is the total market value of bonds at Dec 31, 2020 (Rowel your answer to whole numbers. For example, 51.234,000 not $1.234 million) $ 0.00 SO 2. Preferred shares: What is the total market value of preferred shares at Dec 31, 2020 (Round your answer to whole mers. For comple, 51,234.000 or 51.234 million) SO 3. Common shares: What is the total market value of common shares at Dec 31, 2020 (Round your answer to whole numbers. For example, 51,234,000 or $1.234 million B. What weights are assigned to debt, preferred shares and common equity on Dec 31, 2020 Round all your answers to decimal places. If you want to enter the mer 12.34% for example, outer 12.34 (max 0.1234) and do not enter the percent sign Supporting informatie Debt Preferred Common 0.00 percent 0.00 percent 0.00 percent C. Calculate the after-tax cost of the various components of WACC: (Rowuf all your answers to two decimal placer you want to enter the number 12.34% for example, wer 12.34 mar 0.1234) and do not enter the percent sign.) 1. Bonds a. What is the nominal yield-to-maturity? b. What is the effective yield-to-maturity? . c. Calculate the after-tax cost of new debt (using the effective yield-to-maturity). Supporting information 0.00 percent 0.00 percent 0.00 percent 2. Preferred shares: 0.00 percent 3. Common equity in the form of retained camings: 0.00 percent 0.00 percent 4. Common equity in the form of new shares: D. What is the Weighted Average Cost of Capital if: (Rowuf all your answers to we decimal places. If you want to enter the number 12.34% for example, enter 12.34fnar 0.1234) and do not enter the percent sigt) 1. the company uses new debt, new preferred shares and just retained camnings? Supporting information After-tax Weights Cost Debt Pref Common percent percent percent percent WACCI 2. the company uses new debt, new preferred shares and new common shares? Supporting informatie After-tax Weights Cost Debu Prer Common WACC percent Supporting information E. How much of the new capital projects can be funded without using new shareholders? (Enter your answer in whole numbers. For example, 31.234,000 or S/.234 million 119 Question Sheet Answer sheet Taunton Corp. (If information appears to be missing, change the row height to see it.) Based in Winnipeg, Manitoba, Taunton Corp. (TC) was founded to provide security systems, facilities controls and related services. TC 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 $10.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 4.00 percent per year and this growth is expected to continue indefinitely. A common share dividend of $2.260 per share was recently paid. Common shares trade at $87.000 per share. The company has authorized 345,000 common shares, with 300,000 common shares issued and outstanding. The company has issued 133,000 of the 158,000 preferred shares authorized. The annual preferred share dividend is $2.240 per share. The latest preferred share price is $50.300 per share. TC has an outstanding bond issue, payable semi-annually, that originally had a 20 year maturity. The initial bond offering was sold 8 years ago, at par and raised $19.40 million dollars. (To be specific 19,400 bonds were sold at $1,000 each.) The yield to maturity, when they were issued, was 6.40 percent. Currently, the nominal yield to maturity on bonds with a similar risk is at 5.71 percent. The company will use its current capital structure to set target weights for debt, preferred shares and common shares. Flotation costs are 3.00 percent for preferred shares, 6.00 percent for common shares and 3.00 percent for debt. The company's tax rate is 45.00 percent. After-tax earnings for the year will be $6.00 million and the company has a payout ratio of 40.00 percent. Use this information to answer the questions on the next spreadsheet tab. Sheet Answer sheet Taunton Corp. Unless directed otherwise, Percentages should be founded to wo decimal place you want to enter the number 12.34% for example, enter 12.34 of 0.1230) and do not enter the percent sign, r Bond prices should he towe decimal places leg. 572.34) r Per share figures should be rounded to three decimal places. 51.234 pershane) Total dollar figures should be rounded to serdecimal places les $1.234) The following table is presented to help you organize the information from the case: (there are no marks associated with the information in this table) Bonds Prer Y 0.00 percent Dp: $ 0.00 Te: 0.0 percent Pp: $ 0.00 F: 0.00 percent F: 0.00 percent DI: PO: Common S 0.00 S 0.00 0.00 percent 0.00 percent F: Supporting information 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 annuer do we decimal places. (es $12.34) b. What is the total market value of bonds at Dec 31, 2020 (Rowel your answer to whole numbers. For example, 51.234,000 not $1.234 million) $ 0.00 SO 2. Preferred shares: What is the total market value of preferred shares at Dec 31, 2020 (Round your answer to whole mers. For comple, 51,234.000 or 51.234 million) SO 3. Common shares: What is the total market value of common shares at Dec 31, 2020 (Round your answer to whole numbers. For example, 51,234,000 or $1.234 million B. What weights are assigned to debt, preferred shares and common equity on Dec 31, 2020 Round all your answers to decimal places. If you want to enter the mer 12.34% for example, outer 12.34 (max 0.1234) and do not enter the percent sign Supporting informatie Debt Preferred Common 0.00 percent 0.00 percent 0.00 percent C. Calculate the after-tax cost of the various components of WACC: (Rowuf all your answers to two decimal placer you want to enter the number 12.34% for example, wer 12.34 mar 0.1234) and do not enter the percent sign.) 1. Bonds a. What is the nominal yield-to-maturity? b. What is the effective yield-to-maturity? . c. Calculate the after-tax cost of new debt (using the effective yield-to-maturity). Supporting information 0.00 percent 0.00 percent 0.00 percent 2. Preferred shares: 0.00 percent 3. Common equity in the form of retained camings: 0.00 percent 0.00 percent 4. Common equity in the form of new shares: D. What is the Weighted Average Cost of Capital if: (Rowuf all your answers to we decimal places. If you want to enter the number 12.34% for example, enter 12.34fnar 0.1234) and do not enter the percent sigt) 1. the company uses new debt, new preferred shares and just retained camnings? Supporting information After-tax Weights Cost Debt Pref Common percent percent percent percent WACCI 2. the company uses new debt, new preferred shares and new common shares? Supporting informatie After-tax Weights Cost Debu Prer Common WACC percent Supporting information E. How much of the new capital projects can be funded without using new shareholders? (Enter your answer in whole numbers. For example, 31.234,000 or S/.234 million 119