NaviTag Technologies, LLC shipment monitoring business plan appendix. NaviTag Technologies, LLC is a start-up solution for the first location and security monitoring solution for maritime container cargo shipments.

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

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
NaviTag Technologies, LLC shipment monitoring business plan appendix. NaviTag Technologies, LLC is a start-up solution for the first location and security monitoring solution for maritime container cargo shipments.
\n