Real Estate Analysis Internal Rate of Return Calculator: Approaches and Examples by Eman Hamed January 5, 2018February 12, 2019 by Eman Hamed January 5, 2018February 12, 2019 Every real estate investor knows that it is important to calculate the rate of return on investment properties to estimate expected profits. Despite the fact that the return on investment calculator (ROI) can do just that for a fixed point of time, the internal rate of return calculator (IRR) is a real estate metric that measures investment properties’ long-term yield and provides results more accurately than the ROI calculator. Related: The Ultimate Guide to Rate of Return on Investment Properties What Is the Internal Rate of Return? The internal rate of return (IRR) in real estate investing estimates the value an investment property generates during the entire time frame in which a real estate investor owns it (holding period). Real estate investors also think of the IRR as the rate of growth an investment property can potentially generate. The internal rate of return is also another term used for interest. So, essentially, the IRR on investment is the percentage of interest which a real estate investor receives on each dollar he/she invests in an investment property throughout the entire holding period. The internal rate of return calculator is a comprehensive way to estimate the profitability of real estate investments. It looks beyond the investment property’s net operating income (NOI) and its purchase price, which means you will get a clearer picture of what type of returns the investment will generate from beginning to end – and that is something average return on investment metrics don’t offer. This is extremely helpful for real estate investors planning to invest in the real estate business in the long term. Another advantage of the internal rate of return calculator is that it offers real estate investors with the means to compare different investment properties based on their return. For example, suppose a real estate investor is interested in two rental properties for sale. Both have the same offer price and same expected rent. However, one has higher renovation costs, while the other has higher property tax. How can you, as a real estate investor, determine which property is the better investment? You can make this decision using an internal rate of return calculator. The investment property with the higher IRR would be considered the better. Related: Real Estate Investing Terminology: Internal Rate of Return (IRR) Internal Rate of Return Calculator – Approaches To help clarify these approaches, we’ll use the same following data set: suppose that you, as a real estate investor, purchased a $50,000 investment property. You gained a cash flow of $10,000 in year 1, $20,000 in year 2, and $30,000 in year 3. 1. Internal Rate of Return Calculator: Trial and Error The formula for the internal rate of return calculator is a rather complicated one. Unlike the return on investment (ROI) metrics, the internal rate of return is linked to another component – the net present value (NPV). The NPV is the sum of incoming cash flow minus outgoing cash flow over a certain time period. Now, to estimate the internal rate of return mathematically, you have to set the net present value to zero (0) and then solve for IRR in the following formula: NVP = -CF + CF1/(1 + IRR) + … + CFn/(1+ IRR)^n = 0 Where: NVP: Net present value -CF: Outgoing cash flow CF: Cash flow at the present moment at that step of the formula n: Current period at that point of the formula IRR: Internal rate of return Referring to the scenario mentioned above, the formula would look like: NPV = -50,000 + 10,000/(1+IRR) 1 + 20,000/(1+IRR) 2 + 30,000/(1+IRR) 3 = 0 As you can imagine, the internal rate of return calculator can be a tiresome process if done by hand because, through trial and error, you have to keep trying until you find the value of IRR on investment that makes the NPV equal to zero. Fortunately, there are a number of software programs that real estate investors use as an internal rate of return calculator, mainly financial calculators and Microsoft Excel. 2. Internal Rate of Return Calculator: Using a Financial Calculator Step 1: Enter the outgoing cash flow value of the initial investment into the calculator’s cash flow register. To open the cash flow register, press the Cash Flow [CF] key. The calculator should read [CF0=], which tells you to enter the cash flow for year 0. Because you need to pay $50,000 (outgoing cash flow) to make the initial investment, this value has to be negative. Thus, type in -50,000 for CF0, and hit the [ENTER] key. Step 2: Enter the incoming cash flow values of the subsequent years. After typing in the outgoing cash flow value, hit the down arrow once. The calculator should read [CF1=], which tells you to type in the amount for the first incoming cash flow, 10,000. After you hit [ENTER], the calculator should say [CF1=10,000]. To continue, enter the cash flow value of year 2 by hitting the down arrow twice. The calculator should read [CF2=]. Type in the incoming cash flow of the second year, 20,000, and hit [Enter]. The calculator should say [CF2=20,000]. Do the same thing for the third period and, once again, hit the down arrow twice. Step 3: Calculate the internal rate of return. Once the incoming cash flow values have been entered into the calculator, press the [IRR] key. The calculator should read [IRR=0.000]. Press the [CPT] key (at the top left corner of the calculator) to display the internal rate of return for the data set. If you’ve followed this process accurately, the calculator will display the correct internal rate of return on investment, which for our example is 8.208%. 3. Internal Rate of Return Calculator: Using Microsoft Excel Finding the internal rate of return using Microsoft Excel is fairly straightforward. Step 1: Type the initial amount of the investment property (outgoing cash flow) into any cell on the spreadsheet. Keep in mind that exactly as when using the financial calculator, this initial value must be a negative number. Thus, for our original example, type -50,000 into the A1 cell of the spreadsheet. Step 2: Type the subsequent incoming cash flow values for each year into the cells directly under the outgoing cash flow amount. This means type 10,000 into cell A2, 20,000 into cell A3, and 30,000 into cell A4. Step 3: Calculate the internal rate of return by typing in the function command “= IRR (A1: A4)” into the cell directly under all the values (A5 for our example) and hit the enter key. In that cell, the internal rate of return value should be displayed – which for our example is 8.2%. Related: What Is a Good Rate of Return on a Real Estate Investment Property? Conclusion The internal rate of return is an important number to calculate that some real estate investors neglect. The internal rate of return calculator gives real estate investors a clearer picture of what type of returns the investment will generate from its beginning to its end, which is something other metrics don’t offer. There are a number of approaches to an internal rate of return calculator. You can calculate IRR through trial and error – where you have to use the net present value (NPV) formula, with a financial calculator, or by using Microsoft Excel. Mashvisor’s investment property calculator computes and predicts numerous rate of return metrics like the cash flow, the cap rate, and the cash on cash return, and provides the most accurate results possible. Moreover, it indicates whether or not a property is a good investment opportunity based on the rate of return on investment results provided for the user. Find out more about Mashvisor’s investment property calculator and how it estimates the rate of return here! For more information on anything real estate, don’t forget to start your trial with Mashvisor. Start Your Investment Property Search! START FREE TRIAL Start Your Investment Property Search! START FREE TRIAL Cash FlowInternal Rate of ReturnInvestment CalculatorInvestor ToolsProperty Valuation 0 FacebookTwitterGoogle +PinterestLinkedin Eman Hamed Eman is a Content Writer at Mashvisor. With a focus on market reports, she enjoys researching the state of the real estate market in different cities across the US. Eman also writes about trends, forecasts, and tips for beginner investors to gain the confidence and knowledge they need to make wise decisions. Previous Post Calculating the Rate of Return on Investment Properties: Step by Step Next Post Using Mashvisor’s Investment Property Calculator to Estimate Rate of Return Related Posts What Is a Good Cash on Cash Return in 2020? Real Estate Return on Investment: What to Expect How to Make the Most From the Best Real Estate Websites What Do You Need to Know About Making Money With Investment Properties? Real Estate Data Analytics Is What You Need to Get Rich The capitalization rate is not just a number in real estate investing. It’s much more What Is Cap Rate and How Does It Let You Make Money in Real Estate Investing? Income Capitalization Approach: A Guide for Real Estate Investors How to Determine a Good Rental Property: 12 Steps Real Estate Market 2022: Which Predictions Came True & Which Ones Didn’t? How to Create Your Own Real Estate Market Analysis Template Real Estate Return on Investment Analysis: What Metrics to Use? Leave a Comment Cancel Reply Save my name, email, and website in this browser for the next time I comment.