The other day, I was talking to a close\ncollege friend, who has been a big supporter of Elementum Money. Veering\ntowards Personal Finance as usual, we started talking about how important\ninvesting at this age is for all of us to ensure we are financially sorted by\nthe time of retirement. As we talked about it, she said that one of the things\nwhich sometimes baffles her is how much would be enough for retirement. Wanting\nto make it easy for her, I told her to give me some figures and I could plan it\nout for her. Being my friend, she said she would rather do it herself. Since\nElementum Money is all about enabling and empowering wherever possible, I\nrealized a DIY Guide to Retirement Planning would be something other readers\ncould also find useful. So, here you go PM or PG, whatever you choose to call\nyourself these days!<\/p>\n\n\n\n
While retirement planning can be a simple\nprocess, what makes it complicated is our fuzziness with what that period looks\nlike in our life. What is an ideal retirement time for you? What do you foresee\nyour retired life to look like? While our plans can always change and nothing\nhas to be written in stone, some vision of what are you trying to fund is\nimportant when you plan how to accumulate that money over the years.<\/p>\n\n\n\n
Not only is this a great exercise in visualization, it also gives you a much-needed starting point to the first requirement into calculating how much funds you would need by what age. In fact, research has shown that when we look at a computer-drawn older self, we are more likely to start saving and planning for retirement<\/a>. I am pretty sure the more mind space you give to the idea of retirement and how you can make the most of that time, the more you will make sure you add money to that dream. <\/p>\n\n\n\n So, as a part of the conversation that I had with my friend, I realized that having a DIY excel calculator for retirement planning was something anyone could use. Read on for 3 steps to using this excel calculator for a customized view of how much would you need for retirement and how much can you look to invest every month through SIP<\/a> to get to your destination. The first thing that you\nneed to decide is by when you want to have the choice to retire. Make sure this\nage that you do decide on is not one year beyond 60. Even if, like me, you\nmight be of a mindset of never wanting to retire, financial planning for\nretirement is something that should be completed by 60. <\/p>\n\n\n\n On the other hand, if you are one of the many burned out millennials<\/a> who can\u2019t wait for the day that they could be financially independent<\/a>, retire early and never have to work a day, then feel free to play around with the calculator to see how your expenses toggle with the different options of retirement age as per the number of years left to accumulate the corpus. Also, as of now the age till when the corpus should last has been taken to be 85. If you think that\u2019s too high, keep it that way still and any leftover money could work as your inheritance to the next generation or to charity.<\/p>\n\n\n\n This is another vital\ninput into your retirement planning. Get an idea of what your core expenses are\ntoday, excluding aspects which you foresee disappearing in the future for\ninstance child rearing expenses or house rent as you would have paid off the\nloan. Ideally, keep the bare minimum expenses and add in any indulgences like\ntravel to come to an average monthly expense.<\/p>\n\n\n\n While you may or may not\nfeel the need for it today, this calculator also takes into account a separate\nmedical expense corpus to be accumulated over the decades. Having met so many\nclients in their sunset years, the one thing I have heard from them is their\nwoes of medical expenses, which a lot of health insurance policies also choose\nto side step. For the medical corpus, the default amount is kept at Rs. 10 Lakh\nin today\u2019s terms.<\/p>\n\n\n\n For both these expenses,\nthe sheet automatically adds the impact of inflation so that you are well\nprepared at the time.<\/p>\n\n\n\n While investing for\nretirement, there are two ways that you can go about it. You could either\nchoose to keep the SIP amount uniform over the years. Or you could decide to\nstep up the amount by hiking it every year, in line with the increments at your\njob. <\/p>\n\n\n\n My suggestion? Add in all\nyour details on the Sheet labelled \u201cEqual\u201d to get your customized monthly SIP\namount for an adequate retirement corpus. If you feel you can invest that\namount every month, then start with the amount right away choosing to use\nincremental amounts to meet other financial goals.<\/p>\n\n\n\n In case, the resultant EMI\namount from the \u201cEqual\u201d sheet looks too steep, take a realistic increment\namount in the \u201cStep Up\u201d sheet to bring down the initial amount a bit. However,\nremember that the Step-up method will require far more discipline from your end\nand ideally a professional advisor to keep you on track rather than the Equal\nmethod which can easily be a lock it and forget it method.<\/p>\n\n\n\n The excel calculator is\nfully formula based. In case, you end up messing one of the formulae, just\ndownload the sheet again and it will be back to normal.<\/p>\n\n\n\n The cells highlighted in\ngreen necessarily require input from you to ensure customization of the plan.\nThere are some other cells marked in orange which merely reflect the\nassumptions taken, be it for inflation, rate of return during accumulation or\nrate of return post retirement. The rate for inflation has been assumed at 5{76b947d7ef5b3424fa3b69da76ad2c33c34408872c6cc7893e56cc055d3cd886},\nfor returns in the corpus accumulate phase at 12{76b947d7ef5b3424fa3b69da76ad2c33c34408872c6cc7893e56cc055d3cd886} (long-term post tax equity\nreturns) and the returns on the corpus post retirement have been assumed to be\n8{76b947d7ef5b3424fa3b69da76ad2c33c34408872c6cc7893e56cc055d3cd886}. These are generally taken as industry standards and should be worked\naround.<\/p>\n\n\n\n In case, you already have some funds marked out for retirement, then add those in cell E3 as they form the base for your compounding in the years to come.<\/p>\n\n\n\n While the currency in the calculator is kept at Indian Rupees, ideally it is universal and can work for any currency.<\/p>\n\n\n\n The first step to any big\nchallenge is the recognition and the commitment towards getting there. If you\nare on this post and have downloaded the calculator, congratulations on your\nfirst move. Get cracking on figuring out the best route to a well planned\nretirement and then follow through on this plan. <\/p>\n\n\n\n If you have any feedback on\nthe calculator, I would be delighted to get your views on the same in the\ncomments below. <\/p>\n","protected":false},"excerpt":{"rendered":" The other day, I was talking to a close college friend, who has been a big supporter of Elementum Money. Veering towards Personal Finance as usual, we started talking about how important investing at this age is for all of us to ensure we are financially sorted by the time of retirement. As we talked about it, she said that one of the things which sometimes baffles her is how much would be enough for retirement. Wanting to make it easy for her, I told her to give me some figures and I could plan it out for her. Being my friend, she said she would rather do it herself. Since Elementum Money is all about enabling and empowering wherever possible, I realized a DIY Guide to Retirement Planning would be something other readers could also find useful. So, here you go PM or PG, whatever you choose to call yourself these days! Precursor to Retirement Planning While retirement planning can be a simple process, what makes it complicated is our fuzziness with what that period looks like in our life. What is an ideal retirement time for you? What do you foresee your retired life to look like? While our plans can always change and nothing has to be written in stone, some vision of what are you trying to fund is important when you plan how to accumulate that money over the years. Not only is this a great exercise in visualization, it also gives you a much-needed starting point to the first requirement into calculating how much funds you would need by what age. In fact, research has shown that when we look at a computer-drawn older self, we are more likely to start saving and planning for retirement. I am pretty sure the more mind space you give to the idea of retirement and how you can make the most of that time, the more you will make sure you add money to that dream. 3 Steps to Retirement Planning So, as a part of the conversation that I had with my friend, I realized that having a DIY excel calculator for retirement planning was something anyone could use. Read on for 3 steps to using this excel calculator for a customized view of how much would you need for retirement and how much can you look to invest every month through SIP to get to your destination. 1. Decide an ideal age to retire The first thing that you need to decide is by when you want to have the choice to retire. Make sure this age that you do decide on is not one year beyond 60. Even if, like me, you might be of a mindset of never wanting to retire, financial planning for retirement is something that should be completed by 60. On the other hand, if you are one of the many burned out millennials who can\u2019t wait for the day that they could be financially independent, retire early and never have to work a day, then feel free to play around with the calculator to see how your expenses toggle with the different options of retirement age as per the number of years left to accumulate the corpus. Also, as of now the age till when the corpus should last has been taken to be 85. If you think that\u2019s too high, keep it that way still and any leftover money could work as your inheritance to the next generation or to charity. 2. Arrive at a monthly post-retirement expense in today\u2019s terms This is another vital input into your retirement planning. Get an idea of what your core expenses are today, excluding aspects which you foresee disappearing in the future for instance child rearing expenses or house rent as you would have paid off the loan. Ideally, keep the bare minimum expenses and add in any indulgences like travel to come to an average monthly expense. While you may or may not feel the need for it today, this calculator also takes into account a separate medical expense corpus to be accumulated over the decades. Having met so many clients in their sunset years, the one thing I have heard from them is their woes of medical expenses, which a lot of health insurance policies also choose to side step. For the medical corpus, the default amount is kept at Rs. 10 Lakh in today\u2019s terms. For both these expenses, the sheet automatically adds the impact of inflation so that you are well prepared at the time. 3. Calculate the amount to invest uniformly or stepped up over the years While investing for retirement, there are two ways that you can go about it. You could either choose to keep the SIP amount uniform over the years. Or you could decide to step up the amount by hiking it every year, in line with the increments at your job. My suggestion? Add in all your details on the Sheet labelled \u201cEqual\u201d to get your customized monthly SIP amount for an adequate retirement corpus. If you feel you can invest that amount every month, then start with the amount right away choosing to use incremental amounts to meet other financial goals. In case, the resultant EMI amount from the \u201cEqual\u201d sheet looks too steep, take a realistic increment amount in the \u201cStep Up\u201d sheet to bring down the initial amount a bit. However, remember that the Step-up method will require far more discipline from your end and ideally a professional advisor to keep you on track rather than the Equal method which can easily be a lock it and forget it method. How to use the Excel Calculator The excel calculator is fully formula based. In case, you end up messing one of the formulae, just download the sheet again and it will be back to normal. The cells highlighted in green necessarily require input from you to ensure customization of the plan. There are some other cells marked in orange which merely reflect the assumptions taken, be it for inflation, rate of return during accumulation or rate of return post retirement. The rate for inflation has been assumed at 5{76b947d7ef5b3424fa3b69da76ad2c33c34408872c6cc7893e56cc055d3cd886}, for returns in the corpus accumulate phase at 12{76b947d7ef5b3424fa3b69da76ad2c33c34408872c6cc7893e56cc055d3cd886} (long-term post tax equity returns) and the returns on the corpus post retirement have been assumed to be 8{76b947d7ef5b3424fa3b69da76ad2c33c34408872c6cc7893e56cc055d3cd886}. These are generally taken as industry standards and should be worked around. In case, you already have some funds marked out for retirement, then add those in cell E3 as they form the base for your compounding in the years to come. While the currency in the calculator is kept at Indian Rupees, ideally it is universal and can work for any currency. The first step to any big challenge is the recognition and the commitment towards getting there. If you are on this post and have downloaded the calculator, congratulations on your first move. Get cracking on figuring out the best route to a well planned retirement and then follow through on this plan. If you have any feedback on the calculator, I would be delighted to get your views on the same in the comments below.<\/p>\n","protected":false},"author":1,"featured_media":638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[577],"tags":[246],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/posts\/637"}],"collection":[{"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/comments?post=637"}],"version-history":[{"count":5,"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/posts\/637\/revisions"}],"predecessor-version":[{"id":3882,"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/posts\/637\/revisions\/3882"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/media\/638"}],"wp:attachment":[{"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/media?parent=637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/categories?post=637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elementummoney.com\/blog\/wp-json\/wp\/v2\/tags?post=637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}3\nSteps to Retirement Planning<\/strong><\/h3>\n\n\n\n
<\/p>\n\n\n\n1. Decide an ideal age to retire<\/h4>\n\n\n\n
2. Arrive at a monthly post-retirement expense in today\u2019s terms<\/h4>\n\n\n\n
3. Calculate the amount to invest uniformly or stepped up over the years<\/h4>\n\n\n\n
How to use the Excel Calculator<\/strong><\/h3>\n\n\n\n