Turn-Key Properties LLC
Since 1993
  • Turn-Key Properties LLC
    • Testimonials
    • Real Estate Glossary
  • Property Management
    • FAQ's
    • Overview of Services
    • Why Pay for Property Management?
    • Rental Prices
  • Owner Resources & Articles
    • Emotional Support Animals - Laws for Landlords
    • Common Tax Deductions for Landlords
    • What Records Should I Keep for Tax Purposes?
    • 5 Questions Every First-time Rental Property Investor has
  • Homes for Rent & Tenant Resources
    • Do you want to live in that neighborhood?
    • Pet Policy
    • Putting your touch on your new home
  • Contact Us
    • Related Links
    • Communities >
      • Kansas City >
        • Plaza
        • Westport
        • Old Northeast
        • Downtown
        • River Market
      • Raytown, MO
      • Pleasant Hill, MO
      • Blue Springs, MO
      • Independence, MO
      • Belton, MO
      • Raymore, MO
      • Harrisonville, MO
      • Odessa, MO
      • Liberty, MO
      • Riverside, MO
      • Smithville, MO
      • Grandview, MO
      • Greenwood, MO
      • Lake Lotawana, MO
      • Gladstone, MO
      • Overland Park, KS
      • Olathe, KS
      • Mission, KS
      • Shawnee, KS
      • Kansas City, KS
      • Lenexa, KS
      • Prairie Village, KS
      • Mission Hills, KS
  • 5413 NE Rainbow Ct
  • 14913 Kelly Drive

Internal Rate of Return (IRR)

12/27/2011

0 Comments

 
Occasionally someone will want to calculate the Internal Rate of Return on an investment property. This article explains how that formula works. (IRR)  The internal rate of return (IRR) is a capital budgeting method used by firms to decide whether they should make long term investments. The IRR is defined as any discount rate that results in a net present value of zero, and is usually interpreted as the expected return generated by the investment. In general, if the IRR is greater than the project's cost of capital or hurdle rate, the project will add value for the company.

To find the internal rate of return, find the IRR that satisfies the following equation

Example:
Year Cash flow
0 -100
1 +120

Calculation of NPV:
i = interest rate in percent
NPV = -100 +120/[(1+i/100)^1]
(This calculation is condensed.)

Calculation of IRR:
NPV = 0
-100 +120/[(1+IRR/100)^1] = 0
IRR = 20%

Problems with using IRRAs an investment decision tool, the calculated IRR should not be used to rate mutually exclusive projects, but only to decide whether a single project is worth investing in. In cases where one project has a higher initial investment than a second mutually exclusive project, the first project may have a lower IRR (expected return), but a higher NPV (increase in shareholders' wealth) and should thus be accepted over the second project. A method called marginal IRR can be used to adapt the IRR methodology to this case.

The IRR method should not be used in the usual manner for projects that start with an initial positive cash inflow, for example where a customer makes a deposit before a specific machine is built, resulting in a single positive cash flow followed by a series of negative cash flows (+ - - - -). In this case the usual IRR decision rule needs to be reversed.

If there are multiple sign changes in the series of cash flows, e.g. (- + - + -), there may be multiple IRRs for a single project, so that the IRR decision rule may be impossible to implement. Examples of this type of project are strip mines and nuclear power plants, where there is usually a large cash outflow at the end of the project.

In general, the IRR can be calculated by solving a polynomial. Sturm's Theorem can be used to determine if that polynomial has a unique real solution. Importantly, the IRR equation cannot be solved analytically (i.e. in its general form) but only via iterations.

A critical shortcoming of the IRR method is that it is commonly misunderstood to convey the actual annual profitability of an investment. However, this is not the case because intermediate cash flows are almost never reinvested at the project's IRR; and, therefore, the actual rate of return (akin to the one that would have been yielded by stocks or bank deposits) is almost certainly going to be lower. Accordingly, a measure called Modified Internal Rate of Return (MIRR) is used, which has an assumed reinvestment rate, usually equal to the project's cost of capital.

Despite a strong academic preference for NPV, surveys indicate that executives prefer IRR over NPV. Apparently, managers find it intuitively more appealing to evaluate investments in terms of percentage rates of return than dollars of NPV.

0 Comments

    Turn-Key Properties LLC

    22 years of real estate and property management experience serving Missouri and Kansas.

    Archives

    February 2019
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    July 2016
    August 2013
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    December 2011

    Categories

    All
    1031
    1031 Exchange
    24 CFR 206.125
    Advertising
    After Repair Value
    Apartments
    Appraisal Appeal
    Arv
    Asset Protection
    Bbq
    Board Of Equlization
    Cam
    Can And Can\\
    Cap Rate
    Cash On Cash Return
    Commercial
    Community
    Contract For Deed
    Crime
    Definitions
    Disclaimer
    Document
    Do I Have To Take Section 8
    Download
    Drugs
    Epoxy Injection
    Equestrian Real Estate
    Equine Property
    Fair Housing
    Fannie Mae
    Farm
    Foreclosure
    Form
    Foundation Repair
    Freddie Mac
    Free Commmercial Lease
    Free Forms
    Free Gun
    Free Lease
    Free Online Forms
    Good
    Grill
    Grm
    Gross Lease
    Gross Rent Multiplier
    Gun
    Hakc
    Hecm
    Home Repair
    Homes
    Homes For Rent
    Horse Farm
    Houses
    Housing Authority
    Housing Crisis
    How Much Rent
    Hud
    Independence
    Internal Rate Of Return
    Investment
    Investment Property
    Investors
    Irr
    Jackson County
    Kansas City
    Kc
    Kck
    Kcmo
    Ks
    Land
    Land Contract
    Landlord
    Landlord Licensing
    Lease
    Lease Agreement
    Lease Form
    Lease Terms
    Liability
    Licensing
    Lihtc
    Llc
    Maintenance
    Mhdc
    Mirr
    Mo
    Modified Internal Rate Of Return
    Neighborhood
    Net Lease
    Nnn Lease
    Online
    Phrases
    Privacy Policy
    Property
    Property Management
    Property Tax
    Pros And Cons
    Raytown
    Real Estate
    Real Estate 101
    Real Estate Investment
    Real Estate Tax
    Registration
    Rent
    Rental
    Rental Forms
    Rental Lease. Lease
    Rental Property
    Rental Rates
    Rent My House
    Rent Or Sell
    Repair
    Requirements Section 8
    Residential Lease
    Section 42
    Section 8
    Section Eight
    Swisher Grill
    Swisher Lawn Mower
    Tax
    Tax Appeal
    Tax Credit
    Tax Levy
    Tenant Screening
    Tenant Selection
    Terms
    Top Ten
    Trade Real Estate
    Triple Net
    Turnkey
    Turn-Key
    Turnkeyproperties
    Turn-Key Properties LLC
    Vacancy
    Value
    Website
    Words

    RSS Feed

    Follow this blog
Powered by Create your own unique website with customizable templates.
Photo used under Creative Commons from sunshinecity