Please solve using excel

Using information in the table below, find McDonald's a$.$ cost of equity; b$.$ Unlevered beta

Given

McDonald's levered beta $0\mathrm{.}56$

Risk free rate $4\mathrm{.}20\%$

Market risk premium $5\%$

McDonald's debt $$15\mathrm{.}00$

McDonald's Enterprise Value $$80\mathrm{.}00$

McDonald's Debt beta $0\mathrm{.}2$

Solution

McDonald's Ke

a$.$Cost of equity for McDonald is

Unlevered Beta

b$.$ Mc Donald's unlevered beta is

SOLVE USING EXCEL FUNCTIONS$\backslash$table$[[$Given$,],[$McDonald$\text{'}$s levered beta,$0\mathrm{.}56,],[$Risk free rate,$4\mathrm{.}20\%,],[$Market risk premium,$5\%,],[$McDonald$\text{'}$s debt,$15\mathrm{.}00,$billion$],[$McDonald$\text{'}$s Enterprise Value,$80\mathrm{.}00,$billion$],[$McDonald$\text{'}$s Debt beta,$0\mathrm{.}2,],[$Solution$],[,$McDonald's Ke$,],[$a$.$Cost of equity for McDonald is$],[,$Unlevered Beta,$]]$