Answer:
Depreciation amount has to be added back to the annual income because it is a non cash expense.
Project 22A
Depreciation = 242,000 / 6 years
= $40,333.33
Annual income = 40,333.33 + 16,890
= $57,223.33
IRR using Excel is:
= 11%
Project 23A
Annual income = 20,710 + 271,500 / 9 years
= $50,876.67
IRR = 12%
Project 24A
Annual income = 15,700 + 283,000 / 7 years
= $56,128.57
IRR = 9%
Note: Look at the formula bar to see how IRR was calculated.