BALANCE SHEET TEMPLATE
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHI
1
2
BALANCE SHEET TEMPLATE
https://goo.gl/SkA4FF
3
4
ASSETS20172018LIABILITIES AND OWNER'S EQUITY20172018
5
CURRENT ASSETSCURRENT LIABILITIES
6
Cash$16,585Accounts Payable$4,890
7
Accounts ReceivableShort-Term Loans$8,200
8
InventoryIncome Taxes Payable$4,924
9
Prepaid ExpensesAccrued Salaries and Wages$6,100
10
Short-Term InvestmentsUnearned Revenue
11
Total Current Assets$16,585$0Current Portion of Long-Term Debt
12
FIXED (LONG-TERM) ASSETSTotal Current Liabilities$24,114$0
13
Long-Term Investments$18,000LONG-TERM LIABILITIES
14
Property, Plant, and Equipment$36,580Long-Term Debt$3,450
15
(Less Accumulated Depreciation)-$4,620Deferred Income Tax$2,241
16
Intangible AssetsOther$6,888
17
Total Fixed Assets$49,960$0Total Long-Term Liabilities$12,579$0
18
OTHER ASSETSOWNER'S EQUITY
19
Deferred Income Tax$2,200Owner's Investment$2,100
20
Other$1,660Retained Earnings$6,188
21
Other$6,280Other
22
Total Other Assets$10,140$0Total Owner's Equity$8,288$0
23
24
Total Assets$76,685$0Total Liabilities and Owner's Equity$44,981$0
25
26
COMMON FINANCIAL RATIOS20172018
27
Debt Ratio (Total Liabilities/Total Assets)0.48
28
Current Ratio (Current Assets/Current Liabilities)
0.69
29
Working Capital (Current Assets/Current Liabilities)
-$7,529$0
30
Assets-to-Equity Ratio (Total Assets/Owner's Equity)
9.25
31
Debt-to-Equity Ratio (Total Liabilities/Owner's Equity)
4.43
32
33
CLICK HERE TO CREATE BALANCE SHEET TEMPLATES IN SMARTSHEET
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...
 
 
 
Balance Sheet Template
 
 
Main menu