In: Accounting
Paul Swanson has an opportunity to acquire a franchise from The Yogurt Place, Inc., to dispense frozen yogurt products under The Yogurt Place name. Mr. Swanson has assembled the following information relating to the franchise:
A suitable location in a large shopping mall can be rented for $5,100 per month.
Remodeling and necessary equipment would cost $414,000. The equipment would have a 15-year life and a $27,600 salvage value. Straight-line depreciation would be used, and the salvage value would be considered in computing depreciation.
Based on similar outlets elsewhere, Mr. Swanson estimates that sales would total $540,000 per year. Ingredients would cost 20% of sales.
Operating costs would include $94,000 per year for salaries, $5,900 per year for insurance, and $51,000 per year for utilities. In addition, Mr. Swanson would have to pay a commission to The Yogurt Place, Inc., of 16.0% of sales.
Required:
1. Prepare a contribution format income statement that shows the expected net operating income each year from the franchise outlet.
| The Yogurt Place, Inc. | ||
| Contribution Format Income Statement | ||
| not attempted | not attempted | |
| Variable expenses: | ||
| not attempted | not attempted | |
| not attempted | not attempted | |
| not attempted | not attempted | 0 |
| not attempted | 0 | |
| Fixed expenses: | ||
| not attempted | not attempted | |
| not attempted | not attempted | |
| not attempted | not attempted | |
| not attempted | not attempted | |
| not attempted | not attempted | |
| not attempted | not attempted | |
| not attempted | not attempted | 0 |
| not attempted | 0 | |
2-a. Compute the simple rate of return promised by the outlet.
3-a. Compute the payback period on the outlet.
| The Yogurt Place Inc. | ||||||
| Contribution Income statement | ||||||
| Sales | $ 5,40,000 | |||||
| Variable cost | ||||||
| Component Cost (20% of sales) | $ 1,08,000 | |||||
| Commission (16% of sales) | $ 86,400 | |||||
| Less: | Total Variable cost | $ 1,94,400 | ||||
| Contribution margin | $ 3,45,600 | |||||
| Less: | Fixed expenses | |||||
| Rent ($5,100 X 12) | $ 61,200 | |||||
| Salaries | $ 94,000 | |||||
| Depreciation [($4,14,000 - $27,600) / 15 years] | $ 25,760 | |||||
| Insurance | $ 5,900 | |||||
| Utilities | $ 51,000 | $ 2,37,860 | ||||
| Net Operating Income (loss) | $ 1,07,740 | |||||
| Computation of Simple rate of return: | ||||||
| Simple rate of return | = | Net Profit / Investment | ||||
| = | $1,07,740 / $4,14,000 | |||||
| = | 26% | |||||
| Computation of Pay Back Period: | ||||||
| Pay Back Period | = | Initial Investment / Annual Cash Flow | ||||
| = | $4,14,000 / $1,07,740 | |||||
| = | 3.84 | years | ||||