On January 2, Year 1, the Lyndhurst Company Inc. a privately-held company, issued $1,000,000, five-year, 10% bonds, dated January 2, Year 1. The bonds provided for semiannual interest payments to be made on June 30 and December 31 of each year. Terms of the bond indenture allowed the company to call the bonds at 102 after one year. The bonds were issued when the market interest rate was 8%. Lyndhurst uses the effective interest method for amortizing bond discounts and premiums. The bonds are term bonds that mature on December 31, Year 5. Lyndhurst's fiscal year for financial reporting purposes is December 31. • The company called the bonds at 102 on June 30, Year 2. Use the following spreadsheet to calculate the present values of the principal and interest cash flows related to the bonds, and the resulting bond issue price. For each shaded cell in columns B, C, and D, enter the appropriate figures in the shaded cells. For cells C2 and C3, enter the amortization interest rate (as a decimal). For column E, find the appropriate time value factors in the references located in the "Resources" tab and enter those into the shaded cells. The spreadsheet will automatically calculate the bond issue price based on your entries (cell F4). X✔ fx A Payment Type 2 Principal 3 Interest 4 Bond Issue Price Compounding Period(s) C Interest Rate D Payment Amount E Factor Present Value $0 $0 $0
On January 2, Year 1, the Lyndhurst Company Inc. a privately-held company, issued $1,000,000, five-year, 10% bonds, dated January 2, Year 1. The bonds provided for semiannual interest payments to be made on June 30 and December 31 of each year. Terms of the bond indenture allowed the company to call the bonds at 102 after one year. The bonds were issued when the market interest rate was 8%. Lyndhurst uses the effective interest method for amortizing bond discounts and premiums. The bonds are term bonds that mature on December 31, Year 5. Lyndhurst's fiscal year for financial reporting purposes is December 31. • The company called the bonds at 102 on June 30, Year 2. Use the following spreadsheet to calculate the present values of the principal and interest cash flows related to the bonds, and the resulting bond issue price. For each shaded cell in columns B, C, and D, enter the appropriate figures in the shaded cells. For cells C2 and C3, enter the amortization interest rate (as a decimal). For column E, find the appropriate time value factors in the references located in the "Resources" tab and enter those into the shaded cells. The spreadsheet will automatically calculate the bond issue price based on your entries (cell F4). X✔ fx A Payment Type 2 Principal 3 Interest 4 Bond Issue Price Compounding Period(s) C Interest Rate D Payment Amount E Factor Present Value $0 $0 $0
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter9: Long-term Liabilities
Section: Chapter Questions
Problem 15MCQ
Related questions
Concept explainers
Question
Transcribed Image Text:On January 2, Year 1, the Lyndhurst Company Inc. a privately-held company, issued $1,000,000, five-year, 10% bonds, dated January 2, Year 1. The bonds provided for semiannual interest payments to be made on June 30 and
December 31 of each year. Terms of the bond indenture allowed the company to call the bonds at 102 after one year. The bonds were issued when the market interest rate was 8%.
Lyndhurst uses the effective interest method for amortizing bond discounts and premiums.
The bonds are term bonds that mature on December 31, Year 5.
. Lyndhurst's fiscal year for financial reporting purposes is December 31.
The company called the bonds at 102 on June 30, Year 2.
Use the following spreadsheet to calculate the present values of the principal and interest cash flows related to the bonds, and the resulting bond issue price. For each shaded cell in columns B, C, and D, enter the appropriate figures
in the shaded cells. For cells C2 and C3, enter the amortization interest rate (as a decimal). For column E, find the appropriate time value factors in the references located in the "Resources" tab and enter those into the shaded cells.
The spreadsheet will automatically calculate the bond issue price based on your entries (cell F4).
X✔ fx
A
1
Payment Type
2 Principal
3 Interest
4 Bond Issue Price
B
Compounding
Period(s)
C
Interest Rate
D
Payment
Amount
E
Factor
F
Present Value
$0
$0
SO
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College