Complete the following problem and place the files in the drop box prior to the due date as indicated on the schedule.

Two mutually exclusive projects are under consideration:

Complete the following problem and place the files in the drop box prior to the due date as indicated on the schedule. Two mutually exclusive projects are under consideration: Project A ($5,000) $2,750 $2,750 $2,750 $2,750 $2,750 Project B ($9,000) $1,000 $3,000 $5,000 $7,000 $9,000 Year 1 2 3 4 Answer the following questions, the MARR = 15%. a. Which project should be selected based if the payback method is used? (complete either by hand and in excel) b. Which project should be selected if Future Worth is used? (complete by hand and in excel) c. Which project should be selected if B/C ratios are used? (complete by hand and in excel) d. Explain why any differences in the results. For hand calculations: Use IPE Approach, include the cash flow diagram for each Communicate your formulas correctly, showing the variables; followed by the data; followed by the value you used. (Example: In separate lines of the solution your equations should read as follows: F(p/f,i%,n)... $40,000(p/f,4%,5)... $40,000(0.8219) O For Excel