Time Value of Money - Calculations

Calculations

There are several basic equations that represent the equalities listed above. The solutions may be found using (in most cases) the formulas, a financial calculator or a spreadsheet. The formulas are programmed into most financial calculators and several spreadsheet functions (such as PV, FV, RATE, NPER, and PMT).

For any of the equations below, the formula may also be rearranged to determine one of the other unknowns. In the case of the standard annuity formula, however, there is no closed-form algebraic solution for the interest rate (although financial calculators and spreadsheet programs can readily determine solutions through rapid trial and error algorithms).

These equations are frequently combined for particular uses. For example, bonds can be readily priced using these equations. A typical coupon bond is composed of two types of payments: a stream of coupon payments similar to an annuity, and a lump-sum return of capital at the end of the bond's maturity - that is, a future payment. The two formulas can be combined to determine the present value of the bond.

An important note is that the interest rate i is the interest rate for the relevant period. For an annuity that makes one payment per year, i will be the annual interest rate. For an income or payment stream with a different payment schedule, the interest rate must be converted into the relevant periodic interest rate. For example, a monthly rate for a mortgage with monthly payments requires that the interest rate be divided by 12 (see the example below). See compound interest for details on converting between different periodic interest rates.

The rate of return in the calculations can be either the variable solved for, or a predefined variable that measures a discount rate, interest, inflation, rate of return, cost of equity, cost of debt or any number of other analogous concepts. The choice of the appropriate rate is critical to the exercise, and the use of an incorrect discount rate will make the results meaningless.

For calculations involving annuities, you must decide whether the payments are made at the end of each period (known as an ordinary annuity), or at the beginning of each period (known as an annuity due). If you are using a financial calculator or a spreadsheet, you can usually set it for either calculation. The following formulas are for an ordinary annuity. If you want the answer for the Present Value of an annuity due simply multiply the PV of an ordinary annuity by (1 + i).

Read more about this topic:  Time Value Of Money

Famous quotes containing the word calculations:

    What, really, is wanted from a neighborhood? Convenience, certainly, an absence of major aggravation, to be sure. But perhaps most of all, ideally, what is wanted is a comfortable background, a breathing space of intermission between the intensities of private life and the calculations of public life.
    Joseph Epstein (b. 1937)

    The vulgar call good fortune that which really is produced by the calculations of genius.
    Ralph Waldo Emerson (1803–1882)

    He who is conversant with the supernal powers will not worship these inferior deities of the wind, waves, tide, and sunshine. But we would not disparage the importance of such calculations as we have described. They are truths in physics because they are true in ethics.
    Henry David Thoreau (1817–1862)