# Present Values

#### DavidA

##### New Member
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.

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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.

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.

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.

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?

Replies
3
Views
446
Replies
6
Views
208
Replies
10
Views
297
Replies
7
Views
483
Replies
4
Views
371

1,207,402
Messages
6,078,265
Members
446,324
Latest member
JKamlet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back