| 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 | |||||||||||||
| NaviTag Units | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 200 | 200 | 200 | 300 |
| Access Charges | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 300 | 500 | 700 | 1,000 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 500 | 700 | 900 | 1,300 | |
| 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 | |
| NaviTag Units | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £395.00 | £395.00 | £395.00 | £395.00 | £395.00 | |
| Access Charges | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £39.99 | £39.99 | £39.99 | £39.99 | £39.99 | |
| Sales | |||||||||||||
| NaviTag Units | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £39,500 | £79,000 | £79,000 | £79,000 | £118,500 | |
| Access Charges | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,999 | £11,997 | £19,995 | £27,993 | £39,990 | |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £43,499 | £90,997 | £98,995 | £106,993 | £158,490 | |
| 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 | |
| NaviTag Units | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £296.25 | £296.25 | £296.25 | £296.25 | £296.25 |
| Access Charges | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £22.20 | £22.20 | £22.20 | £22.20 | £22.20 |
| Direct Cost of Sales | |||||||||||||
| NaviTag Units | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £29,625 | £59,250 | £59,250 | £59,250 | £88,875 | |
| Access Charges | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,220 | £6,660 | £11,100 | £15,540 | £22,200 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,845 | £65,910 | £70,350 | £74,790 | £111,075 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.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 | £0 | £0 | £0 | £43,499 | £90,997 | £98,995 | £106,993 | £158,490 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,845 | £65,910 | £70,350 | £74,790 | £111,075 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,845 | £65,910 | £70,350 | £74,790 | £111,075 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £11,654 | £25,087 | £28,645 | £32,203 | £47,415 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 26.79% | 27.57% | 28.94% | 30.10% | 29.92% | |
| Expenses | |||||||||||||
| Payroll | £25,000 | £25,000 | £25,000 | £31,000 | £44,000 | £44,000 | £44,000 | £48,333 | £48,333 | £48,333 | £48,333 | £48,333 | |
| Sales Collateral | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 | £5,000 | £0 | £5,000 | £0 | £5,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 25% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Direct Mail | £0 | £0 | £0 | £0 | £0 | £15,000 | £0 | £15,000 | £15,000 | £0 | £15,000 | £0 | |
| Stationery | £1,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Travel | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Trade Shows | £0 | £0 | £0 | £0 | £0 | £20,000 | £0 | £0 | £0 | £10,000 | £0 | £0 | |
| Advertising | £0 | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| New York - Rent | £7,500 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| New York - Telephone System | £5,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New York - Telephone Charges | £300 | £200 | £150 | £150 | £200 | £400 | £150 | £400 | £400 | £400 | £400 | £400 | |
| New York - Utilities | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 | |
| New York - Furniture | £7,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New York - Office Equipment/Networking | £13,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New York - Internet Access | £350 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| New York - Misc./Office Supplies | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 | |
| Outsourced Development - Discovery | £55,000 | £30,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Inception | £0 | £35,000 | £18,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Elaboration | £0 | £0 | £46,000 | £23,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Construction | £0 | £0 | £0 | £170,000 | £170,000 | £30,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Production | £0 | £0 | £0 | £0 | £0 | £43,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Services - Accounting | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,087 | |
| Outsourced Services - Legal | £10,000 | £5,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Laptop Computers | £13,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Desktop Computers | £0 | £0 | £0 | £0 | £7,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Development/Staging | £30,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Software Licenses/Tools | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Production Hosting | £0 | £0 | £0 | £12,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Maintenance/Support | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | |
| Monitoring Services | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Boston - Rent | £4,167 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | |
| Boston - Telephone System | £4,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boston - Telephone Charges | £150 | £150 | £150 | £300 | £300 | £300 | £150 | £300 | £300 | £300 | £300 | £300 | |
| Boston - Utilities | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 | |
| Boston - Furniture | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boston - Office Equipment/Networking | £6,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boston - Internet Access | £120 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | |
| Boston - Misc./Office Supplies | 15% | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £211,588 | £115,414 | £112,364 | £260,764 | £262,314 | £193,514 | £80,114 | £102,847 | £97,847 | £97,847 | £97,847 | £87,835 | |
| Profit Before Interest and Taxes | (£211,588) | (£115,414) | (£112,364) | (£260,764) | (£262,314) | (£193,514) | (£80,114) | (£91,193) | (£72,760) | (£69,202) | (£65,644) | (£40,420) | |
| EBITDA | (£211,588) | (£115,414) | (£112,364) | (£260,764) | (£262,314) | (£193,514) | (£80,114) | (£91,193) | (£72,760) | (£69,202) | (£65,644) | (£40,420) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£211,588) | (£115,414) | (£112,364) | (£260,764) | (£262,314) | (£193,514) | (£80,114) | (£91,193) | (£72,760) | (£69,202) | (£65,644) | (£40,420) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -209.64% | -79.96% | -69.90% | -61.35% | -25.50% | |
| 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 | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,709,448 | £1,621,403 | £1,540,041 | £1,469,179 | £1,401,874 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £43,499 | £111,297 | £141,460 | £153,191 | £208,420 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,752,947 | £1,732,700 | £1,681,502 | £1,622,370 | £1,610,295 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,752,947 | £1,732,700 | £1,681,502 | £1,622,370 | £1,610,295 |
| 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 | £186,588 | £177,488 | £129,557 | £270,534 | £325,537 | £251,394 | £105,887 | £103,212 | £155,725 | £173,729 | £180,241 | £208,586 |
| 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 | £186,588 | £177,488 | £129,557 | £270,534 | £325,537 | £251,394 | £105,887 | £103,212 | £155,725 | £173,729 | £180,241 | £208,586 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £186,588 | £177,488 | £129,557 | £270,534 | £325,537 | £251,394 | £105,887 | £103,212 | £155,725 | £173,729 | £180,241 | £208,586 |
| Paid-in Capital | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 |
| Retained Earnings | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) |
| Earnings | £0 | (£211,588) | (£327,002) | (£439,366) | (£700,130) | (£962,444) | (£1,155,958) | (£1,236,072) | (£1,327,265) | (£1,400,025) | (£1,469,227) | (£1,534,871) | (£1,575,291) |
| Total Capital | £2,977,000 | £2,765,412 | £2,649,998 | £2,537,634 | £2,276,870 | £2,014,556 | £1,821,042 | £1,740,928 | £1,649,735 | £1,576,975 | £1,507,773 | £1,442,129 | £1,401,709 |
| Total Liabilities and Capital | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,752,947 | £1,732,700 | £1,681,502 | £1,622,370 | £1,610,295 |
| Net Worth | £2,977,000 | £2,765,412 | £2,649,998 | £2,537,634 | £2,276,870 | £2,014,556 | £1,821,042 | £1,740,928 | £1,649,735 | £1,576,975 | £1,507,773 | £1,442,129 | £1,401,709 |
| 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 | ||
| Bob Magown - President | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Jim Galley - CTO | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| VP Sales | 0% | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Division 1 | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Division 2 | 0% | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 | £10,333 | £10,333 | £10,333 | £10,333 | £10,333 |
| Total People | 4 | 4 | 4 | 5 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £25,000 | £25,000 | £25,000 | £31,000 | £44,000 | £44,000 | £44,000 | £48,333 | £48,333 | £48,333 | £48,333 | £48,333 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £23,199 | £68,831 | £95,263 | £103,261 | |
| 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 | £0 | £0 | £0 | £0 | £23,199 | £68,831 | £95,263 | £103,261 | |
| 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 | £25,000 | £25,000 | £25,000 | £31,000 | £44,000 | £44,000 | £44,000 | £48,333 | £48,333 | £48,333 | £48,333 | £48,333 | |
| Bill Payments | £0 | £99,514 | £135,295 | £88,787 | £163,311 | £223,657 | £181,621 | £89,034 | £62,911 | £101,860 | £117,792 | £122,232 | |
| Subtotal Spent on Operations | £25,000 | £124,514 | £160,295 | £119,787 | £207,311 | £267,657 | £225,621 | £137,367 | £111,244 | £150,193 | £166,125 | £170,565 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £25,000 | £124,514 | £160,295 | £119,787 | £207,311 | £267,657 | £225,621 | £137,367 | £111,244 | £150,193 | £166,125 | £170,565 | |
| Net Cash Flow | (£25,000) | (£124,514) | (£160,295) | (£119,787) | (£207,311) | (£267,657) | (£225,621) | (£137,367) | (£88,045) | (£81,362) | (£70,862) | (£67,304) | |
| Cash Balance | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,709,448 | £1,621,403 | £1,540,041 | £1,469,179 | £1,401,874 | |
| 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 | |||||||||||||
| NaviTag Units | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 200 | 200 | 200 | 300 |
| Access Charges | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 300 | 500 | 700 | 1,000 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 500 | 700 | 900 | 1,300 | |
| 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 | |
| NaviTag Units | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £395.00 | £395.00 | £395.00 | £395.00 | £395.00 | |
| Access Charges | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £39.99 | £39.99 | £39.99 | £39.99 | £39.99 | |
| Sales | |||||||||||||
| NaviTag Units | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £39,500 | £79,000 | £79,000 | £79,000 | £118,500 | |
| Access Charges | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,999 | £11,997 | £19,995 | £27,993 | £39,990 | |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £43,499 | £90,997 | £98,995 | £106,993 | £158,490 | |
| 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 | |
| NaviTag Units | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £296.25 | £296.25 | £296.25 | £296.25 | £296.25 |
| Access Charges | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £22.20 | £22.20 | £22.20 | £22.20 | £22.20 |
| Direct Cost of Sales | |||||||||||||
| NaviTag Units | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £29,625 | £59,250 | £59,250 | £59,250 | £88,875 | |
| Access Charges | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,220 | £6,660 | £11,100 | £15,540 | £22,200 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,845 | £65,910 | £70,350 | £74,790 | £111,075 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.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 | £0 | £0 | £0 | £43,499 | £90,997 | £98,995 | £106,993 | £158,490 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,845 | £65,910 | £70,350 | £74,790 | £111,075 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,845 | £65,910 | £70,350 | £74,790 | £111,075 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £11,654 | £25,087 | £28,645 | £32,203 | £47,415 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 26.79% | 27.57% | 28.94% | 30.10% | 29.92% | |
| Expenses | |||||||||||||
| Payroll | £25,000 | £25,000 | £25,000 | £31,000 | £44,000 | £44,000 | £44,000 | £48,333 | £48,333 | £48,333 | £48,333 | £48,333 | |
| Sales Collateral | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 | £5,000 | £0 | £5,000 | £0 | £5,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 25% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Direct Mail | £0 | £0 | £0 | £0 | £0 | £15,000 | £0 | £15,000 | £15,000 | £0 | £15,000 | £0 | |
| Stationery | £1,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Travel | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Trade Shows | £0 | £0 | £0 | £0 | £0 | £20,000 | £0 | £0 | £0 | £10,000 | £0 | £0 | |
| Advertising | £0 | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| New York - Rent | £7,500 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| New York - Telephone System | £5,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New York - Telephone Charges | £300 | £200 | £150 | £150 | £200 | £400 | £150 | £400 | £400 | £400 | £400 | £400 | |
| New York - Utilities | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 | |
| New York - Furniture | £7,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New York - Office Equipment/Networking | £13,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New York - Internet Access | £350 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| New York - Misc./Office Supplies | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 | |
| Outsourced Development - Discovery | £55,000 | £30,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Inception | £0 | £35,000 | £18,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Elaboration | £0 | £0 | £46,000 | £23,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Construction | £0 | £0 | £0 | £170,000 | £170,000 | £30,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Development - Production | £0 | £0 | £0 | £0 | £0 | £43,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Outsourced Services - Accounting | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,087 | |
| Outsourced Services - Legal | £10,000 | £5,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Laptop Computers | £13,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Desktop Computers | £0 | £0 | £0 | £0 | £7,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Development/Staging | £30,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Software Licenses/Tools | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Production Hosting | £0 | £0 | £0 | £12,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Maintenance/Support | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | |
| Monitoring Services | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Boston - Rent | £4,167 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | |
| Boston - Telephone System | £4,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boston - Telephone Charges | £150 | £150 | £150 | £300 | £300 | £300 | £150 | £300 | £300 | £300 | £300 | £300 | |
| Boston - Utilities | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 | |
| Boston - Furniture | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boston - Office Equipment/Networking | £6,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boston - Internet Access | £120 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | |
| Boston - Misc./Office Supplies | 15% | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £163 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £211,588 | £115,414 | £112,364 | £260,764 | £262,314 | £193,514 | £80,114 | £102,847 | £97,847 | £97,847 | £97,847 | £87,835 | |
| Profit Before Interest and Taxes | (£211,588) | (£115,414) | (£112,364) | (£260,764) | (£262,314) | (£193,514) | (£80,114) | (£91,193) | (£72,760) | (£69,202) | (£65,644) | (£40,420) | |
| EBITDA | (£211,588) | (£115,414) | (£112,364) | (£260,764) | (£262,314) | (£193,514) | (£80,114) | (£91,193) | (£72,760) | (£69,202) | (£65,644) | (£40,420) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£211,588) | (£115,414) | (£112,364) | (£260,764) | (£262,314) | (£193,514) | (£80,114) | (£91,193) | (£72,760) | (£69,202) | (£65,644) | (£40,420) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -209.64% | -79.96% | -69.90% | -61.35% | -25.50% | |
| 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 | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,709,448 | £1,621,403 | £1,540,041 | £1,469,179 | £1,401,874 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £43,499 | £111,297 | £141,460 | £153,191 | £208,420 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,752,947 | £1,732,700 | £1,681,502 | £1,622,370 | £1,610,295 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,752,947 | £1,732,700 | £1,681,502 | £1,622,370 | £1,610,295 |
| 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 | £186,588 | £177,488 | £129,557 | £270,534 | £325,537 | £251,394 | £105,887 | £103,212 | £155,725 | £173,729 | £180,241 | £208,586 |
| 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 | £186,588 | £177,488 | £129,557 | £270,534 | £325,537 | £251,394 | £105,887 | £103,212 | £155,725 | £173,729 | £180,241 | £208,586 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £186,588 | £177,488 | £129,557 | £270,534 | £325,537 | £251,394 | £105,887 | £103,212 | £155,725 | £173,729 | £180,241 | £208,586 |
| Paid-in Capital | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 | £3,010,000 |
| Retained Earnings | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) | (£33,000) |
| Earnings | £0 | (£211,588) | (£327,002) | (£439,366) | (£700,130) | (£962,444) | (£1,155,958) | (£1,236,072) | (£1,327,265) | (£1,400,025) | (£1,469,227) | (£1,534,871) | (£1,575,291) |
| Total Capital | £2,977,000 | £2,765,412 | £2,649,998 | £2,537,634 | £2,276,870 | £2,014,556 | £1,821,042 | £1,740,928 | £1,649,735 | £1,576,975 | £1,507,773 | £1,442,129 | £1,401,709 |
| Total Liabilities and Capital | £2,977,000 | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,752,947 | £1,732,700 | £1,681,502 | £1,622,370 | £1,610,295 |
| Net Worth | £2,977,000 | £2,765,412 | £2,649,998 | £2,537,634 | £2,276,870 | £2,014,556 | £1,821,042 | £1,740,928 | £1,649,735 | £1,576,975 | £1,507,773 | £1,442,129 | £1,401,709 |
| 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 | ||
| Bob Magown - President | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Jim Galley - CTO | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| VP Sales | 0% | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Division 1 | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Division 2 | 0% | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 | £10,333 | £10,333 | £10,333 | £10,333 | £10,333 |
| Total People | 4 | 4 | 4 | 5 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £25,000 | £25,000 | £25,000 | £31,000 | £44,000 | £44,000 | £44,000 | £48,333 | £48,333 | £48,333 | £48,333 | £48,333 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £23,199 | £68,831 | £95,263 | £103,261 | |
| 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 | £0 | £0 | £0 | £0 | £23,199 | £68,831 | £95,263 | £103,261 | |
| 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 | £25,000 | £25,000 | £25,000 | £31,000 | £44,000 | £44,000 | £44,000 | £48,333 | £48,333 | £48,333 | £48,333 | £48,333 | |
| Bill Payments | £0 | £99,514 | £135,295 | £88,787 | £163,311 | £223,657 | £181,621 | £89,034 | £62,911 | £101,860 | £117,792 | £122,232 | |
| Subtotal Spent on Operations | £25,000 | £124,514 | £160,295 | £119,787 | £207,311 | £267,657 | £225,621 | £137,367 | £111,244 | £150,193 | £166,125 | £170,565 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £25,000 | £124,514 | £160,295 | £119,787 | £207,311 | £267,657 | £225,621 | £137,367 | £111,244 | £150,193 | £166,125 | £170,565 | |
| Net Cash Flow | (£25,000) | (£124,514) | (£160,295) | (£119,787) | (£207,311) | (£267,657) | (£225,621) | (£137,367) | (£88,045) | (£81,362) | (£70,862) | (£67,304) | |
| Cash Balance | £2,952,000 | £2,827,486 | £2,667,191 | £2,547,404 | £2,340,093 | £2,072,436 | £1,846,815 | £1,709,448 | £1,621,403 | £1,540,041 | £1,469,179 | £1,401,874 | |