please show me step by step how he got the IRR BUY X & BUY Y I do not need to how he did it in excel

Construct a choice table for interest rates from 0% to 100% for two mutually exclusive alternatives and 8-2 the do-nothing alternative. Year BuyX Buy Y 0$100.0 -$50.0 1-4 31.5 16.5 the answer should be : X-O-77 and Y-77-12.1% Show transcribed image text Expert Answer o Anonymous answered this 137 answers Was this answer helpfu?1 First calculate the irr for the two alternatives. You can use Excel for that or try to do it by useing to different rates out of which one gives a positive NPV and the other gives Negative NPV. then use following formula Kd -Lower Rate + (Lower rate NPV Absolute difference in two NPVs) Difference in Rates am using excel for this year BuyBuy Y 100-50 1.5 16.5 31.5 16.5 31.5 16.5 31.5 16.5 0 2 4 IRR 19.9% | 12.1%