In: Accounting
M11-7 Calculating Net Present Value, Predicting Internal Rate of Return [LO 11-3, 11-4]
Vaughn Company has the following information about a potential
capital investment:
Initial investment | $ | 280,000 |
Annual cash inflow | $ | 74,000 |
Expected life | 6 years | |
Cost of capital | 13% | |
1. Calculate the net present value of this
project. (Future Value of $1, Present Value of $1, Future Value
Annuity of $1, Present Value Annuity of $1.) (Use
appropriate factor(s) from the tables provided. Round the final
answer to nearest whole dollar.)
Calculation of Net present value: | ||||
Statement showing NPV | ||||
Particulars | Time | PVf 13% | Amount | PV |
Cash Outflows | - | 1.00 | -2,80,000.00 | -2,80,000.00 |
PV of Cash outflows = PVCO | -2,80,000.00 | |||
Cash inflows | 1.00 | 0.8850 | 74,000.00 | 65,486.73 |
Cash inflows | 2.00 | 0.7831 | 74,000.00 | 57,952.85 |
Cash inflows | 3.00 | 0.6931 | 74,000.00 | 51,285.71 |
Cash inflows | 4.00 | 0.6133 | 74,000.00 | 45,385.59 |
Cash inflows | 5.00 | 0.5428 | 74,000.00 | 40,164.24 |
Cash inflows | 6.00 | 0.4803 | 74,000.00 | 35,543.57 |
PV of Cash Inflows =PVCI | 2,95,818.68 | |||
NPV= PVCI - PVCO | 15,818.68 | |||
Net present value is $15818.68 | ||||
Calculation of internal rtae of return: | ||||
Statement showing NPV | ||||
Particulars | Time | PVf 20% | Amount | PV |
Cash Outflows | - | 1.00 | -2,80,000.00 | -2,80,000.00 |
PV of Cash outflows = PVCO | -2,80,000.00 | |||
Cash inflows | 1.00 | 0.8333 | 74,000.00 | 61,666.67 |
Cash inflows | 2.00 | 0.6944 | 74,000.00 | 51,388.89 |
Cash inflows | 3.00 | 0.5787 | 74,000.00 | 42,824.07 |
Cash inflows | 4.00 | 0.4823 | 74,000.00 | 35,686.73 |
Cash inflows | 5.00 | 0.4019 | 74,000.00 | 29,738.94 |
Cash inflows | 6.00 | 0.3349 | 74,000.00 | 24,782.45 |
PV of Cash Inflows =PVCI | 2,46,087.75 | |||
NPV= PVCI - PVCO | -33,912.25 | |||
IRR= | Lower rate+ | (Lower rate NPV) | *(Higher rate- lower rate) | |
(lowe rate NPV- Higher rate NPV) | ||||
13%+ | 15818.68 | *(20%-13%) | ||
(15818.68+33912.25) | ||||
13%+ 2.27% | ||||
15.270% | ||||
Internal rate of return is 15.27% |