Assets 2001 2000 Cash 7,282 9,000 Short term investment 0 48,600 Acc. Receivable 632,160 351,200 Inventories 1,287,360 715,200 Total current assets 1,926,802 1,124,000 Fixed Assets Plant & Equipment 1,202,950 491,000 Less: Acc dep 263,160 146,200 939,790 344,800 Total assets 2,866,592 1,468,800 Liabilities & Equities Current liability A/c Payable 524,160 145,600 Notes payable 720,000 200,000 Accruals 489,600 136,000 total Current liability 1,733,760 481,600 Long-term debt 1,000,000 323,432 Common Stock 460,000 460,000 Retained Earning -327,168 203,768 1,132,832 987,200 Total equities 2,866,592 1,468,800 Income Statement Sales 5,834,400 3,432,000 Cost of Goods Sold 5,728,000 2,864,000 Other expense 680,000 340,000 dep 116,960 18,900 EBIT/ LOSS -690,560 209,100 Interest expense 176,000 62,500 EBT/ LOSS -866,560 146,600 tax -346624 58640 net income/loss -519,936 87,960 1.Liquidity a. Current Ratio = Current Assets / Current Liabilities 2001 = 1926802 / 1733760 = 1.11 2000 = 1124000 / 481600 = 2.33 b. Quick Ratio = Quick Assets / Current Liabilities 2001 = 639442 / 1733760 = 0.37 2000 = 408800 / 481600 = 0.85 2.Profitability a. Profit Margin = Net Income / Sales 2001 = -519936 / 5834400 = -8.91% 2000 = 87960 / 3432000 = 2.56% b. Return on Assets = Net Income / Total Assets 2001 = -519936 / 2866592 = -18.14% 2000 = 87960 / 1468800 = 5.99% 3.Leverage a. Debt to Equity = Total Liabilities / Total Equity 2001 = 2733760 / 132832 = 20.58 2000 = 785032 / 663768 = 1.18 b. Debt to Assets = Total Liabilities / Total Assets 2001 = 2733760 / 2866592 = 0.95 2000 = 785032 / 1468800 = 0.53 4.Efficiency Ratio a. Accounts Receivable Turnover = Sales / Accounts Receivable 2001 = 5834400 / 632160 = 9.23 2000 = 3432000 / 351200 = 9.77 b. Inventory Turnover = Cost of goods sold / Inventory 2001 = 5728000 / 1287360 = 4.45 2000 = 2864000 / 715200 = 4 5.Coverage Ratio a. Times Interest earned = EBIT / Interest Expense 2001 = -690560 / 176000 = -3.92 Times 2000 = 209100 / 62500 = 3.35 Times 6.Market Ratio - data insufficient for Market ratio Q) Based on these calculations of Liquidity, Profitability, Leverage, Efficiency Ratio and Market Ratio interpret and give your comments about the company’s liquidity, profitability, and solvency
Assets |
2001 |
2000 |
Cash |
7,282 |
9,000 |
Short term investment |
0 |
48,600 |
Acc. Receivable |
632,160 |
351,200 |
Inventories |
1,287,360 |
715,200 |
Total current assets |
1,926,802 |
1,124,000 |
Fixed Assets |
||
Plant & Equipment |
1,202,950 |
491,000 |
Less: Acc dep |
263,160 |
146,200 |
939,790 |
344,800 |
|
Total assets |
2,866,592 |
1,468,800 |
Liabilities & Equities |
||
Current liability |
||
A/c Payable |
524,160 |
145,600 |
Notes payable |
720,000 |
200,000 |
Accruals |
489,600 |
136,000 |
total Current liability |
1,733,760 |
481,600 |
Long-term debt |
1,000,000 |
323,432 |
Common Stock |
460,000 |
460,000 |
|
-327,168 |
203,768 |
1,132,832 |
987,200 |
|
Total equities |
2,866,592 |
1,468,800 |
Income Statement |
||
Sales |
5,834,400 |
3,432,000 |
Cost of Goods Sold |
5,728,000 |
2,864,000 |
Other expense |
680,000 |
340,000 |
dep |
116,960 |
18,900 |
EBIT/ LOSS |
-690,560 |
209,100 |
Interest expense |
176,000 |
62,500 |
EBT/ LOSS |
-866,560 |
146,600 |
tax |
-346624 |
58640 |
net income/loss |
-519,936 |
87,960 |
1.Liquidity
a.
2001 = 1926802 / 1733760 = 1.11
2000 = 1124000 / 481600 = 2.33
b. Quick Ratio = Quick Assets / Current Liabilities
2001 = 639442 / 1733760 = 0.37
2000 = 408800 / 481600 = 0.85
2.Profitability
a. Profit Margin = Net Income / Sales
2001 = -519936 / 5834400 = -8.91%
2000 = 87960 / 3432000 = 2.56%
b. Return on Assets = Net Income / Total Assets
2001 = -519936 / 2866592 = -18.14%
2000 = 87960 / 1468800 = 5.99%
3.Leverage
a. Debt to Equity = Total Liabilities / Total Equity
2001 = 2733760 / 132832 = 20.58
2000 = 785032 / 663768 = 1.18
b. Debt to Assets = Total Liabilities / Total Assets
2001 = 2733760 / 2866592 = 0.95
2000 = 785032 / 1468800 = 0.53
4.Efficiency Ratio
a.
2001 = 5834400 / 632160 = 9.23
2000 = 3432000 / 351200 = 9.77
b. Inventory Turnover = Cost of goods sold / Inventory
2001 = 5728000 / 1287360 = 4.45
2000 = 2864000 / 715200 = 4
5.Coverage Ratio
a. Times Interest earned = EBIT / Interest Expense
2001 = -690560 / 176000 = -3.92 Times
2000 = 209100 / 62500 = 3.35 Times
6.Market Ratio - data insufficient for Market ratio
Q) Based on these calculations of Liquidity, Profitability, Leverage,
Trending now
This is a popular solution!
Step by step
Solved in 2 steps