In: Finance
| Year | Cash Flow | ||||||||
| 0 | $0 | ||||||||
| 1 | ($271,000) | ||||||||
| 2 | ($271,000) | ||||||||
| 3 | $640,000 | ||||||||
| 11.61% | (Using IRR function of excel over the cash flow) | ||||||||
| IRR | 11.61% | ||||||||
| Present Value of Cash Flow=(Cash Flow)/((1+i)^N) | |||||||||
| i=discount rate, N=Year of cash flow | |||||||||
| Working an extra Shift | |||||||||
| Year | Cash Flow | PV at 0% | PV at 5% | PV at 8.11% | PV at 10% | ||||
| 0 | $0 | $0 | $0 | $0 | $0 | ||||
| 1 | ($592,000) | ($592,000) | ($563,810) | ($547,590) | ($538,182) | ||||
| 2 | $640,000 | $640,000 | $580,499 | $547,581 | $528,926 | ||||
| NPV | $48,000 | $16,689 | ($10) | ($9,256) | |||||
| IRR | 8.1081% | (Using IRR function of excel over the cash flow) | |||||||
| Company should work the extra shift if the cost of capital is between 0% and 8.10% | |||||||||
![]() ![]() |
|||||||||