Please find 1) Interest expense 2) cash paid 3) bonds payable Required information P10-6 (Algo) Recording and Reporting Bonds Issued at a Discount LO10-4 [The following information applies to the questions displayed below.] PowerTap Utilities is planning to issue bonds with a face value of $2,100,000 and a coupon rate of 9 percent. The bonds mature in 10 years and pay interest semiannually every June 30 and December 31. All of the bonds were sold on January 1 of this year. PowerTap uses the effective-interest amortization method. Assume an annual market rate of interest of 10 percent. (FV of $1. PV of $1. FVA of $1. and PVA of $1) (Use the appropriate factor(s) from the tables provided.) P10-6 Part 1 Required: 1. What was the issue price on January 1 of this year? (Round your final answers to nearest whole dollar amount.) Issue price $ 2,100,000

Please find 1) Interest expense 2) cash paid 3) bonds payable Required information P10-6 (Algo) Recording and Reporting Bonds Issued at a Discount LO10-4 [The following information applies to the questions displayed below.] PowerTap Utilities is planning to issue bonds with a face value of $2,100,000 and a coupon rate of 9 percent. The bonds mature in 10 years and pay interest semiannually every June 30 and December 31. All of the bonds were sold on January 1 of this year. PowerTap uses the effective-interest amortization method. Assume an annual market rate of interest of 10 percent. (FV of $1. PV of $1. FVA of $1. and PVA of $1) (Use the appropriate factor(s) from the tables provided.) P10-6 Part 1 Required: 1. What was the issue price on January 1 of this year? (Round your final answers to nearest whole dollar amount.) Issue price $ 2,100,000

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

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!
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…
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
Waterway Ltd. issued a $1,062,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 Waterway 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 ANNUITY OF 1 (Round present value factor calculations to 5 decimal places, eg. 1.25124 and final answers to 0 decimal places eg. 58,971.) Proceeds from sale of bond on bond Date $ $ Prepare the journal entries for above transactions. (Round answers to O 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 O for the amounts.…
Kingbird Ltd. issued a $778,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 Kingbird 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 O decimal places e.g. 58,971.) Proceeds from sale of bond on bond Prepare the journal entries for above transactions. (Round answers to O 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 O for the…
Kingbird Ltd. issued a $778,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 Kingbird 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, eg. 1.25124 and final answers to O decimal places eg. 58,971.) Proceeds from sale of bond on bond Date $ 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 O for the…
BlueLtd. Issued a $1,164,000, 10-year bond dated January 1, 2020. 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 Blue 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 tactor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITYOF 1 (For calculation purposes, use 5 decimal places as displayed in the factor table provided and final answers to 0 decimal places, e.g. 5,275.) Proceeds from sale of bond : 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…
On January 1, Nic Inc. issued $100,000 of ten-year, 10% bonds that pay interest semiannually on June 30 and 31st. The bonds are sold to yield 8%. A. Using the information provided in this problem, as well as your time value of money tables to calculate the issue price of the bond. B. Was the bond issued at a premium or a discount, explain your answer.
Your company issues $3,500,000 bonds at 7% interest with annual interest payments. Bonds have a maturity date in 30 years. At the time of issue, the market rate is 5%. а. Calculate the issue price of the bond. b. Record the journal entry for the issue of the bond С. Record the journal entry for the first interest payment d. How much interest is recorded on the income statement in Year 1? е. Record the journal entry for the final entry at the bond maturity date.
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.
Wildhorse Ltd. issued a $1,159,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 Wildhorse 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 O decimal places e.g. 58,971.) Proceeds from sale of bond on bond Date $ $ Prepare the journal entries for above transactions. (Round answers to O 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 O…