In: Accounting
12) Lockwood Company would like to purchase a production machine for $100,000. It is likely to bring in after-tax cash inflows of $40,000 in year 1, $45,000 in year 2, $50,000 in year 3, and $35,000 in year 4. HINT: USE EXCEL function A) Calculate the Internal Rate of Return (IRR) of the production machine when the discount rate (hurdle rate) is 8%. B) Should the company accept this proposal?
| Year | Cash Flow | 
| 0 | -100000 | 
| 1 | 40000 | 
| 2 | 45000 | 
| 3 | 50000 | 
| 4 | 35000 | 
| Use Excel Function , | 25.41% | 
IRR= 25.41%
Yes Company should acept the proposal because IRR is greater than Cost of Capital

