Curriculum Companion Suites

Start your own business plan »

Educational Software K-12 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
Unit Sales
Software Systems 0% 20 20 20 20 20 20 20 20 20 20 20 20
Installation & Customization 0% 20 20 20 20 20 20 20 20 20 20 20 20
Other Consulting 0% 10 10 10 10 10 10 10 10 10 10 10 10
Total Unit Sales 50 50 50 50 50 50 50 50 50 50 50 50
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Software Systems $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00
Installation & Customization $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00
Other Consulting $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00
Sales
Software Systems $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000
Installation & Customization $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000
Other Consulting $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Total Sales $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Software Systems 0.00% $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00
Installation & Customization 0.00% $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00
Other Consulting 0.00% $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00
Direct Cost of Sales
Software Systems $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Installation & Customization $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000
Other Consulting $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Subtotal Direct Cost of Sales $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000
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
Product Development 0% $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000
Installation Technicians 0% $72,917 $72,917 $72,917 $72,917 $72,917 $72,917 $72,917 $72,917 $72,917 $72,917 $72,917 $72,917
Administrative 0% $49,583 $49,583 $49,583 $49,583 $49,583 $49,583 $49,583 $49,583 $49,583 $49,583 $49,583 $49,583
Sales & Marketing 0% $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 82 82 82 82 82 82 82 82 82 82 82 82
Total Payroll $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000
Direct Cost of Sales $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000 $260,000
Gross Margin $590,000 $590,000 $590,000 $590,000 $590,000 $590,000 $590,000 $590,000 $590,000 $590,000 $590,000 $590,000
Gross Margin % 69.41% 69.41% 69.41% 69.41% 69.41% 69.41% 69.41% 69.41% 69.41% 69.41% 69.41% 69.41%
Expenses
Payroll $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500
Sales and Marketing and Other Expenses $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Depreciation $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Utilities $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $40,875 $40,875 $40,875 $40,875 $40,875 $40,875 $40,875 $40,875 $40,875 $40,875 $40,875 $40,875
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $323,475 $323,475 $323,475 $323,475 $323,475 $323,475 $323,475 $323,475 $323,475 $323,475 $323,475 $323,475
Profit Before Interest and Taxes $266,525 $266,525 $266,525 $266,525 $266,525 $266,525 $266,525 $266,525 $266,525 $266,525 $266,525 $266,525
EBITDA $268,525 $268,525 $268,525 $268,525 $268,525 $268,525 $268,525 $268,525 $268,525 $268,525 $268,525 $268,525
Interest Expense $1,650 $1,633 $1,617 $1,600 $1,583 $1,567 $1,550 $1,533 $1,517 $1,500 $1,483 $1,467
Taxes Incurred $79,463 $66,223 $66,227 $66,231 $66,235 $66,240 $66,244 $66,248 $66,252 $66,256 $66,260 $66,265
Net Profit $185,413 $198,669 $198,681 $198,694 $198,706 $198,719 $198,731 $198,744 $198,756 $198,769 $198,781 $198,794
Net Profit/Sales 21.81% 23.37% 23.37% 23.38% 23.38% 23.38% 23.38% 23.38% 23.38% 23.38% 23.39% 23.39%
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 $289,000 $289,000 $289,000 $289,000 $289,000 $289,000 $289,000 $289,000 $289,000 $289,000 $289,000 $289,000
Cash from Receivables $0 $18,700 $561,000 $561,000 $561,000 $561,000 $561,000 $561,000 $561,000 $561,000 $561,000 $561,000
Subtotal Cash from Operations $289,000 $307,700 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000
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 $190,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $289,000 $497,700 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000
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 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500 $272,500
Bill Payments $14,003 $389,646 $376,831 $376,818 $376,806 $376,793 $376,781 $376,768 $376,756 $376,743 $376,731 $376,718
Subtotal Spent on Operations $286,503 $662,146 $649,331 $649,318 $649,306 $649,293 $649,281 $649,268 $649,256 $649,243 $649,231 $649,218
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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $288,503 $664,146 $651,331 $666,318 $666,306 $666,293 $666,281 $666,268 $666,256 $666,243 $666,231 $666,218
Net Cash Flow $497 ($166,446) $198,669 $183,682 $183,694 $183,707 $183,719 $183,732 $183,744 $183,757 $183,769 $183,782
Cash Balance $180,497 $14,051 $212,721 $396,402 $580,096 $763,803 $947,522 $1,131,254 $1,314,998 $1,498,755 $1,682,524 $1,866,306
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 $180,000 $180,497 $14,051 $212,721 $396,402 $580,096 $763,803 $947,522 $1,131,254 $1,314,998 $1,498,755 $1,682,524 $1,866,306
Accounts Receivable $0 $561,000 $1,103,300 $1,103,300 $1,103,300 $1,103,300 $1,103,300 $1,103,300 $1,103,300 $1,103,300 $1,103,300 $1,103,300 $1,103,300
Other Current Assets $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000
Total Current Assets $255,000 $816,497 $1,192,351 $1,391,021 $1,574,702 $1,758,396 $1,942,103 $2,125,822 $2,309,554 $2,493,298 $2,677,055 $2,860,824 $3,044,606
Long-term Assets
Long-term Assets $100,000 $100,000 $100,000 $100,000 $115,000 $130,000 $145,000 $160,000 $175,000 $190,000 $205,000 $220,000 $235,000
Accumulated Depreciation $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $22,000 $24,000
Total Long-term Assets $100,000 $98,000 $96,000 $94,000 $107,000 $120,000 $133,000 $146,000 $159,000 $172,000 $185,000 $198,000 $211,000
Total Assets $355,000 $914,497 $1,288,351 $1,485,021 $1,681,702 $1,878,396 $2,075,103 $2,271,822 $2,468,554 $2,665,298 $2,862,055 $3,058,824 $3,255,606
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 $1,000 $377,085 $364,270 $364,258 $364,246 $364,234 $364,222 $364,210 $364,198 $364,186 $364,174 $364,161 $364,149
Current Borrowing $50,000 $49,000 $48,000 $47,000 $46,000 $45,000 $44,000 $43,000 $42,000 $41,000 $40,000 $39,000 $38,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $51,000 $426,085 $412,270 $411,258 $410,246 $409,234 $408,222 $407,210 $406,198 $405,186 $404,174 $403,161 $402,149
Long-term Liabilities $150,000 $149,000 $148,000 $147,000 $146,000 $145,000 $144,000 $143,000 $142,000 $141,000 $140,000 $139,000 $138,000
Total Liabilities $201,000 $575,085 $560,270 $558,258 $556,246 $554,234 $552,222 $550,210 $548,198 $546,186 $544,174 $542,161 $540,149
Paid-in Capital $178,000 $178,000 $368,000 $368,000 $368,000 $368,000 $368,000 $368,000 $368,000 $368,000 $368,000 $368,000 $368,000
Retained Earnings ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000) ($24,000)
Earnings $0 $185,413 $384,081 $582,763 $781,456 $980,163 $1,178,881 $1,377,613 $1,576,356 $1,775,113 $1,973,881 $2,172,663 $2,371,456
Total Capital $154,000 $339,413 $728,081 $926,763 $1,125,456 $1,324,163 $1,522,881 $1,721,613 $1,920,356 $2,119,113 $2,317,881 $2,516,663 $2,715,456
Total Liabilities and Capital $355,000 $914,497 $1,288,351 $1,485,021 $1,681,702 $1,878,396 $2,075,103 $2,271,822 $2,468,554 $2,665,298 $2,862,055 $3,058,824 $3,255,606
Net Worth $154,000 $339,413 $728,081 $926,763 $1,125,456 $1,324,163 $1,522,881 $1,721,613 $1,920,356 $2,119,113 $2,317,881 $2,516,663 $2,715,456