Or even copy this plan as it exists here
online college bookstore business plan
|
General Assumptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month 1 |
Month 2 |
Month 3 |
Month 4 |
Month 5 |
Month 6 |
Month 7 |
Month 8 |
Month 9 |
Month 10 |
Month 11 |
Month 12 |
Plan Month |
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
Current Interest Rate |
|
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
Long-term Interest Rate |
|
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
Tax Rate |
|
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
27.00% |
Other |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Pro Forma Profit and Loss |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month 1 |
Month 2 |
Month 3 |
Month 4 |
Month 5 |
Month 6 |
Month 7 |
Month 8 |
Month 9 |
Month 10 |
Month 11 |
Month 12 |
Sales |
|
$5,000 |
$60,000 |
$90,000 |
$135,000 |
$110,000 |
$152,500 |
$180,000 |
$210,000 |
$230,000 |
$255,000 |
$315,000 |
$370,000 |
Direct Cost of Sales |
|
$5,000 |
$13,500 |
$30,000 |
$47,500 |
$67,000 |
$90,000 |
$117,500 |
$134,000 |
$135,000 |
$155,000 |
$179,000 |
$210,000 |
Other Costs of Goods |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Total Cost of Sales |
|
$5,000 |
$13,500 |
$30,000 |
$47,500 |
$67,000 |
$90,000 |
$117,500 |
$134,000 |
$135,000 |
$155,000 |
$179,000 |
$210,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Margin |
|
$0 |
$46,500 |
$60,000 |
$87,500 |
$43,000 |
$62,500 |
$62,500 |
$76,000 |
$95,000 |
$100,000 |
$136,000 |
$160,000 |
Gross Margin % |
|
0.00% |
77.50% |
66.67% |
64.81% |
39.09% |
40.98% |
34.72% |
36.19% |
41.30% |
39.22% |
43.17% |
43.24% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
Payroll |
|
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
$34,250 |
Sales and Marketing and Other Expenses |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Depreciation |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Web Hosting |
|
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
Utilities |
|
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
Website Enhancement Projects |
|
$25,000 |
$10,000 |
$10,000 |
$10,000 |
$25,000 |
$25,000 |
$25,000 |
$25,000 |
$25,000 |
$25,000 |
$10,000 |
$10,000 |
Insurance |
|
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
Payroll Taxes |
15% |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
$4,988 |
Other General and Administrative Expenses |
|
$100 |
$100 |
$100 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Operating Expenses |
|
$64,598 |
$49,598 |
$49,598 |
$49,998 |
$64,998 |
$64,998 |
$64,998 |
$64,998 |
$64,998 |
$64,998 |
$49,998 |
$49,998 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Profit Before Interest and Taxes |
|
($64,598) |
($3,098) |
$10,403 |
$37,503 |
($21,998) |
($2,498) |
($2,498) |
$11,003 |
$30,003 |
$35,003 |
$86,003 |
$110,003 |
EBITDA |
|
($64,598) |
($3,098) |
$10,403 |
$37,503 |
($21,998) |
($2,498) |
($2,498) |
$11,003 |
$30,003 |
$35,003 |
$86,003 |
$110,003 |
Interest Expense |
|
$35 |
$33 |
$31 |
$29 |
$26 |
$24 |
$22 |
$20 |
$17 |
$15 |
$13 |
$11 |
Taxes Incurred |
|
($17,451) |
($845) |
$2,800 |
$10,118 |
($5,946) |
($681) |
($680) |
$2,965 |
$8,096 |
$9,447 |
$23,217 |
$29,698 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Profit |
|
($47,182) |
($2,285) |
$7,571 |
$27,356 |
($16,077) |
($1,841) |
($1,839) |
$8,018 |
$21,889 |
$25,541 |
$62,773 |
$80,294 |
Net Profit/Sales |
|
-943.64% |
-3.81% |
8.41% |
20.26% |
-14.62% |
-1.21% |
-1.02% |
3.82% |
9.52% |
10.02% |
19.93% |
21.70% |