Create a spreadsheet to solve Problem 7-24. What would the MV of M1 have to be (at the end of year five) for the firm to select M1?

Data from Problem 7-24:

Refer to Example 6-10. Work this problem on  an after-tax basis when the MARR is 12% per year.  The effective income tax rate is 40%, and MACRS  depreciation is appropriate with a property class of five  years. Recall that the market values of M1 and M2 are  zero at the end of years five and eight, respectively.