“You miss 100 percent of the shots you never take, and if you think it’s expensive to hire a professional to do the job, wait until you hire an amateur “ . ARE YOU READY TO SELL OR PURCHASE YOUR LAND OR COMMERCIAL BUILDING IN PHOENIX, SCOTTSDALE, MARICOPA COUNTY AND PINAL COUNTY, ARIZONA, CLICK HERE AND PLEASE CALL ME. 520-975-5207 or email me walterunger@ccim.net. . VIEW ALL OF WALTERS LISTINGS. Let me know if you are interested in Apartments: CLICK HERE FOR APARTMENTS FOR SALE
KASTEN LONG Commercial Group and AMA Events, Resources & Education For Apartment Owners
JUNE 9, 2014 BY ROBERT SCHMIDT
The internal rate of return (IRR) is a widely used investment performance measure in commercial real estate, yet it’s also widely misunderstood. What is IRR exactly? How is it used and what are its limitations? In this article we’ll discuss what IRR is and how it works. We will also identify some common misconceptions and finally clarify these ideas with some relevant examples.
What is IRR?
First of all, what is IRR? Simply stated, the Internal rate of return (IRR) for an investment is the percentage rate earned on each dollar invested for each period it is invested. IRR is also another term people use for interest. Ultimately, IRR gives an investor the means to compare alternative investments based on their yield.
Mathematically, the IRR can be found by setting the Net Present Value (NPV) equation equal to zero (0) and solving for the rate of return (IRR).
If the above equation scares you don’t worry, we will walk through a detailed example next that shows you exactly how IRR works and it will leave you with a solid intuition behind the internal rate of return.
Step-by-Step Example and Proof of IRR
Memorizing equations is one thing, but truly understanding what’s actually happening with IRR will give you a big advantage. Let’s walk through a detailed example of IRR and show you exactly what it does, step-by-step.
Suppose we are faced with the following series of cash flows:
This is pretty straightforward. An investment of $100,000 made today will be worth $161,051 in 5 years. As shown the IRR calculated is 10%. Now let’s take a look under the hood to see exactly what’s happening to our investment in each of the 5 years:
As shown above in year 1 the total amount we have invested is $100,000 and there is no cash flow received. Since the 10% IRR in year 1 we receive is not paid out to us as an interim cash flow, it is instead added to our outstanding investment amount for year 2. That means in year 2 we no longer have $100,000 invested, but rather we have $100,000 + 10,000, or $110,000 invested.
Now in year 2 this $110,000 earns 10%, which equals $11,000. Again, nothing is paid out in interim cash flows so our $11,000 return is added to our outstanding internal investment amount for year 3. This process of increasing the outstanding “internal” investment amount continues all the way through the end of year 5 when we receive our lump sum return of $161,051. Notice how this lump sum payment includes both the return of our original $100,000 investment, plus the 10% return “on” our investment.
This is much more intuitive than the mathematical (and typical) explanation of IRR as “the discount rate that makes the net present value equal to zero.” While technically correct, that doesn’t exactly help us all that much in understanding what IRR actually means. As shown above, the IRR is clearly the percentage rate earned on each dollar invested for each period it is invested. Once you break it out into its individual components and step through it period by period, this becomes easy to see.
What IRR is Not
IRR can be a very helpful decision indicator for selecting an investment. However, there is one very important point that must be made about IRR: it doesn’t always equal the annual compound rate of return on an initial investment.
Let’s take an example to illustrate. Suppose we have the following series of cash flows that also generates a 10% IRR:
In this example an investment of $100,000 is made today and in exchange we receive $15,000 every year for 5 years, plus we also sell the asset at the end of year 5 for $69,475. The calculated IRR of 10% is exactly the same as our first example above. But let’s examine what’s happening under the hood in order to see why these are two very different investments:
As shown above in year 1 our outstanding investment amount is $100,000, which earns a return on investment of 10% or $10,000. However, our total interim cash flow in year 1 is $15,000, which is $5,000 greater than our $10,000 return “on” investment. That means in year 1 we get our $10,000 return on investment, plus we also get $5,000 of our original initial investment back.
Now, notice what happens to our outstanding internal investment in year 2. It decreases by $5,000 since that is the amount of capital we recovered with the year 1 cash flow (the amount in excess of the return on portion). This process of decreasing the outstanding “internal” investment amount continues all the way through the end of year 5. Again, the reason why our outstanding initial investment decreases is because we are receiving more cash flow each year than is needed to earn the IRR for that year. This extra cash flow results in capital recovery, thus reducing the outstanding amount of capital we have remaining in the investment.
Why does this matter? Let’s take another look at the total cash flow columns in each of the above two charts. Notice that in our first example the total $161,051 while in the second chart the total cash flow was only $144,475. But wait a minute, I thought both of these investments had a 10% IRR?! Well, indeed they did both earn a 10% IRR, as we can see by revisiting the definition or IRR:
The Internal rate of return (IRR) for an investment is the percentage rate earned on each dollar invested for each period it is invested.
The internal rate of return measures the return on the outstanding “internal” investment amount remaining in an investment for each period it is invested. The outstanding internal investment, as demonstrated above, can increase or decrease over the holding period. It says nothing about what happens to capital taken out of the investment. And contrary to popular belief, the IRR does not always measure the return on your initial investment.
The Myth of The Reinvestment Rate Assumption
One of the most commonly cited limitations of the IRR is the so called “reinvestment rate assumption.” In short, the reinvestment rate assumption says that the IRR assumes interim cash flows are reinvested at the IRR, which of course isn’t always feasible. The idea that the IRR assumes interim cash flows are reinvested is a major misconception that’s unfortunately still taught by many business school professors today.
As shown in the step-by-step approach above, the IRR makes no such assumption. The internal rate of return is a discounting calculation and makes no assumptions about what to do with periodic cash flows received along the way. It can’t because it’s a DISCOUNTING function, which moves money back in time, not forward.
This is not to say the the IRR doesn’t have some limitations, as shown in the examples above. It’s just to say that the “reinvestment rate assumption” is not among them. Should you take into account the yield you can earn on interim cash flows that you reinvest? Absolutely, and there have been various measures introduced over the years to turn the IRR into a measure of return on the initial investment. Some of the more popular approaches include the modified internal rate of return (MIRR), the capital accumulation method, and the external rate of return (ERR). These approaches are beyond the scope of this article, but will be explored in the near future.
Conclusion
The Internal Rate of Return (IRR) is a popular measure of investment performance. While it’s normally explained using its mathematical definition (the discount rate that causes the net present value to equal zero), this article showed step-by-step what the IRR actually does. What is IRR? Once you walk through the examples above this question becomes much easier to answer. It also becomes clear that the IRR isn’t always what people think it is. That is, it isn’t always the compound annual return on the initial investment amount. Understanding what IRR is at an intuitive level will go a long ways towards improving your ability to analyze potential investments.
SEE IT ALL: https://www.propertymetrics.com/blog/2014/06/09/what-is-irr/
ARE YOU READY TO SELL OR PURCHASE YOUR LAND OR COMMERCIAL BUILDING IN PHOENIX, SCOTTSDALE, MARICOPA COUNTY AND PINAL COUNTY, ARIZONA, CLICK HERE AND PLEASE CALL ME. 520-975-5207 or email me walterunger@ccim.net. …. VIEW ALL OF WALTERS LISTINGS. Let me know if you are interested in Apartments: CLICK HERE FOR APARTMENTS FOR SALE and CLICK HERE for Map of Apartments Under Construction or in Pipeline.
KASTEN LONG Commercial Group and AMA Events, Resources & Education For Apartment Owners
Timeline of Arizona from 900 BC – 2017
WHY PHOENIX? AMAZING!!! POPULATION IN 1950 – 350 K PEOPLE; “NOW 5 MIL”. – “5TH. BIGGEST CITY IN USA”
FROM ME:
Phoenix Commercial Real Estate and Investment Real Estate: Investors and Owner / Users need to really know the market today before making a move in owner user Commercial Properties, Investment Properties and land in Phoenix / Maricopa County, Pinal County / Arizona, as the market has a lot of moving parts today. What is going on socio-economically, what is going on demographically, what is going on with location, with competing businesses, with public policy in general — all of these things affect the quality of selling or purchasing your Commercial Properties, Commercial Investment Properties and Commercial and large tracts of Residential Land Therefore, you need a broker, a CCIM (Certified Commercial Investment Member) who is a recognized expert in the commercial and investment real estate industry and who understands Commercial Properties and Investment Properties. I am marketing my listings on Costar, Loop-net CCIM, Kasten Long Commercial Group. I also sold hundreds millions of dollars’ worth of Investment Properties / Owner User Properties in Retail, Office Industrial, Multi-family and Land in Arizona and therefore I am working with brokers, Investors and Developers. I am also a CCIM and through this origination ( www.ccim.com ) I have access to marketing not only in the United States, but also internationalClick here to find out what is a CCIM: https://en.wikipedia.org/wiki/CCIM
PLEASE CALL ME 520-975-5207 OR E-MAIL ME walterunger@ccim.net
ARE YOU READY TO SELL OR PURCHASE YOUR LAND OR COMMERCIAL BUILDING IN PHOENIX, SCOTTSDALE, MARICOPA COUNTY AND PINAL COUNTY, ARIZONA, CLICK HERE AND PLEASE CALL ME. 520-975-5207 or email me walterunger@ccim.net
CLICK HERE for Map of Apartments Under Construction or in Pipeline.
Let me know if you are interested in Apartments: CLICK HERE FOR APARTMENTS FOR SALE
WEEKLY APARTMENT CLOSING UPDATE THROUGH April 20, 2018, Phoenix Arizona Metro.
WEEKLY APARTMENT CLOSING UPDATE THROUGH April 13, 2018, Phoenix Arizona Metro.
WEEKLY APARTMENT CLOSING UPDATE THROUGH April 6, 2018, Phoenix Arizona Metro.
8 Reasons You Should Invest in Land
Timeline of Arizona from 900 BC – 2017
WHY PHOENIX? AMAZING!!! POPULATION IN 1950 – 350 K PEOPLE; “NOW 5 MIL”. – “5TH. BIGGEST CITY IN USA”
DOT – LOOP 202 / SOUTH MOUNTAIN FREEWAY / PHOENIX AZ – UNDER CONSTRUCTION
ARIZONA FACTS – YEAR 1848 TO 2013
- DEMOGRAPHIC FACTS ABOUT MARICOPA COUNTY:
- The average age of the population is 34 years old.
- The health cost index score in this area is 102.1. (100 = national average)
- Here are some of the distributions of commute times for the area: <15 min (22.7%), 15-29 min (36.8%), 30-44 min (25.1%), 45-59 min (8.6%), >60 min (6.8%).
PHOENIX PROJECTED AS NUMBER ONE US HOUSING MARKET FOR 2017
LIST OF ECONOMIC DEVELOPMENT PROJECTS IN PINAL COUNTY, REVISED 2-14-17
Reasons to Consider me for Commercial Referrals – I have the Knowledge and Experience
Click here to View My Listings and Profile
Click here to find out what is a CCIM:
Click here to view my website:
Click her to join my mailing list :
Walter Unger CCIM – walterunger@ccim.net – 1-520-975-5207 – http://walter-unger.com
2016 Official Arizona Visitors Guide
Timeline of Phoenix, Arizona history
Facts of Arizona – year 1848 to 2013
Feel free to contact Walter regarding any of these stories, the current market, distressed commercial real estate opportunities and needs, your property or your Investment Needs for Comercial Properties in Phoenix, Tucson, Arizona.
1-520-975-5207
Check out my professional profile and connect with me on LinkedIn.
Kasten Long Commercial Group tracks all advertised apartment communities, including those advertised by other brokerages. The interactive map shows the location of each community (10+ units) and each location is color coded by the size (number of total units).
Walter Unger CCIM, CCSS, CCLS
I am a successful Commercial / Investment Real Estate Broker in Arizona now for 20 years. If you have any questions about Commercial / Investment Properties in Phoenix or Commercial / Investment Properties in Arizona, I will gladly sit down with you and share my expertise and my professional opinion with you. I am also in this to make money therefore it will be a win-win situation for all of us.
Please reply by e-mail walterunger@ccim.net or call me on my cell 520-975-5207
Walter Unger CCIM
Senior Associate Broker
Kasten Long Commercial Group
5110 N 40th Street, Suite 110
Phoenix , AZ 85018
Direct: 520-975-5207
Fax: 602-865-7461
Reasons to Consider me for Commercial Referrals
Delivering the New Standard of Excellence in Commercial Real Estate
- Commercial Real Estate Scottsdale
- Commercial Real Estate Phoenix
- Commercial Real Estate Arizona
- Commercial Investment Properties Phoenix
- Commercial Investment Properties Scottsdale
- Commercial Investment Properties Arizona
- Land Specialist Arizona
- Arizona Land Specialist
- Land Specialist Phoenix
- Phoenix Land Specialist
- Land For Sale Phoenix
- Land for sale Arizona
- Commercial Properties For Sale Phoenix
- Commercial Real Estate Sales Phoenix
- Commercial Properties Phoenix
- Commercial Properties Arizona
- Commercial Land Specialist Phoenix
- Commercial Land Phoenix
- Multifamily land Phoenix
- Retail Land Phoenix
- Industrial Land Phoenix
- Land Commercial Phoenix
- Land Retail Phoenix
- Land Industrial Phoenix
- Land Multifamily Phoenix
- Industrial Land for sale Phoenix
- Land Industrial
- P
- Investment Real Estate
Disclaimer of Liability
The information in this blog-newsletter is for general guidance only, and does not constitute the provision of legal advice, tax advice, accounting services, investment advice, or professional consulting of any kind. The information provided herein should not be used as a substitute for consultation with professional tax, accounting, legal, or other competent advisers. Before making any decision or taking any action, you should consult a professional adviser who has been provided with all pertinent facts relevant to your particular situation. Tax articles in this e-newsletter are not intended to be used, and cannot be used by any taxpayer, for the purpose of avoiding accuracy-related penalties that may be imposed on the taxpayer. The information is provided “as is,” with no assurance or guarantee of completeness, accuracy, or timeliness of the information, and without warranty of any kind, express or implied, including but not limited to warranties of performance, merchantability, and fitness for a particular purpose.