## CalculatorsInterest FAQExcel templates

 Basics:  Yield  Net Present Value
 Effective rates:  Savings Plan  Credit
 Loans:  Repayment Plan  Early repayment charge
 Retirement provision:  Pension by lump sum payment  Withdrawal plan

# How long will my money last?

A suitable alternative to purchasing a life annuity insurance from an insurance company is a capital investment with a withdrawal or payout plan. Financial investments with withdrawal plans ensure that the capital always remains in your hands. You remain flexible in respect of withdrawals, and inheritance to children or other people is possible without difficulty.

However, a problem is posed by the fluctuations of the capital market. Even a security-oriented, well-balanced capital investment is subject to certain fluctuations and risks. In addition, most people tend to underestimate their own expectancy of life.

For that reason, I am of the opinion that financial investments with withdrawal plans come into question only for such people whose lifetime basic requirements are already sufficiently covered by other income or sources of supply such as government, the German pension insurance fund and insurance companies.

Provided this is the case, a financial investment with a payout plan is an opportunity to actively shape one’s retirement.

## Basic conditions--> financial investment

 name of the financial investment: date of investment: 1.JanFebMarchAprilMayJuneJulyAugustSeptOctNovDec1990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020 investment amount: expected rate of return: % start of regular payouts: 1.JanFebMarchAprilMayJuneJulyAugustSeptOctNovDec1980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040 amount of monthly withdrawals: or initial consumption of capital(%): according to withdrawal 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 16% 18% 20% 25% 30% 40% 50% 100% calculate for months/years: 12/1 24/2 36/3 48/4 60/5 120/10 180/15 240/20 300/25 360/30 or other time period in months:

## Withdrawal plan--> result

 no. date account balance previous month rate of interest payout extraordinary withdrawal interest consumption of capital new account balance 1. 2008-04-01 150000.00 562.50 -562.50 150562.50 2. 2008-05-01 150562.50 564.61 -564.61 151127.11 3. 2008-06-01 151127.11 566.73 -566.73 151693.84 4. 2008-07-01 151693.84 568.85 -568.85 152262.69 5. 2008-08-01 152262.69 570.99 -570.99 152833.67 6. 2008-09-01 152833.67 573.13 -573.13 153406.80 7. 2008-10-01 153406.80 575.28 -575.28 153982.07 8. 2008-11-01 153982.07 577.43 -577.43 154559.51 9. 2008-12-01 154559.51 579.60 -579.60 155139.11 10. 2009-01-01 155139.11 581.77 -581.77 155720.88 11. 2009-02-01 155720.88 583.95 -583.95 156304.83 12. 2009-03-01 156304.83 586.14 -586.14 156890.97 13. 2009-04-01 156890.97 588.34 611.66 156279.31 14. 2009-05-01 156279.31 586.05 613.95 155665.36 15. 2009-06-01 155665.36 583.75 616.25 155049.11 16. 2009-07-01 155049.11 581.43 618.57 154430.54 17. 2009-08-01 154430.54 579.11 620.89 153809.66 18. 2009-09-01 153809.66 576.79 623.21 153186.44 19. 2009-10-01 153186.44 574.45 625.55 152560.89 20. 2009-11-01 152560.89 572.10 627.90 151932.99 21. 2009-12-01 151932.99 569.75 630.25 151302.74 22. 2010-01-01 151302.74 567.39 632.61 150670.13 23. 2010-02-01 150670.13 565.01 634.99 150035.14 24. 2010-03-01 150035.14 562.63 637.37 149397.77 amounts: 14400.0 0.0 13797.8 602.2
Any warranty for the correctness of the numbers is excluded.

Encyclopedia
 Performance of the system    about IRRQ    Excel template for this computation    Contact form    Disclaimer Mistakes? Help to improve this page.