DO IN EXCEL

you own a patent for a new glider. The patent will last 10 years. You expect end of the year profits from the patent to be no less than $200,000 a year. At the end of the 10 years, you will sell the patent for 1$ million dollars. If you were to sell the patent today using annual discount rate of 5% for the cash flows, what is the minimum price you will accept? Show why? use the appropriate function to solve this problem