Selasa, 09 Oktober 2012


Effective Interest Rate Calculator

Nominal annual interest rate: %
Number of compounding periods per year: Leave blank if the compounding is continuous

About This Tool

The online Effective Interest Rate Calculator is used to calculate the effective annual interest rate based on the nominal annual interest rate and the number of compounding periods per year.

What is Effective Interest Rate

The effective interest rate is the interest rate on a loan or financial product restated from the nominal interest rate as an interest rate with annual compound interest payable in arrears. It is used to compare the annual interest between loans with different compounding terms(daily, monthly, quarterly, semi-annually, annually, or other). It is also called effective annual interest rate, annual equivalent rate (AER) or simply effective rate.

Formula

The effective interest rate is calculated as if compounded annually. The following is the calculation formula for the effective interest rate:
r = [1 + (i/n)]n - 1
Where:
r = effective interest rate
i = nominal annual interest rate
n = number of compounding periods per year (for example, 12 for monthly compounding)
If the compounding is continuous, the calculation will be:
r = ei - 1
Where:
r = effective interest rate
i = nominal annual interest rate
e = 2.71828183

Effective Interest Rate Table

The effective interest rate table below shows the effective annual rate based on frequency of compounding for the nominal interest rates between 1% and 50%:
Nominal RateSemi-AnnuallyQuarterlyMonthlyDailyContinuous
1%1.002%1.004%1.005%1.005%1.005%
2%2.010%2.015%2.018%2.020%2.020%
3%3.022%3.034%3.042%3.045%3.045%
4%4.040%4.060%4.074%4.081%4.081%
5%5.062%5.095%5.116%5.127%5.127%
6%6.090%6.136%6.168%6.183%6.184%
7%7.122%7.186%7.229%7.250%7.251%
8%8.160%8.243%8.300%8.328%8.329%
9%9.202%9.308%9.381%9.416%9.417%
10%10.250%10.381%10.471%10.516%10.517%
11%11.302%11.462%11.572%11.626%11.628%
12%12.360%12.551%12.683%12.747%12.750%
13%13.422%13.648%13.803%13.880%13.883%
14%14.490%14.752%14.934%15.024%15.027%
15%15.562%15.865%16.075%16.180%16.183%
16%16.640%16.986%17.227%17.347%17.351%
17%17.722%18.115%18.389%18.526%18.530%
18%18.810%19.252%19.562%19.716%19.722%
19%19.903%20.397%20.745%20.919%20.925%
20%21.000%21.551%21.939%22.134%22.140%
21%22.103%22.712%23.144%23.360%23.368%
22%23.210%23.882%24.360%24.599%24.608%
23%24.323%25.061%25.586%25.851%25.860%
24%25.440%26.248%26.824%27.115%27.125%
25%26.563%27.443%28.073%28.392%28.403%
26%27.690%28.647%29.333%29.681%29.693%
27%28.822%29.859%30.605%30.983%30.996%
28%29.960%31.080%31.888%32.299%32.313%
29%31.103%32.309%33.183%33.627%33.643%
30%32.250%33.547%34.489%34.969%34.986%
31%33.403%34.794%35.807%36.325%36.343%
32%34.560%36.049%37.137%37.693%37.713%
33%35.723%37.313%38.478%39.076%39.097%
34%36.890%38.586%39.832%40.473%40.495%
35%38.063%39.868%41.198%41.883%41.907%
36%39.240%41.158%42.576%43.308%43.333%
37%40.423%42.458%43.966%44.746%44.773%
38%41.610%43.766%45.369%46.200%46.228%
39%42.803%45.084%46.785%47.667%47.698%
40%44.000%46.410%48.213%49.150%49.182%
41%45.203%47.746%49.653%50.647%50.682%
42%46.410%49.090%51.107%52.159%52.196%
43%47.623%50.444%52.573%53.687%53.726%
44%48.840%51.807%54.053%55.230%55.271%
45%50.063%53.179%55.545%56.788%56.831%
46%51.290%54.561%57.051%58.362%58.407%
47%52.522%55.952%58.571%59.951%59.999%
48%53.760%57.352%60.103%61.556%61.607%
49%55.003%58.762%61.649%63.178%63.232%
50%56.250%60.181%63.209%64.816%64.872%

Time value of money


Time value of money

From Wikipedia, the free encyclopedia
The time value of money is the value of money figuring in a given amount of interest earned over a given amount of time. The time value of money is the central concept in finance theory.
For example, $100 of today's money invested for one year and earning 5% interest will be worth $105 after one year. Therefore, $100 paid now or $105 paid exactly one year from now both have the same value to the recipient who assumes 5% interest; using time value of money terminology, $100 invested for one year at 5% interest has a future value of $105.[1] This notion dates at least toMartín de Azpilcueta (1491–1586) of the School of Salamanca.
The method also allows the valuation of a likely stream of income in the future, in such a way that the annual incomes are discounted and then added together, thus providing a lump-sum "present value" of the entire income stream.
All of the standard calculations for time value of money derive from the most basic algebraic expression for the present value of a future sum, "discounted" to the present by an amount equal to the time value of money. For example, a sum of FV to be received in one year is discounted (at the rate of interest r) to give a sum of PV at present: PV = FV − r·PV = FV/(1+r).
Some standard calculations based on the time value of money are:
Present value The current worth of a future sum of money or stream of cash flows given a specified rate of return. Future cash flows are discounted at the discount rate, and the higher the discount rate, the lower the present value of the future cash flows. Determining the appropriate discount rate is the key to properly valuing future cash flows, whether they be earnings or obligations.[2]
Present value of an annuity An annuity is a series of equal payments or receipts that occur at evenly spaced intervals. Leases and rental payments are examples. The payments or receipts occur at the end of each period for an ordinary annuity while they occur at the beginning of each period for an annuity due.[3]
Present value of a perpetuity is an infinite and constant stream of identical cash flows.[4]
Future value is the value of an asset or cash at a specified date in the future that is equivalent in value to a specified sum today.[5]
Future value of an annuity (FVA) is the future value of a stream of payments (annuity), assuming the payments are invested at a given rate of interest.

Contents

  [hide

[edit]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).[6]
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, iwill 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).

[edit]Formula

[edit]Present value of a future sum

The present value formula is the core formula for the time value of money; each of the other formulae is derived from this formula. For example, the annuity formula is the sum of a series of present value calculations.
The present value (PV) formula has four variables, each of which can be solved for:
  PV \ = \ \frac{FV}{(1+i)^n}
  1. PV is the value at time=0
  2. FV is the value at time=n
  3. i is the discount rate, or the interest rate at which the amount will be compounded each period
  4. n is the number of periods (not necessarily an integer)
The cumulative present value of future cash flows can be calculated by summing the contributions of FVt, the value of cash flow at time t
  PV \ = \ \sum_{t=0}^{n} \frac{FV_{t}}{(1+i)^t}
Note that this series can be summed for a given value of n, or when n is ∞.[7] This is a very general formula, which leads to several important special cases given below.

[edit]Present value of an annuity for n payment periods

In this case the cash flow values remain the same throughout the n periods. The present value of an annuity (PVA) formula has four variables, each of which can be solved for:
PV(A) \,=\,\frac{A}{i} \cdot \left[ {1-\frac{1}{\left(1+i\right)^n}} \right]
  1. PV(A) is the value of the annuity at time=0
  2. A is the value of the individual payments in each compounding period
  3. i equals the interest rate that would be compounded for each period of time
  4. n is the number of payment periods.
To get the PV of an annuity due, multiply the above equation by (1 + i).

[edit]Present value of a growing annuity

In this case each cash flow grows by a factor of (1+g). Similar to the formula for an annuity, the present value of a growing annuity (PVGA) uses the same variables with the addition of g as the rate of growth of the annuity (A is the annuity payment in the first period). This is a calculation that is rarely provided for on financial calculators.
Where i ≠ g :
PV\,=\,{A \over (i-g)}\left[ 1- \left({1+g \over 1+i}\right)^n \right]
To get the PV of a growing annuity due, multiply the above equation by (1 + i).
Where i = g :
PV\,=\,{A*n \over 1+i}

[edit]Present value of a perpetuity

When n → ∞, the PV of a perpetuity (a perpetual annuity) formula becomes simple division.
PV(P) \ = \ { A \over i }

[edit]Present value of a growing perpetuity

When the perpetual annuity payment grows at a fixed rate (g) the value is theoretically determined according to the following formula. In practice, there are few securities with precise characteristics, and the application of this valuation approach is subject to various qualifications and modifications. Most importantly, it is rare to find a growing perpetual annuity with fixed rates of growth and true perpetual cash flow generation. Despite these qualifications, the general approach may be used in valuations of real estate, equities, and other assets.
  PVGP  \ = \ { A \over (i-g) }
This is the well known Gordon Growth model used for stock valuation.

[edit]Future value of a present sum

The future value (FV) formula is similar and uses the same variables.
  FV   \ = \  PV \cdot (1+i)^n

[edit]Future value of an annuity

The future value of an annuity (FVA) formula has four variables, each of which can be solved for:
FV(A) \,=\,A\cdot\frac{\left(1+i\right)^n-1}{i}
  1. FV(A) is the value of the annuity at time = n
  2. A is the value of the individual payments in each compounding period
  3. i is the interest rate that would be compounded for each period of time
  4. n is the number of payment periods

[edit]Future value of a growing annuity

The future value of a growing annuity (FVA) formula has five variables, each of which can be solved for:
Where i ≠ g :
FV(A) \,=\,A\cdot\frac{\left(1+i\right)^n-\left(1+g\right)^n}{i-g}
Where i = g :
FV(A) \,=\,A\cdot n(1+i)^{n-1}
  1. FV(A) is the value of the annuity at time = n
  2. A is the value of initial payment paid at time 1
  3. i is the interest rate that would be compounded for each period of time
  4. g is the growing rate that would be compounded for each period of time
  5. n is the number of payment periods

[edit]Derivations

[edit]Annuity derivation

The formula for the present value of a regular stream of future payments (an annuity) is derived from a sum of the formula for future value of a single future payment, as below, where C is the payment amount and n the period.
A single payment C at future time m has the following future value at future time n:
FV \ = C(1+i)^{n-m}
Summing over all payments from time 1 to time n, then reversing the order of terms and substituting k = n - m:
FVA \ = \sum_{m=1}^n C(1+i)^{n-m} \ = \sum_{k=0}^{n-1} C(1+i)^k
Note that this is a geometric series, with the initial value being a = C, the multiplicative factor being 1 + i, with n terms. Applying the formula for geometric series, we get
FVA \ = \frac{ C ( 1 - (1+i)^n )}{1 - (1+i)} \ = \frac{ C ( 1 - (1+i)^n )}{-i}
The present value of the annuity (PVA) is obtained by simply dividing by (1+i)^n:
PVA \ = \frac{FVA}{(1+i)^n} = \frac{C}{i} \left( 1 - \frac{1}{(1+i)^n} \right)

Another simple and intuitive way to derive the future value of an annuity is to consider an endowment, whose interest is paid as the annuity, and whose principal remains constant. The principal of this hypothetical endowment can be computed as that whose interest equals the annuity payment amount:
\text{Principal} \times i = C
\text{Principal} = C / i + goal
Note that no money enters or leaves the combined system of endowment principal + accumulated annuity payments, and thus the future value of this system can be computed simply via the future value formula:
FV = PV(1+i)^n
Initially, before any payments, the present value of the system is just the endowment principal (PV = C/i). At the end, the future value is the endowment principal (which is the same) plus the future value of the total annuity payments (FV = C/i + FVA). Plugging this back into the equation:
\frac{C}{i} + FVA = \frac{C}{i} (1+i)^n
FVA = \frac{C}{i} \left[ \left(1+i \right)^n - 1 \right]

[edit]Perpetuity derivation

Without showing the formal derivation here, the perpetuity formula is derived from the annuity formula. Specifically, the term:
 \left({1 - {1 \over { (1+i)^n } }}\right)
can be seen to approach the value of 1 as n grows larger. At infinity, it is equal to 1, leaving  {C \over i}  as the only term remaining.

[edit]Examples

[edit]Example 1: Present value

One hundred euros to be paid 1 year from now, where the expected rate of return is 5% per year, is worth in today's money:
 P \  =  \   F \times (P/F)  \ = F \times \ { 1 \over (1+i)^n }  \ = \ \frac{\ 100}{1.05} \ = \  95.24
So the present value of €100 one year from now at 5% is €95.24.

[edit]Example 2: Present value of an annuity — solving for the payment amount

Consider a 10 year mortgage where the principal amount P is $200,000 and the annual interest rate is 6%.
The number of monthly payments is
 n = 10 {\rm \ years} \times 12 {\rm \ months \ per \ year} = 120 {\rm \ months}
and the monthly interest rate is
 i = { 6 {\rm \% \ per \ year} \over 12 {\rm \ months \ per \ year} } =  0.5 {\rm \% \ per \ month}
The annuity formula for (A/P) calculates the monthly payment:
 A \ = \ P \times \left( A / P  \right) \ = \ P \times {  i (1+i)^n \over (1+i)^n - 1   }
\ = \ \$200,000 \times { 0.005(1.005)^{120}  \over (1.005)^{120} - 1 }
 = \ \$200,000 \times 0.01110205 \ = \ \$2,220.41 {\rm \ per \ month}
