Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help filling in this excel sheet. Please use formulas when necessary and write out the formula that is used. Please refer to assessment

image text in transcribed
I need help filling in this excel sheet. Please use formulas when necessary and write out the formula that is used.
Please refer to assessment instructions and scoring guides before beginning this assessment. You are nearing the end of GPCs audit. As the auditor, you must evaluate the importance of all uncorrected misstatements to determine if the risk of a material misstatement is sufficiently low to support issuance of an unmodified opinion. Four uncorrected misstatements have been identified. Though no individual uncorrected misstatement is qualitatively material, the quantitative affect must be analyzed individually and in the aggregate. The uncorrected misstatements are as follows. 1. Understated accrued liabilities (bonus payable): $5252. Understated prepaid insurance: $459.3. Overstated inventory due to spoilage: $830.4. Understated allowance for uncollectible accounts: $1,000.(Ignore errors discovered in earlier parts of the assessment. Assume they have been adjusted.) Use the provided Excel workbook to complete a schedule of Aggregated Misstatements for Green Pastures Cheese, LLC. Assume that the tax rate is 30%. Analyze the results, and enter a conclusion on the workpaper. Assume that the following amounts are considered material. Current Assets: $18,000Non-current Assets: $9,000Current Liabilities: $12,000Non-current Liabilities: $3,000Owners Equity: $3,000Income before Taxes: $20,000 The schedule should follow the sample format provided in the Excel template. Review the provided sample, the following notes, and evaluation of audit findings in chapter 16 to help you understand the process. Each uncorrected misstatement will require 2 rows of analysis. The first row is the impact of the uncorrected misstatement on the balance sheet and pre-tax net income. The second row is the tax effect of the uncorrected misstatement (based upon the provided marginal tax rate.) Each row will have 3 entries. Use the accounting equation A=L+E to help analyze the effect of the uncorrected misstatement on equity and income before taxes. (Errors that result in an overstatement of income will result in overstated Equity.) Overstatements are entered as a positive number. Understatements are negative. Overstatements of pre-tax net income result in overstated tax expense and taxes payable (current liability). Understatements have the opposite impact. The materiality levels are included below the column totals to support the conclusion that the adjustments are, or are not, considered material. The work paper must include a conclusion, preparer initials, and a date. (Later, the reviewer will add their initials and date.)
image text in transcribed

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

Survey of Accounting

Authors: Paul D. Kimmel, Jerry J. Weygandt

1st edition

1119330025, 978-1119444244, 1119444241, 978-1119306474, 1119306477, 978-1119330028

More Books

Students also viewed these Accounting questions