Environmental Engines

Start your own business plan »

Environmental Car Dealership 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
Sales
Toyota Prius 0% $150,000 $180,000 $216,000 $259,200 $311,040 $373,248 $447,898 $537,477 $644,973 $773,967 $928,760 $1,114,513
Toyota RAV4 0% $70,000 $84,000 $100,800 $120,960 $145,152 $174,182 $209,019 $250,823 $300,987 $361,185 $433,422 $520,106
Honda 0% $25,000 $30,000 $36,000 $43,200 $51,840 $62,208 $74,650 $89,580 $107,495 $128,995 $154,793 $185,752
GM 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Mechanic Labor 0% $10,000 $12,000 $14,400 $17,280 $20,736 $24,883 $29,860 $35,832 $42,998 $51,598 $61,917 $74,301
Total Sales $255,000 $306,000 $367,200 $440,640 $528,768 $634,522 $761,426 $913,711 $1,096,453 $1,315,744 $1,578,893 $1,894,671
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Toyota Prius $120,000 $144,000 $172,800 $207,360 $248,832 $298,598 $358,318 $429,982 $515,978 $619,174 $743,008 $891,610
Toyota RAV4 $56,000 $67,200 $80,640 $96,768 $116,122 $139,346 $167,215 $200,658 $240,790 $288,948 $346,737 $416,085
Honda $20,000 $24,000 $28,800 $34,560 $41,472 $49,766 $59,720 $71,664 $85,996 $103,196 $123,835 $148,602
GM $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Mechanic Labor $8,000 $9,600 $11,520 $13,824 $16,589 $19,907 $23,888 $28,665 $34,399 $41,278 $49,534 $59,441
Subtotal Direct Cost of Sales $204,000 $244,800 $293,760 $352,512 $423,014 $507,617 $609,141 $730,969 $877,163 $1,052,595 $1,263,114 $1,515,737
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
Jack Anderson 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Frank Lee Good 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Jim Handy 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Person 1 0% $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040
Sales Person 2 0% $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040
Sales Person 3 0% $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040
Sales Person 4 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Person 5 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Person 6 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Mechanic 1 0% $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Maintenance 0% $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040
Secretary 0% $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040
Mechanic 2 0% $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600
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 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $255,000 $306,000 $367,200 $440,640 $528,768 $634,522 $761,426 $913,711 $1,096,453 $1,315,744 $1,578,893 $1,894,671
Direct Cost of Sales $204,000 $244,800 $293,760 $352,512 $423,014 $507,617 $609,141 $730,969 $877,163 $1,052,595 $1,263,114 $1,515,737
Sales Commission $12,750 $15,300 $18,360 $22,032 $26,438 $31,726 $38,071 $45,686 $54,823 $65,787 $78,945 $94,734
Total Cost of Sales $216,750 $260,100 $312,120 $374,544 $449,453 $539,343 $647,212 $776,654 $931,985 $1,118,382 $1,342,059 $1,610,471
Gross Margin $38,250 $45,900 $55,080 $66,096 $79,315 $95,178 $114,214 $137,057 $164,468 $197,362 $236,834 $284,201
Gross Margin % 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00%
Expenses
Payroll $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600
Sales and Marketing and Other Expenses $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Depreciation $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Rent $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Utilities (Including costs of photovoltaic cell maintenance) $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $2,190 $2,190 $2,190 $2,190 $2,190 $2,190 $2,190 $2,190 $2,190 $2,190 $2,190 $2,190
Licensing $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 Operating Expenses $40,690 $40,690 $40,690 $40,690 $40,690 $40,690 $40,690 $40,690 $40,690 $40,690 $40,690 $40,690
Profit Before Interest and Taxes ($2,440) $5,210 $14,390 $25,406 $38,625 $54,488 $73,524 $96,367 $123,778 $156,672 $196,144 $243,511
EBITDA ($1,240) $6,410 $15,590 $26,606 $39,825 $55,688 $74,724 $97,567 $124,978 $157,872 $197,344 $244,711
Interest Expense $28,583 $28,000 $27,417 $26,833 $26,250 $25,667 $25,083 $24,500 $23,917 $23,333 $22,750 $22,167
Taxes Incurred ($9,307) ($6,837) ($3,908) ($428) $3,713 $8,646 $14,532 $21,560 $29,958 $40,001 $52,018 $66,403
Net Profit ($21,716) ($15,953) ($9,119) ($999) $8,663 $20,175 $33,908 $50,307 $69,903 $93,337 $121,376 $154,941
Net Profit/Sales -8.52% -5.21% -2.48% -0.23% 1.64% 3.18% 4.45% 5.51% 6.38% 7.09% 7.69% 8.18%
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 $63,750 $76,500 $91,800 $110,160 $132,192 $158,630 $190,356 $228,428 $274,113 $328,936 $394,723 $473,668
Cash from Receivables $0 $6,375 $192,525 $231,030 $277,236 $332,683 $399,220 $479,064 $574,877 $689,852 $827,822 $993,387
Subtotal Cash from Operations $63,750 $82,875 $284,325 $341,190 $409,428 $491,314 $589,576 $707,492 $848,990 $1,018,788 $1,222,545 $1,467,055
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 $63,750 $82,875 $284,325 $341,190 $409,428 $491,314 $589,576 $707,492 $848,990 $1,018,788 $1,222,545 $1,467,055
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 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600 $14,600
Bill Payments $12,011 $360,007 $353,144 $416,911 $493,513 $585,516 $696,002 $828,667 $987,947 $1,179,164 $1,408,706 $1,684,239
Subtotal Spent on Operations $26,611 $374,607 $367,744 $431,511 $508,113 $600,116 $710,602 $843,267 $1,002,547 $1,193,764 $1,423,306 $1,698,839
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 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
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 $96,611 $444,607 $437,744 $501,511 $578,113 $670,116 $780,602 $913,267 $1,072,547 $1,263,764 $1,493,306 $1,768,839
Net Cash Flow ($32,861) ($361,732) ($153,419) ($160,321) ($168,685) ($178,803) ($191,026) ($205,776) ($223,557) ($244,976) ($270,761) ($301,784)
Cash Balance $3,577,189 $3,215,458 $3,062,038 $2,901,717 $2,733,032 $2,554,230 $2,363,203 $2,157,428 $1,933,871 $1,688,894 $1,418,133 $1,116,349
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 $3,610,050 $3,577,189 $3,215,458 $3,062,038 $2,901,717 $2,733,032 $2,554,230 $2,363,203 $2,157,428 $1,933,871 $1,688,894 $1,418,133 $1,116,349
Accounts Receivable $0 $191,250 $414,375 $497,250 $596,700 $716,040 $859,248 $1,031,098 $1,237,317 $1,484,781 $1,781,737 $2,138,084 $2,565,701
Inventory $125,000 $224,400 $269,280 $323,136 $387,763 $465,316 $558,379 $670,055 $804,066 $964,879 $1,157,855 $1,389,426 $1,667,311
Other Current Assets $189,500 $189,500 $189,500 $189,500 $189,500 $189,500 $189,500 $189,500 $189,500 $189,500 $189,500 $189,500 $189,500
Total Current Assets $3,924,550 $4,182,339 $4,088,613 $4,071,924 $4,075,680 $4,103,888 $4,161,357 $4,253,856 $4,388,311 $4,573,030 $4,817,986 $5,135,143 $5,538,860
Long-term Assets
Long-term Assets $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000
Accumulated Depreciation $0 $1,200 $2,400 $3,600 $4,800 $6,000 $7,200 $8,400 $9,600 $10,800 $12,000 $13,200 $14,400
Total Long-term Assets $440,000 $438,800 $437,600 $436,400 $435,200 $434,000 $432,800 $431,600 $430,400 $429,200 $428,000 $426,800 $425,600
Total Assets $4,364,550 $4,621,139 $4,526,213 $4,508,324 $4,510,880 $4,537,888 $4,594,157 $4,685,456 $4,818,711 $5,002,230 $5,245,986 $5,561,943 $5,964,460
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 $348,306 $339,332 $400,562 $474,117 $562,463 $668,556 $795,947 $948,895 $1,132,511 $1,352,930 $1,617,512 $1,935,088
Current Borrowing $2,000,000 $1,970,000 $1,940,000 $1,910,000 $1,880,000 $1,850,000 $1,820,000 $1,790,000 $1,760,000 $1,730,000 $1,700,000 $1,670,000 $1,640,000
Other Current Liabilities $178,000 $178,000 $178,000 $178,000 $178,000 $178,000 $178,000 $178,000 $178,000 $178,000 $178,000 $178,000 $178,000
Subtotal Current Liabilities $2,178,000 $2,496,306 $2,457,332 $2,488,562 $2,532,117 $2,590,463 $2,666,556 $2,763,947 $2,886,895 $3,040,511 $3,230,930 $3,465,512 $3,753,088
Long-term Liabilities $1,500,000 $1,460,000 $1,420,000 $1,380,000 $1,340,000 $1,300,000 $1,260,000 $1,220,000 $1,180,000 $1,140,000 $1,100,000 $1,060,000 $1,020,000
Total Liabilities $3,678,000 $3,956,306 $3,877,332 $3,868,562 $3,872,117 $3,890,463 $3,926,556 $3,983,947 $4,066,895 $4,180,511 $4,330,930 $4,525,512 $4,773,088
Paid-in Capital $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000
Retained Earnings ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450) ($813,450)
Earnings $0 ($21,716) ($37,669) ($46,788) ($47,787) ($39,124) ($18,949) $14,959 $65,266 $135,169 $228,505 $349,881 $504,822
Total Capital $686,550 $664,834 $648,881 $639,762 $638,763 $647,426 $667,601 $701,509 $751,816 $821,719 $915,055 $1,036,431 $1,191,372
Total Liabilities and Capital $4,364,550 $4,621,139 $4,526,213 $4,508,324 $4,510,880 $4,537,888 $4,594,157 $4,685,456 $4,818,711 $5,002,230 $5,245,986 $5,561,943 $5,964,460
Net Worth $686,550 $664,834 $648,881 $639,762 $638,763 $647,426 $667,601 $701,509 $751,816 $821,719 $915,055 $1,036,431 $1,191,372