Attached is a copy of the Janet Janitorial case 23 spreadsheet.

The professor had asked to do each one of the following on separate tabs on same worksheet.

Change analysis

Vertical analysis

Horizontal analysis

Ratios

Depreciation

Overall writeup of your findings

The deadline is today Oct. 2nd at 10 pm

ACME Office Cleaning Services Balance Sheet As of 12/31 Year 1 Year 2 Year 3 Year 4 Year 5 Current Assets: Cash Accounts Receivable Investments - Marketable securities Supplies Inventory Prepaid Rent Total current Assets 26,058 15,212 20,000 34,430 7,403 103,103 22,100 18,406 20,000 11,822 8,059 80,387 40,647 38,532 20,000 29,350 8,735 137,264 78,995 37,888 38,039 9,273 164,195 57,879 33,759 77,368 9,985 178,991 Property: Cleaning Equipment Vans Office Furniture Office Equipment Total Property, Plant & Equipment Less Accumulated Depreciation Net Property, Plant & Equipment 43,000 130,000 15,000 12,000 200,000 (60,067) 139,933 43,000 130,000 16,000 12,000 201,000 (120,334) 80,666 41,000 130,000 16,000 12,500 199,500 (180,034) 19,466 62,000 145,000 17,000 13,000 237,000 (194,267) 42,733 80,000 160,000 17,000 13,200 270,200 (219,500) 50,700 5,000 5,000 5,000 30,000 35,000 5,000 50,000 55,000 7,000 7,000 7,000 7,000 248,036 196,053 211,730 213,928 236,691 Current Liabilities: Accounts Payable Accrued Wages Payable Short-Term portion of L.T. Debt Total Current Liabilities 42,377 1,641 18,188 62,206 5,123 952 19,309 25,384 38,050 2,350 20,500 60,900 52,215 2,672 21,765 76,652 77,128 2,755 23,107 102,990 Long-Term Liabilities: Long-Term Note Payable Total Long-term Liabilities 84,681 84,681 65,372 65,372 44,872 44,872 44,872 44,872 Total Liabilities 146,887 90,756 105,772 121,524 102,990 Equity: Retained Earnings Janet Janitorial, Equity Total Equity 21,149 80,000 101,149 25,297 80,000 105,297 25,958 80,000 105,958 34,169 80,000 114,169 70,701 80,000 150,701 Total Liabilities & Equity 248,036 196,053 211,730 235,693 253,691 Other Assets: Rent Deposit Long term investments Total Other Assets Total Assets - ACME Office Cleaning Services Income Statement Year ended 12/31 Year 1 Year 2 Year 3 Year 4 Year 5 Revenues: Sales 398,769 489,112 540,493 471,837 572,544 Expenses: Cleaning Supplies Advertising & Promotion Bad Debt Expense (write offs) Bank Charges Depreciation Insurance Interest Expense Legal & Professional Miscellaneous Office Supplies Payroll Taxes Rent Expense Repairs & Maintenance Administrative labor Direct Labor Telephone Travel Utilities Total Expenses 57,812 13,567 542 1,822 60,067 4,851 6,734 3,200 451 6,100 19,176 26,400 6,712 35,000 124,800 2,216 2,378 5,792 377,620 62,005 8,554 1,855 2,650 60,267 5,387 5,677 7,988 826 4,722 24,517 27,600 12,542 35,700 151,625 3,344 2,568 7,137 424,964 69,542 10,381 203 2,001 59,700 5,911 8,500 9,433 155 9,025 26,875 28,800 10,615 36,414 187,542 3,575 3,157 8,003 479,832 67,900 12,888 3,511 3,225 14,233 6,744 3,365 10,573 2,736 9,487 26,151 30,000 15,228 40,055 177,872 7,392 3,508 4,758 439,626 82,150 7,391 5,184 1,881 25,233 6,399 2,100 5,544 3,928 7,711 32,887 33,600 7,000 44,061 206,853 5,000 3,028 8,062 488,012 21,149 64,148 60,661 32,211 84,532 Net Income (Loss) Place a "Y" in the accounts for the years that you think need further Investigation. Place an "N" in the accounts for the years that you think are OK. Y N Your Name or Team # ---> = = Investigate OK 100 Your Selected accounts will appear here. Accounts Current Assets: Cash Accounts Receivable Investments - Marketable securities Supplies Inventory Prepaid Rent Year 1 Year 2 Year 3 Year 4 Year 5 N Y Year 1 Year 2 OK Investigate Year 1 Year 2 Year 3 Year 4 Year 5 Year 3 Year 4 Year 5 Property: Cleaning Equipment Vans Office Furniture Office Equipment Total Property, Plant & Equipment Less Accumulated Depreciation Other Assets: Rent Deposit Long term investments Current Liabilities: Accounts Payable Accrued Wages Payable Short-Term portion of L.T. Debt Long-Term Liabilities: Long-Term Note Payable Equity: Retained Earnings Janet Janitorial, Equity Revenues: Sales Expenses: Cleaning Supplies Advertising & Promotion Bad Debt Expense (write offs) Bank Charges Depreciation Insurance Interest Expense Legal & Professional Miscellaneous Office Supplies Payroll Taxes Rent Expense Repairs & Maintenance Administrative labor Direct Labor Telephone Travel Utilities Year 1 Year 2 Year 3 Year 4 Year 5