Showing posts with label Present Value Formulas. Show all posts
Showing posts with label Present Value Formulas. Show all posts

Tuesday, 22 December 2015

IRR Formula


IRR Formula


IRR can be calculated with the help of following formula. It is important that IRR is an estimated calculation only. IRR tell us about the rate, where NPV will become zero. IRR is return of the project, if such return is greater than expected return, then project is to be selected, otherwise rejected.
RL+ {  NPVL          } x (RH-RL)
         NPVL-NPVH

RL= Lower rate of Return
RH= Higher Rate of Return
NPVL = NPV with Lower rate of Return
NPVH= NPV at higher rate of return

Example
Year
0     100,000
1      30,000
2      30,000
3      35,000
4      15,000

Calculate IRR?
Solution
We assume that IRR falls between 10% & 15%.

Year                  Discount           PV @10%     Discount           PV @ 15%
0     100,000         1                   (100,000)                           (100,000)
1      30,000       (1+10%)-1          27,272        (1+15%)-1        26,086  
2      30,000       (1+10%)-2          24,793       (1+15%)-2        22,684   
3      35,000       (1+10%)-3          26,296       (1+15%)-3         23,013   
4      32,000       (1+10%)-4          21,856        (1+15%)-4        18,296
NPV                                             217                                (9,921)            

RL+ {  NPVL          } x (RH-RL)
         NPVL-NPVH

= 10% + [ 217/(217- (-9921)]x [ 15%-10%)
=10%+ [217/10,138] x [5%]
=10.10%


Monday, 21 December 2015

Equal Annual Return Formula

Equal Annual Return Formula

Equal annual return from a project may be calculated by applying annuity Factor. This concept has been explained with an example

Annual Return =         = Present Cash flow
                            Annuity Factor
  
Example
Project cost = 90,000
Term of project = 5 Years
Rate of Return = 12%
Calculate equal return from project?

Solution

Annuity Factor
= 1-(1.12)-5
        .12
=3.6044

Annual Return

Annual Return =         = Present Cash flow
                        Annuity Factor
  

= 90,000/3.6044
=24,969


Future Annuity Present Value Formula

Future Annuity Present Value Formula

Present value of Future annuity may be calculated by the following formula

C x (Annuity Factor) x Discount Factor

Future Annuity Example
Annuity 50,000 ( 6-8)
Discount Rate = 5%

Solution
In first place we would determine the time line
0
1
2
3
4
5
6
7
8






50,000
50,000
50,000

1.    Calculate the annuity at year 5
= 1-(1.05)-3
        .05
=2.723
= $ 50,000 x 2.7232
=136160

2.    Discount the present value at year zero

0
1
2
3
4
5








136,160





$ 136,160 x (1+.05)-5
=$136,160 x .7835
=106,681

Tip of future annuity

One your discount for term of annuity i.e. 3 Year
Discount further for year Zero i.e. 5 Year
Total Discounting 3+5 =8 Years


Method 2

Annuity Factor 8 year      6.4632
Annuiy Factor 5 Year       4.3294
Annuity factor (6-8)         2.1338

50,000 x 2.1338

=106,690