Truckbay internet media advertising business plan appendix. Truckbay, an established company providing online advertising solutions for the global heavy truck and equipment markets, adds new services such as online auctions.

Truckbay

Start your own business plan »

Internet Media Advertising Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
eBay Motors Single Listing 0% $0 $0 $16,000 $32,000 $48,000 $64,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
eBay Motors Unlimited Listings 0% $80 $500 $2,500 $5,000 $7,500 $10,000 $12,500 $15,000 $17,500 $20,000 $22,500 $25,000
Affiliate Buyer's Assistance Programs 0% $0 $0 $250 $300 $360 $432 $518 $622 $746 $896 $1,075 $1,290
Buyer Assistant Partnerships 0% $0 $0 $100 $200 $300 $500 $500 $500 $500 $500 $500 $500
Co-op Advertising 0% $0 $0 $0 $0 $0 $0 $250 $250 $250 $250 $250 $250
Dealers Single Listing 0% $0 $0 $300 $400 $500 $500 $500 $500 $500 $500 $500 $500
Dealer Wholesale Membership 0% $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Sales $80 $500 $22,150 $40,900 $59,660 $78,432 $97,268 $99,872 $102,496 $105,146 $107,825 $110,540
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technology $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Subtotal Direct Cost of Sales $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales Team Personnel
Base salary $0 $0 $7,500 $7,500 $7,500 $10,000 $10,000 $12,500 $15,000 $17,500 $20,000 $20,000
Bonuses 0% $0 $0 $0 $0 $0 $0 $0 $0 $1,200 $1,400 $1,600 $1,600
Commission on standard listing 10% $0 $0 $0 $0 $0 $7,543 $9,427 $9,687 $9,950 $10,215 $10,482 $10,754
Commission on Dealer Single Listing 10% $0 $0 $30 $40 $50 $50 $50 $50 $50 $50 $50 $50
Commission on Full-service Dealer Listing 5% $0 $0 $0 $0 $0 $300 $300 $300 $300 $300 $300 $300
Subtotal $0 $0 $7,530 $7,540 $7,550 $17,893 $19,777 $22,537 $26,500 $29,465 $32,432 $32,704
Development Personnel
Web Developer 1 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
Assistant Web Developer 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Developer Bonus 1% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
General and Administrative Personnel
President $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Other Personnel
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $14,000 $14,000 $21,530 $21,540 $21,550 $31,893 $33,777 $36,537 $40,500 $43,465 $46,432 $46,704
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $80 $500 $22,150 $40,900 $59,660 $78,432 $97,268 $99,872 $102,496 $105,146 $107,825 $110,540
Direct Cost of Sales $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Sales Team Payroll $0 $0 $7,530 $7,540 $7,550 $17,893 $19,777 $22,537 $26,500 $29,465 $32,432 $32,704
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $10,000 $10,000 $17,530 $17,540 $17,550 $27,893 $29,777 $32,537 $36,500 $39,465 $42,432 $42,704
Gross Margin ($9,920) ($9,500) $4,620 $23,360 $42,110 $50,539 $67,492 $67,335 $65,997 $65,681 $65,392 $67,836
Gross Margin % -12400.00% -1900.00% 20.86% 57.11% 70.58% 64.44% 69.39% 67.42% 64.39% 62.47% 60.65% 61.37%
Operating Expenses
Development Expenses
Development Payroll $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Training $1,500 $0 $0 $0 $0 $0 $2,500 $0 $0 $0 $0 $0
Other Development Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Development Expenses $10,500 $9,000 $9,000 $9,000 $9,000 $9,000 $11,500 $9,000 $9,000 $9,000 $9,000 $9,000
Development % 13125.00% 1800.00% 40.63% 22.00% 15.09% 11.47% 11.82% 9.01% 8.78% 8.56% 8.35% 8.14%
General and Administrative Expenses
General and Administrative Payroll $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Marketing/Promotion $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Depreciation $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Rent $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total General and Administrative Expenses $8,967 $8,967 $8,967 $8,967 $8,967 $8,967 $8,967 $8,967 $8,967 $8,967 $8,967 $8,967
General and Administrative % 11208.75% 1793.33% 40.48% 21.92% 15.03% 11.43% 9.22% 8.98% 8.75% 8.53% 8.32% 8.11%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Meals and Entertainment $0 $0 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Trade Shows and Association Dues $0 $0 $0 $0 $0 $1,500 $0 $0 $0 $0 $2,500 $0
Subscriptions $150 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Business Travel $1,000 $1,000 $2,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total Other Expenses $1,150 $1,000 $2,400 $1,400 $1,400 $2,900 $1,400 $1,400 $1,400 $1,400 $3,900 $1,400
Other % 1437.50% 200.00% 10.84% 3.42% 2.35% 3.70% 1.44% 1.40% 1.37% 1.33% 3.62% 1.27%
Total Operating Expenses $20,617 $18,967 $20,367 $19,367 $19,367 $20,867 $21,867 $19,367 $19,367 $19,367 $21,867 $19,367
Profit Before Interest and Taxes ($30,537) ($28,467) ($15,747) $3,993 $22,743 $29,672 $45,625 $47,968 $46,630 $46,315 $43,526 $48,469
EBITDA ($30,337) ($28,267) ($15,547) $4,193 $22,943 $29,872 $45,825 $48,168 $46,830 $46,515 $43,726 $48,669
Interest Expense $56 $53 $51 $49 $46 $44 $41 $39 $36 $34 $32 $29
Taxes Incurred ($9,178) ($8,556) ($4,739) $1,183 $6,809 $8,889 $13,675 $14,379 $13,978 $13,884 $13,048 $14,532
Net Profit ($21,415) ($19,964) ($11,058) $2,761 $15,888 $20,740 $31,909 $33,551 $32,616 $32,396 $30,446 $33,908
Net Profit/Sales -26768.79% -3992.82% -49.93% 6.75% 26.63% 26.44% 32.80% 33.59% 31.82% 30.81% 28.24% 30.67%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $80 $500 $22,150 $40,900 $59,660 $78,432 $97,268 $99,872 $102,496 $105,146 $107,825 $110,540
Subtotal Cash from Operations $80 $500 $22,150 $40,900 $59,660 $78,432 $97,268 $99,872 $102,496 $105,146 $107,825 $110,540
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 $475,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $475,080 $500 $22,150 $40,900 $59,660 $78,432 $97,268 $99,872 $102,496 $105,146 $107,825 $110,540
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $14,000 $14,000 $21,530 $21,540 $21,550 $31,893 $33,777 $36,537 $40,500 $43,465 $46,432 $46,704
Bill Payments $243 $7,261 $6,438 $11,642 $16,586 $22,141 $25,792 $31,323 $29,571 $29,178 $29,140 $30,713
Subtotal Spent on Operations $14,243 $21,261 $27,968 $33,182 $38,136 $54,034 $59,569 $67,860 $70,071 $72,643 $75,573 $77,417
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 $292 $292 $292 $292 $292 $292 $292 $292 $292 $292 $292 $288
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 $10,000 $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 $14,535 $21,553 $38,260 $33,474 $38,428 $54,326 $59,861 $68,152 $70,363 $72,935 $75,865 $77,705
Net Cash Flow $460,545 ($21,053) ($16,110) $7,426 $21,232 $24,106 $37,408 $31,720 $32,134 $32,211 $31,960 $32,835
Cash Balance $464,545 $443,492 $427,382 $434,808 $456,040 $480,145 $517,553 $549,273 $581,407 $613,618 $645,578 $678,414
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $4,000 $464,545 $443,492 $427,382 $434,808 $456,040 $480,145 $517,553 $549,273 $581,407 $613,618 $645,578 $678,414
Other Current Assets $1 $1 $1 $10,001 $10,001 $10,001 $10,001 $10,001 $10,001 $10,001 $10,001 $10,001 $10,001
Total Current Assets $4,001 $464,546 $443,493 $437,383 $444,809 $466,041 $490,146 $527,554 $559,274 $591,408 $623,619 $655,579 $688,415
Long-term Assets
Long-term Assets $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000
Accumulated Depreciation $11,000 $11,200 $11,400 $11,600 $11,800 $12,000 $12,200 $12,400 $12,600 $12,800 $13,000 $13,200 $13,400
Total Long-term Assets $15,000 $14,800 $14,600 $14,400 $14,200 $14,000 $13,800 $13,600 $13,400 $13,200 $13,000 $12,800 $12,600
Total Assets $19,001 $479,346 $458,093 $451,783 $459,009 $480,041 $503,946 $541,154 $572,674 $604,608 $636,619 $668,379 $701,015
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $0 $7,052 $6,055 $11,096 $15,852 $21,288 $24,746 $30,337 $28,598 $28,209 $28,115 $29,722 $28,737
Current Borrowing $7,000 $6,708 $6,416 $6,124 $5,832 $5,540 $5,248 $4,956 $4,664 $4,372 $4,080 $3,788 $3,500
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $7,000 $13,760 $12,471 $17,220 $21,684 $26,828 $29,994 $35,293 $33,262 $32,581 $32,195 $33,510 $32,237
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $7,000 $13,760 $12,471 $17,220 $21,684 $26,828 $29,994 $35,293 $33,262 $32,581 $32,195 $33,510 $32,237
Paid-in Capital $55,000 $530,000 $530,000 $530,000 $530,000 $530,000 $530,000 $530,000 $530,000 $530,000 $530,000 $530,000 $530,000
Retained Earnings ($25,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999) ($42,999)
Earnings ($17,000) ($21,415) ($41,379) ($52,438) ($49,676) ($33,788) ($13,048) $18,860 $52,411 $85,026 $117,423 $147,869 $181,777
Total Capital $12,001 $465,586 $445,622 $434,563 $437,325 $453,213 $473,953 $505,861 $539,412 $572,027 $604,424 $634,870 $668,778
Total Liabilities and Capital $19,001 $479,346 $458,093 $451,783 $459,009 $480,041 $503,946 $541,154 $572,674 $604,608 $636,619 $668,379 $701,015
Net Worth $12,001 $465,586 $445,622 $434,563 $437,325 $453,213 $473,953 $505,861 $539,412 $572,027 $604,424 $634,870 $668,778
Truckbay internet media advertising business plan appendix. Truckbay, an established company providing online advertising solutions for the global heavy truck and equipment markets, adds new services such as online auctions.