please show your work and which excel row you used for the formula( ex: d13*b3)

A B D E F G H 1 j K L M N O Q R S T V 2 A) Debt 6.5% 12.0% 3 30.0% 70.0% 100.0% Equity Total 4 5 Formula: Corporate Cost of Capital = (Percent of Debt Financing * Cost of Debt) + (Percent of Equity Financing * Cost of Equity) 6 B) = Debt Equity Total 7 0.0% 100.0% 100.0% 0.0% 25.4% 8 9 10 C) 8.0% Which option has the lowest Cost of Capital? 11 Debt Equity Total 55.0% 45.0% 100.0% 22.0% 12 13 14 D) Debt 11.0% 44.0% 56.0% 15 20.0% Equity Total 16 100.0% 17 18 19 20 21 22 23 Case Ronart cost of canital