What Is an Annuity Table?

An annuity table is a tool for determining the present value of an annuity or other structured series of payments. Such a tool, used by accountants, actuaries, and other insurance personnel, takes into account how much money has been placed into an annuity and how long it has been there to determine how much money would be due to an annuity buyer or annuitant.

Figuring the present value of any future amount of an annuity may also be performed using a financial calculator or software built for such a purpose.

How an Annuity Table Works

An annuity table provides a factor, based on time, and a discount rate (interest rate) by which an annuity payment can be multiplied to determine its present value. For example, an annuity table could be used to calculate the present value of an annuity that paid $10,000 a year for 15 years if the interest rate is expected to be 3%.

According to the concept of the time value of money, receiving a lump sum payment in the present is worth more than receiving the same sum in the future. As such, having $10,000 today is better than being given $1,000 per year for the next 10 years because the sum could be invested and earn interest over that decade. At the end of the 10-year period, the $10,000 lump sum would be worth more than the sum of the annual payments, even if invested at the same interest rate.

Annuity Table and the Present Value of an Annuity

Present Value of an Annuity Formulas

The formula for the present value of an ordinary annuity, as opposed to an annuity due, is as follows:


$\begin{aligned}&\text{P} =\text{PMT}\times\frac{ 1 – (1 + r) ^ -n}{r}\\&\textbf{where:}\\&\text{P} = \text{Present value of an annuity stream}\\&\text{PMT} =\text{Dollar amount of each annuity payment}\\&r = \text{Interest rate (also known as the discount rate)}\\&n = \text{Number of periods in which payments will be made}\end{aligned}$​P=PMT×r1−(1+r)−n​where:P=Present value of an annuity streamPMT=Dollar amount of each annuity paymentr=Interest rate (also known as the discount rate)​

Assume an individual has an opportunity to receive an annuity that pays $50,000 per year for the next 25 years, with a discount rate of 6%, or a lump sum payment of $650,000. He needs to determine the more rational option. Using the above formula, the present value of this annuity is:


$\begin{aligned}&\text{PVA} = \$50,000 \times \frac{1 – (1 + 0.06) ^ -25}{0.06} = \$639,168\\&\textbf{where:}\\&\text{PVA}=\text{Present value of annuity}\end{aligned}$​PVA=$50,000×0.061−(1+0.06)−25​=$639,168where:​

Given this information, the annuity is worth $10,832 less on a time-adjusted basis, and the individual should choose the lump sum payment over the annuity.

Note, this formula is for an ordinary annuity where payments are made at the end of the period in question. In the above example, each $50,000 payment would occur at the end of the year, each year, for 25 years. With an annuity due, the payments are made at the beginning of the period in question. To find the value of an annuity due, simply multiply the above formula by a factor of (1 + r):


$\begin{aligned}&\text{P} = \text{PMT} \times\left(\frac{1 – (1 + r) ^ -n}{r}\right) \times (1 + r)\end{aligned}$​P=PMT×(r1−(1+r)−n​)×(1+r)​

If the above example of an annuity due, its value would be:


$\begin{aligned}&\text{P}= \$50,000\\&\quad \times\left( \frac{1 – (1 + 0.06) ^ -25}{0.06}\right)\times (1 + 0.06) = \$677,518\end{aligned}$​P=$50,000​

In this case, the individual should choose the annuity due, because it is worth $27,518 more than the lump sum payment.

Present Value of an Annuity Table

Rather than working through the formulas above, you could alternatively use an annuity table. An annuity table simplifies the math by automatically giving you a factor for the second half of the formula above. For example, the present value of an ordinary annuity table would give you one number (referred to as a factor) that is pre-calculated for the (1 – (1 + r) ^ – n) / r) portion of the formula.

The factor is determined by the interest rate (r in the formula) and the number of periods in which payments will be made (n in the formula). In an annuity table, the number of periods is commonly depicted down the left column. The interest rate is commonly depicted across the top row. Simply select the correct interest rate and number of periods to find your factor in the intersecting cell. That factor is then multiplied by the dollar amount of the annuity payment to arrive at the present value of the ordinary annuity.

Below is an example of a present value of an ordinary annuity table:

What Is the Aroon Indicator?

The Aroon indicator is a technical indicator that is used to identify trend changes in the price of an asset, as well as the strength of that trend. In essence, the indicator measures the time between highs and the time between lows over a time period. The idea is that strong uptrends will regularly see new highs, and strong downtrends will regularly see new lows. The indicator signals when this is happening, and when it isn’t.

The indicator consists of the “Aroon up” line, which measures the strength of the uptrend, and the “Aroon down” line, which measures the strength of the downtrend.

The Aroon indicator was developed by Tushar Chande in 1995.

Formulas for the Aroon Indicator


$\begin{aligned} \text{Aroon Up}&= \frac{25-\text{Periods Since 25 period High}}{25} \ast100\\ \text{Aroon Down}&=\frac{25-\text{Periods Since 25 period Low}}{25}\ast100 \end{aligned}$Aroon UpAroon Down​=2525−Periods Since 25 period High​∗100=2525−Periods Since 25 period Low​∗100​

How to Calculate the Aroon Indicator

The Aroon calculation requires the tracking of the high and low prices, typically over 25 periods.

1. Track the highs and lows for the last 25 periods on an asset.
2. Note the number of periods since the last high and low.
3. Plug these numbers into the Up and Down Aroon formulas.

What Does the Aroon Indicator Tell You?

The Aroon Up and the Aroon Down lines fluctuate between zero and 100, with values close to 100 indicating a strong trend and values near zero indicating a weak trend. The lower the Aroon Up, the weaker the uptrend and the stronger the downtrend, and vice versa. The main assumption underlying this indicator is that a stock’s price will close regularly at new highs during an uptrend, and regularly make new lows in a downtrend.

