Retirement Planning and Net Worth Calculation Tool

When planning your retirement, you first need to set your targets, and then to plan your savings and investments accordingly.

This article suggest two Excel spreadsheets that would assist you in both tasks.

Disclaimer: The suggested tools didn't pass examination by personal finance experts. It would be worthwhile to show results to a retirement specialist, for these reasons:

• You may not properly estimate your retirement needs
• Your current saving and investment strategies may need tuning
• Your calculation may simply get wrong, and expert in the field would notice this.

Retirement Targets

There are at least these targets to consider:

• Life planning
  • Q-1 When to retire?
  • Q-2 How long me and my spouse planning to live upon retirement?
  • Q-3 What income do we need?
• Estate planning
  • Q-4 What will we leave as inheritance?

In recent article - Budget Planning Tool - I suggested a budget planning tool that, besides immediate purpose of budget planning, tracking, and cash flow forecast, also helps with question Q-3 - What retirement income do we need? - by allowing long-term expense forecast.

Retirement Planning using Life Planner Excel

After considering your targets, you may use this free Life Planner Excel to plan the retirement and to balance your plan versus the retirement targets. Feel free to customize this Excel for your needs.

Life Planner Excel allows to enter your retirement targets and savings plan, and to receive retirement income forecast.

Setup guidelines

All fields with yellow background represent your retirement targets and savings details, and should be set-up with relevant values.

Fields with green background should be reviewed and optionally set-up, since they represent your local regulations or expected interest rates which you may need to adjust.

You need to set $I3 cell to the previous year (currently, set to 2008).

The spreadsheet is suitable to double currency calculations (for countries which use both foreign currency, like US$, and local currency). If you just use one currency, set $ to Local values (row 8) to 1.

Section 0 - General Details

Adjust inflation rates and income tax forecast according to your country.

Tax for net calculation is used to estimate net worth of your pension funds, and represents generic withdrawal penalty. You may adjust it separately for each saving.

Section 1 - Assets

This section contains planning templates for the following asset types:

• Simple saving programs
• A couple of complex saving programs (called Educational Fund and Managerial Insurance) that you may use as examples for further customization
• Pension funds
• Real estate (your home, rental estate) - covers both asset and liability aspects

This article cannot go into details - I plan to explain more in subsequent articles. I believe that many of you will be able to proceed independently.

You absolutely need to tune this section to your assets. If you have multiple assets belonging to one scheme - don't hesitate to duplicate the related template.

Section 2 - Liabilities

Covers your debts and their repayment plan.

Currently, contains one template for simple debt repayment scheme - should be enough for most cases.

Section 3 - Net Value

This section summarizes your total net value (excluding your personal belongings) and its evolution with time according to your life plan.

Net value should stay positive by end of your plan, and should correspond to what you intend to leave as inheritance (see question Q-4).

Section 4 - Monthly Income

This section represents your retirement income plan, year by year.

This is the cornerstone of the retirement planning, and you definitely need to come to terms with this plan.

Conclusion

I believe that we need to start retirement planning as soon as our careers mature. Hope that this article will move you to start this process.

There are many retirement planning resources on the Web, here several ones to start with:

How much do you need to save for retirement?(by getrichslowly)
Retirement Planning - Introduction (by Forbes)
360 degrees of financial literacy (by The American Institute of Certified Public Accountants)

 
For Golden Rules Organizer users, attached zipped listings.

Comments

[Jordan AJF8]

Hope is bad for the happy man, and good for the unhappy. right??

[illureprerusa]

Drugs Mushrooms Test http://www.dcsdampers.com/ - ativan no prescription medication While some prescribers really like Ativan, most will prescribe it with care because it does cause drowsiness as well as cognitive impairment. http://www.dcsdampers.com/ - generic lorazepam

[Buy Propecia]

