PLEASE USE EXCEL AND SHOW YOUR FORMULAS THAT YOU USED, THANK YOU.

Chapter 6) Consider the following two mutually exclusive alternatives for rec laiming a deteriorating inner-city neighborhood (one ofthem must be chosen) Notice that the IRR for both alternatives is 27.19%. 1) which alternative should be chosen if MARR is 15% per year? 2) Which alternative should be chosen if MARR is 27.5%. Use incremental analysis method. Use Excel to solve this problem. Draw the cash flow diagram (20 Points) Alternative X -$100,000 $50,000 $51,000 $60,000 -$100,000 EOY 0 EOY 1 EOY 2 $205,760 EOY 3 IRR 27.19% 27.19%