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 $4,900 per month.
Remodeling and necessary equipment would cost $402,000. The equipment would have a 20-year life and a $20,100 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 $520,000 per year. Ingredients would cost 20% of sales.
Operating costs would include $92,000 per year for salaries, $5,700 per year for insurance, and $49,000 per year for utilities. In addition, Mr. Swanson would have to pay a commission to The Yogurt Place, Inc., of 15.0% of sales.
Required: 1. Prepare a contribution format income statement that shows the expected net operating income each year from the franchise outlet.
2-a. Compute the simple rate of return promised by the outlet.
2-b. If Mr. Swanson requires a simple rate of return of at least 20%, should he acquire the franchise?
3-a. Compute the payback period on the outlet.
3-b. If Mr. Swanson wants a payback of two years or less, will he acquire the franchise?
Solution: | ||||
1. | PAUL SWANSON | |||
Contribution Format Income Statement | ||||
Sales | $520,000 | |||
Variable expenses: | ||||
Cost of ingredients | $104,000 | |||
Commissions | $78,000 | |||
$182,000 | ||||
Contribution margin | $338,000 | |||
Selling and administrative expenses: | ||||
Salaries | $92,000 | |||
Rent | $58,800 | |||
Depreciation | $19,095 | |||
Insurance | $5,700 | |||
Utilities | $49,000 | |||
$224,595 | ||||
Net operating income | $113,405 | |||
Working Notes: | ||||
PAUL SWANSON | ||||
Contribution Format Income Statement | ||||
I | Sales | $520,000 | ||
Variable expenses: | ||||
II | Cost of ingredients | $104,000 | ||
[$520,000 x 20% = $104,000 ] | ||||
III | Commissions | |||
[$520,000 x 15% = $78,000 ] | $78,000 | |||
IV=II + III | $182,000 | |||
A | Contribution margin | $338,000 | ||
Selling and administrative expenses: | ||||
V | Salaries | $92,000 | ||
VI | Rent | $58,800 | ||
[4,900 x 12 = 58,800 ] | ||||
VII | Depreciation | $19,095 | ||
[($402,000-$20,100)/20 = $19,095 ] | ||||
VIII | Insurance | $5,700 | ||
IX | Utilities | $49,000 | ||
X=V+VI+VII+VIII+IX | $224,595 | |||
XI=A-X | Net operating income | $113,405 | ||
Depreciation | =(cost -salvage value)/life | |||
2.-a. | Simple rate of return | 28.21% | ||
Working Notes: | ||||
Simple rate of return = Annual incremental net operating income /Initial investment | ||||
Simple rate of return = $113,405 /$402,000 | ||||
Simple rate of return = 0.28210199 | ||||
Simple rate of return = 28.21% | ||||
2-b. | YES | |||
Notes: | YES, he should acquire the Franchise since its rate of return 28.21% which is excess of 20% | |||
3-a. | Payback period | 3.03 years | ||
Working Notes: | ||||
Payback period = Initial investment /Annual net cash inflow | ||||
Initial investment = $402,000 | ||||
Annual net cash inflow = Depreciation + Net operating income | ||||
Annual net cash inflow = $19,095+ $113,405 | ||||
Annual net cash inflow = $132,500 | ||||
Payback period = Initial investment /Annual net cash inflow | ||||
Payback period = $402,000 /$132,500 | ||||
Payback period = 3.03396 years | ||||
Payback period = 3.03 years | ||||
3-b. | NO | |||
Working Notes: | ||||
Since, the franchise payback period is 3.03 years, but Mr. Swanson wants a payback of two years or less, hence, He should not acquire the franchise. | ||||
Please feel free to ask if anything about above solution in comment section of the question. |