Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X
PV: present value
FV: future value
I am earning 300000 per year with a discount rate of 5%.
Formula: PV=FV*(1+r)^-n
What will me present value be after 6 years.
My problem is when im plugging numbers in, it takes a lot of times when plugging all the numbers in.
Is there any way to make some kind of shortcut??
This is how i am doing it right now.
Solved! Go to Solution.
Send please your sheet!
Like so
No, not fv() but pv(5%, 6, -300000)=
Werner Exinger wrote:
No, not fv() but pv(5%, 6, -300000)=
Yes. And with units:
Thanks alot Richard !!