The Business Plan's Financial Forecast
Jake is preparing a business plan for a new mobile car wash service. He forecasts the following for the first year: monthly sales of 200 car washes at $30 each; variable costs per wash of $10 (water, soap, labour); fixed costs of $2,000 per month (insurance, vehicle lease, marketing); and initial equipment purchase of $15,000 (depreciated over 3 years). He plans to fund the business with $20,000 of his own savings and a $10,000 bank loan at 10% interest per annum. Jake wants to know if his business will be profitable in the first year and what his cash flow will look like. He also needs to decide whether to offer a subscription service.
1. Prepare a monthly income statement and a cash flow statement for the first year (assuming even sales each month). Calculate the annual profit, and determine the cash balance at the end of the year, considering the loan interest and loan principal repayment of $2,000 at the end of the year. Advise Jake on the financial viability of his business.
Read the worked answer
Monthly income statement: Sales revenue = 200 * $30 = $6,000. Variable costs = 200 * $10 = $2,000. Contribution margin = $4,000. Fixed costs = $2,000. Profit before depreciation and interest = $2,000. Depreciation = $15,000 / 3 years = $5,000 per year, or $416.67 per month. Loan interest = 10% of $10,000 = $1,000 per year, or $83.33 per month. So monthly profit = $2,000 - $416.67 - $83.33 = $1,500. Annual profit = $1,500 * 12 = $18,000.
Cash flow: Monthly cash inflow from sales = $6,000. Cash outflow variable = $2,000, fixed = $2,000, loan interest = $83.33 (assuming paid monthly). Net monthly cash flow before equipment and loan principal = $6,000 - $2,000 - $2,000 - $83.33 = $1,916.67. Initial equipment purchase of $15,000 at start (month 0). Loan principal repayment $2,000 at end of year. Starting cash = $20,000 (own savings) + $10,000 loan = $30,000. After equipment purchase, cash = $15,000. Over the year, net cash from operations = 12 * $1,916.67 = $23,000. So cash before principal repayment = $15,000 + $23,000 = $38,000. After principal repayment = $36,000. So ending cash balance = $36,000. The business is profitable and cash flow positive. Jake should be able to repay the loan and have a healthy cash balance. However, he should consider that sales may not be even, and he needs to ensure he has enough cash for the initial equipment. The business appears viable.
2. Evaluate the potential benefits and risks of introducing a subscription service where customers pay $100 per month for unlimited car washes (up to 4 per month). Assume that 50 existing customers would subscribe, reducing their individual washes from an average of 2 per month to 4 per month, and that variable costs per wash remain $10. Calculate the impact on monthly profit and discuss non-financial factors.
Read the worked answer
Currently, 200 washes per month at $30 each. If 50 customers subscribe, they would previously have been part of the 200 washes. Assuming each of these 50 customers previously had 2 washes per month (total 100 washes), they now have 4 washes each (total 200 washes). So total washes become: original 200 - 100 + 200 = 300 washes. But subscription revenue: 50 * $100 = $5,000. Remaining non-subscription washes: 100 washes at $30 = $3,000. Total revenue = $8,000. Variable costs = 300 * $10 = $3,000. Contribution margin = $5,000. Fixed costs = $2,000. Profit before depreciation and interest = $3,000. Previously profit before depreciation and interest was $2,000. So monthly profit increases by $1,000 before depreciation and interest. After depreciation and interest, profit increases by $1,000. Annual profit increases by $12,000. So financially beneficial. However, risks: subscription may attract customers who wash frequently, increasing variable costs; may cannibalize pay-per-wash sales; and may require capacity to handle 300 washes (currently 200). Jake needs to ensure he can handle the increased volume. Non-financial factors: subscription builds customer loyalty and predictable revenue, but may reduce flexibility. Also, unlimited washes may lead to overuse and higher costs. Jake should consider whether the $100 price is optimal and whether to cap washes. Overall, it seems profitable but requires careful management.