esoyfguxesmnetmoceqb, Generic Propecia, mQUsMnK, [url=http://www.unitedstatesdiscounts.com/]Buy propecia[/url], mUnTfmx, http://www.unitedstatesdiscounts.com/ Propecia, KwFtXLg.

[Buy Propecia]

esoyfguxesmnetmoceqb, Generic Propecia, mQUsMnK, [url=http://www.unitedstatesdiscounts.com/]Buy propecia[/url], mUnTfmx, http://www.unitedstatesdiscounts.com/ Propecia, KwFtXLg.

[Retirement income]

Retirement income fund is useful to save money during a person’s income-earning days to provide for regular periodical payments during retirement days. Its is also paid as long as the recipient is alive.

[agoxfoort]

Accredited Schools Of Holistic Medicine http://www.pinemeadowsretreat.com/ - generic phentermine An appropriate medical authority has certified this drug to be used as a weight reduction measure.

[ennqqcef]

m6mHqot, buy meridia, h6uCxen, meridia diet pills, http://thewisconsinbadgers.com/forum/index.php?topic=38533.0 discount meridia, y7gFjud, diet pill meridia, meridia no rx, f8jXzus, meridia online coupons, y8wSywu

[linux web hosting]

zktnfhpmefosvmfwpmvujpo, Treatment for panic anxiety disorder, cvdYQTK, [url=http://www.antianxietymedicationstreatment.com/]Anxiety Treatment[/url], RSwmPgO, http://www.antianxietymedicationstreatment.com/ First line treatment anxiety disorders, IxMnUsi, Great virtual horse games, GYMFPXv, [url=http://horsegameszone.com/]horse games[/url], lhZdjxb, http://horsegameszone.com/ Online horse racing games, CvRtvhw, Porn clips, IhtRhWv, [url=http://porn-info.org/]Disney porn[/url], kqWcCfN, http://porn-info.org/ Free porn video, LXRDoUF, Quit smoking cold turkey, rLNQFVq, [url=http://quitsmokingnowonline.com/]You can quit smoking[/url], EgYPhNM, http://quitsmokingnowonline.com/ What happens to your body when you quit smoking, GOVGfMP, How to sell loose diamonds, beznCZO, [url=http://www.getgoldcash.com/sell-diamonds.html]Sell Diamonds[/url], lXyicIQ, http://www.getgoldcash.com/sell-diamonds.html Buy sell diamonds, xyrdnkp, cheap linux hosting, BddtXZM, [url=http://www.nffwz.com/linux-hosting/]linux web hosting[/url], KSXOIVz, http://www.nffwz.com/linux-hosting/ linux web hosting, lbWZNxQ.

[linux web hosting]

zktnfhpmefosvmfwpmvujpo, Treatment for panic anxiety disorder, cvdYQTK, [url=http://www.antianxietymedicationstreatment.com/]Anxiety Treatment[/url], RSwmPgO, http://www.antianxietymedicationstreatment.com/ First line treatment anxiety disorders, IxMnUsi, Great virtual horse games, GYMFPXv, [url=http://horsegameszone.com/]horse games[/url], lhZdjxb, http://horsegameszone.com/ Online horse racing games, CvRtvhw, Porn clips, IhtRhWv, [url=http://porn-info.org/]Disney porn[/url], kqWcCfN, http://porn-info.org/ Free porn video, LXRDoUF, Quit smoking cold turkey, rLNQFVq, [url=http://quitsmokingnowonline.com/]You can quit smoking[/url], EgYPhNM, http://quitsmokingnowonline.com/ What happens to your body when you quit smoking, GOVGfMP, How to sell loose diamonds, beznCZO, [url=http://www.getgoldcash.com/sell-diamonds.html]Sell Diamonds[/url], lXyicIQ, http://www.getgoldcash.com/sell-diamonds.html Buy sell diamonds, xyrdnkp, cheap linux hosting, BddtXZM, [url=http://www.nffwz.com/linux-hosting/]linux web hosting[/url], KSXOIVz, http://www.nffwz.com/linux-hosting/ linux web hosting, lbWZNxQ.

[dyeoqklg]

xanax or valium onax xanax 2mg http://www.wnet.co.il/forum/showthread.php?t=275010 xanax blue tablet xanax and valium mixed

[smkfajyc]

acomplia diet drug uk acomplia usos http://phpdirector.co.uk/community/showthread.php?tid=10889 acomplia meridia reductil acomplia la dieta

[ypatmiso]

zolpidem from canada taking zolpidem during the day http://www.wnet.co.il/forum/showthread.php?t=28463 zolpidem 12.5 er zolpidem 78 e

[Best review electronic cigarettes]

ivxzshpmefosvmfwpmvujpo, Buy electronic cigarettes in pittsburgh, hVEqxGy, [url=http://myecigsreviews.com/]Atomizers for electronic cigarettes[/url], jZOwnZY, http://myecigsreviews.com/ Electronic cigarettes safety, qneddIw.

[Carisprodol]

fhmdohpmefosvmfwpmvujpo, organa slim review, UwwKOlf, [url=http://healthydiettrends.com/organa-slim-review]Organa Slim[/url], sfCsWIi, http://healthydiettrends.com/organa-slim-review Organa Slim, ChSOjyk, Carisoprodol high, MBIZpjt, [url=http://crossoverlouisville.com/blog/]Buy carisoprodol online[/url], tvUnVex, http://crossoverlouisville.com/blog/ Cheap carisoprodol online, mgCyVPm, Order lorazepam, xTugoAA, [url=http://www.btxformfactor.com/ativan.html]Buy ativan[/url], ozKqeyn, http://www.btxformfactor.com/ativan.html Ativan no rx, HmFNyyo, Cellucor m5 extreme, HWAeUug, [url=http://healthymensproducts.com/cellucor-no3-chome-review]cellucor[/url], vTKHOGt, http://healthymensproducts.com/cellucor-no3-chome-review Cellucor.com, jBGCrqM, Ativan 1 mg, vXmHtss, [url=http://www.la-cadenatricolor.com/ativan.html]Ativan purchase[/url], AjfDWsG, http://www.la-cadenatricolor.com/ativan.html Ativan effects, MIrXeIi, Jes extender results, tUNMGNh, [url=http://getjesextender.net/]Jes extender spare parts[/url], vFuUpmk, http://getjesextender.net/ Jes Extender, HYjZnYj.

[Online pharmacies no prescription]

glshshpmefosvmfwpmvujpo, Generic Viagra, ZxOushf, [url=http://www.adamandcheri.com/]Viagra[/url], zrDvseN, http://www.adamandcheri.com/ Viagra, miKWFyK, Female viagra tablets cheap, XvxtXjv, [url=http://www.iloveverdi.com/2009/09/view-on-photography.html]Viagra and alcol[/url], jGEfTOK, http://www.iloveverdi.com/2009/09/view-on-photography.html Viagra, tysaYEO, VigRX, SrRVKkh, [url=http://arabidopsis2007.com/]VigRX[/url], IXseJQb, http://arabidopsis2007.com/ Amanuensis vigrx comments e-mail name comment [b][/b] - [i][/i] - [u][/u]- [quote][/qu, xmJJPxH, weight loss tips, OOjboOs, [url=http://healthydiettrends.com/acaimax-review]fast weight loss[/url], NGuBYLK, http://healthydiettrends.com/acaimax-review fast weight loss, gtwfgUG, Order cialis online no rx, VkmoZhW, [url=http://www.45secondprospecting.com/cialis.html]Cialis online no prescription vancouver[/url], UJlwLLM, http://www.45secondprospecting.com/cialis.html Buy cialis online without a prescription, qFhWmvA, Online pharmacies in usa, HNATWjR, [url=http://www.crossoverlouisville.com/]Online canadian pharmacies[/url], yfSdcFf, http://www.crossoverlouisville.com/ Licensed online pharmacy, OpPPUDV.

[Carisprodol]

fhmdohpmefosvmfwpmvujpo, organa slim review, UwwKOlf, [url=http://healthydiettrends.com/organa-slim-review]Organa Slim[/url], sfCsWIi, http://healthydiettrends.com/organa-slim-review Organa Slim, ChSOjyk, Carisoprodol high, MBIZpjt, [url=http://crossoverlouisville.com/blog/]Buy carisoprodol online[/url], tvUnVex, http://crossoverlouisville.com/blog/ Cheap carisoprodol online, mgCyVPm, Order lorazepam, xTugoAA, [url=http://www.btxformfactor.com/ativan.html]Buy ativan[/url], ozKqeyn, http://www.btxformfactor.com/ativan.html Ativan no rx, HmFNyyo, Cellucor m5 extreme, HWAeUug, [url=http://healthymensproducts.com/cellucor-no3-chome-review]cellucor[/url], vTKHOGt, http://healthymensproducts.com/cellucor-no3-chome-review Cellucor.com, jBGCrqM, Ativan 1 mg, vXmHtss, [url=http://www.la-cadenatricolor.com/ativan.html]Ativan purchase[/url], AjfDWsG, http://www.la-cadenatricolor.com/ativan.html Ativan effects, MIrXeIi, Jes extender results, tUNMGNh, [url=http://getjesextender.net/]Jes extender spare parts[/url], vFuUpmk, http://getjesextender.net/ Jes Extender, HYjZnYj.

[Online pharmacies no prescription]

glshshpmefosvmfwpmvujpo, Generic Viagra, ZxOushf, [url=http://www.adamandcheri.com/]Viagra[/url], zrDvseN, http://www.adamandcheri.com/ Viagra, miKWFyK, Female viagra tablets cheap, XvxtXjv, [url=http://www.iloveverdi.com/2009/09/view-on-photography.html]Viagra and alcol[/url], jGEfTOK, http://www.iloveverdi.com/2009/09/view-on-photography.html Viagra, tysaYEO, VigRX, SrRVKkh, [url=http://arabidopsis2007.com/]VigRX[/url], IXseJQb, http://arabidopsis2007.com/ Amanuensis vigrx comments e-mail name comment [b][/b] - [i][/i] - [u][/u]- [quote][/qu, xmJJPxH, weight loss tips, OOjboOs, [url=http://healthydiettrends.com/acaimax-review]fast weight loss[/url], NGuBYLK, http://healthydiettrends.com/acaimax-review fast weight loss, gtwfgUG, Order cialis online no rx, VkmoZhW, [url=http://www.45secondprospecting.com/cialis.html]Cialis online no prescription vancouver[/url], UJlwLLM, http://www.45secondprospecting.com/cialis.html Buy cialis online without a prescription, qFhWmvA, Online pharmacies in usa, HNATWjR, [url=http://www.crossoverlouisville.com/]Online canadian pharmacies[/url], yfSdcFf, http://www.crossoverlouisville.com/ Licensed online pharmacy, OpPPUDV.

[Best quotes term life insurance us]

fxxmshpmefosvmfwpmvujpo, Life Insurance Quotes, NJAhuup, [url=http://magmalifeinsurance.com/]London best quotes life insurance[/url], EfilXff, http://magmalifeinsurance.com/ Comparisons for term life insurance quotes, KtQFcQx.

[Best quotes term life insurance us]

fxxmshpmefosvmfwpmvujpo, Life Insurance Quotes, NJAhuup, [url=http://magmalifeinsurance.com/]London best quotes life insurance[/url], EfilXff, http://magmalifeinsurance.com/ Comparisons for term life insurance quotes, KtQFcQx.

[Meri chaheti hindi pdf velvet deer antler plus]

wmfbmhpmefosvmfwpmvujpo, Vigrx plus, CoFVczc, [url=http://vigrxonline.net/]Blowhard vigrx comments e-mail name comment [b][/b] - [i][/i] - [u][/u]- [quote][/quot[/url], lPAxLhS, http://vigrxonline.net/ Bland vigrx comments e-mail name comment [b][/b] - [i][/i] - [u][/u]- [quote][/quote], WSmriMP, Smoketip consumer reviews, JQtQgFN, [url=http://myecigsreviews.com/category/smoketip]Smoketip usb pass through reviews[/url], psxaqxv, http://myecigsreviews.com/category/smoketip Smoketip consumer reviews, NpbnguV, Ambien online, tkanSvQ, [url=http://www.btxformfactor.com/ambien.html]Where to buy ambien no prescription[/url], nTENJdy, http://www.btxformfactor.com/ambien.html Buy cheap ambien no prescription, FngzjeP, Ge home security systems, fxjNaUS, [url=http://homesecurity-info.org/]Web based wireless camera home security[/url], zRbHyIl, http://homesecurity-info.org/ Apx home security systems, mpPetEV, Deer Antler Plus, GSoBptB, [url=http://deerantlerplus4u.net/]Deer Antler Plus[/url], LNqtFUl, http://deerantlerplus4u.net/ Deer Antler Plus, kWJABYF, Menozac reviews, PiBvcTP, [url=http://menozac2k.net/]Menozac[/url], KCnbEko, http://menozac2k.net/ Menozac, iDtwjDU.

[Meri chaheti hindi pdf velvet deer antler plus]

wmfbmhpmefosvmfwpmvujpo, Vigrx plus, CoFVczc, [url=http://vigrxonline.net/]Blowhard vigrx comments e-mail name comment [b][/b] - [i][/i] - [u][/u]- [quote][/quot[/url], lPAxLhS, http://vigrxonline.net/ Bland vigrx comments e-mail name comment [b][/b] - [i][/i] - [u][/u]- [quote][/quote], WSmriMP, Smoketip consumer reviews, JQtQgFN, [url=http://myecigsreviews.com/category/smoketip]Smoketip usb pass through reviews[/url], psxaqxv, http://myecigsreviews.com/category/smoketip Smoketip consumer reviews, NpbnguV, Ambien online, tkanSvQ, [url=http://www.btxformfactor.com/ambien.html]Where to buy ambien no prescription[/url], nTENJdy, http://www.btxformfactor.com/ambien.html Buy cheap ambien no prescription, FngzjeP, Ge home security systems, fxjNaUS, [url=http://homesecurity-info.org/]Web based wireless camera home security[/url], zRbHyIl, http://homesecurity-info.org/ Apx home security systems, mpPetEV, Deer Antler Plus, GSoBptB, [url=http://deerantlerplus4u.net/]Deer Antler Plus[/url], LNqtFUl, http://deerantlerplus4u.net/ Deer Antler Plus, kWJABYF, Menozac reviews, PiBvcTP, [url=http://menozac2k.net/]Menozac[/url], KCnbEko, http://menozac2k.net/ Menozac, iDtwjDU.

[Canadian car insurance online quotes]

tfsywhpmefosvmfwpmvujpo, seo spyglass discount, PFfgvtA, [url=http://seosoftwaresnow.com/]seo spyglass discount[/url], bvQVdDR, http://seosoftwaresnow.com/ seo spyglass review, VccUyff, Free online car insurance quotes uk, dzRxchQ, [url=http://carinsurancequotesquestions.net/]Car insurance free online quotes[/url], nMPiJZl, http://carinsurancequotesquestions.net/ Free best car insurance quotes, WwVLTnx, Eazol, trLfasl, [url=http://eazol4u.net/]Eazol ingredients[/url], HhIYUNf, http://eazol4u.net/ Eazol ingredients, TFPRfND, Britney spears nude, IsMmDer, [url=http://britneyspears-info.org/]Latest news on britney spears[/url], FgbLrkf, http://britneyspears-info.org/ Dress up britney spears, EDzUwdS, Scripture and personal finance, ulSYEnX, [url=http://personalfinance1.org/]Kiplingers personal finance[/url], PJJCiWu, http://personalfinance1.org/ Finance loan loan personal secured willow, iCkIJrr, seo power suite, qgBIoIO, [url=http://seosoftwarenow.com/]seo powersuite[/url], GtGvWpN, http://seosoftwarenow.com/ link assistant, zhTyTYd.

[Free viagra]

rthhchpmefosvmfwpmvujpo, Viagra online order, sNducaD, [url=http://www.brooksdesignassociates.com/]Buy cheap viagra online no prescription[/url], LaXtubF, http://www.brooksdesignassociates.com/ Viagra online no prescription, SpaWKRd.

[Free viagra]

rthhchpmefosvmfwpmvujpo, Viagra online order, sNducaD, [url=http://www.brooksdesignassociates.com/]Buy cheap viagra online no prescription[/url], LaXtubF, http://www.brooksdesignassociates.com/ Viagra online no prescription, SpaWKRd.

[California online insurance quotes car]

fjcjzhpmefosvmfwpmvujpo, Churchill insurance quotes online car, EZpGRki, [url=http://phylliszullodesigns.com/]Car Insurance Quotes[/url], VYcXbDa, http://phylliszullodesigns.com/ Car insurance rate quotes, ZluFAmk, Revitol, OyTnXma, [url=http://discountrevitol.net/]Revitol stretch mark cream[/url], BvzGAxS, http://discountrevitol.net/ Where can revitol hair removal cream be used, vfzVXGp, The lord s prayer music and lyrics, BrlDRvx, [url=http://musiclyricsarticles.net/]Music lyrics this is our last dance[/url], XXrEcWX, http://musiclyricsarticles.net/ Country music free lyrics, eeXSffW, Dodge, BTKkUXl, [url=http://dodge2000.info/]Dodge journey battery location[/url], YcPurna, http://dodge2000.info/ 2005 dodge cummins serpentine belt, SIdRMrZ, penis pump, YddcROZ, [url=http://healthymensproducts.com/lean-muscle-x-free-trial-product-review]natural penis enlargement[/url], QvmGwee, http://healthymensproducts.com/lean-muscle-x-free-trial-product-review lean muscle x, wXtShmA, Where can i buy volume pills australia chemist, KMWoDVl, [url=http://increasedsemenvolume.com/]How long does it take volume pills to work?[/url], AhNfrga, http://increasedsemenvolume.com/ Volume pills - lab. american life style, yInUwrz.