ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
SMALL BUSINESS BALANCE SHEET TEMPLATE EXAMPLE
https://www.smartsheet.com/try-it?trp=11260&utm_source=integrated-content&utm_campaign=/content/small-business-balance-sheet-templates&utm_medium=Small+Business+Balance+Sheet+Example+google+sheets+11260&lpa=Small+Business+Balance+Sheet+Example+google+sheets+11260
3
[ COMPANY NAME ]BALANCE SHEET
4
ASSETS[ CURRENT YR. ][ PRIOR YR. ]LIABILITIES AND OWNER'S EQUITY[ CURRENT YR. ][ PRIOR YR. ]
5
CURRENT ASSETSCURRENT LIABILITIES
6
Cash $ 25,000.00 $ 18,000.00 Accounts Payable $ 5,000.00 $ 4,500.00
7
Accounts Receivable $ 50,000.00 $ 45,000.00 Short-Term Loans $ 12,500.00 $ 8,500.00
8
Inventory $ 20,000.00 $ 15,000.00 Income Taxes Payable $ 18,500.00 $ 15,000.00
9
Prepaid Expenses $ 10,000.00 $ 10,000.00 Accrued Salaries and Wages $ 85,000.00 $ 70,000.00
10
Short-Term Investments $ 15,000.00 $ 12,000.00 Unearned Revenue $ 4,650.00 $ 2,800.00
11
TOTAL CURRENT ASSETS $ 120,000.00 $ 100,000.00 Current Portion of Long-Term Debt $ 5,600.00 $ 2,800.00
12
FIXED (LONG-TERM) ASSETSTOTAL CURRENT LIABILITIES $ 131,250.00 $ 103,600.00
13
Long-Term Investments $ 45,000.00 $ 37,500.00 LONG TERM LIABILITIES
14
Property, Plant, and Equipment $ 18,500.00 $ 15,000.00 Long-Term Debt $ 5,800.00 $ 8,750.00
15
(Less Accumulated Depreciation) $ (5,600.00) $ (4,250.00)Deferred Income Tax $ 2,500.00 $ 2,200.00
16
Intangible Assets $ 15,000.00 $ 11,000.00 Other $ 4,500.00 $ 3,000.00
17
TOTAL FIXED ASSETS $ 72,900.00 $ 59,250.00 TOTAL LONG-TERM LIABILITIES $ 12,800.00 $ 13,950.00
18
OTHER ASSETSOWNER'S EQUITY
19
Deferred Income Tax $ 2,800.00 $ 2,200.00 Owner's Investment $ 11,000.00 $ 18,500.00
20
Other $ 7,500.00 $ 5,500.00 Retained Earnings $ 20,000.00 $ 15,000.00
21
TOTAL OTHER ASSETS $ 10,300.00 $ 7,700.00 Other $ 4,650.00 $ 2,800.00
22
TOTAL OWNER'S EQUITY $ 35,650.00 $ 36,300.00
23
TOTAL ASSETS $ 203,200.00 $ 166,950.00
24
TOTAL LIABILITIES AND OWNER'S EQUITY $ 179,700.00 $ 153,850.00
25
COMMON FINANCIAL RATIO[ CURRENT YR. ][ PRIOR YR. ]
26
Debt Ratio
Total Liabilities / Total Assets		0.710.70
27
Current Ratio
Current Assets / Current Liabilities		0.910.97
28
Working Capital
Current Assets - Current Liabilities		-$11,250.00-$3,600.00
29
Assets-to-Equity Ratio
Total Assets / Owner's Equity		5.704.60
30
Debt-to-Equity Ratio
Total Liabilities / Owner's Equity		4.043.24
31
32
CLICK HERE TO CREATE IN SMARTSHEET
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