50% Discount on Business Plan Pro Premier Edition
Click here to buy now or call 0845 351 9924
 

Educational Software K-12 Business Plan

Curriculum Companion Suites

This sample business plan can be edited directly in Business Plan Pro software.

previous
next

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
previous
next
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