Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. Adjusting for accounting errors, omissions, and expense analysis Unfortunately, you are not finished yet. Save your Excel file before attempting this section. Your basic

image text in transcribed
image text in transcribed
10. Adjusting for accounting errors, omissions, and expense analysis Unfortunately, you are not finished yet. Save your Excel file before attempting this section. Your basic financial model is complete but it must be modified for extra data and errors. The company's accountant has discovered the following error. Insert rows at appropriate places for any omission or include correct figure where it is incorrect in the Data sheet to make adjustments as needed: (i) The accountant did not account for the environmental carbon tax due on the company's use of factory utility. The taxable penalty is equal to 40% of annual factory utilities, and should be reported as a separate factory overhead cost. You should modify your Data sheet to include this extra factory overhead, and allow for the % charge to be modified in future years. Do not hard code this expense amount or add itet it off against the $72,000 of factory utilities for 2019. Do not use this information to adjust the company's income tax calculation. (ii) The following costs, expenses, and revenues were omitted or not recorded correctly in the original Data sheet and hence, must be included/amended in your Data sheet in the appropriate place: a. Advertising expense is overstated by $ 10,000. b. $13,000 sales staff commissions is omitted. c. $7,000 of legal and borrowing fees from obtaining a bank loan is omitted. (iii) The accountant mistakenly recognized $40,000 of "unearned revenue" as "sales revenue" during the year. Therefore, adjustment should be made accordingly in the Data sheet to reflect the correct annual sales revenue in the income statement for 2019. (iv) The accountant wishes you to provide an analysis of the company's annual operating expenses. Add an extra worksheet called "Expense analysis", and add your 2019 data to the accountant's existing 2018 data in the format shown below

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Tools For Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

7th Edition

1-119-57105-6, 978-1119571056

Students also viewed these Accounting questions