Question
My head is starting to spin looking at all these numbers. I need some ratios calculated from annual consolidated financial statements (Virgin Holdings on ASX,
My head is starting to spin looking at all these numbers.
I need some ratios calculated from annual consolidated financial statements (Virgin Holdings on ASX, consolidated sheets included as JPG)
I have managed to confuse myself a bit and just need someone to run through quickly and put the ratios i need up with the calculations.
ROE
ROA
CEL
CSL
Gross profit margin
Accounts receivable turnover
Net-long term asset turnover
PP&E turnover
Current Ratio
Quick Ratio
Cash Ratio
Operating cash flow ratio
Liability to equity ratio
Debt to equity ratio
Net debt to equity ratio
Debt-to-capital ratio
Net-debt-to-net-capital ratio
My numbers are this.......
Virgin | |
$m | 2015 |
Net income | -93.8 |
Average common shareholders' equity | 1034.45 |
Net interest expense after tax | -103.24 |
Average total assets | 5229.45 |
ROA | -1.97% |
CEL | 0.909 |
CSL | 5.055 |
ROE | -9.07% |
Sales | 3999 |
Cost of Sales | 4499.9 |
EBIT | 65.9 |
EBITDA | 341.3 |
NOPAT | -53.5 |
Operating working capital | -1302 |
Average accounts receivable | 303.85 |
Average net long-term assets | 3690.4 |
Average net PP&E | 2892.15 |
Gross profit margin | -12.5% |
EBIT margin | 1.65% |
EBITDA margin | 8.53% |
NOPAT margin | -1.34% |
Operating working capital to sales ratio | -32.6% |
Operating working capital turnover | -3.071 |
Accounts receivable turnover | 13.161 |
Net long-term asset turnover | 1.084 |
PP&E turnover | 1.383 |
Current assets | 1586 |
Current liabilities | 2299.8 |
Cash + accounts receivable | 1333.3 |
Cash and cash equivilants | 1028.5 |
Cash flow from operations | 218.1 |
Average current liabilities | 2110.2 |
Current ratio | 0.690 |
Quick ratio | 0.580 |
Cash ratio | 0.447 |
Operating cash flow ratio | 0.103 |
Total liabilities | 4758.8 |
Shareholders' equity | 1020.8 |
Short-term + long term debt | 2762.2 |
Liabilities-to-equity ratio | 4.662 |
Debt--to-equity ratio | 2.706 |
Net-debt-to-equity ratio | 1.698 |
Debt-to-capital ratio | 0.730 |
Net-debt-to-net-capital ratio | 0.629 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started