Analyze Deals Like a Pro<\/strong><\/p>\n\n\n\n Deal analysis is one of the first and most critical steps of real estate investing. Maximize your confidence in each deal with this first-ever ultimate guide to deal analysis. Real Estate by the Numbers<\/em> makes real estate math easy, and makes real estate success inevitable. <\/p>\n\n\n\n
Ready to get an estimate of your investment property\u2019s return based on IRR? Let\u2019s get started.<\/p>\n\n\n\n
What Is Internal Rate of Return (IRR)?<\/h2>\n\n\n\n
IRR is a financial metric used to determine the total profitability of a potential investment. Just like annual yield, it\u2019s expressed as a percentage.<\/p>\n\n\n\n
The IRR calculation is commonly compared to the compound annual growth rate<\/a> (CAGR) because IRR projects an initial investment and its growth over time.<\/p>\n\n\n\n That\u2019s why you should use the internal rate of return formula as a guide to making educated guesses\u2014not as a concrete statistic. Because it\u2019s a projection, numbers can differ from the actual output.<\/p>\n\n\n\n\n\n\n <\/p>\n <\/span>\n <\/div>\n <\/div>\n <\/a>\n <\/template>\n <\/div>\n\n\n\n\n The internal rate of return is often used with the NPV, or the net present value. The NPV calculates the present value of an investment in terms of cash. When calculating the IRR, you would set the equation equal to a net present value of zero.<\/p>\n\n\n\n Why is the internal rate of return formula set equal to zero? For hardcore finance gurus, IRR is the discount rate that makes an investment\u2019s net present value (NPV) equal to 0.<\/p>\n\n\n\n Take a look at the formula:<\/p>\n\n\n\n Each symbol within the formula stands for a unique variable:<\/p>\n\n\n\n The equation may look complicated, but follow our step-by-step tutorial below to calculate IRR with a spreadsheet to simplify the process.<\/p>\n\n\n\n I typically use Google Sheets for this, but you can use any other spreadsheet application, such as Microsoft Excel.<\/p>\n\n\n\n We\u2019ll stick with a simple $100,000 purchase price for both of these walkthroughs. In the first example, we\u2019ll examine the internal rate of return of a property in a flourishing market. In the second example, we\u2019ll take a look at the IRR of an investment if the market takes a turn for the worse.<\/p>\n\n\n\n If you set your monthly rent to $1,000, you can expect to earn $12,000 per year. But that is contingent upon a 0% vacancy rate, no maintenance costs, and a stable housing market. And let\u2019s be real: Where and when does that actually exist?<\/p>\n\n\n\n Therefore, when projecting your monthly cash flow, leave a margin for error. For example, if the roof is 24 years old, add a roof replacement expense in year six.<\/p>\n\n\n\n Assuming your monthly rent is $1,000, you may face net negative cash flow<\/a> in that particular year\u2014after all, roofing costs can easily top $12,000.<\/p>\n\n\n\n Let\u2019s say that the housing market is great when you invest in the property, and $1,000 per month for rent is a premium due to the strong market. But if the market goes into a downturn, forcing your tenants to leave due to costs or eviction, you\u2019re left with an unoccupied property.<\/p>\n\n\n\n Each passing month negatively affects cash flow\u2014and even worse, you might have to lower your rent, as prospects are passing on your property due to price. As one would imagine, negative cash flows are not a great sign.<\/p>\n\n\n\n A situation such as an eviction or too-high costs can impact years of calculation, ultimately leading to a loss or an insignificant profit.<\/p>\n\n\n\n Calculating the internal rate of return requires detailed assumptions and open minds regarding potential changes.<\/p>\n\n\n\n So, let me help you understand how to use the IRR formula to your benefit using the same purchase price as above of $100,000. In this example, I list out the steps I took to set up my cash flow at $800 per month in rent.<\/p>\n\n\n\n You might assume that you\u2019ve made a profit based on these numbers. However, this is where the internal rate of return formula comes into play.<\/p>\n\n\n\n On the side of the box where you entered your values, make a new cell that says \u201cIRR=.\u201d In the following box, type \u201c=IRR(C3:C24)\u201d into the function bar. The equation below includes the initial investment, yearly cash flow, and selling price.<\/p>\n\n\n\n Once entered, it should input a percentage value like this:<\/p>\n\n\n\n You\u2019ll see here that the percentage value is 9%, which is not the absolute greatest internal rate of return.<\/p>\n\n\n\n If the number you receive using the IRR formula is positive, congratulations! Positive cash flows<\/a> represent a property that should produce a profit. However, the keyword here is \u201cshould.\u201d The IRR formula is not the end all, be all answer, since there are so many factors to consider.<\/p>\n\n\n\n Now you know that if you receive the monthly projected cash flow and sell at the expected price, you should walk away with cash in your pocket.<\/p>\n\n\n\n It is possible to have a negative internal rate of return value\u2014which means you would lose money over the long haul.<\/p>\n\n\n\n I\u2019ll tell you that a 10% to 12% internal rate of return might be quite respectable for an individual investor buying a long-term hold. Regarding syndication, shoot for mid-teens to make opportunities attractive to partners. Overall, aim for a rate between 10% and 15%.<\/p>\n\n\n\n The purpose of using the IRR formula is to identify the rate of discount, which makes the present value of the sum of annual nominal cash inflows equal to the initial net cash outlay.<\/p>\n\n\n\n If you\u2019re interested in calculating the rate of growth for an investment property, this formula is perfect for those who want an annual estimation.<\/p>\n\n\n\n Again, the keyword here is \u201cestimation.\u201d The actual rate of return can totally differ from the IRR, depending on the circumstances.<\/p>\n\n\n\n The IRR formula is a fantastic, simple way to analyze whether you\u2019ll potentially profit from your initial investment. <\/p>\n\n\n\n Furthermore, it considers the time value of money, which means you can anticipate adverse effects from market shifts<\/a>, maintenance costs, and more by manipulating your yearly, hopefully positive, cash flows.<\/p>\n\n\n\n Since it\u2019s as easy as filling in a few cells on a spreadsheet, it\u2019s worth the time. I recommend running this calculation for every investment.<\/p>\n\n\n\n However, IRR isn\u2019t a foolproof way to determine whether your property will pay off. Since all the numbers, besides the purchase price, are projections, you can never be positive that they\u2019ll be accurate in the long term.<\/p>\n\n\n\n Investors with more experience don\u2019t need help much help calculating their IRR and determining their margin of error. But for those new to the art\u2014or completely foreign to it\u2014the IRR may seem more like an abstract prediction than an educated guess.<\/p>\n\n\n\n The IRR\u2019s simplicity is another crutch. If you\u2019ve invested in real estate before, you know it\u2019s not as simple as lining up the purchase price, cash flows, and selling price on a spreadsheet and calling it a day. Smart investors consider reinvestment rates, mortgage considerations<\/a>, and other metrics\u2014most of which are not included in the IRR model.<\/p>\n\n\n\n The internal rate of return is a fantastic way to calculate whether you\u2019ll profit from your investment, but how does it compare to similar key models?<\/p>\n\n\n\n With the IRR formula, you account for the time value of money\u2014a metric other common models don\u2019t calculate. However, remember that the values entered into an IRR formula are mere estimates and should be considered among other models when investing.<\/p>\n\n\n\n Let\u2019s take a look at some of the top investment property formulas.<\/p>\n\n\n\n The most important distinction between the CAGR and the IRR is that the CAGR is simpler and can easily be calculated by hand. You only need your starting investment, selling price, and the years you\u2019ll likely own the investment.<\/p>\n\n\n\n CAGR and IRR provide a percentage return, but the CAGR only looks at what you start with and end with. The IRR zooms into what\u2019s happening over the years and outputs more in-depth information.<\/p>\n\n\n\n Like CAGR, ROI calculates the growth between your starting and ending values. However, ROI doesn\u2019t consider the time period. Instead, it simply calculates the amount of money made.<\/p>\n\n\n\n Here is the ROI formula<\/a>. Keep in mind that V1 is the ending balance, and V0 is the starting balance.<\/p>\n\n\n\n ROI = (V1 \u2013 V0) \/ (V0)<\/em><\/p>\n\n\n\n Now, let\u2019s look back at our model from earlier. The starting price was $100,000, and we sold the property for $213,000 during a hot market. The equation would look like this:<\/p>\n\n\n\n ($213,000 \u2013 $100,000) \/ $100,000 x 100 = 113%<\/em><\/p>\n\n\n\n A 113% ROI is fantastic, right? Sure, but it\u2019s not the end all, be all number.<\/p>\n\n\n\n ROI doesn\u2019t consider the time value of money or anticipate expenses. For any investments that involve sums of money going in and coming out through the life of the investment, ROI will pretty much ignore cash inflows and outflows, other than the first and the last. This makes it an easy but extremely limited calculation.<\/p>\n\n\n\n The most easily understood real estate investment return metric is cash-on-cash return, usually abbreviated as CCR or COC. The concept is relatively simple, as CCR juxtaposes the cash investment to the cash flow (income minus expenses) received.<\/p>\n\n\n\n For example, let\u2019s say you invest $100,000 cash to buy a fourplex, which generates $2,000\/month of gross income, resulting in $1,200\/month of cash flow.<\/p>\n\n\n\n Since CCR is usually considered an annual return, we must multiply all monthly numbers by 12. Thus, this $100,000 fourplex generates $14,400 of annual cash flow.<\/p>\n\n\n\n If I invest $100,000 in this fourplex, how quickly would I recover my cash? You can find out with the CCR model<\/a>.<\/p>\n\n\n\n All we aim to find out is what percentage of $100,000 does $14,400 represent. In mathematical terms, if $100,000 is 100%, $14,400 is x\u2014at which point we solve for x:<\/p>\n\n\n\n X (CCR) = $14,400 \/ $100,000 = 14.4%<\/em><\/p>\n\n\n\n Thus, having paid $100,000 and received $1,200\/month of cash flow, our CCR is 14.4%.<\/p>\n\n\n\n First, let\u2019s clear up some common misconceptions. I\u2019m sure most investors have heard terms like \u201ccash on cash return,\u201d \u201ctotal return,\u201d \u201creturn on investment,\u201d etc. These are all terms that indicate in some way, shape, or form how successful a particular deal is.<\/p>\n\n\n\n The most common I hear people referring to is ROI. For many investors, this number summarizes a particular investment’s success or failure.<\/p>\n\n\n\n This is where the internal rate of return (IRR) comes in. IRR is the much more powerful cousin to ROI, and while also more complicated than ROI, it\u2019s an essential tool that all serious investors need to understand.<\/p>\n\n\n\n First, you may hear IRR referred to by different names\u2014on your mortgage truth in lending statements as annual percentage yield (APY), as the \u201ceffective interest rate<\/a>\u201d of a loan, as the discounted cash flow rate of return (DCFROR), or sometimes even as the generic rate of return (ROR).<\/p>\n\n\n\n All of these things essentially mean the same thing, and serve to underscore how important and versatile the concept of IRR is when it comes to investing and finance.<\/p>\n\n\n\n Second, and most importantly, I want to point out that calculating IRR using Microsoft Excel, Google Sheets, or any other financial software is a piece of cake once you jump through the initial hoops of setting everything up.<\/p>\n\n\n\n\n \n Sponsored<\/span><\/div>\n \n \n\n
\n <\/span>\n <\/span>\n <\/div>\n <\/div>\n\n \n <\/span>\n Formula for Calculating IRR<\/h2>\n\n\n\n
![\"formula](\"https:\/\/assets1.biggerpockets.com\/uploads\/uploaded_images\/1600789882-image.png\" "\\"\\"")
<\/figure>\n\n\n\n\n
How to Calculate Internal Rate of Return Using a Spreadsheet<\/h2>\n\n\n\n
\n
![\"example](\"https:\/\/assets2.biggerpockets.com\/uploads\/uploaded_images\/1600790351-image.png\" "\\"\\"")
<\/figure>\n\n\n\n\n
<\/li>\n\n\n\n
Pro tip: Type in \u201cCash Flow Year 1\u201d and then drag the bottom right pointer to row 23. This will fill in all the cells with the correct number sequence.<\/strong><\/em><\/li>\n<\/ol>\n\n\n\n\n
<\/li>\n\n\n\nExamples of Calculating IRR<\/h2>\n\n\n\n
1. Calculating IRR in a flourishing market<\/h3>\n\n\n\n
2. Calculating IRR in a declining market<\/h3>\n\n\n\n
![\"example](\"https:\/\/assets0.biggerpockets.com\/uploads\/uploaded_images\/1600790577-image.png\" "\\"\\"")
<\/figure>\n\n\n\n\n
![\"excel](\"https:\/\/assets1.biggerpockets.com\/uploads\/uploaded_images\/1600790671-image.png\" "\\"\\"")
<\/figure>\n\n\n\n![\"the](\"https:\/\/assets0.biggerpockets.com\/uploads\/uploaded_images\/1600790679-image.png\" "\\"\\"")
<\/figure>\n\n\n\nWhat Is a Good IRR?<\/h2>\n\n\n\n
Understanding How to Use IRR<\/h2>\n\n\n\n
Benefits of Calculating IRR<\/h2>\n\n\n\n
Limitations of the IRR Formula<\/h2>\n\n\n\n
IRR Versus Other Key Models<\/h2>\n\n\n\n
Compound annual growth rate (CAGR)<\/h3>\n\n\n\n
Return on investment (ROI)<\/h3>\n\n\n\n
Cash-on-cash return (CCR)<\/h3>\n\n\n\n
Common Misconceptions of the IRR Formula<\/h2>\n\n\n\n
![\"real](\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2022\/08\/REBN_cover_mockup_01-e1679000020543.png\" "\\"\\"")
\n <\/div>\n <\/div>\n<\/div>\n\n <\/div>\n \n\n\n