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
Real Estate Technology
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

408
Posts
37
Votes
Ben Bakhshi
  • Investor
  • Atlanta, GA
37
Votes |
408
Posts

Tracking property values, LTV, mortgages in a single spreadsheet

Ben Bakhshi
  • Investor
  • Atlanta, GA
Posted

I've been using a Google Sheets to keep track of our properties, and I'd like to see what the community thinks of it.

Here is the template

The spreadsheet is semi-automatic, it does require some manual inputs, and then certain parts remain automatic. The prices tab needs to be manually updated, just add a new column to the right, and the summary sheet gets updated automatically with new LTVs.

You can:

Track mortgages

Track LTV

Track prices

Any comments, suggestions?

Loading replies...