Please don't use Excel, a financial calculator is better.
You have the opportunity to join a group of investors who are buying one of the islands in Boston Harbor. Each investor must make a total of 20 payments. The first payment is $125,000 and must be paid today. After that, the remaining 19 payments are due at the end of each year and increase by 3% per year, every year.
If the interest rate is 5% and you decide to invest in the island, what is the present value of the amount that you will pay?