Skip to content

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Followed Discussions Followed Categories Followed People Followed Locations
Buying & Selling Real Estate
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

User Stats

58
Posts
22
Votes
Lee G.
  • Accountant
  • Lumberton, NC
22
Votes |
58
Posts

Total ROI Investment Spreadsheet

Lee G.
  • Accountant
  • Lumberton, NC
Posted

I recently downloaded rental analysis spreadsheet which does a good job of mapping out a year-by-year ROI based on several assumptions. that you must enter. I inserted real-life investment I purchased and currently own, which in hindsight, I probably wouldn't make again, but the learning along the way would justify the purchase in my mind.

On that investment purchase, my ROI in year 1 was calculated at 6.12% per J Scott's spreadsheet (not great!). However by the 5th year, the spreadsheet is showing a 7.5% ROI and by the 10th year, a 10.19% ROI.

How would you grade this investment? 7.5-10% ROI in my book isn't bad (and this is factoring in PM which I also currently handle myself). How would you evaluate or grade an investment that takes several years for the investment to really get going from an ROI standpoint? Is it simply, you would prefer to buy better, but now that you own it and it will return 7.5-10%, it's more of a keeper?

Loading replies...