The Accounting Club recently issued $1,500,000 of 10- year, 9% bonds at an effective interest rate...

The Accounting Club recently issued $1,500,000 of 10- year, 9% bonds at an effective interest rate of 10%. Bond interest is payable annually.

Required:

Create a stright line amortization and effective interest schedule in excel. PLEASE SHOW THE FORMULAS THAT WERE USED TO CALCULATE EACH VALUE.

Amortization Schedule- Stright Line

Year Cash Paid Amortization Interest Exp. Disc./Prem Carrying Value

Amortization Schedule- Effective Interest Method

Year Cash Paid Amortization Interest Exp. Disc./Prem Carrying Value

Solutions

Expert Solution

The bonds were issued at a coupon rate of 9%, whereas the effective rate is 10%. This clearly means that the amount received via issuance of bonds will be lesser than its face value. So, we first need to calculate the amount received.

Formula: Bond Value = C*{[1-(1+(YTM))^-t/(YTM)] + [F / (1+ (YTM))^t]

Where,
B₀ = the bond price
C = the annual coupon payment, = $1,500,000 x 9% = $135,000
F = the face value of the bond, = $1,500,000
YTM = the yield to maturity on the bond, = 10%
t = the number of years remaining until maturity = 10

Bond Value = $135,000*{[1-(1+(0.10))^-10/(0.10)] + [$1,500,000 / (1+ (0.10))¹⁰] =$1,407,831.49

So, the amount received in the bond issue is $1,407,831.49

*Effective Interest Method Amortization Schedule*
Period	Opening	Interest	Payment	Closing	Discount
1	$1,407,831.49	$140,783.15	$135,000.00	$1,413,614.64	-$5,783.15
2	$1,413,614.64	$141,361.46	$135,000.00	$1,419,976.11	-$6,361.46
3	$1,419,976.11	$141,997.61	$135,000.00	$1,426,973.72	-$6,997.61
4	$1,426,973.72	$142,697.37	$135,000.00	$1,434,671.09	-$7,697.37
5	$1,434,671.09	$143,467.11	$135,000.00	$1,443,138.20	-$8,467.11
6	$1,443,138.20	$144,313.82	$135,000.00	$1,452,452.02	-$9,313.82
7	$1,452,452.02	$145,245.20	$135,000.00	$1,462,697.22	-$10,245.20
8	$1,462,697.22	$146,269.72	$135,000.00	$1,473,966.94	-$11,269.72
9	$1,473,966.94	$147,396.69	$135,000.00	$1,486,363.64	-$12,396.69
10	$1,486,363.64	$148,636.36	$135,000.00	$1,500,000.00	-$13,636.36

Formulas to create amortization

Interest = Opening Balance*10%
Payment = $1,500,000*9% = $135,000
Closing Balance = Opening Balance + Interest – Payment
Discount = Payment – Interest

Straight-Line Method Amortization Schedule
Period	Opening	Interest	Payment	Closing	Discount
1	$1,407,831.49	$140,783.15	$135,000.00	$1,413,614.64	$9,216.85
2	$1,413,614.64	$141,361.46	$135,000.00	$1,419,976.10	$9,216.85
3	$1,419,976.10	$141,997.61	$135,000.00	$1,426,973.71	$9,216.85
4	$1,426,973.71	$142,697.37	$135,000.00	$1,434,671.08	$9,216.85
5	$1,434,671.08	$143,467.11	$135,000.00	$1,443,138.19	$9,216.85
6	$1,443,138.19	$144,313.82	$135,000.00	$1,452,452.01	$9,216.85
7	$1,452,452.01	$145,245.20	$135,000.00	$1,462,697.21	$9,216.85
8	$1,462,697.21	$146,269.72	$135,000.00	$1,473,966.93	$9,216.85
9	$1,473,966.93	$147,396.69	$135,000.00	$1,486,363.63	$9,216.85
10	$1,486,363.63	$148,636.36	$135,000.00	$1,499,999.99	$9,216.85

Formulas to create amortization

Interest = Opening Balance*10%
Payment = $1,500,000*9% = $135,000
Closing Balance = Opening Balance + Interest – Payment
Discount = ($1,500,000 - $1,407,831.49)/10 = $9,216.85

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

On July 1, Hanover Company issued $2,000,000 of 10-year, 6% bonds at an effective interest rate...

On July 1, Hanover Company issued $2,000,000 of 10-year, 6% bonds at an effective interest rate of 5%. This netted the company $2,154,435. Interest on the bonds is payable annually on July 1. The president of Hanover has asked you to develop an amortization schedule worksheet (file name AMORT) that will use the effective interest method to calculate annual interest expense, premium (or discount) amortization, unamortized premium (or discount), and bond carrying amount. Your worksheet should include a Data Section....

On 1/1/10, R-U Ready issued $100,000, 6.5%, 10-year bonds at an effective rate of 4.75%. Interest...

On 1/1/10, R-U Ready issued $100,000, 6.5%, 10-year bonds at an effective rate of 4.75%. Interest is paid annually on 12/31 of each year. Edit: Present the accounts and dollar amounts that would appear on comparative balance sheets and income statements for the years ending 12/31/16 and 12/31/15.

Bonds Issued at a Discount (Effective Interest) Sicily Corporation issued $1,550,000 in 10% bonds (payable on...

Bonds Issued at a Discount (Effective Interest) Sicily Corporation issued $1,550,000 in 10% bonds (payable on December 31, 2029) on January 1, 2020, for $1,457,000. Interest is paid on June 30 and December 31. The market rate of interest is 11%. Required: Prepare the amortization table through December 31, 2021, using the effective interest rate method. If an amount box does not require an entry, leave it blank and if the answer is zero, enter "0". If required, round your...

Assume the effective interest method in accounting for these bonds. Build a 10 year amortization table....

Assume the effective interest method in accounting for these bonds. Build a 10 year amortization table. Bond $650,000 Mature 10 years State annual interest 9.25% Effective annual rate 6% Interest is paid every 6 months

Weismann Co. issued 9-year bonds a year ago at a coupon rate of 10 percent. The...

Weismann Co. issued 9-year bonds a year ago at a coupon rate of 10 percent. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 7 percent, what is the current bond price? Multiple Choice $714.05 $1,427.29 $1,181.41 $1,119.12 $1,191.41

Solderman Company issued $520,000, 7%, 10-year bonds for $432,800 with a market rate of 9%. The...

Solderman Company issued $520,000, 7%, 10-year bonds for $432,800 with a market rate of 9%. The effective interest method of amorization is used and interest is paid annually. the journal entry on the first interest payment date would include a: A) credit to interest expense of $36400 B) credit to interest expense of $38952 C)credit to cash of $36400 D)Credit to cash of 38,952

