Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2021, Kaplan, Inc., issues $600.000 of 9% bonds that pay interest semiannually and mature in 10 years (December 31, 2031). a. Using the Excel PV worksheet function, compute the issue price assuming that the bonds' market rate is 8% per year compounded semiannually. (Refer to Appendix A for illustration.) Round answer to two decimal places. Issue price $0 x b. Prepare an amortization table in Excel to demonstrate the amortization of the book (carrying) value to the $600.000 maturity value at the end of the 20th semiannual period. (Refer to Appendix A for illustration.) The amortization schedule can be completed using the following Excel template: Amortization Schedule Using the figures from the amortization schedule created in Excel, complete the amortization schedule below for 2022 Enter answers using two decimal places. Beginning balance Date Period 0 1/1/22 6/30/22 1 $ 27,000 x s 12/31/22 2 0x Payment 27,000 $ 27,000 ✓ Interest Premium amortization 0x s 0x 0x ox S Premium balance 24,000 x $ 0x 0 x Book value 0x 0x 0x

Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2021, Kaplan, Inc., issues $600.000 of 9% bonds that pay interest semiannually and mature in 10 years (December 31, 2031). a. Using the Excel PV worksheet function, compute the issue price assuming that the bonds' market rate is 8% per year compounded semiannually. (Refer to Appendix A for illustration.) Round answer to two decimal places. Issue price $0 x b. Prepare an amortization table in Excel to demonstrate the amortization of the book (carrying) value to the $600.000 maturity value at the end of the 20th semiannual period. (Refer to Appendix A for illustration.) The amortization schedule can be completed using the following Excel template: Amortization Schedule Using the figures from the amortization schedule created in Excel, complete the amortization schedule below for 2022 Enter answers using two decimal places. Beginning balance Date Period 0 1/1/22 6/30/22 1 $ 27,000 x s 12/31/22 2 0x Payment 27,000 $ 27,000 ✓ Interest Premium amortization 0x s 0x 0x ox S Premium balance 24,000 x $ 0x 0 x Book value 0x 0x 0x

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter10: Long-term Liabilities

Section: Chapter Questions

Problem 10.1AP

See similar textbooks

Similar questions

