NaviTag Technologies, LLC
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 | |||||||||||||
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 |