Curriculum Companion Suites
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 |