Ratio analysis
Calculate ratios from financial statements of companies as assigned in the class. Make a judgment of the performance of the company based on the calculation of financial ratios.
|
APPLE
|
|
|
|
|
|
PROFITABILITY RATIOS
|
|
|
|
|
1. PROFIT MARGIN =
|
NET INCOME
|
53394000/233715000
|
0.228457737
|
22.85%
|
|
NET SALES
|
|
|
|
|
2. RETURN ON COMMON EQUITY =
|
53394000/27416000
|
1.947548877
|
194.75%
|
|
NET INCOME
|
|
|
|
|
AVERAGE COMMON STOCK
|
|
|
|
|
LIQUIDITY RATIOS
|
|
|
|
|
|
1. WOORKING CAPITAL =
|
CURRENT ASSETS - CURRENT LIABILITIES
|
89378000-80610000
|
8768000
|
|
|
2. CURRENT RATIO =
|
CURRENT ASSETS
|
89378000/80610000
|
1.108770624
|
|
|
CURRENT LIABILITIES
|
|
|
|
|
3. QUICK RATIO =
|
CURRENT ASSETS - INVENTORY
|
(89378000-2349000)/80610000
|
|
|
|
CURRENT LIABILITIES
|
|
1.079630319
|
|
|
4. ACCOUNTS RECEIVABLE TURNOVER =
|
233715000/[(35889000+31537000)/2]
|
|
|
|
NET SALES
|
|
6.932488951
|
|
|
AVERAGE RECEIVABLES
|
|
|
|
|
5. COLLSETROM PERIOD
|
|
|
52.65064288
|
|
|
6. INVENTORY TURNOVER =
|
140089000/[(2349000+2111000)/2]
|
|
|
|
COST OF GOODS SOLD
|
|
62.82017937
|
|
|
AVERAGE INVENTORY
|
|
|
|
|
7. DAYS SALES IN INVENTORY
|
|
5.810234922
|
|