please solv (B) and using Excel and show how you do it

six alternatives shoul The owner of a downtown a civil engineering consulting firm to advise him on the economic feasibility of constructing an office building on the site. Betty Samuels, a newly hired civil engineer, has been assigned to make the analysis. She has assembled the following data: parking lot has employed 8-33 Total Alternative Sell parking lot Keep parking lot Build 1-story building400,000 Build 2-story building 555,000 Build 3-story building 750,000 Build 4-story building 875,000 Build 5-story building 1,000,000 Total Net Annual Investment Revenue 0 22,000 60,000 72,000 100,000 105,000 120,000 200,000 Includes the value of the land. The analysis period is to be 15 years. For all alternatives, the property has an estimated resale (salvage) value at the end of 15 years equal to the present total investment. (a) Construct a choice table for interest rates from 0% to 100%. (b) If the MARR is 10%, what recommendation should Betty make