Please answer with detailed calculations and good formatting and make sure the answer is 100% correct, else leave it for the other tutor to answer. Otherwise i will downvote the answer and report it for uprofessionalism for sure. Please don't use AI or Chat GPT also make sure there is no plagiari.sm. Requirements1.2.Use the PV function in Excel to calculate the issue price of the bonds.Prepare a bond amortization table for the first four semiannual interestperiods.3. Record the issuance of bonds payable on June 30, 2021; the payment ofinterest on December 31, 2021; and the payment of interest on June 30,2022.-X On June 30, 2021, the market interest rate is 5%. Champ Corporation issues $650,000 of 10%, 30-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bondpremium using the effective-interest method.Read the requirements.Requirement 1. Use the PV function in Excel to calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.)The issue price of the bonds is

The bond can be issued at a coupon rate greater than the market interest rate. The bonds have an…

On June 30, 2021, the market interest rate is 5%. Champ Corporation issues $650,000 of 10%, 30-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. Read the requirements. (...)

On June 30, 2021, the market interest rate is 5%. Champ Corporation issues $650,000 of 10%, 30-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. Read the requirements. (...)

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter13: Long-term Liabilities

Section: Chapter Questions

Problem 4EA: On January 1, 2018, Wawatosa Inc. issued 5-year bonds with a face value of $200,000 and a stated...

See similar textbooks

Related questions

Q: help please answer in text form with proper workings and explanation for each and every part and…

A: The correct option is : A) Open/Closed Principle Reason : The Open/Closed Principle (OCP) is a…

Q: On the 1st of January 2014, Peck PLC purchased a building for £2m which at the time of purchase was…

A: Depreciation means the amount of normal wear or tear of the assets due to usage or passage of time.…

Q: This answer is incorrect I even sent you a screenshot showiung you equipment is not right you sent…

A: Equipment is the type of asset which falls to company or any non-profit organisation under the fixed…

Q: Required: 1. & 2. Indicate below whether each item is a separate performance obligation and allocate…

A: Statement showing the separate performance obligation and allocation of transaction price:…

