Portland Mobile Auto Inspectors

Start your own business plan »

Auto Inspectors 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
Used car purchasers 0% $0 $1,200 $1,900 $2,300 $3,600 $4,500 $5,100 $5,500 $5,900 $6,500 $7,400 $8,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $1,200 $1,900 $2,300 $3,600 $4,500 $5,100 $5,500 $5,900 $6,500 $7,400 $8,000
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
Used car purchasers $0 $84 $133 $161 $252 $315 $357 $385 $413 $455 $518 $560
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $84 $133 $161 $252 $315 $357 $385 $413 $455 $518 $560
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
Owner 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
Name or Title 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other 0% $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 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
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 $0 $1,200 $1,900 $2,300 $3,600 $4,500 $5,100 $5,500 $5,900 $6,500 $7,400 $8,000
Direct Cost of Sales $0 $84 $133 $161 $252 $315 $357 $385 $413 $455 $518 $560
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $84 $133 $161 $252 $315 $357 $385 $413 $455 $518 $560
Gross Margin $0 $1,116 $1,767 $2,139 $3,348 $4,185 $4,743 $5,115 $5,487 $6,045 $6,882 $7,440
Gross Margin % 0.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00% 93.00%
Expenses
Payroll $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Sales and Marketing and Other Expenses $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Depreciation $317 $317 $317 $317 $317 $317 $317 $317 $317 $317 $317 $317
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,642 $3,642 $3,642 $3,642 $3,642 $3,642 $3,642 $3,642 $3,642 $3,642 $3,642 $3,642
Profit Before Interest and Taxes ($3,642) ($2,526) ($1,875) ($1,503) ($294) $543 $1,101 $1,473 $1,845 $2,403 $3,240 $3,798
EBITDA ($3,325) ($2,209) ($1,558) ($1,186) $23 $860 $1,418 $1,790 $2,162 $2,720 $3,557 $4,115
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($1,093) ($758) ($563) ($451) ($88) $163 $330 $442 $554 $721 $972 $1,139
Net Profit ($2,549) ($1,768) ($1,313) ($1,052) ($206) $380 $771 $1,031 $1,292 $1,682 $2,268 $2,659
Net Profit/Sales 0.00% -147.35% -69.08% -45.74% -5.72% 8.45% 15.11% 18.75% 21.89% 25.88% 30.65% 33.23%
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 $1,200 $1,900 $2,300 $3,600 $4,500 $5,100 $5,500 $5,900 $6,500 $7,400 $8,000
Subtotal Cash from Operations $0 $1,200 $1,900 $2,300 $3,600 $4,500 $5,100 $5,500 $5,900 $6,500 $7,400 $8,000
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 $1,200 $1,900 $2,300 $3,600 $4,500 $5,100 $5,500 $5,900 $6,500 $7,400 $8,000
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 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Bill Payments ($768) ($1,091) ($442) ($100) $50 $499 $810 $1,017 $1,157 $1,298 $1,511 $1,822
Subtotal Spent on Operations $2,232 $1,909 $2,558 $2,900 $3,050 $3,499 $3,810 $4,017 $4,157 $4,298 $4,511 $4,822
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 $2,232 $1,909 $2,558 $2,900 $3,050 $3,499 $3,810 $4,017 $4,157 $4,298 $4,511 $4,822
Net Cash Flow ($2,232) ($709) ($658) ($600) $550 $1,001 $1,290 $1,483 $1,743 $2,202 $2,889 $3,178
Cash Balance $9,268 $8,558 $7,900 $7,300 $7,850 $8,850 $10,141 $11,624 $13,367 $15,569 $18,457 $21,635
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 $11,500 $9,268 $8,558 $7,900 $7,300 $7,850 $8,850 $10,141 $11,624 $13,367 $15,569 $18,457 $21,635
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $11,500 $9,268 $8,558 $7,900 $7,300 $7,850 $8,850 $10,141 $11,624 $13,367 $15,569 $18,457 $21,635
Long-term Assets
Long-term Assets $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000
Accumulated Depreciation $0 $317 $634 $951 $1,268 $1,585 $1,902 $2,219 $2,536 $2,853 $3,170 $3,487 $3,804
Total Long-term Assets $19,000 $18,683 $18,366 $18,049 $17,732 $17,415 $17,098 $16,781 $16,464 $16,147 $15,830 $15,513 $15,196
Total Assets $30,500 $27,951 $26,924 $25,949 $25,032 $25,265 $25,948 $26,922 $28,088 $29,514 $31,399 $33,970 $36,831
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 $0 $742 $1,079 $1,214 $1,653 $1,956 $2,159 $2,294 $2,429 $2,631 $2,935 $3,137
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 $0 $742 $1,079 $1,214 $1,653 $1,956 $2,159 $2,294 $2,429 $2,631 $2,935 $3,137
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $0 $742 $1,079 $1,214 $1,653 $1,956 $2,159 $2,294 $2,429 $2,631 $2,935 $3,137
Paid-in Capital $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
Retained Earnings ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500) ($1,500)
Earnings $0 ($2,549) ($4,318) ($5,630) ($6,682) ($6,888) ($6,508) ($5,737) ($4,706) ($3,415) ($1,733) $535 $3,194
Total Capital $30,500 $27,951 $26,182 $24,870 $23,818 $23,612 $23,992 $24,763 $25,794 $27,085 $28,768 $31,036 $33,694
Total Liabilities and Capital $30,500 $27,951 $26,924 $25,949 $25,032 $25,265 $25,948 $26,922 $28,088 $29,514 $31,399 $33,970 $36,831
Net Worth $30,500 $27,951 $26,182 $24,870 $23,818 $23,612 $23,992 $24,763 $25,794 $27,085 $28,768 $31,036 $33,694