Take the 2-minute tour ×
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It's 100% free, no registration required.

I would like to calculate the net present value of a loan schedule or an equation of value. e.g. "For an investor receives R1 000 after 2 years, R2 000 after 5 years and R4000 after 7 years, how much does he have to invest now at 10% p.a compound?"

I am looking for a faster way than to manually compute: 1000(1.1)^-2 + 2000(1.1)^-5 + 4000(1.1)^-7 = R4120.92

Isn't there a built-in sequence one can execute to come up with the present value at Time 0?

share|improve this question
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.