please use excel and show formulas :)

5-7. A machine can be purchased today for $1 million. It will generate cash flows of $200,000 at the end of each year for 10 years. However, a $300,000 overhaul will be required at the end of year 5. At a 10% opportunity cost of money, compute the net present value of this investment