Internal Rate of Return: Understanding the Difference Between IRR, MIRR and FMRR
- Author James Kobzeff
- Published December 9, 2010
- Word count 590
Internal rate of return (IRR), modified internal rate of return (MIRR), and financial management rate of return (FMRR) are three returns used to measure the profitability of investment property. Each method arrives at a percentage rate based upon an initial investment amount and future cash flows, and in each case (of course) the higher the better, but the procedure for making the calculation varies significantly as do the results.
By definition, internal rate of return is the discount rate at which the present value of all future cash flows is exactly equal to the initial capital investment. To make the calculation, negative cash flows are discounted at the same rate (i.e., the IRR) as positive cash flows.
Let's consider the following investment with the initial investment as CF0 (always a negative number because it is cash outflow) and subsequent cash flows as CF1, CF2, etc., with some negative and some positive.
CF0 -10,000
CF1 -100,000
CF2 50,000
CF3 -60,000
CF4 50,000
CF5 249,300
IRR = 30%
Seems all well and good, but the problem here is that the calculation assumes that the cash generated during an investment will be reinvested at the rate calculated by the IRR, which may be unrealistically high and therefore will overstate the return on initial investment. Likewise, since negative cash flows are also discounted at the IRR, if that rate is fairly high, the investor might not accurately estimate the cash required to meet those future negative cash flows.
To deal with this shortcoming many real estate analysts use a method known as MIRR (i.e., modified internal rate of return). In this approach, the assumption is that positive cash flows the investment generates during its life can be reinvested and earns interest at a "reinvestment rate", and negative cash flows must be financed at a "finance rate" during the life of the investment. In other words, rather than simply using one rate (i.e., IRR) to deal with both negative and positive cash flows, MIRR introduces the option to use two different rates.
By applying a finance rate of 5% and a reinvestment rate of 10% here's the result using the same investment criteria as we did earlier.
CF0 -10,000
CF1 -100,000
CF2 50,000
CF3 -60,000
CF4 50,000
CF5 249,300
MIRR = 18.75%
Okay, then along came the financial management rate of return (or FMRR). Though it also provides two separate rates to deal with negative and positive cash flows known as the "safe rate" and "reinvestment rate", FMRR takes it a step further. The assumption here is that where possible, all future outflows are removed by using prior inflows. In other words, negative cash flows are discounted back at the safe rate and are either reduced or eliminate by any positive cash flow that it encounters. The remaining positive cash flows are compounded forward at the reinvestment rate.
We'll apply a safe rate of 5% and a reinvestment rate of 10% to our investment criteria to show you the result. But this time we'll also include a table to show you the adjusted cash flows.
CF0 -10,000
CF1 -100,000
CF2 50,000
CF3 -60,000
CF4 50,000
CF5 249,300
CF0 -111,717
CF1 0
CF2 0
CF3 0
CF4 0
CF5 304,300
FMRR = 22.19%
The financial management rate of return is difficult to compute, which is why most real estate investment software solutions opt for the modified internal rate of return (MIRR) calculation. But after learning about it from CCIM, I considered it a beneficial return for real estate investment analysis, so I included FMRR my ProAPOD real estate investment software as well as my ProAPOD mortgage calculator software. To learn more please visit the link provided below.
James Kobzeff is the developer of ProAPOD - superior real estate investment software since 2000. Create a rental property cash flow analysis in minutes! Easy to use and affordable. Learn more => www.proapod.com
Article source: https://articlebiz.comRate article
Article comments
There are no posted comments.
Related articles
- Top 5 Funniest Gag Gifts for Your Best Friend
- Why Second Hand Pianos for Sale Are a Smart Investment
- Finding the Right Piano Shop Near Me: A Guide to Second Hand Pianos
- “Mira Sorvino: From Oscar Glory to Hollywood Silence.”
- Ireland Sino Institute Launches 2025 China Internship Program
- “Beyond the Spotlight: The Rise and Fall of Dorothy Dandridge.”
- “Through the Mist of Venice: Revisiting Don’t Look Now and Its Haunting Grip on Grief.”
- The Art of Coaching: Cultivating Growth and Inspiration
- Creating a Holistic Backyard Retreat: Old World Elegance Meets Nature
- Understanding T1 and T2 Transit Documents in EU: Your Complete Guide
- Cryptonews.money: Your Ultimate Guide to Understanding Cryptocurrency
- 15 Basketball Dribbling Games and Passing Drills for Better Ball Handling
- Transdermal Progesterone Cream: Benefits for Hot Flashes and Menopause Symptoms
- Tepezcohuite: The Ancient Skin Health Secret You Need to Know
- Quiet Cars and Busy Calendars: The Overlooked Role of Chauffeurs in Post-July Corporate Travel
- 1031 Exchange
- Breaking Karmic Cycles, Creating a Shiva Altar with Deity Carvings and Sculptures from Mogul Interior
- The Art of Whimsical Carved Wall Art & Eclectic Décor
- “Hellfire and Heresy: Ken Russell’s The Devils and the Fury of Sacred Cinema.”
- Transform Your Bedroom into a Productive Haven: Ultimate Guide to Bedroom Inspirations with Desk
- “Heatwave: When Crime, Character, and Two Legends Collided in Michael Mann’s L.A.”
- Steam Vs. Scrub: The Best Chemical-Free Tools For Cleaning Tile Edges And Grout
- A Smart Solution for Clean Environments: Hygienic PVC Wall Cladding
- Choosing the Right Stainless Steel Panel Adhesive for Durable Wall Cladding Installations
- How to Choose the Right PVC Panel Adhesive for a Professional Finish
- Precision Finishing with Steel Cladding Profiles and Trims
- The Finishing Touch: PVC Cladding Trim & Profiles for a Seamless Installation
- Lightweight Strength: Why Aluminum Cladding Sheets Are a Smart Choice for Modern Projects
- Durable and Hygienic: Why Stainless Steel Wall Cladding is the Industry Standard
- Transform Your Interiors with PVC Ceiling Panels and Planks