The indicator focuses on the last 25 periods, but is scaled to zero and 100. Therefore, an Aroon Up reading above 50 means the price made a new high within the last 12.5 periods. A reading near 100 means a high was seen very recently. The same concepts apply to the Down Aroon. When it is above 50, a low was witnessed within the 12.5 periods. A Down reading near 100 means a low was seen very recently.

Crossovers can signal entry or exit points. Up crossing above Down can be a signal to buy. Down crossing below Up may be a signal to sell.

When both indicators are below 50 it can signal that the price is consolidating. New highs or lows are not being created. Traders can watch for breakouts as well as the next Aroon crossover to signal which direction price is going.

Example of How to Use the Aroon Indicator

The following chart shows an example of the Aroon indicator and how it can be interpreted.

In the chart above, there is both the Aroon indicator and an oscillator that combines both lines into a single reading of between 100 and -100. The crossover of the Aroon Up and Aroon Down indicated a reversal in the trend. While the index was trending, prior to the reversal, the Aroon Down remained very low, suggesting that the index had a bullish bias. Despite the rally on the far right, the Aroon indicator hasn’t shown a bullish bias yet. This is because the price rebounded so quickly that it hasn’t made a new high in the last 25 periods (at the time of the screenshot), despite the rally.

The Difference Between the Aroon Indicator and the Directional Movement Index (DMI)

The Aroon indicator is similar to the Directional Movement Index (DMI) developed by Welles Wilder. It too uses up and down lines to show the direction of a trend. The main difference is that the Aroon indicator formulas are primarily focused on the amount of time between highs and lows. The DMI measures the price difference between current highs/lows and prior highs/lows. Therefore, the main factor in the DMI is price, and not time.

Limitations of Using the Aroon Indicator

The Aroon indicator may at times signal a good entry or exit, but other times it will provide poor or false signals. The buy or sell signal may occur too late, after a substantial price move has already occurred. This happens because the indicator is looking backwards, and isn’t predictive in nature.

A crossover may look good on the indicator, but that doesn’t mean the price will necessarily make a big move. The indicator isn’t factoring the size of moves, it only cares about the number of days since a high or low. Even if the price is relatively flat, crossovers will occur as eventually a new high or low will be made within the last 25 periods. Traders still need to use price analysis, and potentially other indicators, to make informed trading decisions. Relying solely on one indicator isn’t advised.

What Is Annualization?

To annualize a number means to convert a short-term calculation or rate into an annual rate. Typically, an investment that yields a short-term rate of return is annualized to determine an annual rate of return, which may also include compounding or reinvestment of interest and dividends. It helps to annualize a rate of return to better compare the performance of one security versus another.

Annualization is a similar concept to reporting financial figures on an annual basis.

Understanding Annualization

When a number is annualized, it’s usually for rates of less than one year in duration. If the yield being considered is subject to compounding, annualization will also account for the effects of compounding. Annualizing can be used to determine the financial performance of an asset, security, or company.

When a number is annualized, the short-term performance or result is used to forecast the performance for the next twelve months or one year. Below are a few of the most common examples of when annualizing is utilized.

Company Performance

An annualized return is similar to a run rate, which refers to the financial performance of a company based on current financial information as a predictor of future performance. The run rate functions as an extrapolation of current financial performance and assumes that current conditions will continue.

Loans

The annualized cost of loan products is often expressed as an annual percentage rate (APR). The APR considers every cost associated with the loan, such as interest and origination fees, and converts the total of these costs to an annual rate that is a percentage of the amount borrowed.

Loan rates for short-term borrowings can be annualized as well. Loan products including payday loans and title loans, charge a flat finance fee such as $15 or $20 to borrow a nominal amount for a few weeks to a month. On the surface, the $20 fee for one month doesn’t appear to be exorbitant. However, annualizing the number equates to $240 and could be extremely large relative to the loan amount.

Tax Purposes

Taxpayers annualize by converting a tax period of less than one year into an annual period. The conversion helps wage earners establish an effective tax plan and manage any tax implications.

For example, taxpayers can multiply their monthly income by 12 months to determine their annualized income. Annualizing income can help taxpayers estimate their effective tax rate based on the calculation and can be helpful in budgeting their quarterly taxes.

Example: Investments

Investments are annualized frequently. Let’s say a stock returned 1% in one month in capital gains on a simple (not compounding) basis. The annualized rate of return would be equal to 12% because there are 12 months in one year. In other words, you multiply the shorter-term rate of return by the number of periods that make up one year. A monthly return would be multiplied by 12 months.

However, let’s say an investment returned 1% in one week. To annualize the return, we’d multiply the 1% by the number of weeks in one year or 52 weeks. The annualized return would be 52%.

Quarterly rates of return are often annualized for comparative purposes. A stock or bond might return 5% in Q1. We could annualize the return by multiplying 5% by the number of periods or quarters in a year. The investment would have an annualized return of 20% because there are four quarters in one year or (5% * 4 = 20%).

Special Considerations and Limitations of Annualizing

The annualized rate of return or forecast is not guaranteed and can change due to outside factors and market conditions. Consider an investment that returns 1% in one month; the security would return 12% on an annualized basis. However, the annualized return of a stock cannot be forecasted with a high degree of certainty using the stock’s short-term performance.

There are many factors that could impact a stock’s price throughout the year such as market volatility, the company’s financial performance, and macroeconomic conditions. As a result, fluctuations in the stock price would make the original annualized forecast incorrect. For example, a stock might return 1% in month one and return -3% the following month.