M7 Individual Assignment (31 points) To complete this homework, you will enter your answers to the questions below on Tab 1 of the M7 IND ASS SUBMISSION TEMPLATE. Once you have completed Tab 1, you will copy it to Tab 2 (copy range is A1:B17). Once you've copied your answers to Tab 2, you will click on Formulas," then on Show Formulas." The homework must be completed according to the Principles of Spreadsheet Design. Remember that you are graded on the assignment as well as your accuracy in using the Principles of Spreadsheet Design Riskfree rate 0.02 Market rate 0.15 Tax rate 0.30 1. Use the information below and the ratings chart in the slides to find this firm's WACC. Debt Equity $22,000,000 Market value $35,000,000 Debt i (30 yr. BBB rating) Beta 2.0 B D A B 1 M7 Ind Ass Submission Template 2 Market rate 3 Riskfreee rate 4 5 Inputs 6 Debt 7 Interest rate 8 Equity 9 Beta 10 Tax rate 11 12 Outputs 13 14 After-taxi 15 % Debt 16 % Equity 17 WACC 18 19 20 21 22 23 24 M7 Individual Assignment (31 points) To complete this homework, you will enter your answers to the questions below on Tab 1 of the M7 IND ASS SUBMISSION TEMPLATE. Once you have completed Tab 1, you will copy it to Tab 2 (copy range is A1:B17). Once you've copied your answers to Tab 2, you will click on Formulas," then on Show Formulas." The homework must be completed according to the Principles of Spreadsheet Design. Remember that you are graded on the assignment as well as your accuracy in using the Principles of Spreadsheet Design Riskfree rate 0.02 Market rate 0.15 Tax rate 0.30 1. Use the information below and the ratings chart in the slides to find this firm's WACC. Debt Equity $22,000,000 Market value $35,000,000 Debt i (30 yr. BBB rating) Beta 2.0 B D A B 1 M7 Ind Ass Submission Template 2 Market rate 3 Riskfreee rate 4 5 Inputs 6 Debt 7 Interest rate 8 Equity 9 Beta 10 Tax rate 11 12 Outputs 13 14 After-taxi 15 % Debt 16 % Equity 17 WACC 18 19 20 21 22 23 24