Balance Sheet Ratios Calculator - Gusto
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
IMPORTANT READ FIRST:
This spreadsheet is view only. To edit the spreadsheet go to File >> Make a Copy. This will add an editable copy to your own Google Drive.

INSTRUCTIONS:
Enter the amounts in the Balance Sheet Totals section. The balance sheet ratios will calculate for you.
Light grey cells: You fill in the information.
White cells: These cells have formulas that will auto-calculate for you. Do not type into these cells or you will lose the formula
s.
2
3
BALANCE SHEET TOTALS
4
Total Current Assets$10,000.00
5
Total Inventory$3,000.00
6
Total Assets$13,000.00
7
Total Current Liabilities$6,000.00
8
Total Liabilities$20,000.00
9
Net Income (from Profit & Loss report)$30,000.00
10
Depreciation (from Profit & Loss report)$7,000.00
11
12
NET WORKING CAPITAL
13
How much money is available for your daily operations and to invest?
14
Working Capital$4,000.00
15
16
CURRENT & QUICK RATIO
17
How liquid is your business?
18
Current Ratio1.7
19
Quick Ratio1.2
20
21
DEBT TO ASSET RATIO
22
How much of your assets were purchased through debt?
23
Debt to Asset Ratio1.5High risk
24
25
SOLVENCY RATIO
26
Can you business pays its long terms debts and remain operational?
27
Solvency Ratio1.9
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...