net present value of investment in Excel

Q59. I am considering an investment of $500 per month for 3 years @ 6% annual interest rate. What is the Present Value of investment?

To do it in Excel, here is the answer:

a) Enter the formula =PV(6%/12,36,500) in an empty cell.

Note: First argument is interest rate - 6% is annual interest rate. Hence it is divided by 12 to get monthly rate.

Note: Second argument is number of periods - (3 years = 36 months).

Note: Third argument is payment per period - ($500).

Above formula returns the Present Value of the investment being considered as shown below.

excel net present value of investment

 

You can find similar Excel Questions and Answer hereunder

1) How can I filter a table to get all records that have less than a particular value in a specific column?

2) Vlookup to return max value from multiple hits in Excel

3) Is there a way I can easily identify the duplicate values in a dataset?

4) Filtering the value field in a pivot table in Excel

5) I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option?

6) How can I ensure that user enters only certain acceptable values in an input cell?

7) Given a raw data Table, how can I find the value of a field for a specific value of another field?

8) How do I find the median salary of employees with the same skillset in my Organization?

9) How can I find the slab in which a given value fits?

10) How can I get the last non-zero value in a row?

11) Is there a way to get a log value of a number using Excel?

12) How can I prevent users from entering duplicate values in a range?

13) How to read a value from a cell in vba in Excel

14) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

15) How can I add and link a Chart Title to a cell value?