In: Accounting
Formula sheet
| A | B | C | D | E | F | G | H | I | 
| 2 | ||||||||
| 3 | Par Value of Bond (P) | 10000 | ||||||
| 4 | Government Bond Yield | 0.038 | (Semi-annual) | |||||
| 5 | Spread for A rate bond | 140 | Basis points | |||||
| 6 | Time to maturity (n) | 5 | Years | |||||
| 7 | ||||||||
| 8 | Effective annual rate for government bond | =((1+D4/2)^2)-1 | =((1+D4/2)^2)-1 | |||||
| 9 | ||||||||
| 10 | Yield for corporate bond (y) | =D8+(D5/10000) | =D8+(D5/10000) | |||||
| 11 | ||||||||
| 12 | a) | |||||||
| 13 | ||||||||
| 14 | Price of zero coupon corporate bond | =Par Value / (1+y)n | ||||||
| 15 | =D3/((1+D8)^D6) | =D3/((1+D8)^D6) | ||||||
| 16 | ||||||||
| 17 | Hence purchase price of bond will be | =D15 | ||||||
| 18 | ||||||||
| 19 | b) | |||||||
| 20 | Price of Bond at the end of 5 year | =Par Value | ||||||
| 21 | =D3 | |||||||
| 22 | ||||||||
| 23 | Capital gain at the end of 5 year | =(Price at the end of 5 year - Purchase Price)/Purchase Price | ||||||
| 24 | =(D21-D17)/D17 | =(D21-D17)/D17 | ||||||
| 25 | ||||||||
| 26 | Hence capital gain | =D24 | ||||||
| 27 | ||||||||
| 28 | c) | |||||||
| 29 | ||||||||
| 30 | Yield | 0.044 | ||||||
| 31 | Time to maturity at the end of 4th year | =5-4 | Year | |||||
| 32 | ||||||||
| 33 | Price of Bond at the end of Year 4 | =Par Value / (1+y)n | ||||||
| 34 | =D3/((1+D30)^D31) | =D3/((1+D30)^D31) | ||||||
| 35 | ||||||||
| 36 | Capital gain at the end of 5 year | =(Price at the end of 5 year - Purchase Price)/Purchase Price | ||||||
| 37 | =(D34-D17)/D17 | =(D34-D17)/D17 | ||||||
| 38 | ||||||||
| 39 | Hence capital gain | =D37 | ||||||
| 40 | ||||||||