Table 1: F uture Value Interest F actor (F. V. IF.) ($1 at r% for n periods). F. V .. Table 3: Future Value of an Annuity Interest Factor (FVIFA) ($1 per period at r%. n \ r. 1%. 2%. 3%. 4%. 5%. 6%. 7%. 8%. 9%. 10%. 11%. 12%. 13%. 14%. 15%. 16%. 17%. 1. This tutorial demonstrates how to create the PVIF, FVIF, PVIFA, and FVIFA tables using Excel. I use conditional formatting, custom number formatting, data.

Author: Arazuru Moogujar
Country: Oman
Language: English (Spanish)
Genre: Art
Published (Last): 1 March 2010
Pages: 312
PDF File Size: 17.54 Mb
ePub File Size: 19.7 Mb
ISBN: 894-7-85310-925-3
Downloads: 85137
Price: Free* [*Free Regsitration Required]
Uploader: Mijinn

You will now see the following dialog box:.

FVIFA Calculator – Tool Slick

Conditional formatting changes the look of a cell or range when certain conditions are met. Notice tablee the value in A10 has changed to 0. Start by adding some data in row 7. For the interest rate we want to allow any decimal number between 0 and 0.

To test it, change B6 to, say, 10 and make sure that only A Your worksheet fbifa now look like the one below, except for the shading in row Formatting isn’t just for making your spreadsheet pretty.

We can do this by applying some data validation rules to those cells. We need to add 1 to the number of tablr because we are including column A, which is not a part of the 30 columns specified. Note that this does not change the formula or the result, only what appears in the cell.

AE70 and then use this rule:. We want to create rules that are based on formulas, so choose the last item in the Rule Type list Use a formula to determine which cells to format.

Click here to learn more. Apply a format with a border on the right edge only, and set the font to bold.

This rule checks to see that it is in column A and that the row number is in the visible range. The complication is because we want the table to handle both regular annuities and annuities due. For reference, if you change B7 to an annuity due you should get 1.

Related Posts  ACURA MDX 2009 MANUAL PDF

If you change the value in B1, for example, then the interest rates in the table will change, and the interest factors will be recalculated as well. For the final touch, we want to make sure that a user cannot enter data that is unexpected in B1: The key to creating the tables is to understand that they are all based upon the basic time value of money formulas.

This flexibility is achieved using standard Excel features such as time value of money functionstwo-input data tables, data validation, and conditional formatting. You can see how the rules are created. In B7 we will enter another data validation rule. 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.

FVIFA Calculator

The format mask to do that is 0. For example, we might want to see how the present value changes when both the interest rate and number of periods changes. So we will simply copy the PVIF worksheet. How much do you need to deposit today in order to achieve your goal?

A70 and then create this formatting rule:. So, armed with the appropriate table and fifa way fvifs multiply any calculator or even with pencil and paper you too can easily solve time value of money problems.

Here is a small piece of the Tagle table so that you can be sure that yours is correct:. Exit from the dialog box so that we can start creating new rules. The fourth, and final, rule will underline the last visible row, but only in visible columns. 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. If you change to an annuity due in B7 then, for tble, you should get 1. The PVIF is 0.


Excel does this repeatedly to fill in the table. Ffifa the entire table A It can also add to the functionality. To create the data table we need to select A Not too bad, but the tables that we create here can easily have the exact interest rate that you need.

AE10 and then call up the dialog box above. This fifa the area specifically, F1 and F2 where Excel will substitute the values from the top row and left column to get the numbers to paste into the table. This tells Excel to display the word “Period” regardless of the result of the formula. In the Type edit box, enter “Period” include the quotation marks. As noted, these fable provide a great deal of flexibility. The average is 0.

In fact, it just confuses things. The Table function will display that array in our table area B However, we need to clean this up a bit to make it more functional.

FVIFA Calculator – Calculate Future Value Interest Factor of Annuity

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. Substituting 1 for FV, 3 for N, and 0. Apply a border to the bottom using the Format button.

You can try it yourself: In A7 enter “Type” for the type of annuity. Click OK to apply the formatting rule.