i want to know like if a person invests Rs100,000 continuosly for 15 years how much he would get back if compounded annually at 10%?
how do you calculate IRR and future value in excel sheet?
04
Jun
Available Services
-
Upcoming
- What is the formula or procedure to estimate the value of the S&P or Dow in 6 months?
- Spectroscopy Measurements of diffraction angle for 1st and 2nd orders of diffraction for yellow sodium doublet
- Present value for a lease with an annual increase in amount due per month?
- A person is to be paid $2000 for work done over a year.?
- What is the present value of $32,088, received 10 years from now, using an interest rate of 12% compounded?
- Help with Compound Interest Math Problem?!!?
- net present value and internal rate of return?
- The accounting definition of income is:?
- How do you calculate the present value of a perpetuity that pays $1000 per year starting 11 years from now?
- How much money will I receive if I hold a bond all the way up til its maturity date?
- Net present value problem please help?
- What is the average annual increase in home value?
- how do you calculate net present value for continuous payments over many years??
- Help with terminating my C loop?
- What is the present value equasion for momentary calculation of an option?
Visitor Stat
SPARTAN
June 4, 2010 at 1:10 pm
For your specific calculation you can just type in
=100+(10/100*100) which is your Amount invested+(Return Rate/100*Corpus Value) in lets say cell A1.
Then in cell A2 write =A1+(A1/100*100) which is your Previous Years Corpus+(10% of the Corpus value).
For the rest of the values just drag this cell till you reach cell A15.
This is your future value calculation compounded annually for 15 years.
There is an inbuilt function for IRR computation for which you will require a discount rate as well!