Accounting Case
Accounting Case
Accounting Case
CASE 3
FIN 103
PRINCIPLES OF FINANCE
UNICORN CLUB
III BS LM
Balance Sheet
January 31, 1992
Assets
Cash*
Accounts Receivable
Inventory
Total Current Assets
Plant and equipment
Less: Allowance for depreciation
Total fixed assets
Total assets
Liabilities and Net Worth
Accounts payable
Short term notes
Accrued Expenses
Total current liabilities
Long-term debt
Common stock, $10 par
Retained Earnings**
Total liabilities and net worth
*balancing figure
**assuming no dividends
360/(Credit Sales/A/R) = 60
A/R = 360/(720,000/A/R) = 60
A/R = $ 120,000.00
COGS/INV = 5
90,000/INV = 5
INV = $ 180,000.00
$ 61,600.00
120,000.00
180,000.00
$ 361,600.00
1,340,000.00
(500,000.00)
$ 840,000.00
$ 1,201,600.00
$ 46,000.00
30,000.00
24,000.00
$ 100,000.00
386,000.00
200,000.00
515,600.00
$ 1,201,600.00
Sales
Cost of goods sold
Gross profit
Income Statement
For the month ended January 31, 1992
$ 100,000.00
(75,000.00)
$ 25,000.00
Operating expenses
Variable cash operating expense
Fixed cash operating expense
Depreciation
Total operating expenses
7,000.00
2,500.00
5,000.00
$(14,500.00)
10,500.00
(2,500.00)
$ 8,000.00
(2,400.00)
Net income
$ 5,600.00
Cash Budget
From January 1, 1992-January 31, 1992
Collections of A/R
Cash received from sale of plant and
equipment
Cash received from long-term debt
Total cash received
$ 100,000.00
75,000.00
186,000.00
$ 361,000.00
Disbursements
To suppliers
For variable cash operating expense
For fixed cash operating exepnse
For interest
For taxes
For short term notes payable
Total disbursements
101,000.00
7,000.00
2,500.00
2,500.00
2,400.00
194,000.00
$ 309,400.00
51, 600.00
10,000.00
$ 61,600.00
We have now come to conclusion that Hartlys proposed plan has succeeded because....
We will now evaluate the financial condition of the firm through the employment of a
ratio analysis of the firm versus the industry.
Current Ratio
Acid-test Ratio
Average Collection Period
Inventory Turnover
Fixed Asset Turnover
Total Asset Turnover
Debt Ratio
Time Interest Earned
Gross Profit Margin
Net Profit Margin
Return on Assets
Return on Equity
Firm
3.616x
1.816x
62 days
5x
1.43x
1x
40.45%
4.2x
25%
5.6%
5.6%
9.4%
Industry
3.5x
1.5x
60 days
5x
1.43x
1x
45%
4.1x
25%
8%
8%
14.55%