In: Finance
1]
The amount paid for the bond to earn 4.4% yield (YTM) compounded semiannually is calculated using PV function in Excel :
rate = 4.4% / 2 (converting annual rate into semiannual rate)
nper = 20 * 2 (total number of semiannual coupon payments = number of years * 2)
pmt = 1000 * 5.5% / 2 (semiannual coupon payment = face value * coupon rate / 2)
fv = 1000 (face value of bond receivable on maturity)
PV is calculated to be $1,145.31
2]
a]
Size of sinking fund payment is calculated using PMT function in Excel :
rate = 1.6% / 2 (converting annual rate earned on sinking fund into semiannual rate)
nper = 20 * 2 (total number of payments into sinking fund = number of years * 2)
pv = 0 (beginning amount in sinking fund is zero)
fv = 5,200,000 (ending amount required in sinking fund is $5.2 million)
PMT is calculated to be $110,822.36
b]
Total amount deposited into sinking fund = monthly deposit * total number of deposits = $110,822.36 * 40 = $4,432,894.51
c]
Amount of interest = ending value of sinking fund - Total amount deposited into sinking fund = $5,200,000 - $4,432,894.51 = $767,105.49