NaviTag Technologies, LLC

Start your own business plan »

Shipment Monitoring 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
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