PRESENT VALUE TABLE. Present value of $1, that is (where r = interest rate; n = number of periods until payment or receipt.) n r. -. +1. Interest rates (r). PVIF Table – Download as PDF File .pdf) or read online. 1, Present value interest factor of $1 per period at i% for n periods, PVIF(i,n). 2, Period, 1%, 2%, 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, 13%, 14%, 15% .

Author: Nikoramar Vorn
Country: Estonia
Language: English (Spanish)
Genre: Technology
Published (Last): 6 August 2015
Pages: 470
PDF File Size: 17.36 Mb
ePub File Size: 12.43 Mb
ISBN: 382-9-86360-122-9
Downloads: 2572
Price: Free* [*Free Regsitration Required]
Uploader: Mem

Notice that the value in A10 has changed ovif 0. This flexibility is achieved using standard Excel features such as time value of money functionstwo-input data tables, data validation, and conditional formatting.

PVIF Calculator – Present Value Factor Calculator

This allows us to enter a formula once, and then it will automatically populate the table based on values in the left column and top row of the table. So, essentially what happens in the data table is that Excel will plug numbers into F1 and F2 and then recalculate the formula in A So we will simply copy the PVIF worksheet.

Tabld that the underscores add spaces to the number format, and that the right paren at the end is required. In recent years these tables have slowly given way to financial calculators, but they are still widely used by some professors and on some professional exams. Note that if you look at the formula bar you will see that the formula is still there.

Tab,e, we will apply a custom format to display the text “Period” instead of the result of the formula. Only the formatting of the result has been changed.


In B7 we will enter another data validation rule. As noted, these tables provide a great deal of flexibility.

For the second rule we want to apply a border to the right edge of column A, but only those rows that are pvof to be visible in the table. How much do you need to deposit today in order to achieve your goal? Click here to learn more. This pvir to the following dialog box:. Let’s set one more custom number format, this time in A This rule checks to see that it is in column A and that the row number is in the visible range.

Present Value Interest Factor – PVIF

They must be formulas that will evaluate to either True or False. In this section we will see how to apply several different kinds of formatting and data validation rules to make the TVM tables more flexible and functional.

Click B7 and then the Data Tablr button. For the final touch, we want to make sure that a user cannot enter tble that is unexpected in B1: F2, so we can hide those cells by setting the font color to white. Determining the value of a preferred stock is important for your portfolio.

That will preserve the data, but it will be invisible because the font color is the same as the background color. There are several things to consider before deciding whether to take a lump sum payment for your pension or receive monthly payments. The format mask to do that is 0. The present value interest factor is based on the foundational financial concept of the time value of money. This feature is typically used for sensitivity analysis.


This tells Excel to display the word “Period” regardless of the result of the formula. It works by substituting the a value from the top row and left column into the cells specified F1 and F2. To test it, change B6 to, say, 10 and make sure that only A The snippet below shows the formulas that are in the PVIF table from above:.

Please note that the actual numbers in F1 and F2 do not matter at all because Excel is going to replace them to create the table.

Rather than creating a large table with the PV function repeated over and over again, we will use Excel’s two-input data table feature.

This is where you tell Excel that cell F1 is where to plug in the numbers from the top row of the table the interest rates and that F2 is where to plug in the numbers from the left column the period numbers. The key to creating the tables is to understand that they are all based upon the basic time value of money formulas. This will provide the user with a drop-down list from which they can choose the type of annuity.

We want to create vpif that are based on formulas, so choose the last item in the Rule Type list Use a formula to determine which cells to format. But what happens if the interest rate is 3. You will now see the following dialog box:.