PLEASE USE EXCEL TO CALCULATE THE BELOW PROBLEM, PLEASE SUBMIT ANSWER WITH EXCEL STYLE SPREADSHEET INCLUDING FORMULA

PLEASE ONLY ANSWER QUESTION B which selection should be selected

8-31 One of these four mutually exclusive alterna- tives must be chosen. Each costs $13,000 and has no salvage value. Similar alternatives will repeat indefinitely. Alter- native Life (yrs) Annual Cost 7 B 6 $1000 first year; then increasing $575 per year $100 first year, then increasing $500 per year $2500 $4250 first year; then declining $500 per year 7 D 8 (a) Construct a choice table for interest rates from 0% to 100%. (b) If the MARR is 8%, which alternative should be selected