Build a spreadsheet to find the EAW of each lawn- mower in Problem 8-29. Use the GOAL

Question:

Build a spreadsheet to find the EAW of each lawn- mower in Problem 8-29. Use the GOAL SEEK tool of Excel to find the IRR of the incremental investment.

Data from 8-29

Don Garlits is a landscaper. He is considering the purchase of a new commercial lawn mower, either, the Atlas or the Zippy. The minimum attractive rate of return is 8%, and the table provides all the necessary information for the two machines.

Atlas Zippy $16,900 1,200 Initial cos! Annual operation and $6700 1500 maintenance cost 4000 Annua! benefit 4,500 1000 3

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: