An Excel 2010 spreadsheet, that allows you to change the 'blue' cells to reflect any stimulus material.
The spreadsheet will then calculate the following formulas to give the answers for the four sets of ratios (liquidity, efficiency, profitability and shareholder ratios);
Current Ratio
Acid Test Ratio
ROCE %
Asset Turnover
Inventory Turnover
Payables Days
Receivables Days
Gearing
DPS
Dividend Yield
The 'Your Response' column turns green when the correct answer is entered (as per the d.p indicated).
The correct answers can also be seen by pressing the 'Show Answers' button, and hidden again by pressing 'hide'.
The spreadsheet will then calculate the following formulas to give the answers for the four sets of ratios (liquidity, efficiency, profitability and shareholder ratios);
Current Ratio
Acid Test Ratio
ROCE %
Asset Turnover
Inventory Turnover
Payables Days
Receivables Days
Gearing
DPS
Dividend Yield
The 'Your Response' column turns green when the correct answer is entered (as per the d.p indicated).
The correct answers can also be seen by pressing the 'Show Answers' button, and hidden again by pressing 'hide'.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00