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 amounts. List all debit entries before credit entries.) Cash Account Titles and Explanation Bonds Payable Interest Expense Bonds Payable Cash Interest Expense Bonds Payable Interest Payable $ Interest Payable $ Cash Debit 39,550 Credit 39,550 39,550 39,550
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 amounts. List all debit entries before credit entries.) Cash Account Titles and Explanation Bonds Payable Interest Expense Bonds Payable Cash Interest Expense Bonds Payable Interest Payable $ Interest Payable $ Cash Debit 39,550 Credit 39,550 39,550 39,550
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 13M
Related questions
Question
![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 amounts. List all debit
entries before credit entries.)
Cash
Account Titles and Explanation
Bonds Payable
Interest Expense
Bonds Payable
Cash
Interest Expense
Bonds Payable
Interest Payable
$
Interest Payable
$
Cash
Debit
39,550
Credit
39,550
39,550
39,550](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5616e8d4-f0be-4a87-bc1a-445a27a140d5%2Fc30b0689-6cc1-41dd-9c7a-affd83747637%2Fpzf1jwq_processed.jpeg&w=3840&q=75)
Transcribed Image Text: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 amounts. List all debit
entries before credit entries.)
Cash
Account Titles and Explanation
Bonds Payable
Interest Expense
Bonds Payable
Cash
Interest Expense
Bonds Payable
Interest Payable
$
Interest Payable
$
Cash
Debit
39,550
Credit
39,550
39,550
39,550
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning