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
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education