Use the following table to answer the question. A B 1 10 5.5 220 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: =max(B1,B2), what will display once the formula is evaluated? 10 50 150 O 12 Use the following table to answer the question. B 5.5 A 1 10 2 20 3 | 30 4 40 5 50 12 7.5 4 10 Assume the following formula exists: EAVERAGEIF(A1:A5,">="&30,31:35). What will display once the formula is evaluated? 7.2 7.8 30 40 B What is the correct formula for B8 to find the cost of new common equity using the constant growth dividend discount model? A 1 Next Dividend (D) 2.25 2 Dividend Growth Rate 4.00% 3 Stock Price $35.00 4 Flotation Cost 6.00% 5 Beta 1.15 6 Risk-free Rate 2.50% 7 Expected Market Return 9.00% 8 Cost of New Common Equity ? =B3/B1+B2 =B5+B4*(B6-B5)*(1-B4) =B1/(B3*(1-B4))+B2 =B5+B4*B6 =B1/B3+B2 B 2016 175 What would be the value of cell B2? A 1 2017 2 Interest Expense =IF(B6=0,C2,B3*B5+B4*B6) 3 Long-Term Debt 2,000 4 Notes Payable 500 5 Rate on LTD 10% 6 Rate on S.T. Notes 5% 7 Iteration 1 200 175 225 190 250 What should be the correct formula for cell B5? A B 1 Debt to Equity Ratio 0.50 2 Cost of Equity 15% 3 After-tax Cost of Debt 6% 4 Tax Rate 35% 5 WACC ? =B2/(1-B1)+B3/(1-B1) =B2/(1-B1)+B3*B4*B1/(1-B1) =B2/(1-B4)+B3*B1/(1-B4) =B2/(1+B1)+B3*(1-B4)*B1/(1+B1) =B2/(1+B1)+B3*B1/(1+B1) What is the value of cell B5? A B 1 26 3 2 58 3 52 4 47 5 =SMALL(A1:A4,4) *SMALL(A1:A4,1)/SMALL(A1:A4,3) 29 32 49 53 47 Use the following table to answer the question. A B 1 10 5.5 2 20 12 3 30 7.5 40 4 5 50 10 Assume the following formula exists: =sum(A2,A5), what will display once the formula is evaluated? 4 70 150 35 0 140 Use the following table to answer the question. A B 1 10 5.5 2 20 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: Emin(A1:A5), what will display once the formula is evaluated? 150 20 50 O 10 Use the following table to answer the question. A B 1 10 5.5 220 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: =max(B1,B2), what will display once the formula is evaluated? 10 50 150 O 12 Use the following table to answer the question. B 5.5 A 1 10 2 20 3 | 30 4 40 5 50 12 7.5 4 10 Assume the following formula exists: EAVERAGEIF(A1:A5,">="&30,31:35). What will display once the formula is evaluated? 7.2 7.8 30 40 B What is the correct formula for B8 to find the cost of new common equity using the constant growth dividend discount model? A 1 Next Dividend (D) 2.25 2 Dividend Growth Rate 4.00% 3 Stock Price $35.00 4 Flotation Cost 6.00% 5 Beta 1.15 6 Risk-free Rate 2.50% 7 Expected Market Return 9.00% 8 Cost of New Common Equity ? =B3/B1+B2 =B5+B4*(B6-B5)*(1-B4) =B1/(B3*(1-B4))+B2 =B5+B4*B6 =B1/B3+B2 B 2016 175 What would be the value of cell B2? A 1 2017 2 Interest Expense =IF(B6=0,C2,B3*B5+B4*B6) 3 Long-Term Debt 2,000 4 Notes Payable 500 5 Rate on LTD 10% 6 Rate on S.T. Notes 5% 7 Iteration 1 200 175 225 190 250 What should be the correct formula for cell B5? A B 1 Debt to Equity Ratio 0.50 2 Cost of Equity 15% 3 After-tax Cost of Debt 6% 4 Tax Rate 35% 5 WACC ? =B2/(1-B1)+B3/(1-B1) =B2/(1-B1)+B3*B4*B1/(1-B1) =B2/(1-B4)+B3*B1/(1-B4) =B2/(1+B1)+B3*(1-B4)*B1/(1+B1) =B2/(1+B1)+B3*B1/(1+B1) What is the value of cell B5? A B 1 26 3 2 58 3 52 4 47 5 =SMALL(A1:A4,4) *SMALL(A1:A4,1)/SMALL(A1:A4,3) 29 32 49 53 47 Use the following table to answer the question. A B 1 10 5.5 2 20 12 3 30 7.5 40 4 5 50 10 Assume the following formula exists: =sum(A2,A5), what will display once the formula is evaluated? 4 70 150 35 0 140 Use the following table to answer the question. A B 1 10 5.5 2 20 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: Emin(A1:A5), what will display once the formula is evaluated? 150 20 50 O 10