Scribd
Upload
54 views11 pages

Janet

The document appears to be financial statements for ACME Office Cleaning Services for years 1 through 5. It includes balance sheets, income statements, and percentages of total assets/sales for various accounts. The balance sheets show total assets decreasing from year 1 to 3 before increasing in years 4 and 5. Total liabilities also decrease from year 1 to 3 before increasing slightly in years 4 and 5. Retained earnings and equity increase each year. The income statements show total sales increasing each year while expenses fluctuate between 86-95% of sales each year, leaving net income between 5-14% of sales.

Uploaded by

Hassan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
54 views11 pages

Janet

The document appears to be financial statements for ACME Office Cleaning Services for years 1 through 5. It includes balance sheets, income statements, and percentages of total assets/sales for various accounts. The balance sheets show total assets decreasing from year 1 to 3 before increasing in years 4 and 5. Total liabilities also decrease from year 1 to 3 before increasing slightly in years 4 and 5. Retained earnings and equity increase each year. The income statements show total sales increasing each year while expenses fluctuate between 86-95% of sales each year, leaving net income between 5-14% of sales.

Uploaded by

Hassan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 11

ACME Offi

Ba
Y-1 % of Assets (Total) Y-2

Cash 26058.00 10.506% 22100.00


Accounts (Receivable) 15212.00 6.133% 18406.00
Investments - (Marketable securities) 20000.00 8.063% 20000.00
Supplies Inventory 34430.00 13.881% 11822.00
Prepaid Rent 7403.00 2.985% 8059.00
Total current Assets 103103.00 41.568% 80387.00

Cleaning Equipment 43000.00 17.336% 43000.00


Vans 130000.00 52.412% 130000.00
Office Furniture 15000.00 6.048% 16000.00
Office Equipment 12000.00 4.838% 12000.00
Total Property, Plant & Equipment 200000.00 80.633% 201000.00
Less Accumulated Depreciation -60067.00 - -120334.00
Net Property, Plant & Equipment 139933.00 56.416% 80666.00

Rent Deposit 5000.00 2.016% 5000.00


Long term investments 0.00 0.000% 30000.00
5000.00 2.016% 35000.00

248036.00 100.000% 196053.00

Accounts Payable 42377.00 28.850% 5123.00


Accrued Wages Payable 1641.00 1.117% 952.00
Short-Term portion of L.T. Debt 18188.00 12.382% 19309.00
Total Current Liabilities 62206.00 42.350% 25384.00

Long-Term Note Payable 84680.99 57.650% 65371.98


Total Long-term Liabilities 84680.99 57.650% 65371.98

146886.99 100.000% 90755.98

Retained Earnings 21149.01 20.909% 25297.01


Janet Janitorial, Equity 80000.00 79.091% 80000.00
Total Equity 101149.01 100.000% 105297.01

248036.00 - 196053.00

ACME Offi
Inco

Year 1 % of Sales Year 2

Sales 398769.00 100.000% 489112.00

Cleaning Supplies 57812.00 14.498% 62005.00


Advertising & Promotion 13567.00 3.402% 8554.00
Bad Debt Expense (write offs) 542.00 0.136% 1855.00
Bank Charges 1822.00 0.457% 2650.00
Depreciation 60067.00 15.063% 60267.00
Insurance 4851.00 1.216% 5387.00
Interest Expense 6733.99 1.689% 5677.00
Legal & Professional 3200.00 0.802% 7988.00
Miscellaneous 451.00 0.113% 826.00
Office Supplies 6100.00 1.530% 4722.00
Payroll Taxes 19176.00 4.809% 24517.00
Rent Expense 26400.00 6.620% 27600.00
Repairs & Maintenance 6712.00 1.683% 12542.00
Administrative labor 35000.00 8.777% 35700.00
Direct Labor 124800.00 31.296% 151625.00
Telephone 2216.00 0.556% 3344.00
Travel 2378.00 0.596% 2568.00
Utilities 5792.00 1.452% 7137.00
Total Expenses 377619.99 94.696% 424964.00

21149.01 5.304% 64148.00


ACME Office Cleaning Services
Balance Sheet
% of Total Assets Y-3 % of Assets (Total) Y-4 % of Assets (Total)

11.272% 40647.00 19.198% 78995.00 36.926%


9.388% 38532.00 18.199% 37888.00 17.711%
10.201% 20000.00 9.446% 0.00 0.000%
6.030% 29350.00 13.862% 38039.00 17.781%
4.111% 8735.00 4.126% 9273.00 4.335%
41.003% 137264.00 64.830% 164195.00 76.752%

21.933% 41000.00 19.364% 62000.00 28.982%


