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