In: Finance
IBX Pty Ltd is considering the purchase of a new machine that is expected to save the company $71,000 at the end of each year in reduced wages.
The machine costs $234,000, plus another $15,000 to be installed. It is expected to last for five years after which it can be sold as scrap for $42,000. Operating expenses (such as fuel and maintenance) are $7,000 pa.
a)Determine the annual net cash flows of this investment (ignore the effect of taxes). Enter the information in the following table. Indicate whether cash flows are + or -:
Time | 0 | 1 | 2 | 3 | 4 | 5 |
---|---|---|---|---|---|---|
Net Cash Flow |
b)Calculate the NPV if the required rate of return is 11% pa. Give your answer in dollars and cents to the nearest cent.
NPV11% = $
c)Calculate the NPV if the required rate of return is 13% pa. Give your answer in dollars and cents to the nearest cent.
NPV13% = $
A | Computation of Initial Cash Outflow: | Year 0 |
Cost of New Machine | $ 234,000 | |
Installation Cost | $ 15,000 | |
Initial Cash Outlay | $ 249,000 |
B | Computation of Operational Cash Inflow | |
Year 1-5 | ||
Annual Savings | $ 71,000 | |
Operating Expenses (Annaul) | $ 7,000 | |
Net Operational Cashflow | $ 64,000 |
C | Computation of Terminal Cash Inflows | Year 5 |
Sale of Scrap | $ 42,000 | |
Terminal Cash Inflow | $ 42,000 |
(a).
Time | 0 | 1 | 2 | 3 | 4 | 5 |
Net Cash Flow | $ - 249,000 | $ 64,000 | $ 64,000 | $ 64,000 | $ 64,000 | $ 106,000 |
($ 64,000 + $ 42,000) |
(b)
Computation of NPV | ||||
Year | Cashflows | PVF@ 11 % | PV | |
A | 0 | $ (249,000) | 1.0000 | $ (249,000) |
PV of Cash Outflows | $ (249,000) | |||
B | 1 | $ 64,000 | 0.9009 | $ 57,658 |
2 | $ 64,000 | 0.8116 | $ 51,944 | |
3 | $ 64,000 | 0.7312 | $ 46,796 | |
4 | $ 64,000 | 0.6587 | $ 42,159 | |
5 | $ 106,000 | 0.5935 | $ 62,906 | |
PV of Cash Inflows | $ 261,462 | |||
NPV | = B-A | $ 12,462 |
(c)
Computation of NPV | ||||
Year | Cashflows | PVF at 13 % | PV | |
A | 0 | $ -249,000 | 1.0000 | $ -249,000 |
PV of Cash Outflows | $ -249,000 | |||
B | 1 | $ 64,000 | 0.8850 | $ 56,637 |
2 | $ 64,000 | 0.7831 | $ 50,121 | |
3 | $ 64,000 | 0.6931 | $ 44,355 | |
4 | $ 64,000 | 0.6133 | $ 39,252 | |
5 | $ 106,000 | 0.5428 | $ 57,533 | |
PV of Cash Inflows | $ 247,899 | |||
NPV | = B-A | $ -1,101 |