66.309% 130000.00 61.399% 145000.00 67.780%
8.161% 16000.00 7.557% 17000.00 7.947%
6.121% 12500.00 5.904% 13000.00 6.077%
102.523% 199500.00 94.224% 237000.00 110.785%
- -180034.00 - -194267.00 -
41.145% 19466.00 9.194% 42733.00 19.975%

2.550% 5000.00 2.361% 7000.00 3.272%


15.302% 50000.00 23.615% 0.00 0.000%
17.852% 55000.00 25.976% 7000.00 3.272%

100.000% 211730.00 100.000% 213928.00 100.000%

5.645% 38050.00 35.974% 52215.00 42.967%


1.049% 2350.00 2.222% 2672.00 2.199%
21.276% 20500.00 19.381% 21765.00 17.910%
27.970% 60900.00 57.577% 76652.00 63.076%

72.030% 44872.00 42.423% 44872.00 36.924%


72.030% 44872.00 42.423% 44872.00 36.924%

100.000% 105772.00 100.000% 121524.00 100.000%

24.024% 25958.01 24.498% 34169.01 29.928%


75.976% 80000.00 75.502% 80000.00 70.072%
100.000% 105958.01 100.000% 114169.01 100.000%

- 211730.01 - 235693.01 -

ACME Office Cleaning Services


Income Statement

% of Sales Year 3 % of Sales Year 4 % of Sales

100.000% 540493.00 100.000% 471837.00 100.000%

12.677% 69542.00 12.866% 67900.00 14.391%


1.749% 10381.00 1.921% 12888.00 2.731%
0.379% 203.00 0.038% 3511.00 0.744%
0.542% 2001.00 0.370% 3225.00 0.683%
12.322% 59700.00 11.045% 14233.00 3.017%
1.101% 5911.00 1.094% 6744.00 1.429%
1.161% 8500.00 1.573% 3365.00 0.713%
1.633% 9433.00 1.745% 10573.00 2.241%
0.169% 155.00 0.029% 2736.00 0.580%
0.965% 9025.00 1.670% 9487.00 2.011%
5.013% 26875.00 4.972% 26151.00 5.542%
5.643% 28800.00 5.328% 30000.00 6.358%
2.564% 10615.00 1.964% 15228.00 3.227%
7.299% 36414.00 6.737% 40055.00 8.489%
31.000% 187542.00 34.698% 177872.00 37.698%
0.684% 3575.00 0.661% 7392.00 1.567%
0.525% 3157.00 0.584% 3508.00 0.743%
1.459% 8003.00 1.481% 4758.00 1.008%
86.885% 479832.00 88.777% 439626.00 93.173%

13.115% 60661.00 11.223% 32211.00 6.827%


Y-5

57879.00
33759.00
0.00
77368.00
9985.00
178991.00

80000.00
160000.00
17000.00
13200.00
270200.00
-219500.00
50700.00

7000.00
0.00
7000.00

236691.00

77128.00
2755.00
23107.00
102990.00

0.00
0.00

102990.00

70701.01
80000.00
150701.01

253691.01

Year 5

572544.00

82150.00
7391.00
5184.00
1881.00
25233.00
6399.00
2100.00
5544.00
3928.00
7711.00
32887.00
33600.00
7000.00
44061.00
206853.00
5000.00
3028.00
8062.00
488012.00

84532.00
Place a 'Y'' in the accounts for the years that You thinkk need further Investigation.
Place a ''N'' in the accounts for the years that You think are OK..

'Y'' = Investigated
'N'' = OK.

'N''ame or Team # --->


