• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Wealth Pilgrim

No Money Worries. No Matter What.

Neal Frankle featured in
  • Home
  • Life Insurance
  • Investing
    • Build Strong Investment Building Blocks To Avoid Going Broke In Retirement
    • Systematic Mutual Fund and ETF Investing
    • Stock Market Investing Guide
    • Choosing the Right Investment Brokerage Guide
    • How Bonds Work Guide
    • How Banks Really Work Guide
    • Annuities – What You Need To Know Before You Invest
    • A Beginners Guide To Buying Individual Stocks
    • Create A Pool Of Great Mutual Funds and ETFs To Pick From To Secure Your Retirement
    • ETF and Index Fund Investment Guide
  • Earn More
  • Banking
  • Retirement Planning
    • Retirement Guide
  • Reviews
    • Upgrade Personal Loans Review
    • Lending Club Review
    • Prosper Review
    • Ally Invest TradeKing Review
    • CIT Bank Review
    • LegalZoom Review
    • Lexington Law Review
    • Airbnb Host Review
    • Should You Drive For Uber?
  • Tax
  • Courses
    • Raise Your Credit Score So You Can Buy a House – Free Video Course

What is a Time Weighted Return

by Neal Frankle, CFP ®, The article represents the author's opinion. This post may contain affiliate links. Please read our disclosure for more info.

You might not know what a time weighted return is but it’s a very important concept to understand if you want to evaluate true investment performance.

I realized this yesterday as I was speaking with William. Even though he is an experienced investor he didn’t have a clue about this concept. As a result he was jumping to the wrong conclusions about his investments and making some very bad decisions. In fact, even though he made some great investments for his retirement, he found it impossible to stick with them.

I am pretty sure William is going to make better investments now that he gets the idea. And a conversation about time weighted returns will probably benefit you too. The good news is you intuitively already understand it.

Let’s say you hire a contractor to install a sink in your home. It takes her 4 hours to complete the job. You pay her hourly wage and happily start using your sink. You like the sink so much you decide to have Kate the Contractor come back and install another one. Kate tells you she’ll start the job tomorrow morning at 8 a.m.

You trust Kate so you leave the key under the mat for her to come in and do the work. You come back at noon and see that Kate isn’t even half way done. You assume that Kate’s been raiding the ice box rather than installing the sink so you let her have it. The only problem is Kate got to your home an hour ago. She was delayed because of an emergency. So even though you think she’s been working (and charging you) for four hours, she has really only been there for one hour.

This is an example of ignoring the time weighted return on your investment in Kate. You assumed that you were getting a poor return on the hourly rate you pay Kate but actually the return is the same as in the first installment job.

So time weighted return looks at how much you invest and when you invest. This helps really level the playing field in evaluating performance.

Let’s apply this to money and reinforce the concept.

If I told you I invested $100 and now it is worth $200, do you think I made a good investment? Well I did get back twice what I put in but that doesn’t mean I’m smart or that the investment was a good one. Why? Because until you know when I made the investment and when I cashed in, you really don’t know very much.

Also, without having that information, you really can’t compare that investment to any other one. This is true whether you are investing in a business or evaluating mutual funds.

Let’s look at the investment again. If I told you that I invested that $100 last year you be pretty impressed. But if I told you that I invested that $100 four decades ago, you probably wouldn’t be so excited by my investment acumen.

And you’d be right to feel that way. When you figure that it took me 40 years to double my money that means I earned very little. That my friend is a time weighted return.

How do you calculate time weighted returns?

The easiest way to do this is to just open up Excel. There is a function that will do all the work for you. Let’s assume you deposited $1000 in January and then $500 more in November. At the end of the year your investment was worth $1700. Let’s use Excel to calculate the time weighted return. Look at the example below:

 

time weighted return

 

(The excell function is xirr. So to run the numbers above you’d type in @xirr(B1:B12,A1:A12). The numbers in column “B” are the cash flows. The dates are in column “A”.)

Type in the deposits as a negative number and the value of the account as a positive number. The negative makes sense because it is money you took out of your pocket and invested. The positive is used because that’s money that you got back.

In this example, your return is 21%. Pretty good.

Now, to demonstrate the importance of timing, look at the following;

 

time weighted return

 

 

If I make that additional deposit earlier in the year, the return goes down. Why? Because the money was working longer and since the end result is the same ($1700) the return is lower. The deposits in the first example were made later. That money had less time to earn for you. If the end result is the same it means the investment must have had a higher return.

Conclusion

Use the excel function to calculate your time weighted return on investment. This will help you evaluate and compare investments. Even if you don’t use the formula, now that you understand the concept, it should help you think about your money a little differently. Don’t just look at the bottom line. Consider when you invested, what you invested, what you withdrew and when in order to really understand your returns.

