1. Compute market price of bonds. Provide detailed computation. Use functions in Excel 2. What is an amount of discount /premium? Indicate, what it is (discount or premium). Computation. 3. Prepare amortization schedule for first 5 years. Use formulas in Excel. 4. Prepare journal entry to record bond issue. 5. Prepare journal entry on July 1, 2020. 5. Prepare journal entry on December 31, 2020. 7. Prepare journal entry on January 1, 2021

1. Compute market price of bonds. Provide detailed computation. Use functions in Excel 2. What is an amount of discount /premium? Indicate, what it is (discount or premium). Computation. 3. Prepare amortization schedule for first 5 years. Use formulas in Excel. 4. Prepare journal entry to record bond issue. 5. Prepare journal entry on July 1, 2020. 5. Prepare journal entry on December 31, 2020. 7. Prepare journal entry on January 1, 2021

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

See similar textbooks

Similar questions

2. complete the amoritzation table by calculating interest expense, beginning & ending bond carrying amounts at the end of each period, please show work & formulas used.
Compute bond proceeds, amortizing discount by interest method, and interest expense Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $80,000,000 of five-year, 9% bonds at a market (effective) interest rate of 11%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet Compute the following: a. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $ b. The amount of discount to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ c. The amount of discount to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ d. The amount of the bond interest expense for the first…
5 0 V File C13 123456 7 89 Home 18 19 20 Insert Arial X ✓ fx Face amount of bonds Contract rate of interest Draw Term of bonds, years Market rate of interest Interest payment Page Layout く 10 Formulas DATA B ✓ ✓ V Data A B C Compute bond proceeds, amortizing discount by interest method, and interest expense Av $80,000,000 9% 5 11% Semiannual Review Amount ... View Ev ab ≡く D Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (C13:C16) into the appropriate fields in CNOWv2 10 for gradina. 11 12 13 a. PV of cash proceeds 14 b. Discount amortized for the 1st interest payment period 15 c. Discount amortized for the 2nd interest payment period 16 d. Interest expense for the 1st year 17 Help Formulas Editing ✓ Currency E $ 500 ✓ C →>>
Donna Clark Company issued $612,000 of 9%, 20-year bonds on January 1, 2025, at 101. Interest is payable semiannually on July 1 and January 1. Clark Company uses the straight-line method of amortization for bond premium or discount. Prepare the journal entries to record the following.
Sheridan Inc. is building a new hockey arena at a cost of $2,150,000. It received a down payment of $430,000 from local businesses to support the project, and now needs to borrow $1,720,000 to complete the project. It therefore decides to issue $1,720,000 of 10- year, 10.5% bonds. These bonds were issued on January 1, 2023, and pay interest annually on each January 1. The bonds yield 10.5% to the investor and have an effective interest rate to the issuer of 10.40530%. (There is an increased effective interest rate due to the capitalization of the bond issue costs.) Any additional funds that are needed to complete the project will be obtained from local businesses. Sheridan paid and capitalized $43,000 in bond issuance costs related to the bond issue. Sheridan prepares financial statements in accordance with IFRS.
iRequirements 1. Journalize Andersen Brothers's transactions related to the bonds for 2018. 2. Journalize the entry required on the Thomson bonds maturity date. (Assume the last interest payment has already been recorded.) Print Done
How to find accrued interest on bonds payable for just March 2018 info on bonds payable- 6%, interest payment dates May 1 and Nov 1, due May 2036; balance per ledger is 10,000,000
The first semiannual interest payment on December 31, Year 1, and the amortization of the bond premium, using the straight-line method. Round to the nearest dollar. a. Bonds Payable b. The interest payment on June 30, Year 2, and the amortization of the bond premium, using the straight-line method. Round to the nearest dollar. 3. Determine the total interest expense for Year 1. Round to the nearest dollar. 4. Will the bond proceeds always be greater than the face amount of the bonds when the contract rate is greater than the market rate of interest? 5. Compute the price of $65,332,160 received for the bonds by using Present value at compound interest, and Present value of an annuity. Round to the nearest dollar. Your total may vary slightly from the price given due to rounding differences. Present value of the face amount Present value of the semiannual interest payments
An accounting example: Otter Products inc issued bonds on January 1, 2019. Interest to be paid semi-annually. Term in years is 2; Face value of bonds issued is $200,000; Issue Price $206,000; Specified Interest Rate each payment period is 6% Question. Calculate a. the amount of interest paid in cash every payment period. b. The amount of amortization to be recorded at each interest payment date (use straight-line method) c. complete amoritzation table by calculating interest expense and beginning and ending bond carrying amounts at the each period over 2 years. The term is for 2 years however 3 years is showing on the workbook. How do I calcuate the 3rd year if the problem only says the term is 2 years?
Bond (Held-to-Maturity)Investment Journalize the entries to record the following selected bond investment transactions for Marr Products: If an amount box does not require an entry, leave it blank. D.) Received face value of remaining bonds at their maturity. Cash- Investments- Hotline Inc. Bonds- I just need help with part D, Thanks!
Compute bond proceeds, amortizing discount by interest method, and interest expense Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $80,000,000 of five-year, 9% bonds at a market (effective) interest rate of 11%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet Compute the following: a. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $ b. The amount of discount to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ 73,969,806 X $ c. The amount of discount to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. 468,339 X $ 442,581 X d. The amount of the bond…
Please do not give solution in image format ? And Fast answering please and explain proper steps by Step.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

SEE MORE TEXTBOOKS