Your Selected accounts will app
Accounts Y- 1 Y-2 Y-3 Y- 4 Y-5 Y-1 Y-2
Current (Assets):
Cash 'N'' 'Y'' 'N'' 'Y'' 'N'' OK. Investigated
Accounts-R 'N'' 'N'' 'N'' 'Y'' 'N'' OK. OK.
Invest - Ma 'N'' 'N'' 'N'' 'Y'' 'Y'' OK. OK.
Supplies I 'N'' 'Y'' 'N'' 'N'' 'Y'' OK. Investigated
Prepaid (R 'Y'' 'N'' 'N'' 'N'' 'N'' Investigated OK.

Property
Clea''N''i'' 'N'' 'N'' 'N'' 'Y'' 'N'' OK. OK.
Va''N''s 'N'' 'N'' 'N'' 'Y'' 'N'' OK. OK.
Office Fur'' 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Office Equi 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Total Propert''Y'', Pla''N''t & Equipme''N''t
Less Accumu 'Y'' 'Y'' 'Y'' 'Y'' 'Y'' Investigated
Investigated

Other Assets:
Re''N''t De 'N'' 'N'' 'N'' 'Y'' 'Y'' OK. OK.
Lo''N''g ter 'N'' 'Y'' 'Y'' 'N'' 'N'' OK. Investigated

Curre''N''t Liabilities:
Accou''N''ts 'N'' 'Y'' 'N'' 'Y'' 'N'' OK. Investigated
Accrued Wa 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Short-Term 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.

Lo''N''g-Term Liabilities:
Lo''N''g-Ter 'N'' 'N'' 'N'' 'Y'' 'N'' OK. OK.

Equit''Y'':
Retai''N''ed 'N'' 'N'' 'N'' 'N'' 'Y'' OK. OK.
Ja''N''et Ja' 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.

Reve''N''ues: 'Y''ear 1 'Y''ear 2 'Y''ear 3 'Y''ear 4 'Y''ear 5 'Y''ear 1 'Y''ear 2


Sales 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Expe''N''ses:
Clea''N''i'' 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Advertisi''N 'N'' 'N'' 'N'' 'N'' 'Y'' OK. OK.
Bad Debt Ex 'N'' 'N'' 'N'' 'Y'' 'Y'' OK. OK.
Ba''N''k Ch 'N'' 'N'' 'N'' 'Y'' 'N'' OK. OK.
Depreciatio' 'Y'' 'Y'' 'Y'' 'Y'' 'Y'' Investigated
Investigated
I''N''sura''N 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
I''N''terest 'N'' 'N'' 'Y'' 'N'' 'N'' OK. OK.
Legal & Pro 'N'' 'Y'' 'Y'' 'Y'' 'N'' OK. Investigated
Miscella''N 'N'' 'N'' 'N'' 'Y'' 'Y'' OK. OK.
Office Supp 'N'' 'N'' 'Y'' 'Y'' 'N'' OK. OK.
Pa''Y''roll 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Re''N''t Exp 'N'' 'N'' 'N'' 'N'' 'Y'' OK. OK.
Repairs & Ma 'N'' 'Y'' 'Y'' 'Y'' 'N'' OK. Investigated
Admi''N''ist 'N'' 'N'' 'N'' 'Y'' 'Y'' OK. OK.
Direct Labo 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Telepho''N' 'N'' 'N'' 'N'' 'Y'' 'N'' OK. OK.
Travel 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
Utilities 'N'' 'N'' 'N'' 'N'' 'N'' OK. OK.
er Investigation.

elected accounts will appear here. Ratios Comparison


Y-3 Y-4 Y-5 Janet Janitorial Service
Y-1 Y-2 Y-3 Y-4 Y-5
OK. Investigated OK. Solve''N''c''Y'':
OK. Investigated OK. Quick R 0.98 0.58 2.38 1.10 1.63
OK. Investigated
Investigated Curre''N' 1.7 1.0 3.2 1.5 2.3
OK. OK. Investigated Curre''N''t 1.81 3.05 2.15 4.64 2.07
OK. OK. OK.
Efficie''N''c''Y'':
Collectio' 13.92 22.39 13.74 34.27 26.02
OK. Investigated OK. Sales/ I''N 11.58 7.20 41.37 16.58 18.42
OK. Investigated OK. Assets/ 0.62 1.00 0.40 1.00 0.39
OK. OK. OK. Accou''N' 0.11 0.29 0.01 0.06 0.07
OK. OK. OK.
Profitabilit''Y'':
Investigated
Investigated
Investigated Retur''N' 5.30% 5.30% 13.12% 13.12% 11.22%
Retur''N' 8.527% 5.304% 32.720% 13.115% 28.650%

OK. Investigated
Investigated
Investigated OK. OK.

OK. Investigated OK.


OK. OK. OK.
OK. OK. OK.

OK. Investigated OK.

OK. OK. Investigated


OK. OK. OK.

'Y''ear 3 'Y''ear 4 'Y''ear 5


OK. OK. OK.
OK. OK. OK.
OK. OK. Investigated
OK. Investigated Investigated
OK. Investigated OK.
Investigated
Investigated
Investigated
OK. OK. OK.
Investigated OK. OK.
Investigated
Investigated OK.
OK. Investigated Investigated
Investigated
Investigated OK.
OK. OK. OK.
OK. OK. Investigated
Investigated
Investigated OK.
OK. Investigated Investigated
OK. OK. OK.
OK. Investigated OK.
OK. OK. OK.
OK. OK. OK.
on
Industry Average

3
3.4
695.3

36.3
219.3
22.2
2.8

4.80%
21.20%

You might also like