Question

The purpose of this calculation question is for you to compute the fair value of the financial liabilities of XYZ Company. XYZ Company has only 1 financial liability. It is a non-callable publicly traded bond. Here are your facts to input into this question: Maturity value of the bond = $260,000,000 Coupon Rate for the bond is 5.38% paid semi-annually. Bond matures on the last day of the firm’s financial year. Last Financial Year end – the yield to maturity was 4.80% based on periodic compounding (not EAR) Last Financial Year end – bond had exactly 18 years to maturity This Year Financial Year end – the yield to maturity demanded by the market is 4.30% (based on doubling the periodic rate) Required: Compute the fair value of the bond to be reported on this year’s balance sheet. Round to the nearest dollar and do NOT include the dollar sign in your response.

Answer 1

Given

Face value of the bond(FV) = $260,000,000

Coupon paid Semiannual (pmt)= 260000000*5.38%/2

                                                = $6,994,000

Years to maturity = 18

Number of periods (nper)= 18*2 = 36

Market interest rate( Semiannual) = 4.30%/2 = 0.0215   

We can calculate fair value by using excel PV function:

Fair value = PV(rate,nper,pmt,pv,0)

                   = PV(0.0215,36,-6994000,-260000000)

                   = $294,939,142.87

Fair value to be reported on this year’s balance sheet = 294,939,143