DIY Management Accounting
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEF
1
Fill in your own figures in the blue areas!
2
3
4
5
6
7
Fill in your own figures in the blue areas!
8
9
10
Balance sheet Ratios:36.5
11
12
Debtors Days:Creditors Days:
13
Debtors Balance from Balance Sheet25000Creditors Balance from Balance Sheet16000
14
Sales for the year (including GST)180000Purchases for the year (including vat)280000
15
Debtor Days51Creditor Days21
16
17
The lower this figure is, the quicker your getting your money in = a good signThis figure should be around the 60 day mark. Too low, and you are not negotiating credit terms. Too high, and you may be indicating cashflow problems or just bad supplier management.22.85714286
18
19
20
Liquidity Ratio 1 - Current ratioSupplier Finance Ratio:
21
Total Current Assets550000Creditors Balance from Balance Sheet16000
22
Total Current Liabilities40000Sales for the year (including vat)360000
23
Current Ratio14Supplier Finance Ratio4.44%
24
Current Assets is the sum of Debtors and Bank Balances, Current Liabilities is the sum of Creditors and Short Term Loans. This indicates your ability to pay what you currently owe. Inventory is generally not included in this calc.Used in conjunction with Creditor days, it shows how well you are managing cashflow, by using good supplier credit terms to finance costs of sales. However if the creditor days is suspiciously high, it could just mean that you are not paying your suppliers and they will soon cut you off.
25
Loading...
 
 
 
Sheet1