Simple Balance Sheet Template

	B	C	D	E	F	H	I
1
2		www.MSOfficeGeek.com
3		Simple Balance Sheet Template
4		(Excel, OpenOffice & Google Sheet)
5
6	Insert Company Name
7	Balance Sheet as on				Date
8	Assets		Amount	Total	Liabilities	Amount	Total
9	Current Assets				Current Liabilities
10	Cash and Cash Equivalents		$22,000		Short-term loans payable	$ 50,000
11	Investments - Short-term		$100,000		Current Portion - Long-Term Debt	$ 150,000
12	Accounts Recevable		$395,000		Accounts payable	$ 209,000
13	Other Receivables		$10,000		Accrued compensation and benefits	$ 85,000
14	Inventories		$310,000		Other Accrued Expenses	$ 61,000
15	Prepaid Expenses		$15,000		Income tax payable	$ 40,000
16	Miscellaneous		$38,000		Deferred revenues	$ 15,000
17	Long Term Investments		$360,000
18
19	Total Current Assets - A			$1,250,000	Total Current Liabilities - A		$ 610,000
20
21	Fixed Assets				Long Term Liabilities
22	Land		$55,000
23	Land Improvements		$65,000		Notes Payable	$ 200,000
24	Building		$1,800,000		Bonds Payable	$ 3,750,000
25	Equipment		$2,010,000		Deffered Income Tax	$ 250,000
26	Accumulated Depreciation		-$560,000
27
28	Total Fixed Assets - B			$3,370,000	Total Long Term Liabilities - B		$ 4,200,000
29
30	Intangible Assets				Total Liabilities - C = (A+B)		$ 4,810,000
31	Goodwill		$1,050,000
32	Licenses, Trademarks, Patents, Copyrights		$2,000,000		Shareholder's Equity
33					Share Capital	$ 1,100,000
34	Total Intangible Assets - C			$3,050,000	Reserves and Surplus	$ 2,200,000
35					Additional Paid-in Capital	$ 90,000
36	Other Assets				Treasury Stock	$ (500,000)
37	Receivables from Employees		$30,000
38
39	Total Other Assets - D			$30,000	Total Shareholder's Equity - D		$ 2,890,000
40
41	Total Assets (A+B+C+D)			$7,700,000	Total Liabilities and Equity (C + D)		$ 7,700,000
42	Balance Sheet Financial Ratio Analysis
43	Total Assets		$7,700,000		Total Current Assets	$1,250,000
44	Total Equity		$2,890,000		Total Current Liabilities	$610,000
45	Asset To Equity Ratio			2.7	Current Ratio		2.05
46	Total Liabilities		$4,810,000		Total Liabilities	$4,810,000
47	Total Equity		$2,890,000		Total Assets	$7,700,000
48	Debt To Equity Ratio			1.7	Debt Ratio		0.62
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