Investigate
(Not rated)
(Not rated)
| 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 | = | Investigate | |||||||||||
| N | = | OK | |||||||||||
| Your Name or Team # ---> | 100 | ||||||||||||
| Your Selected accounts will appear here. | |||||||||||||
| Accounts | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
| Current Assets: | |||||||||||||
| Cash | N | Y | OK | Investigate | |||||||||
| Accounts Receivable | |||||||||||||
| Investments - Marketable securities | |||||||||||||
| Supplies Inventory | |||||||||||||
| Prepaid Rent | |||||||||||||
| 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: | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
| 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 | |||||||||||||
11 years ago
Investigate
NOT RATED
Purchase the answer to view it

- case_23_janet_janitorial_spreadsheetsolution.xlsx