Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 54%
$32.50 /mo
$390 billed annualy
MONTHLY
$69 /mo
billed monthly
7 day free trial. Cancel anytime
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

Updated over 7 years ago on . Most recent reply

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...