FoodFun Lifeskills Instructional Software

Start your own business plan »

Computer Software Business Plan

Appendix

Sales Forecast
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
Centers for Independent Living 0% $0 $0 $0 $0 $540 $1,350 $1,944 $2,970 $3,918 $4,023 $4,266 $4,428
School Districts 0% $0 $0 $0 $0 $1,000 $2,500 $3,600 $5,500 $7,255 $7,450 $7,900 $8,200
Proactive Parents 0% $0 $0 $0 $0 $230 $575 $828 $1,265 $1,669 $1,714 $1,817 $1,886
Agencies 0% $0 $0 $0 $0 $460 $1,150 $1,656 $2,530 $3,337 $3,427 $3,634 $3,772
Total Sales $0 $0 $0 $0 $2,230 $5,575 $8,028 $12,265 $16,179 $16,614 $17,617 $18,286
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Centers for Independent Living $0 $0 $0 $0 $38 $95 $136 $208 $274 $282 $299 $310
School Districts $0 $0 $0 $0 $70 $175 $252 $385 $508 $522 $553 $574
Proactive Parents $0 $0 $0 $0 $16 $40 $58 $89 $117 $120 $127 $132
Agencies $0 $0 $0 $0 $32 $81 $116 $177 $234 $240 $254 $264
Subtotal Direct Cost of Sales $0 $0 $0 $0 $156 $390 $562 $859 $1,133 $1,163 $1,233 $1,280
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sue 0% $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Accounting 0% $0 $0 $0 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Software Documentation 0% $0 $0 $0 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Product Development 0% $0 $0 $0 $0 $0 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Customer Service/ Tech Support 0% $0 $0 $0 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Customer Service/ Tech Support 0% $0 $0 $0 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Marketing/ Sales 0% $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Marketing/ Sales 0% $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total People 0 1 1 7 7 8 8 8 8 8 8 8
Total Payroll $0 $2,000 $2,000 $16,400 $16,400 $18,600 $18,600 $18,600 $18,600 $18,600 $18,600 $18,600
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 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $0 $0 $0 $0 $2,230 $5,575 $8,028 $12,265 $16,179 $16,614 $17,617 $18,286
Direct Cost of Sales $0 $0 $0 $0 $156 $390 $562 $859 $1,133 $1,163 $1,233 $1,280
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $156 $390 $562 $859 $1,133 $1,163 $1,233 $1,280
Gross Margin $0 $0 $0 $0 $2,074 $5,185 $7,466 $11,406 $15,046 $15,451 $16,384 $17,006
Gross Margin % 0.00% 0.00% 0.00% 0.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00%
Expenses
Payroll $0 $2,000 $2,000 $16,400 $16,400 $18,600 $18,600 $18,600 $18,600 $18,600 $18,600 $18,600
Sales and Marketing and Other Expenses $0 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Depreciation $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Rent $0 $950 $950 $950 $950 $950 $950 $950 $950 $950 $950 $950
Utilities $0 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $0 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Taxes 15% $0 $300 $300 $2,460 $2,460 $2,790 $2,790 $2,790 $2,790 $2,790 $2,790 $2,790
Programming $3,000 $3,000 $3,000 $3,000 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,150 $8,000 $8,000 $24,560 $21,560 $24,090 $24,090 $24,090 $24,090 $24,090 $24,090 $24,090
Profit Before Interest and Taxes ($3,150) ($8,000) ($8,000) ($24,560) ($19,486) ($18,905) ($16,624) ($12,684) ($9,044) ($8,639) ($7,706) ($7,084)
EBITDA ($3,000) ($7,850) ($7,850) ($24,410) ($19,336) ($18,755) ($16,474) ($12,534) ($8,894) ($8,489) ($7,556) ($6,934)
Interest Expense $823 $812 $801 $790 $779 $767 $756 $745 $733 $722 $710 $698
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($3,973) ($8,812) ($8,801) ($25,350) ($20,265) ($19,673) ($17,380) ($13,428) ($9,777) ($9,361) ($8,416) ($7,782)
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% -908.73% -352.87% -216.49% -109.48% -60.43% -56.35% -47.77% -42.56%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $0 $0 $0 $0 $558 $1,394 $2,007 $3,066 $4,045 $4,153 $4,404 $4,572
Cash from Receivables $0 $0 $0 $0 $0 $56 $1,756 $4,243 $6,127 $9,297 $12,145 $12,485
Subtotal Cash from Operations $0 $0 $0 $0 $558 $1,450 $3,763 $7,309 $10,172 $13,450 $16,549 $17,057
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $0 $0 $0 $558 $1,450 $3,763 $7,309 $10,172 $13,450 $16,549 $17,057
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $0 $2,000 $2,000 $16,400 $16,400 $18,600 $18,600 $18,600 $18,600 $18,600 $18,600 $18,600
Bill Payments $127 $3,917 $6,661 $6,722 $8,733 $6,766 $6,140 $7,096 $7,096 $7,413 $7,261 $7,361
Subtotal Spent on Operations $127 $5,917 $8,661 $23,122 $25,133 $25,366 $24,740 $25,696 $25,696 $26,013 $25,861 $25,961
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,291 $1,302 $1,313 $1,324 $1,335 $1,346 $1,357 $1,369 $1,380 $1,392 $1,403 $1,415
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $1,419 $7,219 $9,974 $24,446 $26,468 $26,712 $26,098 $27,064 $27,076 $27,404 $27,265 $27,375
Net Cash Flow ($1,419) ($7,219) ($9,974) ($24,446) ($25,910) ($25,262) ($22,335) ($19,755) ($16,904) ($13,955) ($10,715) ($10,319)
Cash Balance $212,081 $204,862 $194,888 $170,441 $144,531 $119,269 $96,934 $77,178 $60,274 $46,320 $35,604 $25,286
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 $213,500 $212,081 $204,862 $194,888 $170,441 $144,531 $119,269 $96,934 $77,178 $60,274 $46,320 $35,604 $25,286
Accounts Receivable $0 $0 $0 $0 $0 $1,673 $5,798 $10,063 $15,019 $21,026 $24,190 $25,258 $26,487
Inventory $0 $0 $0 $0 $0 $844 $454 $892 $1,033 $1,246 $1,279 $1,357 $1,408
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $213,500 $212,081 $204,862 $194,888 $170,441 $147,047 $125,520 $107,889 $93,231 $82,546 $71,789 $62,218 $53,180
Long-term Assets
Long-term Assets $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Accumulated Depreciation $0 $150 $300 $450 $600 $750 $900 $1,050 $1,200 $1,350 $1,500 $1,650 $1,800
Total Long-term Assets $9,000 $8,850 $8,700 $8,550 $8,400 $8,250 $8,100 $7,950 $7,800 $7,650 $7,500 $7,350 $7,200
Total Assets $222,500 $220,931 $213,562 $203,438 $178,841 $155,297 $133,620 $115,839 $101,031 $90,196 $79,289 $69,568 $60,380
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 $3,695 $6,440 $6,429 $8,506 $6,562 $5,904 $6,860 $6,849 $7,171 $7,016 $7,115 $7,124
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $3,695 $6,440 $6,429 $8,506 $6,562 $5,904 $6,860 $6,849 $7,171 $7,016 $7,115 $7,124
Long-term Liabilities $100,000 $98,709 $97,406 $96,094 $94,770 $93,435 $92,089 $90,731 $89,363 $87,983 $86,591 $85,188 $83,773
Total Liabilities $100,000 $102,404 $103,846 $102,523 $103,276 $99,997 $97,992 $97,591 $96,211 $95,154 $93,607 $92,303 $90,897
Paid-in Capital $145,000 $145,000 $145,000 $145,000 $145,000 $145,000 $145,000 $145,000 $145,000 $145,000 $145,000 $145,000 $145,000
Retained Earnings ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500) ($22,500)
Earnings $0 ($3,973) ($12,784) ($21,585) ($46,935) ($67,200) ($86,872) ($104,252) ($117,680) ($127,458) ($136,819) ($145,235) ($153,017)
Total Capital $122,500 $118,527 $109,716 $100,915 $75,565 $55,300 $35,628 $18,248 $4,820 ($4,958) ($14,319) ($22,735) ($30,517)
Total Liabilities and Capital $222,500 $220,931 $213,562 $203,438 $178,841 $155,297 $133,620 $115,839 $101,031 $90,196 $79,289 $69,568 $60,380
Net Worth $122,500 $118,527 $109,716 $100,915 $75,565 $55,300 $35,628 $18,248 $4,820 ($4,958) ($14,319) ($22,735) ($30,517)