This is considering an interest rate compounding monthly. If the interest were only to compound yearly at 6%, the monthly payment would be significantly different.

[edit]Example 3: Solving for the period needed to double money

Consider a deposit of $100 placed at 10% (annual). How many years are needed for the value of the deposit to double to $200?
Using the algrebraic identity that if:
 x \ = \ b^y
then
 y \ = \ {\log (x) \over \log(b)}
The present value formula can be rearranged such that:
 y \ = \ {\log ({FV \over PV}) \over \log (1+i)} \ = \  {\log ({200 \over 100}) \over \log (1.10)} \ =\ 7.27    (years)
This same method can be used to determine the length of time needed to increase a deposit to any particular sum, as long as the interest rate is known. For the period of time needed to double an investment, the Rule of 72 is a useful shortcut that gives a reasonable approximation of the period needed.

[edit]Example 4: What return is needed to double money?

Similarly, the present value formula can be rearranged to determine what rate of return is needed to accumulate a given amount from an investment. For example, $100 is invested today and $200 return is expected in five years; what rate of return (interest rate) does this represent?
The present value formula restated in terms of the interest rate is:
 i \ = \ \left({FV \over PV}\right)^{1 \over n} - 1 \ = \ \left({200 \over 100}\right)^{1 \over 5} - 1 \ = \ 2^{0.20} - 1 \ = \ 0.15 \ = \ 15%
see also Rule of 72

[edit]Example 5: Calculate the value of a regular savings deposit in the future.

To calculate the future value of a stream of savings deposit in the future requires two steps, or, alternatively, combining the two steps into one large formula. First, calculate the present value of a stream of deposits of $1,000 every year for 20 years earning 7% interest:
PVA \,=\,A\cdot\frac{1-\frac{1}{\left(1+i\right)^n}}{i} \ = \ 1000\cdot\frac{1-\frac{1}{\left(1+.07\right)^{20}}}{.07} \ = \ 1000\cdot {1- 0.258 \over .07} \ = \ 1000 * 10.594 \ = \ $10,594
This does not sound like very much, but remember - this is future money discounted back to its value today; it is understandably lower. To calculate the future value (at the end of the twenty-year period):
  FV   \ = \  PV  (1+i)^n \ = \ $10,594 * (1+.07)^{20} \ = \ $10,594 * 3.87 \ = \ $40,995
These steps can be combined into a single formula:
FV \,=\,A\cdot\frac{1-\frac{1}{\left(1+i\right)^n}}{i} \cdot (1+i)^n \,=\,A\cdot\frac{\left(1+i\right)^n-1}{i}

[edit]Example 6: Price/earnings (P/E) ratio

It is often mentioned that perpetuities, or securities with an indefinitely long maturity, are rare or unrealistic, and particularly those with a growing payment. In fact, many types of assets have characteristics that are similar to perpetuities. Examples might include income-oriented real estate, preferred shares, and even most forms of publicly-traded stocks. Frequently, the terminology may be slightly different, but are based on the fundamentals of time value of money calculations. The application of this methodology is subject to various qualifications or modifications, such as the Gordon growth model.
For example, stocks are commonly noted as trading at a certain P/E ratio. The P/E ratio is easily recognized as a variation on the perpetuity or growing perpetuity formulae - save that the P/E ratio is usually cited as the inverse of the "rate" in the perpetuity formula.
If we substitute for the time being: the price of the stock for the present value; the earnings per share of the stock for the cash annuity; and, the discount rate of the stock for the interest rate, we can see that:
  {P \over E}  \ = \ {1 \over i} \ = \ {PV \over A }
And in fact, the P/E ratio is analogous to the inverse of the interest rate (or discount rate).
 { 1 \over P/E } \ = \ i
Of course, stocks may have increasing earnings. The formulation above does not allow for growth in earnings, but to incorporate growth, the formula can be restated as follows:
 { P \over E } \ = \ {1 \over (i-g)}
If we wish to determine the implied rate of growth (if we are given the discount rate), we may solve for g:
 g \ = \ i - {E \over P}

[edit]Continuous compounding

Rates are sometimes converted into the continuous compound interest rate equivalent because the continuous equivalent is more convenient (for example, more easily differentiated). Each of the formulæ above may be restated in their continuous equivalents. For example, the present value at time 0 of a future payment at time t can be restated in the following way, where e is the base of thenatural logarithm and r is the continuously compounded rate:
 \text{PV}  = \text{FV}\cdot e^{-rt}
