Portland Mobile Auto Inspectors
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 |