{"id":924,"date":"2022-05-27T13:13:41","date_gmt":"2022-05-27T13:13:41","guid":{"rendered":"https:\/\/sharpely.in\/blogs\/financial-goal-planning-dynamic-programming-approach\/"},"modified":"2026-05-22T21:23:32","modified_gmt":"2026-05-22T21:23:32","slug":"financial-goal-planning-dynamic-programming-approach","status":"publish","type":"post","link":"https:\/\/sharpely.in\/blogs\/financial-goal-planning-dynamic-programming-approach\/","title":{"rendered":"Financial Goal Planning \u2013 Dynamic Programming approach"},"content":{"rendered":"

In the\u00a0previous part<\/a>\u00a0of this Financial Goal Planning series we looked at how the traditional approach to portfolio construction based on \u201cExpected\u201d returns is not optimal \u2013 it doesn\u2019t select a portfolio that has the highest probability of achieving the goal.<\/p>\n

We also explored the static approach to goal planning where we pick an optimal portfolio today and then simply rebalance the portfolio till maturity (goal horizon).<\/p>\n

Let\u2019s revisit our toy example so that we can use it in this blog as well.<\/p>\n

The goal was to reach a corpus of Rs 1.79 cr in 10 years\u2019 time. For this, we agreed on a starting SIP amount of Rs 76,000 per month and grow it by 5% every year. Implied required rate of return (annualized) was 9%. Our portfolio choice was restricted to 2 assets \u2013 risky asset represented by exposure to Nifty 50 Index through ETF and risk-free asset represented by exposure to a Liquid fund.<\/p>\n

We saw that 40:60 portfolio was suboptimal since the chances of achieving the goal was barely 53%. Instead, a 70:30 portfolio has roughly 70% odds.<\/p>\n

Suppose we do start with a 70:30 portfolio. We then enter a bear market for 2 years and after 2 years, the required return of achieving the goal becomes 12% (from 9%).<\/p>\n

Do we stick with the 70:30 portfolio or we do change the portfolio?<\/p>\n

A simple and intuitive approach<\/strong><\/h2>\n

Suppose we can select portfolios only once \u2013 at the start of the year. A very simple approach could be \u2013 at the start of the year,<\/p>\n

    \n
  1. Evaluate your current wealth and calculate the required return to achieve the goal based on years left.<\/li>\n
  2. Select a portfolio that maximizes the probability of achieving the goal, given new inputs.<\/li>\n<\/ol>\n

    In our example, we start with a required rate of 9% and 10 years to goal with a 70:30 portfolio. After 1 year, suppose the market tanks and your required return becomes 12% with 9 years to goal. This combination of horizon and required return can fully determine your choice of portfolio. We call this combination as\u00a0\u201cstate\u201d<\/strong>\u00a0and the choice of portfolio as\u00a0\u201caction\u201d<\/strong>. We will denote a state by\u00a0<required return, horizon>.<\/strong><\/p>\n

    Note that we have transitioned from state\u00a0<9%, 10 years><\/strong>\u00a0to state\u00a0<12%, 9 years><\/strong>. Then, we pick a portfolio that is optimal for\u00a0<12%, 9 years><\/strong>\u00a0combination.<\/p>\n

    This is a very simple and intuitive approach. Every year, evaluate the state you are in and pick an action (portfolio) that maximizes the probability of achieving the goal.<\/p>\n

    This is not a bad approach. But can we do better?<\/p>\n

    In this approach, at every step, we are picking a portfolio that is optimal for that combination of required return and horizon. This has an implicit assumption that\u00a0once we pick a portfolio, we are not going to change it<\/strong>.<\/p>\n

    In other words, the knowledge that\u00a0I am going to get to pick portfolios every year<\/strong>\u00a0is not used in this approach.<\/p>\n

    To incorporate this knowledge, we need to solve for optimal policy by going backwards in time.<\/p>\n

    Dynamic programming \u2013 an informal introduction<\/strong><\/h2>\n

    So, what are we trying to solve?<\/p>\n

    Given a combination of required return and horizon, we need to pick the best portfolio which need not be the \u201coptimal\u201d portfolio for this combination.<\/p>\n

    We also know that we will get to course correct (pick a portfolio) every year and our action today should account for that fact.<\/p>\n

    To solve this, we need to move backwards in time.<\/p>\n

    We start with 1 year to goal and pick the best portfolios for different levels of required return. Note that with only 1 year to goal, the best action is the optimal portfolio \u2013 one that maximizes the chances of achieving a return that is greater than or equal to the required return.<\/p>\n

    Now we move back 1 step and look at 2 years to goal. Suppose that we are solving for a best action for 10% required return. Let\u2019s assume that next year returns can only be 3 outcomes \u2013 5%, 10% and 15%. Then, possible outcomes for required return in the next step (1 year to horizon) are 15.2%, 10% and 5.2%. We have already solved for best actions for these outcomes.<\/p>\n

    Our action today (2 years to goal) will be such that we maximize the overall probability accounting for A. probability of landing up in different states in 1 year\u2019s time and B. probability of achieving the goal once we have landed in a particular state in 1 year\u2019s time.<\/p>\n

    We then keep moving backwards in time till we reach the present day. This gives us our policy \u2013 for each state (return, horizon pair) we have an action (portfolio).<\/p>\n

    Dynamic programming \u2013 a formal setup<\/strong><\/h2>\n

    This is a slightly technical section where we discuss the details of our model and setup. Readers can skip to the next section without breaking the flow of discussion.<\/p>\n

    To solve this dynamic programming problem, we need to formulate our goal planning exercise as a Markov Decision Processes (MDP). MDP has a state space and an action space and a set of transition probabilities \u2013 that controls transition from 1 state to the next.<\/p>\n

    We have already introduced state as a combination of required return and horizon \u2013\u00a0<required return, horizon><\/strong>. Given this definition, we see that there can be infinite number of states. Therefore, we need to discretize both the dimensions.<\/p>\n

    We discretize the required return into integer returns from 1% to 20%. Any level lower than 1% is absorbed in 1% and any level higher than 20% is absorbed in 20%.<\/p>\n

    We discretize horizon by taking annual steps. Thus, for a 10-year horizon (in our toy example), we have 10 steps along the time dimension.<\/p>\n

    This discretization converts the state space into a 20 x 10 grid with rows representing a level of required return (1% to 20%) and columns representing time (annual steps).<\/p>\n

    There are methods for solving continuous state dynamic programming problems. Ideally, we would like to work with continuous state along the return dimension but that is beyond the scope of this blog.<\/em><\/p>\n

    We have also introduced the notion of action which is simply picking a portfolio from our restricted set of assets. Even with this restricted set, we can see that the action space is also infinite. Hence, we need to discretize action space as well. In our example, we limit the action space to 21 portfolios starting with 100% liquid and going all the way up to 100% Nifty 50 index with an increment of 5%.<\/p>\n

    We have our state space and our action space. Now we need a model for transition probabilities. Given a state (required return\u00a0R<\/strong>\u00a0and\u00a0H<\/strong>\u00a0years to horizon) and an action (choice of portfolio), what are the probabilities of moving to next 20 states \u2013 1% to 20% required return and\u00a0H-1<\/strong>\u00a0years to horizon.<\/p>\n

    First, we model annual returns of Nifty 50 as univariate student-t distribution with 4 degrees of freedom. We use maximum likelihood to estimate the parameters of our distribution.<\/p>\n

    Liquid returns are assumed to be deterministic \u2013 4% return with probability of 1. Here are the steps involved:<\/p>\n

      \n
    1. Sample large number of scenarios of Nifty 50 returns from the specified distribution. Combined with deterministic liquid returns, we have return scenarios for each of our 21 portfolios.<\/li>\n
    2. Each scenario of 1-year return yields a scenario of required return in the next step. Thus, we have a scenario probability distribution of required returns.<\/li>\n
    3. \u00a0We then discretize these scenarios to yield a probability mass function for our discreet levels of required returns \u2013 1% to 20%. This is our transition probability model.<\/li>\n<\/ol>\n

      We can now solve our MDP using standard DP technique to get our optimal policy.<\/p>\n

      For 1-year to horizon the problem reduces to picking an action that maximizes the probability of 1-year return being greater than required return and we can directly use the CDF of our student-t distribution.<\/em><\/p>\n

      Is dynamic programming even worth the effort?<\/strong><\/h2>\n

      Let\u2019s first start with our toy example. A dynamic approach increases the probability to 85% from 74% in a static approach.<\/p>\n

      Now let\u2019s look at more general results.<\/p>\n

      In the\u00a0previous part<\/a>, we presented a heat map that showed the probability of achieving the goal for different combinations of required return and horizon. This was assuming that we pick an optimal portfolio at start and then take no action (apart from periodic rebalancing).<\/p>\n

      It would be interesting to compare that heatmap (static approach) with a similar heat map for a dynamic approach.<\/p>\n

      To calculate the probabilities, we have used a technique called historical bootstrapping to simulate 1000 possible 10-year paths of Nifty 50 and ran the portfolio for each path. We have used a deterministic 4% annual return form liquid fund and not assumed any taxes or transaction costs. Probability is calculated as the number of paths in which portfolio\u2019s final value is greater than the target value divided by 1000.<\/p>\n

      First, we present the standalone results for dynamic approach in the chart below:<\/p>\n

      <\/p>\n

      A better chart would be a heat map of difference in probabilities between dynamic and static approach. Below, we present a heat map that shows the increase in probability achieved by using a dynamic programming approach over the static approach.<\/span><\/p>\n

      <\/p>\n

      Few interesting observations:<\/h3>\n
        \n
      • Difference in column 1 is 0 by construction \u2013 both dynamic and static approach are same for 1 year horizon.<\/li>\n
      • Dynamic approach adds value and increases the odds of achieving the goal by 6% to 10%.<\/li>\n
      • As we move down the grid (increasing required return), benefit of a dynamic approach decreases. This is expected because odds of achieving the goal are anyways so low that a dynamic approach can barely add any value. Dynamic approach works best in 8% to 14% range.<\/li>\n
      • Benefit of dynamic approach appears to decrease with increase in horizon. This is slightly counter intuitive and is likely due to lower variation in portfolio outcomes over longer horizons. Nonetheless, the benefit is still significant.<\/li>\n<\/ul>\n

        Use of dynamic programming for financial goal planning seems to add significant value over a one-step static approach.<\/p>\n

        Note that we have used a distributional assumption for Nifty 50 returns to solve our dynamic programming problem. Such an approach is called model-based approach because the agent has full knowledge of (or can infer) state transition probabilities. Agent uses this knowledge to arrive at the optimal policy.<\/p>\n

        What if our distributional assumption (or parameter estimation) is incorrect? It appears that a more robust approach would be a model-free approach where we let the agent learn the best policy from experience. That is jumping into the realm of Reinforcement Learning which we will explore in our next blog.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Explore the power of dynamic programming in financial goal planning. Learn how to choose the best portfolio over time to maximise the probability of achieving your financial goals. Discover how a dynamic approach significantly improves the odds of success.<\/p>\n","protected":false},"author":6,"featured_media":923,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,11],"tags":[],"class_list":["post-924","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-investor-education","category-research-tools","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"_links":{"self":[{"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/posts\/924","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/comments?post=924"}],"version-history":[{"count":1,"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/posts\/924\/revisions"}],"predecessor-version":[{"id":1071,"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/posts\/924\/revisions\/1071"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/media\/923"}],"wp:attachment":[{"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/media?parent=924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/categories?post=924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sharpely.in\/blogs\/wp-json\/wp\/v2\/tags?post=924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}