• A.CRE
    • A.CRE-MMU Home
    • A.CRE Home
  • LOGIN
A.CRE MMU AcceleratorA.CRE MMU Accelerator
  • A.CRE
    • A.CRE-MMU Home
    • A.CRE Home
  • LOGIN

Internal Rate of Return

  • Home
  • Internal Rate of Return

Internal Rate of Return

« Back to Glossary Index

The discount rate at which the net present value of an investment is equal to zero. The internal rate of return is a time value of money metric, representing the true annual rate of earnings on an investment. In real estate practice, IRR is used together with other return metrics such as equity multiple, cash-on-cash return, and average rate of return to compare real estate investments and make investment decisions.

Unlevered IRR or unleveraged IRR is the internal rate of return of a string of cash flows without financing.

Levered IRR or leveraged IRR is the internal rate of return of a string of cash flows with financing included.

The Internal Rate of Return is arrived at by using the same formula used to calculate net present value (NPV), but by setting net present value to zero and solving for discount rate r. In Excel, IRR can be calculated by using the IRR(), XIRR(), or MIRR functions.

 
Related Content:
  • Glossary: Equity Multiple
  • Glossary: Unlevered Cash Flow
  • Glossary: Levered Cash Flow
  • Glossary: Key Performance Indicator
  • The Definitive Guide to Microsoft Excel - The Features That Matter
« Back to Glossary Index
  • Share:
The A.CRE Team
The A.CRE Team
Real Estate Financial Modeling, Careers, Education, and Networking

Next post

Curtailment
June 29, 2018

You may also like

What’s New – Accelerator for Marcus & Millichap Changelog
1 June, 2019

« Back to Glossary IndexJanuary 2022 Added a ‘Calculating Gross Returns vs. Net Returns’ section to the Adding GP Fees lesson in the Modeling Partnership Cash Flows course Created a ‘Calculating Gross Returns vs. Net Returns’ tutorial video By popular …

Search Accelerator

Forum Navigation

  • A.CRE
    • A.CRE-MMU Home
    • A.CRE Home
  • LOGIN
logo-accelerator-enterprise

admin@adventuresincre.com

Company

  • About A.CRE
  • Library of Excel Models
  • CRE Careers
  • CRE Education

Accelerator

  • Login
  • Changelog
  • Courses
  • Forums

Support

  • Accelerator Guide
  • Forums
  • Contact Us
  • FAQ

Other Resources

  • Library of Excel Models
  • Glossary of CRE Terms
  • Graduate Education
  • Deep Dive Series

Presented by Adventures in CRE - Copyright 2023

  • Privacy
  • Terms
  • Disclaimer