In: Accounting
Emery Communications Company is considering the production and marketing of a communications system that will increase the efficiency of messaging for small businesses or branch offices of large companies. Each unit hooked into the system is assigned a mailbox number, which can be matched to a telephone extension number, providing access to messages 24 hours a day. Up to 20 units can be hooked into the system, allowing the delivery of the same message to as many as 20 people. Personal codes can be used to make messages confidential. Furthermore, messages can be reviewed, recorded, cancelled, replied to, or deleted all during the same message playback. Indicators wired to the telephone blink whenever new messages are present.
To produce this product, a $1.75 million investment in new equipment is required. The equipment will last 10 years but will need major maintenance costing $150,000 at the end of its sixth year. The salvage value of the equipment at the end of 10 years is estimated to be $100,000. If this new system is produced, working capital must also be increased by $90,000. This capital will be restored at the end of the product's 10-year life cycle. Revenues from the sale of the product are estimated at $1.65 million per year. Cash operating expenses are estimated at $1.32 million per year.
Required: | |
1. | Prepare a schedule of cash flows for the proposed project. (Assume that there are no income taxes.) |
2. | Assuming that Emery's cost of capital is 12%, compute the project's NPV. Should the product be produced? |
schedule of cash flow
year 0 | ||
Equipment | (1,750,000) | |
working capital | (90000) | |
Total | (1,840,000) | |
Year 1-5 | ||
Revenues | 1,650,000 | |
Operating expenses | (1,320,000) | |
Total | 330000 | |
Year 6 | ||
Revenues | 1,650,000 | |
operating expense | (1,320,000) | |
Major maintenance | (150000) | |
Total | 180000 | |
Year 7-9 | ||
Revenue | 1,650,000 | |
Operating expenses | (1,320,000) | |
Total | 330000 | |
Year 10 | ||
Revenues | 1,650,000 | |
Operating expense | (1,320,000) | |
salvage | 100000 | |
recovery of working capital | 90000 | |
Total | 520,000 | |
NPV
YEARS | cash flow | pv factor @ 12% | present value of cash flow | |
0 | (1840000) | 1 | (1840000) | |
1-5 | 330000 | 3.60478 | 1189577.4 | |
6 | 180000 | 0.50663 | 91193.4 | |
7-9 | 330000 | 1.21684 | 401557.2 | |
10 | 520000 | 0.32197 | 167424.4 | |
Net present value | 9752$ | |||
npv of project is 9752$
YES PRODUCT BE PRODUCED AS THE NPV IS POSITIVE.