In: Accounting
In five years, Kent Duncan will retire. He is exploring the possibility of opening a self-service car wash. The car wash could be managed in the free time he has available from his regular occupation, and it could be closed easily when he retires. After careful study, Mr. Duncan determined the following:
Mr. Duncan will not open the car wash unless it provides at least a 15% return.
Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.
Required:
1. Assuming that the car wash will be open 52 weeks a year, compute the expected annual net cash receipts from its operation.
2-a. Determine the net present value using the net present value method of investment analysis.
2-b. Would you advise Mr. Duncan to open the car wash?
Solution 1:
Computation of expected annual cash receipt from operation | ||
Particulars | Amount | |
Autowash cash receipt | $119,340.00 | |
Vacuum cash receipt ($2,295/1.35*0.90*60%*52) | $47,736.00 | |
Total cash receipt | $167,076.00 | |
Less: Cash disbursements: | ||
Water ($2,295 / 1.35 * 0.075*52) | $6,630.00 | |
Electricity ($2,295/1.35*60%*0.10*52) | $5,304.00 | |
Rent | $45,600.00 | |
Cleaning | $27,600.00 | |
Insurance | $900.00 | |
Maintenance | $21,540.00 | |
Total cash disbursements | $107,574.00 | |
Annual net cash flow from operations | $59,502.00 |
Solution 2a:
Computation of NPV | ||||
Particulars | Period | Amount | PV Factor | Present Value |
Cash outflows: | ||||
Cost of equipment | 0 | $210,000 | 1 | $210,000 |
Working capital | 0 | $3,000 | 1 | $3,000 |
Present value of cash outflows (A) | $213,000 | |||
Cash Inflows: | ||||
Annual cash inflows | 1-5 | $59,502 | 3.352 | $199,451 |
Salvage value | 5 | $18,900 | 0.497 | $9,393 |
Release of working capital | 5 | $3,000 | 0.497 | $1,491 |
Present value of cash inflow (B) | $210,335 | |||
NPV (B-A) | -$2,665 |
Solution 2b:
As NPV is negative, therefore Mr, Duncan should not open the car wash.