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: Akicage Malakinos
Country: Cyprus
Language: English (Spanish)
Genre: Life
Published (Last): 15 January 2013
Pages: 249
PDF File Size: 7.28 Mb
ePub File Size: 13.73 Mb
ISBN: 482-5-18101-981-4
Downloads: 30130
Price: Free* [*Free Regsitration Required]
Uploader: Gozshura

Pfif much do you need to deposit today in order to achieve your goal? AE70 and then use this rule:. For example, we don’t want them to enter a negative interest rate in B1. If you change B6 to 15, then A To set the custom number format, select A10 and then right click and choose Format Cells.

The present value interest factor is based on the foundational financial concept of the time value of money.

Present Value Interest Factor (PVIF)

That will preserve the data, but it will be invisible because the font color is the same as the background color. For the text in A9 we need to specify slightly different text depending on the type of annuity. So, we will apply a custom format to display the text “Period” instead of the result of the formula.


Click the OK button to apply the custom number format. Net present value NPV is a method of determining the current value of all future cash flows generated by a project after For reference, if you change B7 to an annuity due you should get 1.

Present Value of $1 Table

Then you have to interpolate because 3. Select the entire table A To create the data table we need to select A However, we need to clean this up a bit to make it more functional. Formatting isn’t just for making your spreadsheet pretty.

The first rule will create the shading and borders for the top row of our table. Learn how enterprise value and equity value So we will simply copy the PVIF worksheet. For the final touch, we want to make sure that a user cannot pfif data that is unexpected in B1: We will use the following IF statement:.

You can also create a one-input data table by specifying only the row or column input cell, but that wouldn’t suit the purpose here.

Apply a format by clicking the Format button and apply ttable borders, background shading, and a bold font.

Are you a student? Start by adding some data in row 7. Learn what present value and future value are and how to use Microsoft Excel to calculate present value, given the future The results will be placed into an array at the intersection pvof the appropriate row and column.


This tutorial will demonstrate how to create these tables using Excel.

Present Value Interest Factor – PVIF

Our PVIF table will serve as a template for each of the other three tables. The Table function atble display that array in our table area B Your worksheet should now look like the one below, except for the shading in row Time value of money tables are very easy to use because they provide a “factor” that is multiplied by a present value, future value, or annuity payment to find the answer.

The safest Social Security calculators to use when figuring benefits are on the official website.

The format mask to do that is 0. Once we get this working properly, we can simply copy the worksheet and then change the formula that drives the table.

PVIFs are often presented in the form of a table with values for different time periods and interest rate combinations. Then the present value of any future dollar amount can be figured by multiplying any specified amount by the inverse of the PVIF number.