Is time weighted return a new concept for you? Do you think this will be a good tool for you?

Tweet
Pin
Share

Reader Interactions

User Generated Content (UGC) Disclosure: Please note that the opinions of the commenters are not necessarily the opinions of this site.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Are You Human? * Time limit is exhausted. Please reload CAPTCHA.

Primary Sidebar

Who is Neal Frankle

Neal Frankle

I'm a CERTIFIED FINANCIAL PLANNER™ Professional with more than 25 years of experience. I feel very blessed and hope to share my personal financial experience and professional wisdom with readers of WealthPilgrim.
Read More »

Stay Connected

Facebook Twitter YouTube RSS
We are on YouTube
Retirement financial education for people age 55+ seeking to retire well and for those retired seeking to enjoy a better retirement.  We discuss retirement planning, retirement investments, taxes in retirement, retirement spending, IRA and 401k distributions and we will personally answer questions that you pose in the video comments.

While so much financial information is about preparing for retirement, what about managing your finances in your retirement years? That's exactly what we cover at Retirement Crusaders.

Neal Frankle is a retired registered investment adviser. Larry Klein is a retired financial advisor and retired CPA. They have 70 years of financial advising experience to share so that you have your best retirement years.

Retirement financial education for people age 55+ seeking to retire well and for those retired seeking to enjoy a better retirement. We discuss retirement planning, retirement investments, taxes in retirement, retirement spending, IRA and 401k distributions and we will personally answer questions that you pose in the video comments.

While so much financial information is about preparing for retirement, what about managing your finances in your retirement years? That's exactly what we cover at Retirement Crusaders.

Neal Frankle is a retired registered investment adviser. Larry Klein is a retired financial advisor and retired CPA. They have 70 years of financial advising experience to share so that you have your best retirement years.

YouTube Video UCoU0buhwVplzXrsyf342nOg

Retirement Crusaders

June 10, 2022 1:19 PM

Subscribe
This error message is only visible to WordPress admins

Error 403: Requests from referer are blocked..

Domain code: global
Reason code: forbidden

More Categories

Career Development
College Funding
Credit Cards
Credit Score Fixes
Money and Marriage
Debt Relief
Estate Protection
Property Investment Loans
Small Business Strategies
Spend Less Money
Retirement financial education for people age 55+ seeking to retire well and for those retired seeking to enjoy a better retirement.  We discuss retirement planning, retirement investments, taxes in retirement, retirement spending, IRA and 401k distributions and we will personally answer questions that you pose in the video comments.

While so much financial information is about preparing for retirement, what about managing your finances in your retirement years? That's exactly what we cover at Retirement Crusaders.

Neal Frankle is a retired registered investment adviser. Larry Klein is a retired financial advisor and retired CPA. They have 70 years of financial advising experience to share so that you have your best retirement years.

Retirement financial education for people age 55+ seeking to retire well and for those retired seeking to enjoy a better retirement. We discuss retirement planning, retirement investments, taxes in retirement, retirement spending, IRA and 401k distributions and we will personally answer questions that you pose in the video comments.

While so much financial information is about preparing for retirement, what about managing your finances in your retirement years? That's exactly what we cover at Retirement Crusaders.

Neal Frankle is a retired registered investment adviser. Larry Klein is a retired financial advisor and retired CPA. They have 70 years of financial advising experience to share so that you have your best retirement years.

YouTube Video UCoU0buhwVplzXrsyf342nOg

Retirement Crusaders

June 10, 2022 1:19 PM

Subscribe
This error message is only visible to WordPress admins

Error 403: Requests from referer are blocked..

Domain code: global
Reason code: forbidden

Disclaimer

Wealth Pilgrim is not responsible for and does not endorse any advertising, products or resource available from advertisements on this website. Wealth Pilgrim receives compensation from Google for advertising space on this website, but does not control the advertising selection or content. Please do the appropriate research before participating in any third party offers. The information contained in WealthPilgrim.com is for general information or entertainment purposes only and does not constitute professional financial advice. Please contact an independent financial professional for advice regarding your specific situation. Wealth Pilgrim does not provide investment advisory services and is not a registered investment adviser. Neal may provide advisory services through Wealth Resources Group, a registered investment adviser. Wealth Pilgrim and Wealth Resources Group are affiliated companies. In accordance with FTC guidelines, we state that we have a financial relationship with some of the companies mentioned in this website. This may include receiving payments,access to free products and services for product and service reviews and giveaways. Any references to third party products, rates, or websites are subject to change without notice. We do our best to maintain current information, but due to the rapidly changing environment, some information may have changed since it was published. Please do the appropriate research before participating in any third party offers.


About · Contact · Disclaimer & Privacy policy

Copyright © Wealth Pilgrim 2023 All Rights Reserved