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 |
By 
