Net Present Value Method
The following data are accumulated by Geddes Company in evaluating the purchase of $137,200 of equipment, having a four-year useful life:
Net Income | Net Cash Flow | |||
Year 1 | $32,000 | $54,000 | ||
Year 2 | 20,000 | 42,000 | ||
Year 3 | 9,000 | 31,000 | ||
Year 4 | (1,000) | 21,000 |
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Solution:
a)
Purchase price of equipment = 137,200
Required rate if return = 10%
Assume that equipment is purchased at the beginning of the year and the cash flows are occured at the end of the year
Present value of net cash flow = 121,402
Less : amount to be invested = 137,200
Net present value = -15,798
Calculation of present value of Net cash flow
Year | Cash flow | PV factor @ 1 | Discounted cashflow |
1 | 54,000 | 0.909 | 49,086 |
2 | 42,000 | 0.826 | 34,692 |
3 | 31,000 | 0.751 | 23,281 |
4 | 21,000 | 0.683 | 14,343 |
Total present value of net cashflow | 121,402 |
b)
No , present value indicates that the return on proposal is less than the minimum desired return of 10%
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $102,900 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $33,000 $56,000 Year 2 20,000 43,000 Year 3 10,000 32,000 Year 4 (1,000) 22,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $89,500 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $30,000 $50,000 Year 2 18,000 39,000 Year 3 9,000 29,000 Year 4 (1,000) 20,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $206,000 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $44,000 $75,000 Year 2 27,000 58,000 Year 3 13,000 44,000 Year 4 (1,000) 29,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $206,000 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $44,000 $75,000 Year 2 27,000 58,000 Year 3 13,000 44,000 Year 4 (1,000) 29,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $105,000 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $31,000 $52,000 Year 2 19,000 40,000 Year 3 9,000 30,000 Year 4 (1,000) 20,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $130,600 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $30,000 $50,000 Year 2 18,000 39,000 Year 3 9,000 29,000 Year 4 (1,000) 20,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $161,000 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $35,000 $59,000 Year 2 21,000 45,000 Year 3 10,000 34,000 Year 4 (1,000) 23,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Paxton Company in evaluating the purchase of $106,400 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 Year 2 Year 3 Year 4 $35,000 $60,000 22,000 46,000 11,000 35,000 (1,000) 23,000 Present Value of $1 at Compound Interest 6% 10% 12% 15% 20% 0.943 0.9090.893 0.870 0.833 0.890 0.826 0.797 0.756 0.694 0.840 0.751 0.712 0.658 0.579 0.792 0.683 0.636 0.572 0.482 0.747 0.621 0.567...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $139,500 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $34,000 $57,000 Year 2 21,000 44,000 Year 3 10,000 33,000 Year 4 (1,000) 22,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683...
Net Present Value Method The following data are accumulated by Geddes Company in evaluating the purchase of $97,400 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $32,000 $55,000 Year 2 20,000 42,000 Year 3 10,000 32,000 Year 4 (1,000) 21,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 0.943 0.909 0.893 0.870 0.833 0.890 0.826 0.797 0.756 0.694 0.840 0.751 0.712 0.658 0.579 0.792 0.683 0.636 0.572 0.482 5...