Answer:
Method B should be used
Explanation:
Note: See the attached excel file for the calculation of the present worth (in bold red color) of Methods A and B.
From the attached excel file, we have:
Present worth of Method A = –$150,261.25
Present worth of Method B = –$125,178.34
Since the present worth of Method B of –$125,178.34 is lower than the present worth of Method A of –$150,261.25, it implies that Method B cost is less and more attractive at an interest rate of 12% per year than Method A cost. Therefore, Method B should be used.