On January 1, 2018, Wawatosa Inc. issued 5-year bonds with a face value of $200,000 and a stated interest rate of 12% payable semi-annually on July 1 and January 1. The bonds were sold to yield 10%. Assuming the bonds were sold at 107.732, what is the selling price of the bonds? Were they issued at a discount or a premium?
North Co. Issued bonds on July 1, 2018 worth $100,000 with a coupon rate of 10% and an effective interest rate of 8%. Interest is paid annually, every July 1, and bonds mature after 5 years. Required: PV of Bonds: Calculation PV of Principal and PV of Interest and give your explanation about your calculation! Make issuance journal and please explain about the journal! Amortization: Calculation Bond Amortization Table and explain the result! Make Interest adjustment, amortization journal, and explain about the journal! Make Interest payment journal, amortization, and explain about the journal! Journalize Redemption at maturity and explain about the journal!
1. On January 1, 2024, Lansing Group issued $1,000,000 of 6% bonds, dated January 1. Interest is payable semiannually on June 30 and December 31. The bonds mature in five years. The market yield for bonds of similar risk and maturity is 8%. INSTRUCTIONS: 1. Determine the price of these bonds that are issued to yield the 8% market rate using the Time Value of Money Tables. Include the table and relevant components for each factor used. 2. Record the issuance of these bonds by Lansing Group. 3. Prepare an amortization schedule that determines interest at the effective rate through the maturity date of the bonds. 4. Prepare the entries to record the interest on June 30, 2024, and December 31, 2024. 5. Assume that Lansing Group retires the bonds on January 1, 2026, paying $1,027,544. Prepare the entry to record the retirement.
tELLiy, you must enter your ID number on the first sheet! On January 1, 2020 Omsk Corporation issued Bonds pay interest each July 1 and January 1. 150,000 of 5 % bonds, due in 17 years 12 % market rate of interest. Assume Requirements (Round to 0 decimals, Rounding errors do not matter): 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. 6. Prepare journal entry on December 31, 2020. 7. Prepare journal entry on January 1, 2021
Hey, can I please be helped with the following task and please show calculations on how you got the answers On April 1, 2018 client federline corp. Issued 20-year, 6% bonds with a face value of $8,000,000 at 96 as the market rate at the time was 7%. Interest is to be paid semi-annually. -make the journal entries for: April 1, 2018(the bond issue date) september 30, 2018(first interest payment date assume the straight line Amortization method has been used) September 30, 2018( assume the effective interest method has been used) dec 31, 2018 (the adjusting entry assuming the straight-line method has been used) dec 31, 2018 (the closing entry assuming straight line has been used) Assume the details expect that the bond was issued at 105 to yield an effective interest rate of 5%. Cowell company issued a $6000,000, 10%, 20-year bond at 94 on january 1, 2005. On January 1, 2018 Cowell recalled the entire bond issue at 103. -Make the journal entry for jan 1, 2018 assuming the straight-line…
Use the paper copy of the Present Value Tables, provided on Canvas, to answer the following question Williams Company issued 200 of its B, $1,000, 5-year bonds on January 1, 2023. On that date, the market rate of interest was 12%. The bonds pay interest quarterly How much would an investor pay for this bond? Select one O a $150,000 Ob $170,308 O C$150,066 d $114129 e $107.973 O Previous Save Answers Next O et Selfle Perem 2023-10 Screensh 2023-104 reenshot 03.03 PM eenshot 00.32 PM
← The Airfoil Aircraft Company has issued 5% convertible bonds that mature October 1, 2029. Suppose the bonds are issued October 1, 2021, and pay interest each April 1 and October 1. (Click the icon to view the bond data.) Read the requirements. Requirement 1. Assume the bonds are issued at a price of 93.4. Using the straight-line method of amortization for bond discount: a. Calculate interest expense on bonds payable for each semiannual interest payment period. Use two decimal places. (Round intermediary and final calculations to the nearest cent.) The total interest expense each interest period if the bonds are issued at 93.4 is
Metlock Ltd. issued a $791,000, 10-year bond dated January 1, 2023. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Metlock followed IFRS. Using 1. factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ORDINARY ANNUITY OF 1. (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places e.g. 58,971.) Proceeds from sale of bond Discount on bond Prepare the journal entries for above transactions. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the…
Assume that on January 1, 2021, Water World issues $200,000 of 9% bonds, due in 10 years, with interest payable semiannually on June 30 and December 31 each year.Required:1. If the market rate is 9%, the bonds will issue at $200,000. Record the bond issue on January 1, 2021, and the first two semiannual interest payments on June 30, 2021, and December 31, 2021.2. If the market rate is 10%, the bonds will issue at $187,538. Record the bond issue on January 1, 2021, and the first two semiannual interest payments on June 30, 2021, and December 31, 2021.3. If the market rate is 8%, the bonds will issue at $213,590. Record the bond issue on January 1, 2021, and the first two semiannual interest payments on June 30, 2021, and December 31, 2021.
Temptation Vacations issues $60 million in bonds on January 1, 2021, that pay interest semiannually on June 30 and December 31. Portions of the bond amortization schedule appear below:Required:1. Were the bonds issued at face amount, a discount, or a premium?2. What is the original issue price of the bonds?3. What is the face amount of the bonds?4. What is the stated annual interest rate?5. What is the market annual interest rate?6. What is the total cash paid for interest assuming the bonds mature in 20 years?
With this information how would i make a journal entry for this situation Issued $75,000 of 6% term bonds due on January 1, 2025 (10 periods), with interest payable each June 30 and December 31. Investors require an effective interest rate of 8%. Record the entries for the issuance of the bond and Book the interest payment and amortization on the discount for the bond.
On January 1, 2020, XYZ Co. issued 8-year bonds with a face value of $1,500,000 and a stated (nominal) interest rate of 6%, payable semiannually on June 30 and December 31. The bonds were sold to yield 4%. : Instructions (a) Calculate the selling price of the bonds payable. HINT: You will need to look up the appropriate discount values in the present value tables (b) Prepare the interest amortization table for 2020 only, assuming that amortization is recorded on interest payment dates.