Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 14, Problem 4R
Suppose that an audit of Prime Sports Gear encountered the following two errors:
- a. Inventory totaling $4,500 should have been written off as worthless at the end of the year. Year-end inventory should be only $195,600. Net income is reduced to $117,110.
- b. Checks totaling $20,000 for some of the salaries payable at year-end had in fact been written and mailed out on December 31, 2013. Thus, both the cash account and the salaries payable account are overstated at year-end.
Correct both errors on the worksheet. Save your completed file as CASHFLOW4. Print the worksheet when done. What impact did each of these adjustments have on cash flow for 2013?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Atlantic Company reported the following net income: Year 2021 - P 4,000,000, and year 2022 - P 5,000,000. During your audit for the year 2022, the following errors were revealed:
A cash collection of P 100,000 was received from a customer on December 28, 2022 but not recorded until January 4, 2023.
Received a supplier's invoice on December 29, 2022 for P 160,000 worth of merchandise also received on the same date but no entry was made until January 5, 2023.
Inventories on December 31, 2021 and 2022 wee correctly stated.
Depreciation for the year 2021 was understated by P 90,000.
The office supplies purchased on November 10, 2022 amounting to P 20,000 was charged to purchases account. The company's accounting policy is to expense office supplies as expensed when incurred.
Sales invoice dated December 30, 2022 amounting to P 300,000 was recorded only on January 3, 2023.
What is the corrected net income for the year 2022?
a. 3,910,000b. 5,140,000c. 4,540,000d. 5,460,000
In 2018, the internal auditors of Development Technologies, Inc., discovered that (a) 2017 accrued wages of$2 million were not recognized until they were paid in 2018, and (b) a $3 million purchase of merchandisein 2018 was recorded in 2017 instead. The physical inventory count at the end of 2017 was correct. Ignoringincome taxes, what journal entries are needed in 2018 to correct each error? Also, briefly describe any othermeasures Development Technologies would take in connection with correcting the errors
The review of subsequent cash receipts has revealed that several of the trade receivables thatwere considered doubtful have now been paid. However, the audit procedures have shownthat a large debtor that was considered safe at 30 June was unexpectedly declared bankrupton 20 July. The year-end for the company is 30 June and the audit report is due to be signed on 20 August.Required:For each of the items above, explain what type of subsequent event it is and the appropriatetreatment of the item in the financial report.
Chapter 14 Solutions
Excel Applications for Accounting Principles
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.Similar questions
- On July 5, 2013, Smee Corp. received its bank statement for the month ending June 30. The statement showed a P209,500 balance while the cash account balance on June 30 was P35,000. In reconciling the balances, the auditor discovered that: 1. The June 30 collections of P176,000 were recorded on the books but were not deposited until July.2. The bank service charges for the month of June totaled P3,0003. A paid check for P24,300 was entered incorrectly in the cash paymentsjournal as P34,200. 32. What is the total outstanding checks at June 30, 2013? This is the answer to the solution manual: 32. P343,600 Is this really the correct answer? Please show the computation, please. Thank you!arrow_forwardSo, owner of a trading company engaged your services as auditor. There is a discrepancy between the company’s income and the sales volume. The owner suspects that the staff is committing theft. You are to determine whether or not this is true. Your investigation revealed the following: The physical taken on December 31, 2018 under your observation showed that cost was P26,500. The inventory on January 1, 2018 showed cost of P39,000. The accounts receivable as of January 1, 2018 were P13,500. During 2018, accounts receivable written off amounted to P1,000. Accounts receivable as of December 31, 2018 were P37,500. Outstanding purchase invoices amounted to P30,000 at the end of 2018. At the beginning of 2018, they were P37,500. Receipts from customers during 2018 amounted to P300,000. Disbursement to merchandise creditors amounted to P200,000. The average gross profit rate was 40% of net sales. Required: Total Sales Total Purchases Inventory Shortagearrow_forwardCalifornia Cannery began in 2008 with a debit balance in Accounts Receivable $150,000 and a credit balance in Allowance for Doubtful Accounts for 7,500 for the year. During the year California Cannery sold 1,300,000 of product and collected 1,350,000 from customers. In addition, $4,000 of Accounts Receivable balance was written off as uncollectable during the year. Management uses the allowance method to account for bad debts and believes that ultimately 5% of the year-end balance in Accounts Receivable will not be collected. How much bad debt expenses will be recorded in 2008?arrow_forward
- You are auditing the accounts receivable for Conor Company as of December 31, 2022 One of your procedures was to send positive confirmations to a sample of 50 accounts. Of those 50 confirmations, 40 have been positively confirmed without comments, 7 had minor differences that have been cleared satisfactorily. The remaining 3 had the following comments: “We received $6,000 of goods on consignment on November 20, 2022. We have not sold them yet.” “We received these goods on January 5, 2023 and mailed a check on January 7, 2023.” “The balance of $2,000 was paid on December 10, 2022.” For each of these comments, identify the steps that you would take to clear (resolve) them.arrow_forwardBased on the audit findings, answer the following: 1. What is the unadjusted book receipts in december? 2. What is the unadjusted book disbursements in december? - need answer for this question 3. what is the correct cash balance as of november 30? 4. what is the unadjusted cash balance per books as of december 31? - need answer for this question 5. what is the correct cash balance as of december 31? - need answer for this questionarrow_forwardThe following information from Tiny Company’s first year of operations is to be used in testing the accuracy of Accounts Receivable. The December 31, 2015, balance is $28,300. (a) Collections from customers, $48,000 (b) Merchandise purchased, $74,000 (c) Ending merchandise inventory, $31,500 (d) Goods sell at 60% above cost (e) All sales on account Compute the balance that Accounts Receivable should show and determine the amount of any shortage or overage.arrow_forward
- Detection of Errors and Fraud. For each of the following independent events, indicate the (1) effect of the error or fraud on the financial statements and (2) what auditing procedures could have detected the misstatement resulting from error or fraud.a. The physical inventory count of J. Payne Enterprises, which has a December 31 year-end, was conducted on August 31 without incident. In September, the perpetual inventory was not reduced for the cost of sales.b. Holmes Drug Stores counted its inventory on December 31, which is its fiscal year-end. The auditors observed the count at 20 of Holmes’s 86 locations. The company falsified the inventory at 20 of the locations not visited by the auditors by including fictitious goods in the counts.c. Pope Automotive inadvertently included in its inventory automobiles that it was holding on consignment for other dealers.d. Peffer Electronics Inc. overstated its inventory by pricing wiring at $200 per hundred feet instead of $200 per thousand…arrow_forwardAssume that you are auditing the inventory of Husky Manufacturing Company for the year ended December 31, 2015, and you are using MUS. The book value is $8,124,998.66. The risk of incorrect acceptance is 10% (90% confidence level). The tolerable misstatement is $275,000, and expected misstatement is $80,000, so the ratio of expected misstatement to tolerable misstatement is 29%. The ratio of tolerable misstatement to the population book value is 4.3%. Calculate the sample size and the sampling interval. Calculate the total estimated misstatement assuming the following misstatements were found in the sample: Book value Audit value $41,906.45 $36,906.45 $335,643.28 $333,643.28 What conclusion do you reach based upon your calculation?arrow_forwardYou were able to gather the following in connection with our audit of the TMC Corporation for the year ended December 31, 2018. Dec. 31, 2017 Dec 31, 2018 Accounts Receivable 6,400,000 4,000,000 Unpaid Merchandise invoices ? 2,621,000 Accrued Wages 85,000 125,000 Advertising supplies inventory 35,000 75,000 Accrued advertising expense 14,250 40,000 Prepaid Insurance 25,000 0 Unexpired insurance 0 41,000 During the year: Amount collected from customers, P10,000,000 Wages paid, P3,050,000 Advertising paid which includes, P250,000 Insurance premium paid, P125,000 Total payments to suppliers of merchandise, P13,618,000 Total payments to suppliers of merchandise of prior years, P4,632,000 Requirements: Compute for the Accrual advertising expense in 2018arrow_forward
- Whaley Distributors is a wholesale distributor of electronic components. Financial statements for the years ended December 31, 2022 and 2023, reported the following amounts and subtotals ($ in millions): Assets Liabilities Shareholders' Equity Net Income Expenses 2022 $660 $290 $370 $170 $142 2023 740 360 380 190 167 In 2024, the following situations occurred or came to light: 1. Internal auditors discovered that ending inventories reported on the financial statements the two previous years were misstated due to faulty internal controls. The errors were in the following amounts: 2022 inventory Overstated by $11.2 million 2023 inventory Understated by $9.2 million -Record entry necessary as a direct result of the change or error correction. -Record adjusting journal entry if needed for 2024 2. A liability was accrued in 2022 for a probable payment of $5.4 million in connection with a lawsuit ultimately settled in December 2024 for $3.2 million. -Record entry necessary as a…arrow_forwardIn your audit of Ledo Plastic Corporation , you noted that the company’s statement of financial position shows the accounts receivable balance as at December 31, 2020 as follows : Accounts Receivable P 3,600,000 Allowance for Doubtful Accounts 72,000 P 3,528,000 During 2021 , transactions relating to the accounts were as follows: Sales on account , P 38,400,000 Cash received from collection of current receivable totaled P 31,360,000 after discount of P 640,000 were allowed for prompt payment Customer’s accounts of P 160,000 were ascertained to be worthless and were written off Bad debts accounts previously written prior to 2021 amounting to P 40,000 were recovered The company decided to provide for P 184,000 for doubtful accounts by journal entry at the end of the year Accounts receivable of P 5,600,000 have been pledged to a local bank on a loan of P 3,200,000. Collections of P 1,200,000 were made on these receivables (not…arrow_forwardAn auditor decided to render sales cut-off as part of auditing an audit client's accounts receivable. Entries in the Sales Journal from December 16, 2016 to the subsequent period January 15, 2017 were vouched to the supporting documents. Which of the following is correct regarding the January entries? *a. January sales journal entries vouched back to the sales invoice shall help uncover possible overstatement of Sales/Accounts receivable.b. January sales journal entries vouched back to the delivery receipts shall help uncover possible understatement of Sales/Accounts receivable.c. December sales journal entries vouched back to the delivery receipts shall help uncover possible overstatement of Sales/Accounts Receivables.d. December sales journal entries vouched back to the sales invoice shall help uncover possible understatement of Sales/Accounts receivable.e. None of the above.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningAuditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License