Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It is the usual accountants storya friend of yours (John Dough) has purchased a small business and knows that you are proficient at analyzing financial

It is the usual accountants storya 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 200%. John decided to quit his job and purchase and operate a retail toys 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 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.

image text in transcribed

image text in transcribed

Year Ended 12/31 1 4 Current Assets: $12,351 $19,553 $42,862 $31,055 $21,908 Cash $17,459 $22,725 $46,826 $57,357 $68,606 A/R $20,000 $40.000 $20,000 $5,000 Investments - CD $88,749 $83,457 $78,958 $107,763 $67,915 Inventory $5,922 $6,355 $6,988 $7,419 $7,988 Prepaid Insurance $119,189 $147,591 $244,439 $183,746 $192,251 Total current Assets Property $36,599 $37,596 $37,596 $39.458 $44,187 Equipment Furniture & Fixtures $27,495 $27,495 $30,509 $30,509 $30,509 $157,976 $157,976 $157,976 $157,976 $157,976 Buildings $223,067 $227,943 $222,070 $226,081 $232,672 Total Property, Plant & Equipment S(64,216) $(18,580) $(38,050) S(84,803) $(103,634) Less Accumulated Depreciation $203,490 $185,017 $161,865 $143,140 $129,038 Net Property, Plant & Equipment Total Assets $322,679 $332,608 $326.886 $321,289 $406.304 Current Liabilities $12,897 $20,589 $22,477 $25,688 $27,195 Accounts Payable $1,233 $2,241 $1,685 $1,957 $2,391 Accrued Wages Payable $18,426 $19,758 $21,186 $22,718 $24,360 Sho IT ebt $42,588 $45,348 $50,363 $53,946 $32,556 Total Current Liabilities Long-Term Liabilities $204,391 $188,135 $171,392 $153.799 $135,762 Long-Term Note Payable $153.799 $204.391 $188,135 $171,392 $135,762 Total Long-term Liabilities $236,947 $230,723 $216,740 $189,708 Total Liabilities $204,162 5 Equity John Dough, Equity $85,732 $101,885 $159,564 $122,724 $131,581 $101,885 $131,581 Total Equity $85,732 $159,564 $122,724 $322,679 $332,608 $376,304 $326,886 Total Liabilities & Equity $321,289 Revenues: $373,492 $452,781 $449,685 $362,755 $399,975 Sales S(2,895) S(1,670) $(8,477) $(9,317) S(11,179) Less Returns Allowances $370,597 $451,111 $441.208 $353,438 $388,796 Net Sales $128,968 $158,987 $176,388 $169,589 $162,832 Less Cost of Goods Sold $241.629 $292,124 $264.820 $183,849 $225,964 Gross Profit Expenses $10,725 $4,343 $8,289 $6,131 $5,700 Advertising & Promotion $399 $1,483 $1,300 $125 $2,349 Bad Debt Expense (write offs) Bank Charges $1.940 $2,177 $1,803 $1,799 $1,998 $18.580 $19,470 $26,166 $20,587 $18,831 Depreciation $3,948 $5,143 $4,477 $4,695 $5,637 Insurance Interest Expense $16,256 $16,743 $17,593 $18,037 $18,397 $8,697 $6,602 $6,419 $8,627 $8,885 Legal & Professional $426 Miscellaneous $261 $778 $1,875 $2,972 Office Supplies $4,265 $3,871 $4,825 $4,385 $4,000 $9,215 $10,982 $14,397 $15,183 $16,831 Payroll Taxes $5,042 $10,928 $11,472 $18,035 $15,849 Repairs & Maintenance $77,587 Salaries & Wages $79,915 $85,6 $90,590 $94,715 $1,840 $2,770 $2,812 $3,871 $3,700 Telephone $3,092 $1,982 $2,279 $1,806 $3,240 Travel $4,788 $5,819 $6,392 $11,471 $6,100 Utilities $165,525 $172,285 $193,191 $211,175 $208,155 Total Expenses $76,104 $119,839 $71,629 $(27,326) $17,809 Net Income (Loss) Year Ended 12/31 1 4 Current Assets: $12,351 $19,553 $42,862 $31,055 $21,908 Cash $17,459 $22,725 $46,826 $57,357 $68,606 A/R $20,000 $40.000 $20,000 $5,000 Investments - CD $88,749 $83,457 $78,958 $107,763 $67,915 Inventory $5,922 $6,355 $6,988 $7,419 $7,988 Prepaid Insurance $119,189 $147,591 $244,439 $183,746 $192,251 Total current Assets Property $36,599 $37,596 $37,596 $39.458 $44,187 Equipment Furniture & Fixtures $27,495 $27,495 $30,509 $30,509 $30,509 $157,976 $157,976 $157,976 $157,976 $157,976 Buildings $223,067 $227,943 $222,070 $226,081 $232,672 Total Property, Plant & Equipment S(64,216) $(18,580) $(38,050) S(84,803) $(103,634) Less Accumulated Depreciation $203,490 $185,017 $161,865 $143,140 $129,038 Net Property, Plant & Equipment Total Assets $322,679 $332,608 $326.886 $321,289 $406.304 Current Liabilities $12,897 $20,589 $22,477 $25,688 $27,195 Accounts Payable $1,233 $2,241 $1,685 $1,957 $2,391 Accrued Wages Payable $18,426 $19,758 $21,186 $22,718 $24,360 Sho IT ebt $42,588 $45,348 $50,363 $53,946 $32,556 Total Current Liabilities Long-Term Liabilities $204,391 $188,135 $171,392 $153.799 $135,762 Long-Term Note Payable $153.799 $204.391 $188,135 $171,392 $135,762 Total Long-term Liabilities $236,947 $230,723 $216,740 $189,708 Total Liabilities $204,162 5 Equity John Dough, Equity $85,732 $101,885 $159,564 $122,724 $131,581 $101,885 $131,581 Total Equity $85,732 $159,564 $122,724 $322,679 $332,608 $376,304 $326,886 Total Liabilities & Equity $321,289 Revenues: $373,492 $452,781 $449,685 $362,755 $399,975 Sales S(2,895) S(1,670) $(8,477) $(9,317) S(11,179) Less Returns Allowances $370,597 $451,111 $441.208 $353,438 $388,796 Net Sales $128,968 $158,987 $176,388 $169,589 $162,832 Less Cost of Goods Sold $241.629 $292,124 $264.820 $183,849 $225,964 Gross Profit Expenses $10,725 $4,343 $8,289 $6,131 $5,700 Advertising & Promotion $399 $1,483 $1,300 $125 $2,349 Bad Debt Expense (write offs) Bank Charges $1.940 $2,177 $1,803 $1,799 $1,998 $18.580 $19,470 $26,166 $20,587 $18,831 Depreciation $3,948 $5,143 $4,477 $4,695 $5,637 Insurance Interest Expense $16,256 $16,743 $17,593 $18,037 $18,397 $8,697 $6,602 $6,419 $8,627 $8,885 Legal & Professional $426 Miscellaneous $261 $778 $1,875 $2,972 Office Supplies $4,265 $3,871 $4,825 $4,385 $4,000 $9,215 $10,982 $14,397 $15,183 $16,831 Payroll Taxes $5,042 $10,928 $11,472 $18,035 $15,849 Repairs & Maintenance $77,587 Salaries & Wages $79,915 $85,6 $90,590 $94,715 $1,840 $2,770 $2,812 $3,871 $3,700 Telephone $3,092 $1,982 $2,279 $1,806 $3,240 Travel $4,788 $5,819 $6,392 $11,471 $6,100 Utilities $165,525 $172,285 $193,191 $211,175 $208,155 Total Expenses $76,104 $119,839 $71,629 $(27,326) $17,809 Net Income (Loss)

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_2

Step: 3

blur-text-image_3

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

Gas And Mileage Log Book

Authors: TopStoxx Publishing

1st Edition

B08DDM8FVC, 979-8668873487

More Books

Students also viewed these Accounting questions

Question

Describe how projective tests are used.

Answered: 1 week ago