This can be generalized to discount rates that vary over time: instead of a constant discount rate r, one uses a function of time r(t). In that case the discount factor, and thus the present value, of a cash flow at time T is given by the integral of the continuously compounded rate r(t):
 \text{PV}  = \text{FV}\cdot \exp\left(-\int_0^T r(t)\,dt\right)
Indeed, a key reason for using continuous compounding is to simplify the analysis of varying discount rates and to allow one to use the tools of calculus. Further, for interest accrued and capitalized overnight (hence compounded daily), continuous compounding is a close approximation for the actual daily compounding. More sophisticated analysis includes the use of differential equations, as detailed below.

[edit]Examples

Using continuous compounding yields the following formulas for various instruments:
Annuity
 \ PV \ = \ {A(1-e^{-rt}) \over e^r -1}
Perpetuity
 \ PV  \ = \  {A \over e^r - 1}
Growing annuity
 \ PV  \ = \  {A(1-e^{-(r-g)t}) \over e^{(r-g)} - 1}
Growing perpetuity
 \ PV  \ = \  {A \over e^{(r-g)} - 1}
Annuity with continuous payments
 \ PV  \ = \  { 1 - e^{(-rt)} \over r }

[edit]Differential equations

Ordinary and partial differential equations (ODEs and PDEs) – equations involving derivatives and one (respectively, multiple) variables are ubiquitous in more advanced treatments of financial mathematics. While time value of money can be understood without using the framework of differential equations, the added sophistication sheds additional light on time value, and provides a simple introduction before considering more complicated and less familiar situations. This exposition follows (Carr & Flesaker 2006, pp. 6–7).
The fundamental change that the differential equation perspective brings is that, rather than computing a number (the present valuenow), one computes a function (the present value now or at any point in future). This function may then be analyzed – how does its value change over time – or compared with other functions.
Formally, the statement that "value decreases over time" is given by defining the linear differential operator \mathcal{L} as:
\mathcal{L} := -\partial_t + r(t).
This states that values decreases (−) over time (∂t) at the discount rate (r(t)). Applied to a function it yields:
\mathcal{L} f = -\partial_t f(t) + r(t) f(t).
For an instrument whose payment stream is described by f(t), the value V(t) satisfies the inhomogeneous first-order ODE \mathcal{L}V = f("inhomogeneous" is because one has f rather than 0, and "first-order" is because one has first derivatives but no higher derivatives) – this encodes the fact that when any cash flow occurs, the value of the instrument changes by the value of the cash flow (if you receive a $10 coupon, the remaining value decreases by exactly $10).
The standard technique tool in the analysis of ODEs is the use of Green's functions, from which other solutions can be built. In terms of time value of money, the Green's function (for the time value ODE) is the value of a bond paying $1 at a single point in time u – the value of any other stream of cash flows can then be obtained by taking combinations of this basic cash flow. In mathematical terms, this instantaneous cash flow is modeled as a delta function \delta_u(t) := \delta(t-u).
The Green's function for the value at time t of a $1 cash flow at time u is
b(t;u) := H(u-t)\cdot \exp\left(-\int_t^u r(v)\,dv\right)
where H is the Heaviside step function – the notation ";u" is to emphasize that u is a parameter (fixed in any instance – the time when the cash flow will occur), while t is a variable (time). In other words, future cash flows are exponentially discounted (exp) by the sum (integral, \textstyle{\int}) of the future discount rates (\textstyle{\int_t^u} for future, r(v) for discount rates), while past cash flows are worth 0 (H(u-t) = 1 \text{ if } t < u, 0 \text{ if } t > u), because they have already occurred. Note that the value at the moment of a cash flow is not well-defined – there is a discontinuity at that point, and one can use a convention (assume cash flows have already occurred, or not already occurred), or simply not define the value at that point.
In case the discount rate is constant, r(v) \equiv r, this simplifies to
b(t;u) = H(u-t)\cdot e^{-(u-t)r} = \begin{cases} e^{-(u-t) r} & t < u\\ 0 & t > u,\end{cases}
where (u-t) is "time remaining until cash flow".
Thus for a stream of cash flows f(u) ending by time T (which can be set to T = +\infty for no time horizon) the value at time t, V(t;T) is given by combining the values of these individual cash flows:
V(t;T) = \int_t^T f(u) b(t;u)\,du.
This formalizes time value of money to future values of cash flows with varying discount rates, and is the basis of many formulas in financial mathematics, such as the Black–Scholes formula with varying interest rates.

[edit]See also

[edit]References

[edit]External links

detikNews - Berita

Powered By Blogger

kunjungan google

Google bot last visit powered by Bots Visit

JADWAL SHOLAT

iklan

Promo & kejutan di LAZADA