Insturction: Input the excel formulae/ function for the green cell so it will show the numerical answer.

Input Area: Shares outstanding Market price per share $ Book value per share $ Bond (1) par value $ Coupon rate % of par Maturity Bond (I) par value Coupon rate % of par Maturity 3,900,000 84 11 65,000,000 6.30% 98 20 50,000,000 5.80% 97 12 Output Area: a. BV(E) BV(D) V $ 42,900,000 $ 115,000,000 $ 157,900,000 EN DN b. MV(E) MV(D) V $ $ $ 327,600,000 112,200,000 439,800,000 EN DV The market value weights are more relevant because they represent a more current valuation of the debt and equity