{"id":6210,"date":"2026-10-30T06:05:23","date_gmt":"2026-10-30T06:05:23","guid":{"rendered":"https:\/\/www.incredmoney.com\/knowledge-center\/?p=6210"},"modified":"2026-10-30T06:08:19","modified_gmt":"2026-10-30T06:08:19","slug":"what-is-time-weighted-rate-of-return","status":"publish","type":"post","link":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/","title":{"rendered":"What is Time Weighted Rate of Return\u200b ?"},"content":{"rendered":"<p>Regular deposits and surprise withdrawals distort standard return calculations, hiding the true performance of your underlying assets. The Time Weighted Rate of Return (TWR) removes these distortions of cash flows so you can measure portfolio performance with institutional grade precision.<\/p>\n<h2 id=\"how-to-calculate-time-weighted-return-example-included\">How to Calculate Time Weighted Return (Example Included)<\/h2>\n<p>For active investors, most retail portfolio dashboards are a failure, because they conflate the performance of the underlying assets with personal saving habits. If you are adding money on a regular basis, the simple calculation of returns is very much dependent on the timing and size of the deposits into a diversified portfolio. The distortions are so severe that it is virtually impossible to point to any particular alternative investment or a particular bond and say &#8220;this is what you are really yielding&#8221;.<\/p>\n<p>TWR addresses this structural problem by separating the compound growth rate of the investment. You need to segment your investment horizon into distinct time intervals in an effort to eliminate cash flow distortions. Each time you deposit or withdraw money, the current sub-period ends and the next one starts immediately.<\/p>\n<p>Consider an investor actively managing a debt and alternative equity portfolio over a calendar year. They start with an initial lump sum, add capital a few months later and make a strategic withdrawal later in the year. They have to see three different sub-periods to find their real yield.<\/p>\n<p class=\"step\"><strong>01 \u2013 Define the First Sub-Period<\/strong><br \/>\nOn 1st January, the investor invests \u20b91,00,000 in the portfolio. By March 15, the portfolio value is \u20b91,05,000, owing to interest earned and appreciation in the assets. Sub-Period 1 is the same period, from January 1 to the moment just before the next deposit.<\/p>\n<p class=\"step\"><strong>02 \u2013 Calculate Return for Sub-Period 1<\/strong><br \/>\nTo calculate holding period return, take the ending value and subtract the beginning value. Divide that number by the beginning value. It is calculated as (\u20b91,05,000 &#8211; \u20b91,00,000) \/ \u20b91,00,000. This gives a return of 0.05 or 5% for the first subperiod.<\/p>\n<p class=\"step\"><strong>03 \u2013 Enter the First Cash Flow<\/strong><br \/>\nOn March 15, the investor adds another \u20b950,000 to arrive at a portfolio balance of \u20b91,55,000. Now, this \u20b950,000 has not been created by the underlying assets. This is a pure cash flow distortion. This new balance of \u20b91,55,000 will be the opening value for Sub-Period 2.<\/p>\n<p class=\"step\"><strong>04 \u2013 Calculate Return for Sub-Period 2<\/strong><br \/>\nAs of 10th August, the portfolio balance stands at \u20b91,62,750. Now calculate the yield between 15th March and 10th August as follows: (\u20b91,62,750 &#8211; \u20b91,55,000) \/ \u20b91,55,000. This yields a return of 0.05 or 5% for the second sub-period.<\/p>\n<p class=\"step\"><strong>05 \u2013 Withdrawals Recorded<\/strong><br \/>\nOn 10th August, the investor withdraws \u20b920,000 for some external expense. The balance amount left in the account is \u20b91,42,750. Sub-Period 3 begins. The balance remaining by December 31 is \u20b91,49,887.<\/p>\n<p class=\"step\"><strong>06 \u2013 Calculate Return for Sub-Period 3<\/strong><br \/>\nFinal sub-period return is (\u20b91,49,887 &#8211; \u20b91,42,750) \/ \u20b91,42,750. This is another 0.05, or 5% return. Now you have three 5% sub-period returns that are uncontaminated.<\/p>\n<p class=\"step\"><strong>07 \u2013 Perform Geometric Linking<\/strong><br \/>\nYou have to geometrically link the sub-periods to find the total portfolio growth. To do this, add 1 to each return, multiply them together, and subtract 1. <\/p>\n<p> The formula is: [(1 + 0.05) \u00d7 (1 + 0.05) \u00d7 (1 + 0.05)] \u2013 1. The Time-Weighted Return in the end is 15.76%. <\/p>\n<p>The investor segmented the time line into different blocks. Therefore, the injection of \u20b950,000 and withdrawal of \u20b920,000 were not considered for evaluating the asset\u2019s performance. The underlying assets grew at 15.76% irrespective of the personal liquidity needs of the investor.<\/p>\n<h2 id=\"how-to-calculate-twr-in-excel-step-by-step\">How to Calculate TWR in Excel: Step by Step<\/h2>\n<p>The academic definitions of geometric linking are of almost no use to an active investor managing his own wealth. You need to create a permanent TWR tracker if you want to remain accountable for unlisted shares, bonds or other debt. You can automate that calculation with Excel and not have to depend on opaque platform dashboards.<\/p>\n<p>The most important step is setting up your spreadsheet&#8217;s architecture. According to Groww and other financial resources, the success of the entire calculation depends on correctly mapping the period. If you input a deposit date incorrectly, the math will get the starting value of the next sub-period wrong and break the metric.<\/p>\n<p>Open a new spreadsheet and create six columns: Date (Col A), Beg Value (Col B), Cash Flow (Col C), Ending Value Before Next Cash Flow (Col D), Sub Period Return (Col E), Linking Multiplier (Col F).<\/p>\n<p class=\"step\"><strong>01 \u2013 Arrange the Cash Flow Lines<\/strong><br \/>\nYour sheet has one line for each sub-period. The end of the sub-period is the date of a new deposit\/withdrawal. In Column C, write each deposit as a positive number, each withdrawal as a negative number. Make sure that the Ending Value in Column D is precisely what the balance was before the new cash flow hits the ledger.<\/p>\n<p class=\"step\"><strong>02 \u2013 Sub-Period Return Variable Coding<\/strong><br \/>\nIn cell E2, enter the following formula exactly as it appears: <code>=(D2-(B2+C2))\/(B2+C2)<\/code>. This formula isolates the raw growth of the asset over that period of time. Simply copy this formula down Column E for each row that has a logged cash flow.<\/p>\n<p class=\"step\"><strong>03 \u2013 Build the Geometric Multiplier<\/strong><br \/>\nGeometric linking just adds 1 to all percentage returns before multiplying them together. In cell F2 type the formula <code>=1+E2<\/code>. Drag this formula down Column F. Now a 5% return will show up as 1.05, the format for compound math.<\/p>\n<p class=\"step\"><strong>04 \u2013 Determine the Total Time-Weighted Return<\/strong><br \/>\nSelect an empty summary cell outside of your key table of data. Take the product of the whole column of multiplier in excel and take out the base integer. Type the formula: <code>=PRODUCT(F2:F10)-1<\/code> (change the cell range to match your data). Format this final cell as a percent.<\/p>\n<p>With this framework set up, all you need to do is update the spreadsheet on days when money actually enters or exits the portfolio. The sub-periods will be dynamically generated. It takes a heavy mathematical theory and turns it into a light-weight, practical tool for institutional-grade portfolio tracking.<\/p>\n<p>When you automate the math, you instantly remove the noise of your own behavior. You can clearly see if that corporate bond or other alternative asset is actually providing the yield promised, outside of your monthly SIPs.<\/p>\n<h2 id=\"twr-vs-money-weighted-return-which-one-to-use\">TWR vs. Money-Weighted Return: Which One to Use?<\/h2>\n<p>When analyzing financial statements, investors will often see both TWR and Money-Weighted Return (MWR). The wrong metric leads to totally wrong conclusions about portfolio health. The only thing that matters is who controls when the cash flows occur and that determines which metric you believe.<\/p>\n<p>Money-Weighted Return is calculated by using the Internal Rate of Return (IRR) calculation, which takes into account the size and timing of each deposit. TWR actively removes those variables. Knowing this structural difference determines how you measure success.<\/p>\n<figure class=\"wp-block-table\">\n<table>\n<thead>\n<tr>\n<th scope=\"col\">Metric<\/th>\n<th scope=\"col\">Cash Flow Treatment<\/th>\n<th scope=\"col\">Ideal Application<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td data-label=\"Metric\">Time-Weighted Return (TWR)<\/td>\n<td data-label=\"Cash Flow Treatment\">Ignores the size and timing of external deposits and withdrawals.<\/td>\n<td data-label=\"Ideal Application\">Evaluating the performance of underlying assets, fund managers, or investment platforms.<\/td>\n<\/tr>\n<tr>\n<td data-label=\"Metric\">Money-Weighted Return (MWR)<\/td>\n<td data-label=\"Cash Flow Treatment\">Heavily weights performance based on when money enters or exits the account.<\/td>\n<td data-label=\"Ideal Application\">Evaluating a retail investor&#8217;s personal market timing and cash flow decisions.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>If you are looking at a particular investment vehicle, only TWR is a real measure. It tells you how well the underlying asset put capital to work, regardless of whether you personally invested money at a market high or a market low. Institutional professionals use TWR exclusively to objectively measure asset yield.<\/p>\n<p>MWR, in contrast, is more suited to measuring your own decision making. If you want to know if your specific timing of a massive portfolio withdrawal permanently hurt your compounding wealth, MWR will tell you the truth. It punishes you for putting money in before a dip, and rewards you for putting money in before a rally.<\/p>\n<p>Active retail investors with diversified debt and alternative portfolios should default to TWR for daily evaluation. It also prevents a badly timed personal liquidity event from obscuring the steady yield of a high-performing corporate bond.<\/p>\n<h2 id=\"frequently-asked-questions\">Frequently Asked Questions<\/h2>\n<style>#sp-ea-6212 .spcollapsing { height: 0; overflow: hidden; transition-property: height;transition-duration: 300ms;}#sp-ea-6212.sp-easy-accordion>.sp-ea-single {margin-bottom: 10px; border: 1px solid #e2e2e2; }#sp-ea-6212.sp-easy-accordion>.sp-ea-single>.ea-header a {color: #444;}#sp-ea-6212.sp-easy-accordion>.sp-ea-single>.sp-collapse>.ea-body {background: #fff; color: #444;}#sp-ea-6212.sp-easy-accordion>.sp-ea-single {background: #eee;}#sp-ea-6212.sp-easy-accordion>.sp-ea-single>.ea-header a .ea-expand-icon { float: left; color: #444;font-size: 16px;}<\/style><div id=\"sp_easy_accordion-1793340025\"><div id=\"sp-ea-6212\" class=\"sp-ea-one sp-easy-accordion\" data-ea-active=\"ea-click\" data-ea-mode=\"vertical\" data-preloader=\"\" data-scroll-active-item=\"\" data-offset-to-scroll=\"0\"><div class=\"ea-card ea-expand sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-62120\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse62120\" aria-controls=\"collapse62120\" href=\"#\" aria-expanded=\"true\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-minus\"><\/i> How to compute time-weighted return in Excel?<\/a><\/h3><div class=\"sp-collapse spcollapse collapsed show\" id=\"collapse62120\" data-parent=\"#sp-ea-6212\" role=\"region\" aria-labelledby=\"ea-header-62120\"> <div class=\"ea-body\"><p class=\"western\"><span style=\"font-family: Arial, serif\">Columns for Beginning Balance, Cash Flow, Ending Balance, and Sub-Period Return. Use the formula = (Ending Balance \u2013 Beginning Balance) \/ Beginning Balance for each period between deposits. Then add 1 to each individual return, multiply them all together in Excel using the =PRODUCT() function, and subtract 1 to get the final compound growth rate.<\/span><\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-62121\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse62121\" aria-controls=\"collapse62121\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> Why is my portfolio return different from fund return?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse62121\" data-parent=\"#sp-ea-6212\" role=\"region\" aria-labelledby=\"ea-header-62121\"> <div class=\"ea-body\"><p class=\"western\"><span style=\"font-family: Arial, serif\">The dashboard of your personal portfolio usually calculates a simple or Money-Weighted return which heavily depends on the exact dates and amounts of your specific deposits and withdrawals. The Fund Manager reports a Time-Weighted Return (TWR) which deliberately removes all individual investor cash flows to show only the raw performance of the underlying assets.<\/span><\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-62122\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse62122\" aria-controls=\"collapse62122\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> TWR or MWR which is better?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse62122\" data-parent=\"#sp-ea-6212\" role=\"region\" aria-labelledby=\"ea-header-62122\"> <div class=\"ea-body\"><p class=\"western\"><span style=\"font-family: Arial, serif\">TWR is strictly superior for evaluating the actual performance of an investment, because it removes the mathematical distortion of your own deposit schedule. MWR is only better if you\u2019re trying to evaluate your own market timing and cash-management behaviors. TWR is the industry standard for holding an asset class or fund accountable for yield.<\/span><\/p><\/div><\/div><\/div><script type=\"application\/ld+json\">{ \"@context\": \"https:\/\/schema.org\", \"@type\": \"FAQPage\", \"@id\": \"sp-ea-schema-6212-6afa6bad96313\", \"mainEntity\": [{ \"@type\": \"Question\", \"name\": \"How to compute time-weighted return in Excel?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"<p>Columns for Beginning Balance, Cash Flow, Ending Balance, and Sub-Period Return. Use the formula = (Ending Balance \u2013 Beginning Balance) \/ Beginning Balance for each period between deposits. Then add 1 to each individual return, multiply them all together in Excel using the =PRODUCT() function, and subtract 1 to get the final compound growth rate.<\/p>\" } },{ \"@type\": \"Question\", \"name\": \"Why is my portfolio return different from fund return?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"<p>The dashboard of your personal portfolio usually calculates a simple or Money-Weighted return which heavily depends on the exact dates and amounts of your specific deposits and withdrawals. The Fund Manager reports a Time-Weighted Return (TWR) which deliberately removes all individual investor cash flows to show only the raw performance of the underlying assets.<\/p>\" } },{ \"@type\": \"Question\", \"name\": \"TWR or MWR which is better?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"<p>TWR is strictly superior for evaluating the actual performance of an investment, because it removes the mathematical distortion of your own deposit schedule. MWR is only better if you\u2019re trying to evaluate your own market timing and cash-management behaviors. TWR is the industry standard for holding an asset class or fund accountable for yield.<\/p>\" } }] }<\/script><\/div><\/div>\n<div class=\"disclaimer\">\n<h2 id=\"disclaimer\">Disclaimer<\/h2>\n<p><em>This article is for educational and informational purposes only and does not constitute investment, financial, tax, or legal advice. The examples, figures, and calculations shown are hypothetical and illustrative; they do not represent actual investment results. Past performance is not indicative of future returns. Investments in debt, alternative, and unlisted assets are subject to market, credit, and liquidity risks, including possible loss of principal. Please consult a SEBI-registered investment adviser or a qualified financial professional before making any investment decisions.<\/em>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Regular deposits and surprise withdrawals distort standard return calculations, hiding the true performance of your underlying assets. The Time Weighted Rate of Return (TWR) removes these distortions of cash flows so you can measure portfolio performance with institutional grade precision. How to Calculate Time Weighted Return (Example Included) For active investors, most retail portfolio dashboards [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[27],"tags":[],"class_list":["post-6210","post","type-post","status-publish","format-standard","hentry","category-share-market"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>TWR Explained: Calculate Time-Weighted Return in Excel | InCred Money<\/title>\n<meta name=\"description\" content=\"Learn to measure investment skill accurately. See what is time weighted rate of return and how to calculate compound growth by isolating your personal cash flows.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TWR Explained: Calculate Time-Weighted Return in Excel | InCred Money\" \/>\n<meta property=\"og:description\" content=\"Learn to measure investment skill accurately. See what is time weighted rate of return and how to calculate compound growth by isolating your personal cash flows.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/\" \/>\n<meta property=\"og:site_name\" content=\"InCred Money | Knowledge Centre\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-30T06:05:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-30T06:08:19+00:00\" \/>\n<meta name=\"author\" content=\"InCred Money\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InCred Money\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/\"},\"author\":{\"name\":\"InCred Money\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#\\\/schema\\\/person\\\/45384c8f17896ed1084ffb558efa008e\"},\"headline\":\"What is Time Weighted Rate of Return\u200b ?\",\"datePublished\":\"2026-10-30T06:05:23+00:00\",\"dateModified\":\"2026-10-30T06:08:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/\"},\"wordCount\":1350,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#organization\"},\"articleSection\":[\"Share Market\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/\",\"url\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/\",\"name\":\"TWR Explained: Calculate Time-Weighted Return in Excel | InCred Money\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#website\"},\"datePublished\":\"2026-10-30T06:05:23+00:00\",\"dateModified\":\"2026-10-30T06:08:19+00:00\",\"description\":\"Learn to measure investment skill accurately. See what is time weighted rate of return and how to calculate compound growth by isolating your personal cash flows.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/share-market\\\/what-is-time-weighted-rate-of-return\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Time Weighted Rate of Return\u200b ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#website\",\"url\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/\",\"name\":\"InCred Money | Knowledge Centre\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#organization\",\"name\":\"InCred Money | Knowledge Centre\",\"url\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/incred-money-1.webp\",\"contentUrl\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/incred-money-1.webp\",\"width\":516,\"height\":184,\"caption\":\"InCred Money | Knowledge Centre\"},\"image\":{\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/#\\\/schema\\\/person\\\/45384c8f17896ed1084ffb558efa008e\",\"name\":\"InCred Money\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fa3ca621e2126aa06847bfc76570805abd5bcc3be1841b0be0f56d69de3b1d18?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fa3ca621e2126aa06847bfc76570805abd5bcc3be1841b0be0f56d69de3b1d18?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fa3ca621e2126aa06847bfc76570805abd5bcc3be1841b0be0f56d69de3b1d18?s=96&d=mm&r=g\",\"caption\":\"InCred Money\"},\"url\":\"https:\\\/\\\/www.incredmoney.com\\\/knowledge-center\\\/author\\\/incred-money\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TWR Explained: Calculate Time-Weighted Return in Excel | InCred Money","description":"Learn to measure investment skill accurately. See what is time weighted rate of return and how to calculate compound growth by isolating your personal cash flows.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/","og_locale":"en_US","og_type":"article","og_title":"TWR Explained: Calculate Time-Weighted Return in Excel | InCred Money","og_description":"Learn to measure investment skill accurately. See what is time weighted rate of return and how to calculate compound growth by isolating your personal cash flows.","og_url":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/","og_site_name":"InCred Money | Knowledge Centre","article_published_time":"2026-10-30T06:05:23+00:00","article_modified_time":"2026-10-30T06:08:19+00:00","author":"InCred Money","twitter_card":"summary_large_image","twitter_misc":{"Written by":"InCred Money","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/#article","isPartOf":{"@id":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/"},"author":{"name":"InCred Money","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#\/schema\/person\/45384c8f17896ed1084ffb558efa008e"},"headline":"What is Time Weighted Rate of Return\u200b ?","datePublished":"2026-10-30T06:05:23+00:00","dateModified":"2026-10-30T06:08:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/"},"wordCount":1350,"commentCount":0,"publisher":{"@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#organization"},"articleSection":["Share Market"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/","url":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/","name":"TWR Explained: Calculate Time-Weighted Return in Excel | InCred Money","isPartOf":{"@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#website"},"datePublished":"2026-10-30T06:05:23+00:00","dateModified":"2026-10-30T06:08:19+00:00","description":"Learn to measure investment skill accurately. See what is time weighted rate of return and how to calculate compound growth by isolating your personal cash flows.","breadcrumb":{"@id":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/share-market\/what-is-time-weighted-rate-of-return\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.incredmoney.com\/knowledge-center\/"},{"@type":"ListItem","position":2,"name":"What is Time Weighted Rate of Return\u200b ?"}]},{"@type":"WebSite","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#website","url":"https:\/\/www.incredmoney.com\/knowledge-center\/","name":"InCred Money | Knowledge Centre","description":"","publisher":{"@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.incredmoney.com\/knowledge-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#organization","name":"InCred Money | Knowledge Centre","url":"https:\/\/www.incredmoney.com\/knowledge-center\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#\/schema\/logo\/image\/","url":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/incred-money-1.webp","contentUrl":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/incred-money-1.webp","width":516,"height":184,"caption":"InCred Money | Knowledge Centre"},"image":{"@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.incredmoney.com\/knowledge-center\/#\/schema\/person\/45384c8f17896ed1084ffb558efa008e","name":"InCred Money","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fa3ca621e2126aa06847bfc76570805abd5bcc3be1841b0be0f56d69de3b1d18?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fa3ca621e2126aa06847bfc76570805abd5bcc3be1841b0be0f56d69de3b1d18?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fa3ca621e2126aa06847bfc76570805abd5bcc3be1841b0be0f56d69de3b1d18?s=96&d=mm&r=g","caption":"InCred Money"},"url":"https:\/\/www.incredmoney.com\/knowledge-center\/author\/incred-money\/"}]}},"_links":{"self":[{"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/posts\/6210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/comments?post=6210"}],"version-history":[{"count":5,"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/posts\/6210\/revisions"}],"predecessor-version":[{"id":6216,"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/posts\/6210\/revisions\/6216"}],"wp:attachment":[{"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/media?parent=6210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/categories?post=6210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.incredmoney.com\/knowledge-center\/wp-json\/wp\/v2\/tags?post=6210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}