DIY Wash N' Fix
Appendix
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 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | |
Direct Cost of Sales | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | |
Gross Margin | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | $69,189 | |
Gross Margin % | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | 93.49% | |
Expenses | |||||||||||||
Payroll | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | |
Sales and Marketing and Other Expenses | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | $19,003 | |
Depreciation | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Insurance | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | $1,507 | |
Payroll Taxes | 15% | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 | $2,828 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | $42,289 | |
Profit Before Interest and Taxes | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | $26,900 | |
EBITDA | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | |
Interest Expense | $3,465 | $3,460 | $3,456 | $3,452 | $3,447 | $3,443 | $3,438 | $3,434 | $3,429 | $3,425 | $3,421 | $3,416 | |
Taxes Incurred | $7,030 | $9,376 | $9,377 | $9,379 | $9,381 | $9,383 | $9,385 | $9,386 | $9,388 | $9,390 | $9,392 | $9,393 | |
Net Profit | $16,404 | $14,064 | $14,066 | $14,069 | $14,072 | $14,074 | $14,077 | $14,079 | $14,082 | $14,085 | $14,087 | $14,090 | |
Net Profit/Sales | 22.17% | 19.00% | 19.01% | 19.01% | 19.01% | 19.02% | 19.02% | 19.02% | 19.03% | 19.03% | 19.03% | 19.04% |
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 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | |
Subtotal Cash from Operations | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | |
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 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | |
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 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | |
Bill Payments | $1,465 | $43,858 | $40,994 | $40,992 | $40,989 | $40,986 | $40,984 | $40,981 | $40,978 | $40,976 | $40,973 | $40,970 | |
Subtotal Spent on Operations | $20,317 | $62,710 | $59,846 | $59,844 | $59,841 | $59,838 | $59,836 | $59,833 | $59,830 | $59,828 | $59,825 | $59,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 | $663 | $663 | $663 | $663 | $663 | $663 | $663 | $663 | $663 | $663 | $663 | $663 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $21,106 | $63,498 | $60,635 | $60,632 | $60,629 | $60,627 | $60,624 | $60,621 | $60,619 | $60,616 | $60,613 | $60,611 | |
Net Cash Flow | $52,904 | $10,512 | $13,375 | $13,378 | $13,381 | $13,383 | $13,386 | $13,389 | $13,391 | $13,394 | $13,397 | $13,399 | |
Cash Balance | $230,266 | $240,778 | $254,153 | $267,531 | $280,912 | $294,295 | $307,681 | $321,070 | $334,461 | $347,855 | $361,252 | $374,651 |
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 | $177,362 | $230,266 | $240,778 | $254,153 | $267,531 | $280,912 | $294,295 | $307,681 | $321,070 | $334,461 | $347,855 | $361,252 | $374,651 |
Inventory | $0 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 | $5,303 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $177,362 | $235,569 | $246,081 | $259,457 | $272,835 | $286,215 | $299,598 | $312,984 | $326,373 | $339,764 | $353,158 | $366,555 | $379,954 |
Long-term Assets | |||||||||||||
Long-term Assets | $578,200 | $578,325 | $578,450 | $578,575 | $578,700 | $578,825 | $578,950 | $579,075 | $579,200 | $579,325 | $579,450 | $579,575 | $579,700 |
Accumulated Depreciation | $0 | $100 | $200 | $300 | $400 | $500 | $600 | $700 | $800 | $900 | $1,000 | $1,100 | $1,200 |
Total Long-term Assets | $578,200 | $578,225 | $578,250 | $578,275 | $578,300 | $578,325 | $578,350 | $578,375 | $578,400 | $578,425 | $578,450 | $578,475 | $578,500 |
Total Assets | $755,562 | $813,794 | $824,331 | $837,732 | $851,135 | $864,540 | $877,948 | $891,359 | $904,773 | $918,189 | $931,608 | $945,030 | $958,454 |
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 | $42,491 | $39,628 | $39,625 | $39,623 | $39,620 | $39,618 | $39,615 | $39,613 | $39,610 | $39,607 | $39,605 | $39,602 |
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 | $42,491 | $39,628 | $39,625 | $39,623 | $39,620 | $39,618 | $39,615 | $39,613 | $39,610 | $39,607 | $39,605 | $39,602 |
Long-term Liabilities | $520,380 | $519,717 | $519,053 | $518,390 | $517,727 | $517,063 | $516,400 | $515,737 | $515,073 | $514,410 | $513,747 | $513,083 | $512,420 |
Total Liabilities | $520,380 | $562,208 | $558,681 | $558,015 | $557,349 | $556,684 | $556,018 | $555,352 | $554,686 | $554,020 | $553,354 | $552,688 | $552,022 |
Paid-in Capital | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 | $236,182 |
Retained Earnings | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) | ($1,000) |
Earnings | $0 | $16,404 | $30,468 | $44,534 | $58,603 | $72,675 | $86,749 | $100,826 | $114,905 | $128,987 | $143,072 | $157,160 | $171,250 |
Total Capital | $235,182 | $251,586 | $265,650 | $279,716 | $293,785 | $307,857 | $321,931 | $336,008 | $350,087 | $364,169 | $378,254 | $392,342 | $406,432 |
Total Liabilities and Capital | $755,562 | $813,794 | $824,331 | $837,732 | $851,135 | $864,540 | $877,948 | $891,359 | $904,773 | $918,189 | $931,608 | $945,030 | $958,454 |
Net Worth | $235,182 | $251,586 | $265,650 | $279,716 | $293,785 | $307,857 | $321,931 | $336,008 | $350,087 | $364,169 | $378,254 | $392,342 | $406,432 |
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 | ||
Unit Sales | |||||||||||||
Car Wash | 0% | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 |
Vacuum Cleaning | 0% | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 | 1,260 |
Car Paint | 0% | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 |
Oil Change | 0% | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 |
Other Repair | 0% | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 | 630 |
Vending Machines, etc. | 0% | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 |
Total Unit Sales | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | 4,530 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Car Wash | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | |
Vacuum Cleaning | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | |
Car Paint | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | |
Oil Change | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | |
Other Repair | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | |
Vending Machines, etc. | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | |
Sales | |||||||||||||
Car Wash | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | $6,300 | |
Vacuum Cleaning | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | $1,260 | |
Car Paint | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | $31,500 | |
Oil Change | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | $9,450 | |
Other Repair | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | $25,200 | |
Vending Machines, etc. | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Total Sales | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | $74,010 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Car Wash | 0.00% | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 | $2.13 |
Vacuum Cleaning | 0.00% | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 | $0.43 |
Car Paint | 0.00% | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 | $1.13 |
Oil Change | 0.00% | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 | $0.38 |
Other Repair | 0.00% | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 | $0.85 |
Vending Machines, etc. | 0.00% | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 | $1.06 |
Direct Cost of Sales | |||||||||||||
Car Wash | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | $2,678 | |
Vacuum Cleaning | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | |
Car Paint | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | |
Oil Change | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | |
Other Repair | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | $536 | |
Vending Machines, etc. | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | |
Subtotal Direct Cost of Sales | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 | $4,821 |
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 | ||
General Manager | 0% | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 |
Mechanics | 0% | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 | $12,124 |
Administrative | 0% | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 | $3,395 |
Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
Total Payroll | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 | $18,852 |
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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
Tax Rate | 30.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |