Originally Posted by

**GIS2017** Hi, Here are my expenses:

2017: 1000\$

2018: 1000\$

2019: 1000\$

Yearly Interest rate: 3%

-----------------------

Capitalizing the costs above (= Present value terms = PV)

2017: 1000\$/(1+3%)^1 = ~971

2018: 1000\$/(1+3%)^2 = ~943

2019: 1000\$/(1+3%)^3 = ~915

------------------------------

Expenses in 2017-2019 in PV terms = ~2829

__Average__ expenses in 2017-2019 in PV terms = ~943

--------------------------------------------------

My question: Is the average line (~943) correct?

If any of you are familiar with the PMT function in Excel, Should I use it here instead? if yes, how?

Thank you in advance,