| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||
2 | BALANCE SHEET TEMPLATE | https://goo.gl/SkA4FF | |||||||
3 | |||||||||
4 | ASSETS | 2017 | 2018 | LIABILITIES AND OWNER'S EQUITY | 2017 | 2018 | |||
5 | CURRENT ASSETS | CURRENT LIABILITIES | |||||||
6 | Cash | $16,585 | Accounts Payable | $4,890 | |||||
7 | Accounts Receivable | Short-Term Loans | $8,200 | ||||||
8 | Inventory | Income Taxes Payable | $4,924 | ||||||
9 | Prepaid Expenses | Accrued Salaries and Wages | $6,100 | ||||||
10 | Short-Term Investments | Unearned Revenue | |||||||
11 | Total Current Assets | $16,585 | $0 | Current Portion of Long-Term Debt | |||||
12 | FIXED (LONG-TERM) ASSETS | Total Current Liabilities | $24,114 | $0 | |||||
13 | Long-Term Investments | $18,000 | LONG-TERM LIABILITIES | ||||||
14 | Property, Plant, and Equipment | $36,580 | Long-Term Debt | $3,450 | |||||
15 | (Less Accumulated Depreciation) | -$4,620 | Deferred Income Tax | $2,241 | |||||
16 | Intangible Assets | Other | $6,888 | ||||||
17 | Total Fixed Assets | $49,960 | $0 | Total Long-Term Liabilities | $12,579 | $0 | |||
18 | OTHER ASSETS | OWNER'S EQUITY | |||||||
19 | Deferred Income Tax | $2,200 | Owner's Investment | $2,100 | |||||
20 | Other | $1,660 | Retained Earnings | $6,188 | |||||
21 | Other | $6,280 | Other | ||||||
22 | Total Other Assets | $10,140 | $0 | Total Owner's Equity | $8,288 | $0 | |||
23 | |||||||||
24 | Total Assets | $76,685 | $0 | Total Liabilities and Owner's Equity | $44,981 | $0 | |||
25 | |||||||||
26 | COMMON FINANCIAL RATIOS | 2017 | 2018 | ||||||
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 | |||||||||
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 | |||||||||