• A.CRE
    • Accelerator Home
    • A.CRE Home
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
  • TRY ACCELERATOR 2.0
  • COURSES
  • LEARN MORE
  • ENROLL
  • LOGIN
    • Accelerator Member
    • Enterprise Member
A.CRE AcceleratorA.CRE Accelerator
  • A.CRE
    • Accelerator Home
    • A.CRE Home
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
  • TRY ACCELERATOR 2.0
  • COURSES
  • LEARN MORE
  • ENROLL
  • LOGIN
    • Accelerator Member
    • Enterprise Member

Internal Rate of Return

  • Home
  • Internal Rate of Return

Internal Rate of Return

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: Time Value of Money
  • From Theory to an Excel Workbook
  • Introduction to this Mini-Course
  • Key Return Metrics
  • Lakefront Industrial Part 2
« Back to Glossary Index
  • Share:
A.CRE
A.CRE
AdventuresinCRE.com (A.CRE) was started by Spencer Burton and Michael Belasco during their first year of graduate real estate studies at Cornell University. The site was initially meant to fill a need for readily available real estate financial modeling tools. Today, it is the web's preeminent real estate financial modeling, careers, and education resource.

Next post

Curtailment
June 29, 2018

You may also like

What’s New – Accelerator Changelog
9 November, 2021

Not yet an Accelerator member? Click here to learn more and to join. January 2022 Added the ‘Ground Lease Valuation Model‘ to the Financial Models Bundle Added a ‘Calculating Gross Returns vs. Net Returns’ section to the Adding GP Fees …

My Forums and Topics

  • New posts since last visit

Topic Tags

amortization (9) apartment (3) bridge loan (3) capital reserve (4) Cap Rate (8) Cash-on-cash (3) cash-on-cash return (3) catch up (5) Concessions (7) Construction Loan (3) debt (5) debt yield (3) Development (9) Direct Cap (4) discount rate (4) distributions (4) expense growth (4) gross up (4) growth (3) hotel (4) interest reserve (6) IRR (10) irr hurdle (3) Loss-to-Lease (11) mixed use (6) npv (4) portfolio (4) preferred return (6) promote (5) property tax (7) Refinance (4) renovation (5) rent roll (3) residual land value (3) RUBS (4) s-curve (3) Sensitivity (4) SUMIF (3) Tax (4) vacancy (3) value-add (8) Waterfall (11) wst macros (6) XIRR() (6) Yield on Cost (6)

Forum Navigation

  • A.CRE
    • Accelerator Home
    • A.CRE Home
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
  • TRY ACCELERATOR 2.0
  • COURSES
  • LEARN MORE
  • ENROLL
  • LOGIN
    • Accelerator Member
    • Enterprise Member
logo-eduma-the-best-lms-wordpress-theme

[email protected]

Company

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

Accelerator

  • Login
  • Changelog
  • Courses
  • Enroll

Support

  • Accelerator Guide
  • Forums
  • Contact Us
  • FAQ

Other Resources

  • Glossary of CRE Terms
  • Graduate Education
  • CRE Interviews
  • Deep Dive Series

Presented by Adventures in CRE - Copyright 2021

  • Privacy
  • Terms
  • Disclaimer

In Jan 2022, we launched our new Accelerator 2.0 platform. This legacy platform will be phased out by Q4 2022. Click here to learn how to transition to the new Accelerator 2.0. Dismiss