It is the usual accountant’s story…a friend of yours (John Dough) has purchased a small business and knows that you are proficient at analyzing financial information. He has asked you to help him with his financial analysis. He informs you of the following background information:

After 20 years of service at his prior job, John was burned out and considering a change. While Christmas shopping, he was talking with a retail owner at a local mall and was informed that most retail stores mark up their prices by 200%. John decided to quit his job and purchase and operate a retail toy and hobby shop. So, after finding the right opportunity, in January of year 1, he purchased a small store and inventory of toys/games for $300,000. He financed the purchase through the local bank, which loaned him 80% of the money at 7% for 10 years and required John to personally finance the other 20%. Since he is the owner of a small business, he has been operating it as a sole proprietor and has not issued any stock. He is not paid a salary but draws money out as needed. He has a full-time bookkeeper who handles all his books and accounting functions. There are two full-time sales clerks that work in the store and stock inventory in storage or on the shelves as it is delivered. All three of these employees have worked for him since he opened his business. John started each of them out at about $25,000 per year and has given each of them raises every year (approximately 3% per year). Additionally, if the company has a good year (net income), he rewards the employees by paying each of them a bonus of 3% of the net income amount. The bonuses are paid in the following year (February).

For years 1 and 2, he had some external accountants prepare a compilation report. For years 3, 4 and 5 he had a different set of external accountants prepare the compilation reports. The compilation reports state that the books are kept on an accrual basis of accounting according to GAAP and that Property & Equipment is capitalized at cost and depreciated using the straight-line method over the useful life of the property (Equipment 3 years, Furniture 5 years and Buildings 15 years).

Required : List 5 accounts that are suspicious relating to possible irregularities and why you believe additional investigative work should focus on them. Hint: to answer this you need to example the relationship between two accounts, ie. if one account increases what do you expect from the other related account. You should list 5 of such relationships.

 

Transcribed Image Text:

Current Assets: Property: Total Assets Current Liabilities Long-Term Liabilities Total Liabilities Cash A/R Investments CD Inventory Prepaid Insurance Total current Assets Equipment Furniture & Fixtures Buildings Total Property, Plant & Equipment Less Accumulated Depreciation. Net Property, Plant & Equipment Accounts Payable Accrued Wages Payable Short term portion of LT debt Total Current Liabilities Long-Term Note Payable Total Long-term Liabilities 1 $12,351 $17,459 $- $83,457 $5,922 $119,189 $36,599 $27,495 $157,976 $222,070 $(18,580) $203,490 $322,679 $12,897 $1,233 $18,426 $32,556 $204,391 $204,391 $236,947 Year Ended 12/31 2 $19,553 $22,725 $20,000 $78,958 $6,355 $147,591 $37,596 $27,495 $157,976 $223,067 $(38,050) $185,017 $332,608 $20,589 $2,241 $19,758 $42,588 $188,135 $188,135 $230,723 3 $42,862 $46,826 $40,000 $107,763 $6,988 $244,439 $37,596 $30,509 $157,976 $226,081 $(64,216) $161,865 $406,304 $22,477 $1,685 $21,186 $45,348 $171,392 $171,392 $216,740 4 $31,055 $57,357 $20,000 $67,915 $7,419 $183,746 $39,458 $30,509 $157,976 $227,943 $(84,803) $143,140 $326,886 $25,688 $1,957 $22,718 $50,363 $153,799 $153,799 $204,162 5 $21,908 $68,606 $5,000 $88,749 $7,988 $192,251 $44,187 $30,509 $157,976 $232,672 $(103,634) $129,038 $321,289 $27,195 $2,391 $24,360 $53,946 $135,762 $135,762 $189,708 Current Assets: Property: Total Assets Current Liabilities Long-Term Liabilities Total Liabilities Cash A/R Investments CD Inventory Prepaid Insurance Total current Assets Equipment Furniture & Fixtures Buildings Total Property, Plant & Equipment Less Accumulated Depreciation. Net Property, Plant & Equipment Accounts Payable Accrued Wages Payable Short term portion of LT debt Total Current Liabilities Long-Term Note Payable Total Long-term Liabilities 1 $12,351 $17,459 $- $83,457 $5,922 $119,189 $36,599 $27,495 $157,976 $222,070 $(18,580) $203,490 $322,679 $12,897 $1,233 $18,426 $32,556 $204,391 $204,391 $236,947 Year Ended 12/31 2 $19,553 $22,725 $20,000 $78,958 $6,355 $147,591 $37,596 $27,495 $157,976 $223,067 $(38,050) $185,017 $332,608 $20,589 $2,241 $19,758 $42,588 $188,135 $188,135 $230,723 3 $42,862 $46,826 $40,000 $107,763 $6,988 $244,439 $37,596 $30,509 $157,976 $226,081 $(64,216) $161,865 $406,304 $22,477 $1,685 $21,186 $45,348 $171,392 $171,392 $216,740 4 $31,055 $57,357 $20,000 $67,915 $7,419 $183,746 $39,458 $30,509 $157,976 $227,943 $(84,803) $143,140 $326,886 $25,688 $1,957 $22,718 $50,363 $153,799 $153,799 $204,162 5 $21,908 $68,606 $5,000 $88,749 $7,988 $192,251 $44,187 $30,509 $157,976 $232,672 $(103,634) $129,038 $321,289 $27,195 $2,391 $24,360 $53,946 $135,762 $135,762 $189,708

Answer rating: 100% (QA)

1 The analysis of the Income statement is given below Income Statament Year 2 Year 3 Year 4 Year 5 Y... View the full answer