In: Accounting
V. S. Yogurt is considering two possible expansion plans. Proposal A involves opening 10 stores in northern California at a total cost of $3,150,000. Under another strategy, Proposal B, V. S. Yogurt would focus on southern California and open six stores for a total cost of $2,500,000. Selected data regarding the two proposals have been assembled by the controller of V. S. Yogurt as follows.
Proposal A | Proposal B | ||||||
Required investment | $ | 3,150,000 | $ | 2,500,000 | |||
Estimated life of store locations | 7 years | 7 years | |||||
Estimated salvage value | $ | 0 | $ | 400,000 | |||
Estimated annual net cash flow | 750,000 | 570,000 | |||||
Depreciation on equipment (straight-line basis) | 450,000 | 300,000 | |||||
Estimated annual net income | ? | ? | |||||
Required:
a. For each proposal, compute the following.
Assume discounted at management's required rate of return of 15
percent. Use Exhibits 26-3 and 26-4 where necessary.
(1) Payback period
(2) Return on average investment
(3) Net present value
b. On the basis of your analysis in part a, state
which proposal you would recommend.
Proposal A | Proposal B | ||||||
Investment | $3,150,000 | $2,500,000 | |||||
annual income | 300000 | 270000 | |||||
(1) | Payback period | 10.50 | 9.26 | ||||
(3,150,000/300,000) | (2,500,000/270,000) | ||||||
(2) | Return on average investment | 1 | 0.86957 | ||||
Proposal A | Proposal B | 2 | 0.75614 | ||||
Annual income | 300000 | 270000 | 3 | 0.65752 | |||
Investment | $3,150,000 | $2,500,000 | 4 | 0.57175 | |||
Return | 9.52% | 10.80% | 5 | 0.49718 | |||
(300,000/3,150,000) | (270,000/2,500,000) | 6 | 0.43233 | ||||
7 | 0.37594 | ||||||
(3) | Proposal A | Proposal B | 4.16043 | ||||
Annual cash inflow | 750000 | 570000 | |||||
Present value annuity factor @ 15% | 4.16043 | 4.16043 | |||||
Present value | 3120322.5 | 2371445.1 | |||||
Present value of salvage value | 150376 | ||||||
3,120,323 | 2,521,821 | ||||||
Initial investement | $3,150,000 | $2,500,000 | |||||
NPV | (29,677) | 21,821 | |||||
NPV of the Proposal B is positive same should be accepted. |