PLEASE ANSWER IN EXCEL FORM PLEASE

PLEASE ANSWER IN EXCEL FORM PLEASE

PLEASE ANSWER IN EXCEL FORM PLEASE

PLEASE ANSWER IN EXCEL FORM PLEASE

PLEASE ANSWER IN EXCEL FORM

PROBLEM 4-6 Solution a. Cost of equity \begin{tabular}{rr} Low ERP & High ERP \\ \hline 6.28% & 11.16% \end{tabular} b. WACC with Low ERP \begin{tabular}{|r|r|rr|} \hline & Cap Str & \multicolumn{1}{|c|}{ After-Tax } & Product \\ \cline { 2 - 5 } Debt & 25.00% & 0.00% & 0.73% \\ \hline Equity & 75.00% & 11.16% & \\ \cline { 1 - 4 } & & & \\ \hline \hline \end{tabular} WACC with High MRP \begin{tabular}{|c|c|c|c|} \hline & Cap Str & After-Tax & Product \\ \cline { 2 - 4 } Debt & 25.00% & \\ \hline Equity & 75.00% \\ \hline \end{tabular}