You are to evaluate alternative equipment investments given the information below. You are to compare the presented equipment investments across a range of MARR values Data: Krax Seamer Split-Co Seamer Data Life ( Purchase Price Annual Benefits Benefits Gradient Annual O&M Costs O&M Gradient Salvage Value S 202,000 73,000 S 1,200 S 18,000 S 600 S42,000 S 285,000 S 88,000 S1,300 S 34,000 S 1,100 $48,000 Krax Seamer Split-Co Seamer Loan Down Payment(% of Purchase Price) Loan Period (years) 30% 30% Loan Pa S34,392.1 S37.44193 Calculate the following utilizing Excel: A. Note your analysis must be descriptive as to what you are doing, what type of analysis is involved, what your decision criteria will be B. Your discussion must discuss an evaluation of the data, what the data is telling you and what are the consequences resulting from a range of possible MARRs. Select a MARR and discuss what alternative is selected based upon that MARR. If the MARR that is selected could vary up to +/-5% what are the consequences based upon your decision criteria. C. Conclude your discussion with a recommendation. You are to evaluate alternative equipment investments given the information below. You are to compare the presented equipment investments across a range of MARR values Data: Krax Seamer Split-Co Seamer Data Life ( Purchase Price Annual Benefits Benefits Gradient Annual O&M Costs O&M Gradient Salvage Value S 202,000 73,000 S 1,200 S 18,000 S 600 S42,000 S 285,000 S 88,000 S1,300 S 34,000 S 1,100 $48,000 Krax Seamer Split-Co Seamer Loan Down Payment(% of Purchase Price) Loan Period (years) 30% 30% Loan Pa S34,392.1 S37.44193 Calculate the following utilizing Excel: A. Note your analysis must be descriptive as to what you are doing, what type of analysis is involved, what your decision criteria will be B. Your discussion must discuss an evaluation of the data, what the data is telling you and what are the consequences resulting from a range of possible MARRs. Select a MARR and discuss what alternative is selected based upon that MARR. If the MARR that is selected could vary up to +/-5% what are the consequences based upon your decision criteria. C. Conclude your discussion with a recommendation