Question

In: Accounting

Prepare amortization schedule for the bond issuances. Note interest is semi- annual for the coupon bonds...

Prepare amortization schedule for the bond issuances. Note interest is semi- annual for the coupon bonds and you may assume annual for the zero- coupon bonds. ABC Co. issued $3,527 million face value, 20-year, zero coupon bonds on July 1, 2017 that mature June 30, 2037 for a cash price of $2,619 million. The effective market interest rate at issuance was 1.5%. Amounts shown in millions.

Solutions

Expert Solution

Periods Opening book value of bond (1) Interest expense (2) (1 x 1.5%) Interest paid (3) Closing book value of bonds (1 + 2 - 3)
1             2,619.00                   39.29                          -                 2,658.29
2             2,658.29                   39.87                          -                 2,698.16
3             2,698.16                   40.47                          -                 2,738.63
4             2,738.63                   41.08                          -                 2,779.71
5             2,779.71                   41.70                          -                 2,821.41
6             2,821.41                   42.32                          -                 2,863.73
7             2,863.73                   42.96                          -                 2,906.68
8             2,906.68                   43.60                          -                 2,950.28
9             2,950.28                   44.25                          -                 2,994.54
10             2,994.54                   44.92                          -                 3,039.46
11             3,039.46                   45.59                          -                 3,085.05
12             3,085.05                   46.28                          -                 3,131.32
13             3,131.32                   46.97                          -                 3,178.29
14             3,178.29                   47.67                          -                 3,225.97
15             3,225.97                   48.39                          -                 3,274.36
16             3,274.36                   49.12                          -                 3,323.47
17             3,323.47                   49.85                          -                 3,373.33
18             3,373.33                   50.60                          -                 3,423.93
19             3,423.93                   51.36                          -                 3,475.28
20             3,475.28                   52.13                          -                 3,527.41

The cash value of the bonds should be multiplied with the effective interest rate year on year to arrive at the face value of the bonds, that will be paid at the end of the period of bond. No interest would be actually paid since the bond carry's zero coupon


Related Solutions

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest...
Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?
A full amortization schedule for a note that is payed monthly (Interest and principle). The time...
A full amortization schedule for a note that is payed monthly (Interest and principle). The time frame is 5 years=60 months, the Interest Rate=5%, the Note is for $75,000.
A $5000 semi-annual coupon bond paying interest at 12.4%/year compounded semi-annually is redeemable at par in...
A $5000 semi-annual coupon bond paying interest at 12.4%/year compounded semi-annually is redeemable at par in 16 years. It is callable at 115 at the end of 8 years and at 111 at the end of 11 years. Determine the price to guarantee a yield rate of 13.4%/year compounded semi-annually.
You have two bonds (A and B) with a (modified) duration of 4.3. Bond A is a coupon bond with a semi-annual coupon of SEK 75 and Bond B is a zero coupon bond.
You have two bonds (A and B) with a (modified) duration of 4.3. Bond A is a coupon bond with a semi-annual coupon of SEK 75 and Bond B is a zero coupon bond.a) How much does the value of each bonds change if the interest rate changes by 0.1%-unit.b) What is the time to maturity for the zero coupon bond?c) Which bond has the longest time to maturity?d) Calculate the accrued interest of the coupon bond if you buy...
how to create an amortization schedule for bonds that are sold at a premium ($1,000 bond...
how to create an amortization schedule for bonds that are sold at a premium ($1,000 bond is sold for more than $1,000). given facts about a bond sold at a premium, someone should be able to follow your instructions and produce an amortization schedule
You have two bonds to choose from with semi-annual coupon payments: Bond A Bond B Time...
You have two bonds to choose from with semi-annual coupon payments: Bond A Bond B Time to maturity (years) 5 6 Annual yield to maturity 4.00% 4.00% Annual coupon payment 40.00 65.94 Current price -1000 -1000 Face value 1000 826.02 So we start with two bonds of equal price ($1000) and annual yield to maturity (4.00%). A) What is the Macaulay duration (in years) for Bond A? B) What is the Macaulay duration (in years) for Bond B? C) Which...
Consider the following two bonds. One bond with a coupon rate of 6%, semi-annual coupons, and...
Consider the following two bonds. One bond with a coupon rate of 6%, semi-annual coupons, and 20 years until maturity. The second bond has 10 years until maturity but is otherwise the same. a. What is the most you should pay for each asset if current yields are 7%? b. Do the bonds sell at a premium or a discount? c. Suppose current yields increase to 8%, what are the new bond prices? d. Which bond is more sensitive to...
For a semi-annual coupon bond with 3 years to maturity, an annual coupon of 8% (paid...
For a semi-annual coupon bond with 3 years to maturity, an annual coupon of 8% (paid 4% each six-month period), and a current yield to maturity of 4.5%, What is the Macauley duration of this bond? What is the modified duration of this bond? An investor owns $100M (market value or price NOT face or par) of these bonds, what is the Dollar Duration of this position? What is the price elasticity of this bond for a 1bp increase in...
a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and...
a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and the loan calls for equal payments. How much interest is paid in the fifth year? How much interest is paid over the life of the loan? b)What is the present value of $2,625 per year at a discount rate of 8%, if the first payment is received six years from now and the last payment is received 20 years from now?
3. A $1,000 par bond has a 5% semi-annual coupon and 12 years to maturity. Bonds...
3. A $1,000 par bond has a 5% semi-annual coupon and 12 years to maturity. Bonds of similar risk are currently yielding 6.5%. a. What should be the current price of the bond? b. If the bond’s price five years from now is $1,105, what would be the yield to maturity for the bond at that time? c. What will the price of this bond be 1 year prior to maturity if its yield to maturity is the same as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT