Keystone Computers & Networks, Inc.
Balance Sheet
As of December 31
Vertical Analysis
Preliminary 12/31/X5
Audited 12/31/X4
CURRENT ASSETS
Dollar Value
% of Total Assets
Dollar Value
% of Total Assets
Cash
$53,964
0.45%
Trade receivables
$8,534,524
71.84%
Allowance for bad debts
($96,000)
-0.81%
Accounts receivables-officers
$57,643
0.49%
Inventory
$1,234,589
10.39%
Prepaid expenses
$156,900
1.32%
Total current assets
$9,941,620
83.68%
PROPERTY, PLANT, AND EQUIPMENT
Equipment & furniture
$1,090,634
9.18%
Leasehold improvements
$98,900
0.83%
Accumulated depreciation
($250,987)
-2.11%
Total property, plant, and equipment
$938,547
7.90%
Software development costs
-
0.00%
Intangible assets, net of amortization
$1,000,000
8.42%
TOTAL ASSETS
$11,880,167
100.00%
CURRENT LIABILITIES
Line of credit
$6,612,550
55.66%
Accounts payable
$1,349,839
11.36%
Current maturities of capital leases
$43,200
0.36%
Unearned service revenue
-
0.00%
Accrued expenses
$178,900
1.51%
Total current liabilities
$8,184,489
68.89%
LONG-TERM CAPITAL LEASES
$456,700
3.84%
Total liabilities
$8,641,189
72.74%
STOCKHOLDERS' EQUITY
Common stock
$200,000
1.68%
Additional paid-in capital
$423,500
3.56%
Retained earnings - beginning balance
$1,626,203
13.69%
Dividends
-
0.00%
Current year net income
$989,275
8.33%
Total stockholders' equity
$3,238,978
27.26%
TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY
$11,880,167
100.00%