Present Values

[DavidA]

I am attempting to calculate a present value of a series of cashflows. Beyond year 1, the answer is incorrect when compared to a financial calculator. I believe that I am inputing the info incorrectly. Can anyone explain.

 

[hatman]

Welcome to the board!

There are many people here who coul dprobably explain. Could you please post the formula you are using, and the expected results? Otherwise, it is tought to speculate on what might be happenning.

 

[orbea_adam]

I am attempting to calculate a present value of a series of cashflows. Beyond year 1, the answer is incorrect when compared to a financial calculator. I believe that I am inputing the info incorrectly. Can anyone explain.

When you use multiple years, make sure to include the total number of months in "nper", assuming the interest rate compounds monthly.

 

[hatman]

I am attempting to calculate a present value of a series of cashflows. Beyond year 1, the answer is incorrect when compared to a financial calculator. I believe that I am inputing the info incorrectly. Can anyone explain.

When you use multiple years, make sure to include the total number of months in "nper", assuming the interest rate compounds monthly.

Also worthy of note is that the Rate, if expressed as an Annual Percentage Rate. needs to be divided by the number of periods per year, usually 12, for monthly payments.

 

[orbea_adam]

DavidA,
I don't think you're fully understanding the PV concept and how to use it in Excel. Or maybe I don't fully understand your post.

*How long will cashflow occur?
*Amount of each?
*Discount rate?

Adam