Cornerstone Exercise 9-38 Bonds Issued at a Premium (Effective Interest) Charger Battery issued $200,000 of 11%,...

Cornerstone Exercise 9-38 Bonds Issued at a Premium (Effective Interest) Charger Battery issued $200,000 of 11%, 7-year bonds on January 1, 2020, for $220,132. Interest is paid annually on December 31. The market rate of interest is 9%. Required: Prepare the journal entries for December 31, 2021 and 2022. If required, round your answers to the nearest whole dollar. (Show your work)

Toys Co. issued 10-year bonds a year ago at a coupon rate of 10%. The bonds...

Toys Co. issued 10-year bonds a year ago at a coupon rate of 10%. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 9%, what is the current bond price?

JRJ Corporation recently issued 10-year bonds at a price of $1,000. These bonds pay $89 in interest each six months.

JRJ Corporation recently issued 10-year bonds at a price of $1,000. These bonds pay $89 in interest each six months. Their price has remained stable since they were issued, i.e., they still sell for $1,000. Due to additional financing needs, the firm wishes to issue new bonds that would have a maturity of 16 years, a par value of $1,000, and pay $69 in interest every six months. If both bonds have the same yield, how many new bonds must...

Starbucks recently issued 10-year, $1,000 par value bonds at an 10% coupon rate.. Two years later,...

Starbucks recently issued 10-year, $1,000 par value bonds at an 10% coupon rate.. Two years later, similar bonds are yielding investors 8%. At what price are Starbucks bonds selling? What would the bonds be selling for if yields had risen to 10%?

Subjects