All Forum Posts by: Nick Peters

@Elinor Amsalem

Welcome to BiggerPockets! You came to the right place to learn more about real estate and connect with other motivated investors. If you wish to network or ask specific questions about your local market, you can go to your local real estate forum and discuss with investors from your area: https://www.biggerpockets.com/forums/86-local-real-estate-networking

Or you can directly meet them by registering to real estate events around you: https://www.biggerpockets.com/forums/521-events-and-happenings

Please let me know if I can help, and best of luck!

@Dale Miller You can have a look at the mini version of the spreadsheet I've developed. It's available in the FilePlace of BP:

https://www.biggerpockets.com/files/user/NickPeters/file/ultimate-rental-property-analysis-spreadsheet-mini-version

The prebuilt spreadsheet is very easy to use and it takes 1 minute to fill out. It will help you review and analyze rental properties and buy & hold investments and includes all the basics: 30-year projections, profitability analysis, etc.

Let me know if you have any questions! Happy to help.

@Julie N.

I'll let him clarify his statement but I confirm mine: IRR assumes reinvestment of interim cash flows in projects with equal rates of return (the reinvestment can be the same project or a different project). Therefore, IRR overstates the annual equivalent rate of return for a project that has interim cash flows which are reinvested at a rate lower than the calculated IRR. That's the whole point of MIRR which lets you decide of this reinvestment rate.

For more details, you can check "IRR vs MIRR" on google, there are a few good articles about that subject.

IRR indeed assumes that the project's cash flows are reinvested at the IRR rate. Because that's often not the case in real life, an adjusted IRR, called Modified IRR (MIRR) is also available in Excel. The key difference is that it allows you to specify your own reinvestment rate in the formula, which is very useful for real estate investments.

Hi @Julie N.,

If you test it on excel, you'll see that IRR = CAGR (compounded Annual growth rate) if there is no intermediary cash flow. When your project generates cashflow in intermediary periods, then your IRR will start to differ from a compounded annual growth rate (which always assumes a one-time initial investment and a one-time final payout). That's what you're observing in your two examples.

@Dagan Mcintire

Welcome to BiggerPockets! You came to the right place to learn more about real estate and connect with other motivated investors. BP is full of great content, so I strongly recommend you to have a look at the following resources:

1. Start by reading the Ultimate Real Estate Investing Guide: https://www.biggerpockets.com/guides/ultimate-real-estate-investing-guide/introduction

2. Then check out other online guides available here: https://www.biggerpockets.com/guides

3. Have a look at BP's blog where new articles are published every day: https://www.biggerpockets.com/blog

4. If you wish to network or ask specific questions about your local market, you can go to your local real estate forum and discuss with investors from your area: https://www.biggerpockets.com/forums/86-local-real-estate-networking

5. Or you can directly meet them by registering to real estate events around you: https://www.biggerpockets.com/forums/521-events-and-happenings

6. Finally, BP has various tools available to help you analyze your deals (rental, flips, wholesale, etc), feel free to use them: https://www.biggerpockets.com/investment-calculators

Please let me know if I can help, and best of luck!

@Gabriela C.

Welcome to BiggerPockets! You came to the right place to learn more about real estate and connect with other motivated investors. BP is full of great content, so I strongly recommend you to have a look at the following resources:

1. Start by reading the Ultimate Real Estate Investing Guide: https://www.biggerpockets.com/guides/ultimate-real-estate-investing-guide/introduction

2. Then check out other online guides available here: https://www.biggerpockets.com/guides

3. Have a look at BP's blog where new articles are published every day: https://www.biggerpockets.com/blog

4. If you wish to network or ask specific questions about your local market, you can go to your local real estate forum and discuss with investors from your area: https://www.biggerpockets.com/forums/86-local-real-estate-networking

5. Or you can directly meet them by registering to real estate events around you: https://www.biggerpockets.com/forums/521-events-and-happenings

6. Finally, BP has various tools available to help you analyze your deals (rental, flips, wholesale, etc), feel free to use them: https://www.biggerpockets.com/investment-calculators

Please let me know if I can help, and best of luck!

@Brendan Carlson

Welcome to BiggerPockets! You came to the right place to learn more about real estate and connect with other motivated investors. BP is full of great content, so I strongly recommend you to have a look at the following resources:

1. Start by reading the Ultimate Real Estate Investing Guide: https://www.biggerpockets.com/guides/ultimate-real-estate-investing-guide/introduction

2. Then check out other online guides available here: https://www.biggerpockets.com/guides

3. Have a look at BP's blog where new articles are published every day: https://www.biggerpockets.com/blog

4. If you wish to network or ask specific questions about your local market, you can go to your local real estate forum and discuss with investors from your area: https://www.biggerpockets.com/forums/86-local-real-estate-networking

5. Or you can directly meet them by registering to real estate events around you: https://www.biggerpockets.com/forums/521-events-and-happenings

6. Finally, BP has various tools available to help you analyze your deals (rental, flips, wholesale, etc), feel free to use them: https://www.biggerpockets.com/investment-calculators

Please let me know if I can help, and best of luck!

@Jaehan Kim

Welcome to BiggerPockets! You came to the right place to learn more about real estate and connect with other motivated investors. BP is full of great content, so I strongly recommend you to have a look at the following resources:

1. Start by reading the Ultimate Real Estate Investing Guide: https://www.biggerpockets.com/guides/ultimate-real-estate-investing-guide/introduction

2. Then check out other online guides available here: https://www.biggerpockets.com/guides

3. Have a look at BP's blog where new articles are published every day: https://www.biggerpockets.com/blog

4. If you wish to network or ask specific questions about your local market, you can go to your local real estate forum and discuss with investors from your area: https://www.biggerpockets.com/forums/86-local-real-estate-networking

5. Or you can directly meet them by registering to real estate events around you: https://www.biggerpockets.com/forums/521-events-and-happenings

6. Finally, BP has various tools available to help you analyze your deals (rental, flips, wholesale, etc), feel free to use them: https://www.biggerpockets.com/investment-calculators

Please let me know if I can help, and best of luck!

@Justin Elliott

Welcome to BiggerPockets! You came to the right place to learn more about real estate and connect with other motivated investors. BP is full of great content, so I strongly recommend you to have a look at the following resources:

1. Start by reading the Ultimate Real Estate Investing Guide: https://www.biggerpockets.com/guides/ultimate-real-estate-investing-guide/introduction

2. Then check out other online guides available here: https://www.biggerpockets.com/guides

3. Have a look at BP's blog where new articles are published every day: https://www.biggerpockets.com/blog

4. If you wish to network or ask specific questions about your local market, you can go to your local real estate forum and discuss with investors from your area: https://www.biggerpockets.com/forums/86-local-real-estate-networking

5. Or you can directly meet them by registering to real estate events around you: https://www.biggerpockets.com/forums/521-events-and-happenings

6. Finally, BP has various tools available to help you analyze your deals (rental, flips, wholesale, etc), feel free to use them: https://www.biggerpockets.com/investment-calculators

Please let me know if I can help, and best of luck!