Question - I have goal of 3 lakhs in next three years with rate of 8% how much should i save per month?

http://www.1728.org/annuity.htm

Years : 3
Rate : 8
Total : 3,00,000

 Annual Amount :   85564.87 /12 = 7100 per month.

FD, RD calculators

http://www.calculator.net/interest-calculator.html


RD:

For example for RD we may need Monthly installment,Duration of invest. (months)*,Type of Compounding,Applicable tax slab

I have attached the sample in (Recurring Deposit Sample.png).

So I have attached the excel sheet for RD Calculator in (Comprehensive-RD-calculator-2.xls). If you find this excel sheet useful. Please send the feedback to pattu@iitm.ac.in

I have downloaded this from http://www.onemint.com/wp-content/uploads/2013/05/Comprehensive-RD-calculator-2.xlsx


---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
FD

The same things holds for FD as well.

http://freefincal.com/fixed-deposit-calculators/


Attached the excel sheet in modified-fd-investment-tenure-years-and-months

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Question: Annuity

http://www.jagoinvestor.com/2008/09/3-most-important-formulas-you-should.html


Vikas is planning his retirement , and planning to invest 5,000 per month in a Mutual fund for 20 yrs where he expects a return of 15% , then take out all the amount after 20 yrs and then put it in a FD for 15 yrs which gives him 9.5% return .




Here , we there are two parts

A. He makes monthly payment for 20 yrs (here we have to apply annuity)

B. then he takes the money out after 20 yrs and then put it in FD for 15 yrs (as this is one time payment , here we will apply compound interest)

A )


n = 240 and i = 1.25% (as the payment are monthly)

A = P * [{(1+i)^n - 1 }/i] * (1+i) (if payment are being made at the start)


  His money after 20 years = [5,000 * (1 + .0125)^240 - 1) / .0125] * ( 1.0125) = 75,80,000 (75 lacs)

Or use this calculator

http://www.investopedia.com/calculator/fvannuitydue.aspx

with the values

 Interest Rate Per Time Period: 1.25 % (15/12 months)
Number of Time Periods:  240 (12 * 20 Years)
Payment Value: 5000 (per month)
 Future Value: 7,579,774.87  (75 Lakhs)
Now he invests this money into a FD for 15 yrs at 9.5% .

B) Final amount = 75,80,000 * (1.095)^15 = 2,95,00,000 (2.95 crores OR 29.5 millions)



So his final corpus will be 2.95 crores .

You can use this calculator also

http://www.investopedia.com/calculator/annuityfv.aspx

Interest Rate Per Time Period:  9.5
Number of Time Periods: 15
Present Value: 7580000
Future Value: 29,572,020.14  (2.95 crores)



 

Inflation Adjusted Expense

How to calculate Inflation adjusted future expense ?

To plan and invest accordingly to the future requirements, one needs to calculate the inflation adjusted future expense compared to present expense.

Suppose your monthly expense is 5000 and the inflation rate is 7%, you want to know what will be the monthly expense after 15 years ? It can be done by using below formula.



Future Amount =Present expense amount * (1+inflation%)^number of years

                        = 5000 * (1+7%)^15 = 13,795


13,795 is the amount you require per month after 15 years instead of present 5,000, with an inflation rate of 7%. If the inflation rate is more, the amount also increased accordingly

http://www.bemoneyaware.com/blog/understanding-inflation/

Monthly Contribution Calculator

http://manish.pucsd.googlepages.com/Monthly_contribution_calculator.xls


http://public.sheet.zoho.com/public/manish.pucsd/monthly-contribution-calculator

Use Geometric Mean in Investment and Not Arthimetic Mean

http://www.financeformulas.net/Geometric_Mean_Return.html

how long will some X Amount Survive

http://www.jagoinvestor.com/2012/09/income-generated-from-lumpsum-amount.html


Amount : 50 Lakhs
ROI : 8 %
monthy Expense : 30K
Inflation = 6%
Remaining Amount Reinvested 

 Total Money Interest Earned Monthly Expense Annual Expense Remaining Money Remaining Money


5000000 400000 30000 360000 40000 5040000

5040000 403200 31800 381600 21600 5061600

5061600 404928 33708 404496 432 5062032

5062032 404962.56 35730.48 428765.76 -23803.2 5038228.8

5038228.8 403058.304 37874.3088 454491.7056 -51433.4016 4986795.398

4986795.398 398943.6319 40146.76733 481761.2079 -82817.57606 4903977.822

4903977.822 392318.2258 42555.57337 510666.8804 -118348.6546 4785629.168

4785629.168 382850.3334 45108.90777 541306.8932 -158456.5598 4627172.608

4627172.608 370173.8086 47815.44224 573785.3068 -203611.4982 4423561.11

4423561.11 353884.8888 50684.36877 608212.4252 -254327.5365 4169233.573

4169233.573 333538.6859 53725.4309 644705.1708 -311166.4849 3858067.088

3858067.088 308645.3671 56948.95675 683387.481 -374742.1139 3483324.974

3483324.974 278665.998 60365.89416 724390.7299 -445724.7319 3037600.242

3037600.242 243008.0194 63987.8478 767854.1737 -524846.1543 2512754.088

2512754.088 201020.3271 67827.11867 813925.4241 -612905.097 1899848.991

1899848.991 151987.9193 71896.74579 862760.9495 -710773.0302 1189075.961

1189075.961 95126.07688 76210.55054 914526.6065 -819400.5296 369675.4314

369675.4314 29574.03451 80783.18357 969398.2029 -939824.1684 -570148.737

Capital Gain Calculator

http://www.bemoneyaware.com/blog/calculators-quiz/capital-gain-calculator/


http://public.sheet.zoho.com/publish/manish.pucsd/temp

Compare Returns for different cases.

http://www.jagoinvestor.com/2009/08/what-is-irr-and-xirr-and-how-to.html

EPF CALCULATOR

http://www.caclubindia.com/forum/epf-rate-in-india-73513.asp
http://www.bemoneyaware.com/blog/epf/

Simple Retirement Calculator

http://www.jagoinvestor.com/calculators/html/Retirement-Calculator.html

SIP Calculator, Future Value Calculator, Life Insurance Calculator

http://investmentyogi.com/investment-calculator.aspx

Retirement Calculator

http://www.onemint.com/wp-content/uploads/2011/06/ret-planner-pattu-v3.xls

Budgeting

http://www.tflguide.com/wp-content/uploads/2011/08/Budget-Good-One.xls
http://www.tflguide.com/wp-content/uploads/2011/08/Personal-Monthly-Budget.xls

SIP Calculator

http://www.moneycontrol.com/mf/sipcalculator.php

Calculation for Mutual Fund, PPF, FD, Comparison of Investments

http://www.youtube.com/watch?v=L9gjZ_Ze9us&feature=plcp