Or even copy this plan as it exists here
online college bookstore business plan
|
Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month 1 |
Month 2 |
Month 3 |
Month 4 |
Month 5 |
Month 6 |
Month 7 |
Month 8 |
Month 9 |
Month 10 |
Month 11 |
Month 12 |
Assets |
Starting Balances |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash |
$2,315 |
$97,167 |
$129,349 |
$156,092 |
$207,523 |
$208,964 |
$234,145 |
$258,588 |
$285,777 |
$313,290 |
$359,168 |
$443,650 |
$559,873 |
Other Current Assets |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
Total Current Assets |
$7,315 |
$102,167 |
$134,349 |
$161,092 |
$212,523 |
$213,964 |
$239,145 |
$263,588 |
$290,777 |
$318,290 |
$364,168 |
$448,650 |
$564,873 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
Long-term Assets |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
Accumulated Depreciation |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Total Long-term Assets |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
$150,000 |
Total Assets |
$157,315 |
$252,167 |
$284,349 |
$311,092 |
$362,523 |
$363,964 |
$389,145 |
$413,588 |
$440,777 |
$468,290 |
$514,168 |
$598,650 |
$714,873 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Liabilities and Capital |
|
Month 1 |
Month 2 |
Month 3 |
Month 4 |
Month 5 |
Month 6 |
Month 7 |
Month 8 |
Month 9 |
Month 10 |
Month 11 |
Month 12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Payable |
$0 |
$17,334 |
$27,101 |
$46,573 |
$70,948 |
$88,766 |
$116,088 |
$142,669 |
$162,141 |
$168,065 |
$188,702 |
$210,712 |
$246,941 |
Current Borrowing |
$5,000 |
$4,700 |
$4,400 |
$4,100 |
$3,800 |
$3,500 |
$3,200 |
$2,900 |
$2,600 |
$2,300 |
$2,000 |
$1,700 |
$1,400 |
Other Current Liabilities |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Subtotal Current Liabilities |
$5,000 |
$22,034 |
$31,501 |
$50,673 |
$74,748 |
$92,266 |
$119,288 |
$145,569 |
$164,741 |
$170,365 |
$190,702 |
$212,412 |
$248,341 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long-term Liabilities |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Total Liabilities |
$5,000 |
$22,034 |
$31,501 |
$50,673 |
$74,748 |
$92,266 |
$119,288 |
$145,569 |
$164,741 |
$170,365 |
$190,702 |
$212,412 |
$248,341 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid-in Capital |
$210,000 |
$335,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
$360,000 |
Retained Earnings |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
($57,685) |
Earnings |
$0 |
($47,182) |
($49,467) |
($41,896) |
($14,540) |
($30,617) |
($32,458) |
($34,297) |
($26,279) |
($4,390) |
$21,151 |
$83,923 |
$164,218 |
Total Capital |
$152,315 |
$230,133 |
$252,848 |
$260,419 |
$287,775 |
$271,698 |
$269,857 |
$268,018 |
$276,036 |
$297,925 |
$323,466 |
$386,238 |
$466,533 |
Total Liabilities and Capital |
$157,315 |
$252,167 |
$284,349 |
$311,092 |
$362,523 |
$363,964 |
$389,145 |
$413,588 |
$440,777 |
$468,290 |
$514,168 |
$598,650 |
$714,873 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Worth |
$152,315 |
$230,133 |
$252,848 |
$260,419 |
$287,775 |
$271,698 |
$269,857 |
$268,018 |
$276,036 |
$297,925 |
$323,466 |
$386,238 |
$466,533 |