Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Tax Liens & Mortgage Notes
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated almost 7 years ago on . Most recent reply

User Stats

1,530
Posts
1,103
Votes
Andy Mirza
  • Lender
  • Ladera Ranch, CA
1,103
Votes |
1,530
Posts

Do you use IRR for NPN's?

Andy Mirza
  • Lender
  • Ladera Ranch, CA
Posted

What are folks using to provide numbers to show historical data on their NPN returns? I've been using ROI and Annualized ROI when communicating with current and potential investors but I've always felt that IRR (Internalized Rate of Return) should be the most accurate. I recently found a calculator that can make the IRR calculation using monthly cash flows and I ran the calculations for some of my last NPN returns. (Using monthly cashflows seems to me to be the most useful for the amount of time needed to do the calculations versus bi-weekly, weekly, or daily cashflows.) Annualized ROI was pretty close to the IRR calculation for most. Where it differed was with the NPN's we took back as REOs, since we had to put additional capital into the deal.

Thoughts??

Most Popular Reply

User Stats

17,779
Posts
15,309
Votes
Chris Seveney
  • Investor
  • Virginia
15,309
Votes |
17,779
Posts
Chris Seveney
  • Investor
  • Virginia
ModeratorReplied

Andreas Mirza
Yes I use internal rate of return. If your using it in excel DO NOT use the IRR function as you are much better using XIRR OR IRR in a formula to get it based on monthly cash flows.

I would be happy to talk offline more about it

  • Chris Seveney
business profile image
7e investments
5.0 stars
16 Reviews

Loading replies...