Accounting Case Study

MBA 5850 Spring 201 7 Block 2 Case Study #2 Quantum Products, Inc. is in its second year of operations. The majority owner and president of the company, Mr. Bradshaw, has no prior accounting experience and h as been preparing the financial statements on his own. The preliminary financial stat ements for Quantum Products, Inc. are presented below : Quantum Products, Inc. has hired you to review the financial statements and make any necessary adjustments before being presented to the board of directors . Mr. Bradshaw has provided the following information to help you adjust the financial statements. (1) Inventory is c osted using the first -in first out method . Inventory at December 31, 201 5 was comprised of: 2,200 units at $25.10 per unit . 2016 p urchases included: 2/4/2016: 1,125 units @ $26.00 per unit 4/8/16: 1,160 units @25.25 per unit 6/20/16: 1,080 units @ $25.80 per unit 9/6/16: 1,170 units @ $25.40 per unit 11/22/16: 1,090 units @ $25.50 per unit 6,625 units were sold in 2016. (2) Equipment includes two assets. a. Asset #1 was purchased on April 1, 201 6 for a cost of $ 40 ,000. This asset has a salvage value of $ 4,000 and an expected useful life of 5 years. The asset is depreciated using the straight -line method. b. Asset #2 was purchased on November 1, 201 6 for a cost of $ 36 ,000. This asset has no salvage value and an expected useful life of 3 years. The asset is depreciated using the straight -line method. (3) Accounts receivable detail is as follows: The allowance for doubtful accounts is based on the aging of accounts receivab le method. The estimated percentage of uncollectible amounts is as follows: Current amounts (not yet due) = 1% 1 - 30 days past due = 3% 31 – 60 days past due = 5% Over 60 days past due = 9% Invoices are billed at net 30 days. (4) There were two loa ns with activity during 201 6. a. Note amount, $ 6,000. Annual interest rate of 6%. Interest was accrued monthly. Loan date: Ju ne 1, 201 1. The loan and all accrued loan interest was paid off on June 1, 2016 . b. Note amount, $ 12,000. Annual interest rate of 4%. Interest is accrued monthly. Loan date: March 1, 201 6. The loan and all accrued interest is due on March 1, 202 1. (5) Deferred revenue is for product to be delivered in 201 7 and should be $ 12 ,500 at December 31, 201 6. (6) A physical count of supplies at the e nd of the year reflected $ 3,000 of supplies on hand at December 31, 201 6. (7) Total rent for the year should reflect 12 payments of $ 2,500 per month. Prepaid rent is included in the Prepaid Expenses account. Requirements: (1) Prepare a trial balance spreadsheet for the year ended December 31, 201 6 as demonstrated in Exhibit 4.5 of the text . You should use the accounts included on the preliminary financial statements provided above . All necessary accounts are included on the preliminary financial statements. (2) Rec ord the adjustments required based on the seven items of information presented above. Be sure to include all calculations used to determine adjustment amounts. These calculations should be made on separate worksheets (tabs) in your one Excel file . (3) Using you r adjusted trial balance, prepare a properly formatted income statement, balance sheet, and statement of stockholders’ equity for the calendar year 201 6. (4) Prepare a memo to Mr. Bradshaw detailing what problems you found on his preliminary financial statements. In addition to the issues with the preliminary financial state ment, provide Mr. Bradshaw with : current ratio, working capital, net profit margin, receivable turnover ratio, average collection period, inventory turnover ratio , average days to sell inventory. Additional information to assist you with your memo is: a. Average net profit margin for Quantum Product ’s competitors is 15 %. b. Accounts receivable at 12/31/201 5, $ 36 ,000 c. Product inventory at 12/31/201 5, $2 5,000 (base your inventor y turnover ratio and average days to sell inventory on the product inventory only).