Forecasted Balance Sheet - Example for the Internet Company

THE INTERNET COMPANY
FORECASTED BALANCE SHEET
FOR YEARS ENDING DECEMBER 31...
Beginning
Jan. 1
200X
Ending
Dec. 31
200X
Ending
Dec. 31
200Y
Ending
Dec. 31
200Z
CURRENT ASSETS:
Ending Cash Balance $14,796 $ 878 $20,746 $44,688
Accounts Receivable $ 0 N/A $20,266 $22,120
Allowance for Doubtful Account $ 0 N/A ($5,520) ($7,000)
Net Accounts Receivable $ 0 0 $14,746 $15,120
TOTAL CURRENT ASSETS $14,796 $ 878 $35,492 $59,808
FIXED ASSETS:
Office Equipment - (net) (4 yr life) $4,000 $4,000 $18,850 $18,850
Less Accumulated Deprecation $ 0 $1,000 $ 5,712 $10,425
Net Office Equipment (net) $4,000 $3,000 $13,138 $ 8,425
TOTAL ASSETS $18,796 $3,878 $48,629 $68,233
CURRENT LIABILITIES:
Short-Term Investors $ 0 $5000 $ 0 $ 0
Taxes Payable N/A N/A $7,408 $8,062
TOTAL CURRENT LIABILITIES $ 0 $5,000 $7,408 $8,062
Long Term Debt Outstanding $ 0 $ 0 $15,000 $15,000
Principal Payment on Debt $ 0 $ 0 ($2,659) ($5,475)
Remaining Long-term Debt $ 0 $ 0 $12,341 $ 9,525
TOTAL LIABILITIES $0 $5,000 $19,749 $17,587
EQUITY
Contributed Capital $18,796 $18,796 $18,796 $18,796
Common Shares $ 0 $ 0 $10,000 $10,000
Retained Earnings $ 0 $(19,918) $ 84 $21,850
TOTAL EQUITY $18,796 $ ( 1,122) $28,880 $50,646
TOTAL LIABILITIES & EQUITY $18,796 $ 3,878 $48,629 $68,233