Q: Which of the following are examples of how IP can be commercialised? (you may tick more than one…

A: Answer:Licensing and franchising are examples of how intellectual property (IP) can be…

Q: Brief Exercise 7-18 (Algo) Account for the exchange of long-term assets (LO7-6) China Inn and…

A: As per IAS 16, Property, plant and Equipment, The asset acquired in exchange for another asset is…

Q: Wildhorse Company uses the allowance method for estimating uncollectible accounts. Prepare journal…

A: The journal entries are prepared to record the transactions on regular basis. The allowance for…

Q: 5 Position Type 6 Executives 7 Managers 8 Professionals 9 Interim 10 Total 11 12 Percentage per…

A: In the given case, the monthly contribution of sales in total sales is calculated. In other words,…

Q: Why use categories? Select one: They help you find and sort e-mails later on. They look good, but…

A: In the context of emails, categories are used to organize and manage emails effectively. They are…

Q: Errors in Inventory Counts The following information was taken from the records of Taylor…

A: Inventory: It refers to the items held by an organization which were in various forms like raw…

Q: What does internal rate of return (IRR) help you to determine

A: Internal Rate of Return (IRR) is a financial metric used to evaluate potential profitability of an…

Q: IFRS16 allows lessees not to recognise a right-of-use asset or a lease liability for certain types…

A: The right-of-use asset is a lessee's right to use an asset over the life of a lease. It is recorded…

Q: Use both the TVM equations and a financial calculator to find the following values. (Hint: If you…

A: Financial management consists of directing, planning, organizing and controlling of financial…

Q: S1: Audit debriefing process should be led by the audit manager. S2: An audit benefits the public.…

A: Audit debriefing process relates to the review of the results of the audit so that the process may…

Q: Please solve this accounting question

A: Step 1: Introduction to the Absorption CostingAbsorption costing is a cost accounting method that…

Q: User acceptance testing is more important in an object-oriented development process than in a…

Q: Match the two lists, below, by placing the capital letter from List 1 in each of the cells preceding…

A: Control Environment A control environment is made up of the standards, policies, procedures, and…

Q: Please give me an example of the relationship between two entities? Please don't use the student and…

A: The objective of this question is to provide an example of a relationship between two entities in a…

Q: For each of the following file processing operations, indicate whether a sequential file, indexed…

A: Definition: Access Method: Access method is the method by which data stored in the database can be…

Q: Alice bought $P worth of shares in a start-up company. She created the following scenarios with the…

A: Share investments represents buying a portion of equity in a company. We buy shares of a company…

Q: Which of the following is a situation that might call for an indirect strategy? Check all that…

A: strategy is considered to be important part of an organisations which help the organisation to…

Q: You overheard a friend at a party say that computers and information technology will greatly…

A: Auditors:- The auditor is the person who verifies, check, and examine the company's accounts and…

Q: An initial $700 compounded for 10 years at 4%. $ An initial $700 compounded for 10 years at 8%.…

A: “Since you have posted a question with multiple subparts, we will solve first three subparts for…

Q: Which of the following defines iterative calculation?

A: SPREADSHEET

Q: Make sure to calculate the NPV correctly! The previous answer was wrong!

A: Net Present Value: It represents the present value of a project after taking into account all cash…

Concept explainers

Capital Gain

Any capital asset when sold can give the seller a higher or lower price from its purchase price leading to a capital gain or capital loss. The time period of holding an asset is decided based on if it is a long term or short-term capital gain. On that basis, the rate of taxation is decided if it is 20%, 15% or according to the tax brackets. The rate of taxation differs in the case of equity or debt, whether long or short term. The capital gain can be adjusted from capital loss to arrive at a net capital gain. The amount of gains and the exemption has to be reported in the tax return filed in the financial year in which the asset was transferred. The tax return can be filed quarterly, monthly, semi-annually or annually.

Question

Please answer with detailed calculations and good formatting and make sure the answer is 100% correct, else leave it for the other tutor to answer. Otherwise i will downvote the answer and report it for uprofessionalism for sure. Please don't use AI or Chat GPT also make sure there is no plagiari.sm.

Requirements
1.
2.
Use the PV function in Excel to calculate the issue price of the bonds.
Prepare a bond amortization table for the first four semiannual interest
periods.
3. Record the issuance of bonds payable on June 30, 2021; the payment of
interest on December 31, 2021; and the payment of interest on June 30,
2022.
-
X

On June 30, 2021, the market interest rate is 5%. Champ Corporation issues $650,000 of 10%, 30-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond
premium using the effective-interest method.
Read the requirements.
Requirement 1. Use the PV function in Excel to calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.)
The issue price of the bonds is

Definition Definition Structural system an enterprise uses to collect, store, report, retrieve, and process financial data. Accounting information systems are used by business analysts, auditors, accountants, and consultants for accurate and efficient access to financial data.

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!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Working

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Chung Inc. issued $50,000 of 3-year bonds on January 1, 2018, with a stated rate of 4% and a market rate of 4%. The bonds paid interest semi-annually on June 30 and Dec. 31. How much money did the company receive when the bonds were issued? The bonds would be quoted at what rate?
On June 30, 2021, the market interest rate is 5%. Champs Corporation issues $600,000 of 10%, 30-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. Read the requirements. Requirement 1. Use the PV function in Excel to calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is Requirements 1. 2. 3. Use the PV function in Excel to calculate the issue price of the bonds. Prepare a bond amortization table for the first four semiannual interest periods. Record the issuance of bonds payable on June 30, 2021; the payment of interest on December 31, 2021; and the payment of interest on June 30, 2022. Print Done X
Hartley Corporation issued $560,000 of 5%, 10-year bonds payable on March 31, 2022. The market interest rate at the date of issuance was 8 %, and the bonds pay interest semiannually. Hartley Corporation's year-end is March 31. Read the requirements 1. Using the PV function in Excel, calculate the issue price of the bonds. (Round your answer to the nearest Whole dollar) The issue price of the bonds is Requirements 1. Using the PV function in Excel, calculate the issue price of the bonds 2. Prepare an effective-interest amortization table for the bonds through the first three interest payments. Round amounts to the nearest dollar. 3. Record Hartley Corporation's issuance of the bonds on March 31, 2022, and payment of the first semiannual interest amount and amortization of the bond discount on September 30, 2022 Explanations are not required Print Done
On January 1, 2020, Everly Bottle Company sold $4,000,000 in long-term bonds. The bonds will mature in 4 years and have a stated interest rate of 10% and a yield rate of 8%. The bonds pay interest July 1 and January 1 of each year. The bonds are to be accounted for under the effective-interest method. Instructions: 1. Calculate the bond proceeds using the attached present value tables, Excel, or a financial calculator. Upload Choose a File
answer is A: how do you get to this answers?
On January 1, 2024, Martin Company issued $5,000,000, 10% bonds. Interest is payable semi-annually on June 30 and December 31. The bonds mature on January 1, 2034. The bonds are sold to yield 12%. Will the bonds be issued at a premium or discount? Explain why. Calculate the issue price of the bonds. Prepare the amortization table for the bonds assuming the effective interest method is used to calculate interest. You may (should) prepare the table in Excel then copy and paste into Word.
Waldron Corporation issued $900,000 of 16%, 10-year bonds payable on January 1, 2022. The market interest rate at the date of issuance was 14%, and the bonds pay interest semiannually (on June 30 and December 31). Waldron Corporation's year-end is June 30. Read the requirements 1. Using the PV function in Excel, calculate the issue price of the bonds. (Round your answer to the nearest whole dollar) The issue price of the bonds is Requirements 1. Using the PV function in Excel, calculate the issue price of the bonds. 2. Prepare an effective-interest amortization table for the bonds through the first three interest payments, Round amounts to the nearest dollar. 3. Record Waldron Corporation's issuance of the bonds on January 1, 2022, and payment of the first semiannual interest amount and amortization of the bond premium on June 30, 2022 Explanations are not required Print Done
Rangel Corporation issued $520,000 of 5%, 15-year bonds payable on March 31, 2022. The market interest rate at the date of issuance was 8%, and the bonds pay interest semiannually. Rangel Corporation's year-end is March 31. Read the requirements. 1. Using the PV function in Excel, calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is
On January 1, 2018, Technicians Credit Union (TCU) issued 5%, 20-year bonds payable with face value of $100,000. These bonds pay interest on June 30 and December 31. The issue price of the bonds is 106. Journalize the following bond transactions: a (Click the icon to view the bond transactions.) (Assume bonds payable are amortized using the straight-line amortization method. Record debits first, then credits. Select explanations on the last line of the journal entry. Round your answers to the nearest whole dollar.) - X a. More Info a. Issuance of the bonds on January 1, 2018. b. Payment of interest and amortization on June 30, 2018. c. Payment of interest and amortization on December 31, 2018. d. Retirement of the bond at maturity on December 31, 2037, assuming the last interest payment has already been recorded. Print Done
Use the following information for the following 3 questions: (round all parts to the nearest dollar) Porter, Inc. issued $400,000, 10-year, 10% bonds for $354,200 on January 1, 2022; the bonds pay interest semiannually on June 30 and December 31. On the date of issuance, the interest rate in the bond market is 12%. Round all parts of the problem to the nearest dollar. What will Porter record as interest expense for the year ending December 31, 2022? $42,579 $40,000 $21,252 $21,327 $20,000
Radhubhai
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…