Forum Discussion

Copper Contributor

Jan 08, 2020

Solved

Formula To Calculate Total Paid with Escalation

Need some Excel assistance. I have done some google searching and no luck finding an answer. I am looking for a formula that will tell me how much I have paid over a period of time assuming there...

Formulas and Functions

Twifoo
Jan 09, 2020
MeriHall
You can use the FV function, like this:
=FV(0.03,3,-1000)

MeriHall

Copper Contributor

Jan 09, 2020

Thank you so much! I had seen this formula but the example people were giving was slightly different and only giving the payment in the year selected, not a sum.

Twifoo

Silver Contributor

Jan 09, 2020

You’re very much welcome!