complete term projects details attached
CCL DETAILED RATIO CALCULATIONS 2014
| Gross profit percentage | Gross profit = 2,585,637 – 1,891,506 = 694,131 Gross profit percentage = 694,131 / 2,585,637 | 26.85% |
| Net profit margin percentage | 216,566 / 2,585,637 | 8.38% |
| Return on total assets (ROA) | Average total assets = (2,401,648 + 2,618,375) /2 = 2,510,011.50 ROA = 216,566 / 2,510,011.50 | 8.63% |
| Return on equity (ROE) | Average shareholder’s equity = (1,018,135 + 1,216,219) /2 =1,117,177 ROE = 216,566 / 1,117,177 | 19.39% |
| Basic earnings per share (EPS) | (from Consolidated Statement of Income) | $6.31 |
| Accounts receivable turnover ratio | Average AR = (347,631+364,195) /2 = 355,914.50 AR turnover ratio = 2,585,637 / 355,914.50 | 7.26 |
| Inventory turnover ratio | Average inventory = (181,644+192,286) /2 = 186,965 Inventory turnover ratio= 1,891,506/ 186,965 | 10.12 |
| Asset turnover ratio | 2,585,637 / 2,510,011.50 | 1.03 |
| Current ratio | 821,883 / 600,197 | 1.37 |
| Debt to total assets ratio | 1,402,156 / 2,618,375 | 0.54 |
| Times interest earned ratio | Income before taxes & interest = 304,198 + 26,705 = 330,903 Times interest earned ratio = 330,903 / 26,705 | 12.39 |
| Price/earnings ratio | $125.87 / $6.31 | 19.95 |
WINPAK DETAILED RATIO CALCULATIONS 2014
| Gross profit percentage | Gross profit = 786,754 – 562,379 = 224,375 Gross profit percentage = 224,375 / 786,754 | 28.52% |
| Net profit margin (percentage) | 79,652 / 786,754 | 10.12% |
| Return on total assets (ROA) | Average total assets = (713,204 + 734,327) /2 = 723,765.50 ROA = 79,652 / 723,765.50 | 11.01% |
| Return on equity (ROE) | Average shareholder’s equity = (592,613 + 601,387) /2 = 597,000 ROE = 79,652 / 597,000 | 13.34% |
| Basic earnings per share (EPS) | (from Consolidated Statement of Income) | $1.21 |
| Accounts receivable turnover ratio | Average AR = (89,077 + 105,338*) /2 = 97,207.50 AR turnover ratio = 786,754 / 97,207.50 | 8.09 |
| Inventory turnover ratio | Average inventory = (92,304 + 100,586) /2 = 96,445 Inventory turnover ratio = 562,379 / 96,445 | 5.83 |
| Asset turnover ratio | 786,754 / 723,765.50 | 1.09 |
| Current ratio | 364,018/ 71,090 | 5.12 |
| Debt to total assets ratio | 132,940 / 734,327 | 0.18 |
| Times interest earned ratio | Income before taxes & interest = 115,181 + 469 = 115,650 Times interest earned ratio = 115,650 / 469 | 246.59 |
| Price/earnings ratio | $32.39 / $1.21 | 26.77 |