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:
11
12
Debtors Days:Creditors Days:
13
Debtors Balance from Balance Sheet10000Creditors Balance from Balance Sheet70
14
Sales for the year (including GST)100000Purchases for the year (including vat)700
15
Debtor Days37Creditor Days37
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.0.1
18
19
20
Liquidity Ratio 1 - Current ratioSupplier Finance Ratio:
21
Total Current Assets20000Creditors Balance from Balance Sheet70
22
Total Current Liabilities1600Sales for the year (including vat)3200
23
Current Ratio13Supplier Finance Ratio2.19%
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