Can you please show me on excel $($& please show formulas$)$ how to do this problem: Fran McClure of Alba Advisers is estimating the cost of capital of Frontier Corporation as part of

her valuation analysis of Frontier. McClure will be using this estimate, along with projected cash

flows from Frontier's new projects, to estimate the effect of these new projects on the value of

Frontier. McClure has gathered the following information on Frontier Corporation:

Current Year Forecasted for Next Year

Book value of debt

Market value of debt

Book value of shareholders' equity

Market value of shareholders' equity

$$50$

$$50$

$$62$

$$63$

$$55$

$$58$

$$210$

$$220$

The weights that McClure should apply in estimating Frontier's cost of capital for debt and equity

are, respectively:

Debt

Equity