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% | |||||||||