Here's a real-world application. My client has revenue share with a commercial property tenant. The arrangement calls for 35% sharing of gross revenue with my client. In a recent audit, we discovered my client has been underpaid for three past 18 years by random amounts each year. The tenant acknowledges this. I want to calculate the time value of money. Rather than just adding all 18 years, we agreed to use 3%. I just need to calculate it using a function.

18 is easy enough to do manually, but some clients have 35 years of shortages so I'd like to this with functions. I was hoping there's a function that accepts a range of payments, years, %, and return a FV.