Financial Statement Analysis Assignment
AmazingExpert
4_tables_sample.xlsxPROFITABILITY
| PROFITABILITY | ||||||||||||
| PBT | Finance Cost | PBIT | Total Equity | Debt (Borrowings) | Capital Employed | Total Assets | Current Liabilities | TALCL | PAT (Profit for the year) | Revenue | ||
| Tate & Lyle Plc. | 2013 | |||||||||||
| Tate & Lyle Plc. | 2012 | |||||||||||
| Dairy Crest Group Plc. | 2013 | |||||||||||
| Dairy Crest Group Plc. | 2012 | |||||||||||
| PBIT growth | PAT growth | Revenue growth | ROCE 1 | ROCE 2 | ROE | Profit Margin | Asset Turnover | |||||
| Tate & Lyle Plc. | 2013 | |||||||||||
| Tate & Lyle Plc. | 2012 | |||||||||||
| Dairy Crest Group Plc. | 2013 | |||||||||||
| Dairy Crest Group Plc. | 2012 | |||||||||||
| NOTES | ROCE 1 is based on Debt + Equity as per column H | |||||||||||
| ROCE 2 is based on TALCL as per column K |
LIQUIDITY
| LIQUIDITY | |||||||||
| Current Assets | Current Liabilities | Inventories | Trade Payables | Trade Receivables | COS | Inventory Expenses | Working Capital | ||
| Tate & Lyle Plc. | 2013 | ||||||||
| Tate & Lyle Plc. | 2012 | ||||||||
| Dairy Crest Group Plc. | 2013 | ||||||||
| Dairy Crest Group Plc. | 2012 | ||||||||
| Current Ratio | Quick Ratio | Inventory Turnover 1 (no of times) | Inventory Turnover 2 (days) | Payables Days | Receivables Days | Inv/COS | |||
| Tate & Lyle Plc. | 2013 | ||||||||
| Tate & Lyle Plc. | 2012 | ||||||||
| Dairy Crest Group Plc. | 2013 | ||||||||
| Dairy Crest Group Plc. | 2012 | ||||||||
GEARING
| GEARING | ||||||||||||||
| Equity | Debt (Borrowings) | Capital Employed | Finance Cost | PBIT | Net cash from operating activities | Total Debt (Total Liabilities) | ST + LT Debt | Gearing 1 | Gearing 2 | Interest Cover | Cash Flow ratio | Beaver | ||
| Tate & Lyle Plc. | 2013 | |||||||||||||
| Tate & Lyle Plc. | 2012 | |||||||||||||
| Dairy Crest Group Plc. | 2013 | |||||||||||||
| Dairy Crest Group Plc. | 2012 | |||||||||||||
| Z SCORE | ||||||||||||||
| Working Capital | Total Assets | Return Earnings | PBIT | Market Value of Equity | Debt | Revenue | X1 | X2 | X3 | X4 | X5 | Z | ||
| Tate & Lyle Plc. | 2013 | |||||||||||||
| Dairy Crest Group Plc. | 2013 | |||||||||||||
| 1 | Based on Debt/Equity | |||||||||||||
| 2 | Based on Debt/Capital Employed |
SHAREHOLDER INTEREST
| DPS | Basic EPS | Market Price | DY | EY | PE | Dividend Cover | PE (FT) | No. of Shares | |||
| Tate & Lyle Plc. | 2013 | ||||||||||
| Tate & Lyle Plc. | 2012 | ||||||||||
| Tate & Lyle Plc. | 2011 | ||||||||||
| Tate & Lyle Plc. | 2010 | ||||||||||
| Tate & Lyle Plc. | 2009 | ||||||||||
| Dairy Crest Group Plc. | 2013 | ||||||||||
| Dairy Crest Group Plc. | 2012 | ||||||||||
| Dairy Crest Group Plc. | 2011 | ||||||||||
| Dairy Crest Group Plc. | 2010 | ||||||||||
| Dairy Crest Group Plc. | 2009 |
