CASE STUDY 9 ACME PAINT COMPANY
Advance Your World.
To help you prepare for Chapter 9, there is a case to be reviewed and analyzed prior to attending the class. You should be prepared to share and discuss the following:
\u2022 Evaluate the financial health of the company.
\u2022 As the officer of the account, you will identify specific issues that are of major concern.
\u2022 Note any recognizable problem-loan warning signs.
The case study will address the following issues:
\u2022 Case Study Acme Paint Company
\u2013 Evaluation of the company
\u2013 Identifying problem loans and warning signs<\/p>\n
CS 9 \u2013 2
CASE 1: ACME PAINT COMPANY ACME PAINT COMPANY BALANCE SHEET (FROM COMPANY RECORDS, PREPARED WITHOUT AUDIT)
Fiscal Year Assets
6\/30\/X1 06\/30\/X2 06\/30\/X3 06\/30\/X4 06\/30\/X5
Cash $30,600 $69,100 $30,000 $21,700 $1,200
Accounts Receivable 209,000 250,100 190,200 213,500 174,700
Inventory 472,800 425,600 388,200 360,000 399,000
Prepaid Expenses 37,000 8,900 500 16,400 8,200 Total Current Assets
749,400
753,700
608,900
611,600
583,100
Land & Buildings (net) 145,100 146,200 282,500 280,100 323,800
Equipment (net) 32,200 33,500 55,000 59,800 96,500 Total Fixed Assets
177,300
179,700
337,500
339,900
420,300
TOTAL ASSETS $926,700 $933,400 $946,400 $951,500 $1,003,400
Liabilities
Notes Payable \u2013 Banks $85,000 $77,000 $100,000 $119,500 $132,700
Accounts Payable 230,000 254,400 255,100 257,300 254,500
Other Current Liabilities 31,800 40,400 26,000 27,700 22,900 Total Current Liabilities
346,800
371,800
381,100
404,500
410,100
Mortgage & Contracts Payable 191,400 168,400 164,100 144,200 188,100
TOTAL LIABILITIES $538,200
$540,200
$545,200
$548,700
$598,200
Common Stock
$189,600
$189,600
$189,600
$189,600
$189,600
Retained Earnings 198,900 203,600 211,600 213,200 215,600 TOTAL NET WORTH
$388,500
$393,200
$401,200
$402,800
$405,200
TOTAL LIABILITIES & NET WORTH $926,700 $933,400 $946,400 $951,500 $1,003,400<\/p>\n
CS 9 \u2013 3
ACME PAINT COMPANY INCOME STATEMENT
Fiscal Year 06\/30\/X1 06\/30\/X2 06\/30\/X3 06\/30\/X4 06\/30\/X5
Sales $2,900,000 $2,400,000 $2,200,000 $1,900,000 $2,000,000
Less: Cost of Goods Sold
2,262,000
1,800,000
1,700,000
1,450,000
1,500,000
Gross Profit
$638,000
$600,000
$500,000
$450,000
$500,000
Expenses
General & Administrative $574,000 $548,000 $432,000 $389,000 $437,000 Depreciation 10,000 11,000 21,000 22,000 26,000 Interest 33,000 31,000 34,000 32,000 36,000
Total Operating Expenses
617,000
590,000
487,000
443,000
499,000
Operating Profit
21,000
10,000
13,000
7,000
1,000
Other Income -0- -0- -0- -0- 2,000 Other Expenses 6,000 4,000 3,000 5,000 -0- Net Profit before Tax
15,000
6,000
10,000
2,000
3,000
Income Tax 3,300 1,300 2,000 400 600 Net Profit after Tax
$11,700
$4,700
$8,000
$1,600
$2,400<\/p>\n
CS 9 \u2013 4
ACME PAINT COMPANY CASE ANALYSIS
Solvency
Year \u2019X1 Year \u2019X2 Year \u2019X3 Year \u2019X4 Year \u2019X5 RMA
1. Current Ratio 2.16 2.02 1.60 1.51 1.42 2.10 2. Quick Ratio .69 .86 .58 .58 .43 1.00
Safety
3. Debt-to-Worth Ratio 1.39 1.37 1.36 1.36 1.47 1.00
Profitability
4. Gross Margin % 22.0 25.0 22.7 23.7 25.0 29.0 5. Net Margin % (pretax) 0.52 0.25 0.45 0.10 0.15 4.1
Asset Management
6. Sales to Assets 3.13 2.57 2.32 2.00 1.99 2.30 7. Return on Assets % 1.30 0.50 0.80 0.20 0.20 9.0 8. Return on Investment % 3.10 1.30 0.80 0.40 0.60 19.4 9. Inventory Turnover 4.78x 4.23x 4.38x 4.03x 3.76x 4.90x 10. Inventory (Days) 75 85 82 89 96 74 11. Accounts Receivable Turnover 13.88x 9.60x 11.57x 8.90x 11.49x 8.90x 12. Collection Period Days 26 38 31 40 31 41
YEARS \u2019X1 TO \u2019X5 Trend Analysis
Sales: Down 31%
Net Profit: Down 79%
Working Capital: Down 57%
Total Assets: Up 8%
Gross Margin % Up 14%
Net Margin % Down 71%<\/p>\n
CS 9 \u2013 5
ACME PAINT COMPANY HISTORICAL SOURCES AND USES (WORKING CAPITAL) ($000S)
ID 1: Fiscal Year-end: June 30 ID 2: Date: X6-Sept.- X5 SOURCES
Company Year \u2019X3
Company Year \u2019X4
Company Year \u2019X5
1. Net Income (Loss) before Nonrecurring. G\/L 8 2 2 2. Nonrecurring G\/L 0 0 0 3. Depreciation Expense 21 22 26 4. Amortization Expense 0 0 0 5. Deferred Taxes 0 0 0 6. FUNDS FROM OPERATIONS 29 24 28 7. Increase (Decr.) Minority Interest 0 0 0 8. Increase (Decr.) Preferred Stock 0 0 0 9. Increase (Decr.) Cap. Stock & Surpl. 0 0 0 10. Adjustments to Retained Earnings 0 0 0 11. Increase (Decr.) Long-term Debt (4) (20) 44 12. Increase (Decr.) Subordinated Debt 0 0 0 13. Increase (Decr.) Other Noncurr. Liabs. 0 0 0 14. TOTAL SOURCES OF FUNDS 25 4 72
APPLICATIONS 15. Preferred Dividend
0
0
0
16. Common Dividend 0 0 0 17. Increase (Decr.) Treasury Stock 0 0 0 18. Increase (Decr.) Fixed Assets 179 24 106 19. Increase (Decr.) Intangible Assets 0 0 0 20. Increase (Decr.) Other Noncurr.Assets 0 0 0 21. Increase (Decr.) in Working Capital (154) (21) (34)
22. TOTAL USES OF FUNDS 25 4 72 CURRENT ASSETS 23. Increase (Decr.) Cash & Equivalents
(39)
(8)
(21) 24. Increase (Decr.) Marketable Sec. 0 0 0 25. Increase (Decr.) Accounts Rec.-Trade (60) 23 (39) 26. Increase (Decr.) Notes Rec.-Trade 0 0 0 27. Increase (Decr.) Inventories (37) (28) 39 28. Increase (Decr.) Prepaids (8) 16 (8) 29. Increase (Decr.) Other Curr. Assets 0 0 0
30. TOTAL CHANGE IN CURRENT ASSETS (145) 3 (29) CURRENT LIABILITIES 31. Increase (Decr.) N\/P-Bank
23
20
13 32. Increase (Decr.) CPLT & Sub. Debt 0 0 0 33. Increase (Decr.) Accounts Payable 1 2 (3) 34. Increase (Decr.) Income Tax Payable 0 0 0 35. Increase (Decr.) Other Accrued Exp. (14) 2 (5) 36. Increase (Decr.) Other Curr. Liabs. 0 0 0
37. TOTAL CHANGE IN CURR. LIABS. 9 24 5 38. INCREASE (DECR.) IN WORKING CAPITAL (154) (21) (34
39. TOTAL CHANGE CURR. LIABS. & WC (145) 3 29<\/p>\n
CS 9 \u2013 6
ACME PAINT COMPANY HISTORICAL CASH FLOW ($000S) ( ) = Cash Outflow
ID 1: Fiscal Year-end: June 30
LESS DISBURSEMENTS 6. Cost of Goods Sold (Less Depr.) (1,700) (1,450) (1,500) 7. Inventories-Decr. (Incr.) 37 28 (39) 8. Accounts Payable-Incr. (Decr.) 1 2 (3) 9. Operating Exp. (Exc. Depr. & Amort.) (432) (389) (437) 10. Interest Expense (34) (32) (36) 11. Income Taxes (Paid) (2) (0) (1) 12. Fixed Assets-Decr.(Incr.) (179) (24) 106) 13. Net Other Cash Disbursements* (6) (14) 0 14. TOTAL DISBURSEMENTS (2,315) (1,880) (2,122) 15. CASH FLOW BEFORE FINANCING (58) (8) (78) 16. CASH SURPLUS (DEFICIT) 11 22 (56)
FINANCING SOURCES 17. Notes Payable Bank-Incr. (Decr.)
23
20
13
18. Long-Term Debt-Incr. (Decr.) (4) (20) 44 19. Subordinated Debt-Incr. (Decr.) 0 0 0 20. Capital Stock and Miscellaneous Income-Incr. (Decr.) 0 0 0 21. Dividends Paid 0 0 0 22. Adjustment to Retained Earnings 0 0 0 23. CASH BALANCE ENDING 30 22 1
CUMULATIVE BALANCES 24. Notes Payable Bank
100
120
133
25. Long-term Debt 164 144 188 26. Subordinated Debt 0 0 0 * OTHER CASH RECEIPTS (DISBURSEMENTS) 27. Nonrecurr. Gains (Losses) 0 0 0 28. Marketable Securities-Decr. (Incr.) 0 0 0 29. Oth. Rec., Prepaids, Oth. Curr.Assets-Decr. (Incr.) 8 (16) 8 30. Interest Accrual, LT Inv. & Oth. NCA-Decr. (Incr.) 0 0 0 31. Accruals & Other Curr. Liabs.-Incr. (Decr.) (14) 2 (5) 32. Noncurr. Liabs.-Incr. (Decr.) 0 0 0 33. * NET OTHER CASH RECEIPTS (DISBURSEMENTS) (6) (14) 3
C re
di t E
ss en
tia ls
C ou
rse
ID 2: Date: X6-Sept.-X5
Company Year \u2019X3
Company Year \u2019X4
Company Year \u2019X5
1. Cash Balance Beginning Plus Receipts 69 30 22 2. Accounts Receivable Collections 2,260 1,877 2,039 3. Other Income (Expense) (3) (5) 2 4. Net Other Case Receipts* 0 0 3 5. TOTAL RECEIPTS 2,257 1,872 2,044<\/p>\n
CS 9 \u2013 7
ACME PAINT COMPANY HISTORICAL FINANCIAL RATIOS
ID 1: ID 2:
Company
Company
Fiscal Year-end: June 30 Company Company
Date: X6-Sept. X5 Year X2 Year X3 Year X4 Year X5
LIQUIDITY & SOLVENCY RATIOS 1. Current Ratio (x)
2.03
1.60
1.51
1.42
2. Quick Ratio (x) 0.86 0.58 0.58 9.43 3. Working Capital ($) 382.00 228.00 207.00 173.00 4. Working Capital (% Sales) 15.91 10.35 10.87 8.65
SAFETY RATIOS 5. Debt\/Worth (x)
1.37
1.36
1.36
1.48
6. Debt\/Worth (w\/Sub.debt)(x) 1.37 1.36 1.36 1.48 7. Break-even Sales ($) 2,360.00 2,143.00 1,870.00 1,996.00 8. Actual Sales\/Break-even Sales (x) 1.02 1.03 1.02 1.00 9. Z Factor (#) 4.43 3.39 3.17 2.80
GROWTH RATIOS 10. Sales (Annual %)
NA
-8.33
-13.64
5.26
11. Pretax Income (Annual %) NA 66.67 -80.00 50.00 12. Sust. Growth-same D\/W (%) 1.21 2.03 0.40 0.60 13. Sust. Growth-new D\/W 2.20 37.01 39.43 36.15 30.22 14. Sust. Growth-No New Debt (%) 0.84 1.44 0.29 0.41
PROFITABILITY RATIOS 15. Gross Margin (%)
25.00
22.73
23.68
25.00
16. Operating Expense (%) 23.29 20.59 21.63 23.15 17. Operating Profit Margin (%) 1.71 2.14 2.05 1.85 18. Pretax Profit Margin (%) 0.25 0.45 0.11 0.15 19. Net Profit Margin (%) 0.20 0.36 0.08 0.12
BALANCE SHEET MANAGEMENT RATIOS 20. Sales to Assets (x)
2.57
2.32
2.00
1.99
21. Assets to Sales (%) 38.89 43.02 50.08 50.17 22. Sales to Net Fixed Assets (x) 13.36 6.52 5.59 4.76 23. Return on Assets (Pretax %) 0.64 1.06 0.21 0.30 24. Return on Equity (Pretax %) 1.53 2.49 0.50 0.74 25. A\/R Collection Period (Days) 0.00 0.00 0.00 0.00 26. Inventory Turnover (Days) 0.00 0.00 0.00 0.00 27. A\/P Payment Period (Days) 0.00 0.00 0.00 0.00
FINANCING RATIOS 28. Net Profit Bank to Sales (%)
3.21
4.55
6.32
6.64
29. Interest Coverage (x) 1.19 1.29 1.06 1.08 30. Principal & Interest Coverage (x) NA 1.29 1.06 1.08 31. Net Profit to A\/R (%) 75.00 30.79 52.58 56.21 75.96 32. Inv. Reliance (%) 60.00 0.00 0.00 0.00 0.00 33. Credit Based on Inv. and A\/R 443.00 376.00 376.00 370.00 34. Credit Avail. (Deficit) ($) 366.00 276.00 258.00 238.00 35. LTD to Net Fixed Assets (%) 93.71 48.62 42.42 44.75 36. LTD with Sub. Debt\/Net Fixed Assets (%) 93.71 48.62 42.42 44.75<\/p>\n
( ) = Cash Outflow<\/p>\n","protected":false},"excerpt":{"rendered":"
CASE STUDY 9 ACME PAINT COMPANY Advance Your World. To help you prepare for Chapter 9, there is a case to be reviewed and analyzed prior to attending the class. You should be prepared to share and discuss the following: \u2022 Evaluate the financial health of the company. \u2022 As the officer of the account, … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-37642","post","type-post","status-publish","format-standard","hentry","category-essaywr"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/posts\/37642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/comments?post=37642"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/posts\/37642\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/media?parent=37642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/categories?post=37642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/writings\/wp-json\/wp\/v2\/tags?post=37642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}