Please help with

A. creating a ratios analysis of John Doe's case from accounts information provided.

B. what does a ratios analysis reveals (please show the formulas and calculations)

C. recommendation on which financial accounts John should reevaluate

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 Building 15 years).

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