The following data are accumulated by Geddes Company in evaluating the purchase of $140,000 of equipment, having a four-year useful life:
Net Income | Net Cash Flow | |||
Year 1 | $42,000 | $77,000 | ||
Year 2 | 26,500 | 61,500 | ||
Year 3 | 13,000 | 48,000 | ||
Year 4 | 4,000 | 39,000 |
Assuming that the desired rate of return is 15%, determine the net present value for the proposal. If required, round to the nearest dollar.
Solution
Geddes Company
Computation of net present value:
Net present value = present value of net cash flows over the useful life of the asset/project – initial investment
Initial investment = $140,000
Since, net cash flows are provided directly in the question, there is no need to separately compute and add depreciation to net income to arrive at net cash flow. The following is the computation of net present value –
Year |
PV of $1 at 15% |
Net Cash Flow |
PV of net cash flow |
0 |
1 |
($140,000) |
($140,000) |
1 |
0.87 |
$77,000 |
$66,990 |
2 |
0.756 |
$61,500 |
$46,494 |
3 |
0.658 |
$48,000 |
$31,584 |
4 |
0.572 |
$39,000 |
$22,308 |
Net Present Value |
$27,376 |
Hence, the net present value of the proposal at 15% rate of return = $27,376
The following data are accumulated by Geddes Company in evaluating the purchase of $140,000 of equipment,...
The following data are accumulated by Geddes Company in evaluating the purchase of $130,000 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $49,000 $81,500 Year 2 24,500 57,000 Year 3 13,000 45,500 Year 4 7,000 39,500 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Assuming that the desired rate of return is 15%, determine...
he following data are accumulated by Geddes Company in evaluating the purchase of $131,700 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $44,000 $74,000 Year 2 27,000 57,000 Year 3 13,000 43,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 0.636 0.572 0.482 5...
The following data are accumulated by Geddes Company in evaluating the purchase of $96,000 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...
The following data are accumulated by Geddes Company in evaluating the purchase of $139,600 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $37,000 $63,000 Year 2 23,000 49,000 Year 3 11,000 37,000 Year 4 (1,000) 25,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...
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 $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...
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...
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 $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...