E. Assuming the company closets it's books on December 31, prepare the journal entres for 12/31/2019 and 1/1/2020

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

E. Assuming the company closets it's books on December 31, prepare the journal entres for 12/31/2019 and 1/1/2020

COURSE LEARNING OBJECTIVE: Students will use electronic worksheets or other productivity tools to
solve problems and develop models.
EXCEL LEARNING OBJECTIVES:
- Use the built-in formulas to determine the present value (PV) of a bond
Use the built-in formulas to determine the effective issuance rate of a bond with issue costs (RATE)
Set up an automated bond amortization schedule.
Name cells using the Name Box
Use Scenario Manager to create a scenario describing the effects of a change in the market interest rate (an
independent variable) on the proceeds from issuing the bond (a dependent variable) and the corresponding
total interest expense (a dependent variable) over the term of the bond.
1
Correcting entries for bonds transactions
AAA Inc. recently hired a new accountant with extensive experience in tax accounting. Because of the
pressures of the new job, the accountant was unable to review the topic of accounting for bonds payable.
During the first year, he made the following entries for the issuance of new bonds and the two interest
payments.
DR
607,434
CR
01/01/19 Cash
Accounts Payable
(Issued $600,000, of 12%, 3-year bonds. Interest is payable semiannually on
June 30 and January 1. The effective rate was 11.5%.)
607,434
06/30/19 Interest Expense
36,000
Cash
(First semiannual interest payment)
36,000
12/31/19 Interest Expense
Interest Payable
(Second semiannual interest)
36,000
36,000
INSTRUCTIONS:
Based on the explanation of each entry,
a. Set up an Excel sheet similar to the example below.
b. Determine the proceeds from the issuance of bonds using Excel's built-in formula for PRESENT VALUE =
PV.
Function Arguments
Rate
- number
Nper
- number
Pmt
Fv
- number
Type
A- number
Returns the present value of an investment: the total amount that a series of future payments is worth now.
Rate is the interest rate per period. For example, use 64 for quarterly
payments at 6N APR.
c. Set up an amortization schedule (entirely using formulas) in Excel under the effective interest method.
d. Prepare the entries (in Excel) that should have been made on 1/1/19 and 6/30/19 assuming the company
uses the effective interest method to amortize the premium and discount on its bonds.
e. Assuming the company closes its books on December 31st, prepare the journal entries for 12/31/19 and
1/1/20.
f. What is the effect of these errors on Net Income, Earnings per Share, Total Liabilities and Retained
Earnings if they are not discovered (detected) before the publication of the annual report?
g. Assuming the error was discovered at the end of 2019 but before closing the books, prepare the necessary
journal entry(ies) to correct the error.
h. Assuming the error was discovered at the beginning of January of 2020, prepare the necessary journal
entry(ies) to correct the error.
Prof. Aníbal Báez-Díaz ©2019
•..
Transcribed Image Text:COURSE LEARNING OBJECTIVE: Students will use electronic worksheets or other productivity tools to solve problems and develop models. EXCEL LEARNING OBJECTIVES: - Use the built-in formulas to determine the present value (PV) of a bond Use the built-in formulas to determine the effective issuance rate of a bond with issue costs (RATE) Set up an automated bond amortization schedule. Name cells using the Name Box Use Scenario Manager to create a scenario describing the effects of a change in the market interest rate (an independent variable) on the proceeds from issuing the bond (a dependent variable) and the corresponding total interest expense (a dependent variable) over the term of the bond. 1 Correcting entries for bonds transactions AAA Inc. recently hired a new accountant with extensive experience in tax accounting. Because of the pressures of the new job, the accountant was unable to review the topic of accounting for bonds payable. During the first year, he made the following entries for the issuance of new bonds and the two interest payments. DR 607,434 CR 01/01/19 Cash Accounts Payable (Issued $600,000, of 12%, 3-year bonds. Interest is payable semiannually on June 30 and January 1. The effective rate was 11.5%.) 607,434 06/30/19 Interest Expense 36,000 Cash (First semiannual interest payment) 36,000 12/31/19 Interest Expense Interest Payable (Second semiannual interest) 36,000 36,000 INSTRUCTIONS: Based on the explanation of each entry, a. Set up an Excel sheet similar to the example below. b. Determine the proceeds from the issuance of bonds using Excel's built-in formula for PRESENT VALUE = PV. Function Arguments Rate - number Nper - number Pmt Fv - number Type A- number Returns the present value of an investment: the total amount that a series of future payments is worth now. Rate is the interest rate per period. For example, use 64 for quarterly payments at 6N APR. c. Set up an amortization schedule (entirely using formulas) in Excel under the effective interest method. d. Prepare the entries (in Excel) that should have been made on 1/1/19 and 6/30/19 assuming the company uses the effective interest method to amortize the premium and discount on its bonds. e. Assuming the company closes its books on December 31st, prepare the journal entries for 12/31/19 and 1/1/20. f. What is the effect of these errors on Net Income, Earnings per Share, Total Liabilities and Retained Earnings if they are not discovered (detected) before the publication of the annual report? g. Assuming the error was discovered at the end of 2019 but before closing the books, prepare the necessary journal entry(ies) to correct the error. h. Assuming the error was discovered at the beginning of January of 2020, prepare the necessary journal entry(ies) to correct the error. Prof. Aníbal Báez-Díaz ©2019 •..
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Methods of accounting
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education