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 tosolve problems and develop models.EXCEL LEARNING OBJECTIVES:- Use the built-in formulas to determine the present value (PV) of a bondUse 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 BoxUse Scenario Manager to create a scenario describing the effects of a change in the market interest rate (anindependent variable) on the proceeds from issuing the bond (a dependent variable) and the correspondingtotal interest expense (a dependent variable) over the term of the bond.1Correcting entries for bonds transactionsAAA Inc. recently hired a new accountant with extensive experience in tax accounting. Because of thepressures 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 interestpayments.DR607,434CR01/01/19 CashAccounts Payable(Issued $600,000, of 12%, 3-year bonds. Interest is payable semiannually onJune 30 and January 1. The effective rate was 11.5%.)607,43406/30/19 Interest Expense36,000Cash(First semiannual interest payment)36,00012/31/19 Interest ExpenseInterest Payable(Second semiannual interest)36,00036,000INSTRUCTIONS: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 ArgumentsRate- numberNper- numberPmtFv- numberTypeA- numberReturns 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 quarterlypayments 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 companyuses 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 and1/1/20.f. What is the effect of these errors on Net Income, Earnings per Share, Total Liabilities and RetainedEarnings 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 necessaryjournal entry(ies) to correct the error.h. Assuming the error was discovered at the beginning of January of 2020, prepare the necessary journalentry(ies) to correct the error.Prof. Aníbal Báez-Díaz ©2019•..

A journal entry is a form of accounting entry that is used to report a business transaction in a…

Answered: E. Assuming the company closets it's…

Business

Accounting

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

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter10: Forecasting Financial Statement

Section: Chapter Questions

Problem 1AIC

See similar textbooks

Similar questions

Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all…
Imagine that you are a financial manager researching investments for your client. Think of a friend or a family member as a client. Define their characteristics and goals such as an employee or employer, relatively young (less than 40 years) or close to retirement, having some savings/property, a risk taker or risk averter, etc. Next, use Nexis Uni at the Strayer University library, located at Nexis Uni, click on “Company Dossier” to research the stock of any U.S. publicly traded company that you may consider as an investment opportunity for your client. Your investment should align with your client’s investment goals. (Note: Please ensure that you are able to find enough information about this company in order to complete this assignment. You will create an appendix, in which you will insert related information.) Provide a rationale for the stock that you selected, indicating the significant economic, financial, and other factors that led you to consider this stock. Suggest the…
Why should a client provide their investment manager with an investment policy statement? Be specific. Edit View Insert Format Tools Table
I need help to do question 9 from A to D and please include the formulas on how to solve using Excel and the answer for the Finance homework.
Please solve exercise applying concepts of the sum of sets of terms of a sequence. The problem related to annuities must be resolved using sequences or series.In the following exercises and problems you will be able to:• model investment and annuity problems;• explain the difference between sequences and series;• solve exercises applying concepts of the sum of sets of terms of a sequence, and• solve problems related to annuities using sequences or seriesIn the case that the result is decimal, you will round it to two decimal places. 3. The new parents decide to invest $ 100 a month in an annuity for their young daughter. The account will pay 5% interest per year, which is compounded monthly. How much will be in the child's account when he turns eighteen?
Please solve exercise applying concepts of the sum of sets of terms of a sequence. The problem related to annuities must be resolved using sequences or series.In the following exercises and problems you will be able to:• model investment and annuity problems;• explain the difference between sequences and series;• solve exercises applying concepts of the sum of sets of terms of a sequence, and• solve problems related to annuities using sequences or seriesIn the case that the result is decimal, you will round it to two decimal places. 4. New grandparents decide to invest $ 200 a month in an annuity for their grandchild. The account will pay 5% interest per year, which is compounded monthly. How much will be in the child's account when he turns 21?
Write a paragraph on each of the following topics: liquidity, asset management, debt management and profitability. Be sure to label these separately. Analyze each topic using the answers from your ratios to support your analysis by deciphering what they are telling you. Create a text box (Insert Menu, click on the “Text” button on the right side of the menu bar, and choose, “Text box”. Then click and drag a box to write in.
According to the risk management process in ISO 31000, which of the following is a necessary step in risk assessment? Select one: A. Risk treatment B. Risk transfer C. Risk analysis D. Risk minimisation #### i want answer within one hour,Thanks
Hello this is for a financial mathematics class
I need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance.
Find the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $400 compounded for 1 year at 9.5%. $ An initial $400 compounded for 2 years at 9.5%. $ The present value of $400 due in 1 year at a discount rate of 9.5%. $ The present value of $400 due in 2 years at a discount rate of 9.5%. $
Write a research paper explaining how the T Account process works