Forecasted Balance Sheet example for SIS

FORECASTED BALANCE SHEET
SCHOLARSHIP INFORMATION SERVICES
AS OF DECEMBER 31, 200X and 200Y

Beginning
JULY 1, 200X
Ending
DEC 31, 200X
Ending
DEC 31, 200Y
CURRENT ASSETS:
Cash $2,500 $10,373 $24,905
Accounts Receivable $ 0 $ 0 $ 0
Ending Finished Inventory $ 0 $ 2,592 $ 3,564
Total Current Assets $2,500 $12,965 $28,469
FIXED ASSETS:
Automobile $6,000 $6,000 $6,000
Less: Accumulated Deprecation $ 0 $1000 $3,000
Estimated Worth - Auto $6,000 $5,000 $3,000
Office Equipment $3,900 $8,400 $9,600
Less: Accumulated Deprecation $ 0 $1,400 $4,600
Estimated Worth - Office Equipment $3,900 $7,000 $5,000
Total Fixed Assets $9,900 $12,000 $8,000
TOTAL ASSETS $12,400 $24,965 $36,469
Current Liabilities:
Accounts payable on purchases $ 0 $2,736 $3,828
Income Taxes Payable $ 0 $2,349 $7,428
Total Current Liabilities $ 0 $5,085 $11,256
Long Term Liabilities: $ 0 $ 0 $ 0
TOTAL LIABILITIES $ 0 $5,085 $11,256
EQUITY:
Capital - $12,400 $14,880 $20,213
Government Grant $ 0 $ 5,000 $ 5,000
Total Equity $12,400 $19,880 $25,213
TOTAL LIABILITIES & EQUITY $12,400 $24,965 $36,469