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 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime.
Level up your investing with Pro
Explore exclusive tools and resources to start, grow, or optimize your portfolio.
10+ investment analysis calculators
$1,000+/yr savings on landlord software
Lawyer-reviewed lease forms (annual only)
Unlimited access to the Forums

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
Starting Out
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 5 years ago on . Most recent reply

User Stats

34
Posts
14
Votes
Devan W.
  • Investor
  • Englewood, CO
14
Votes |
34
Posts

Excel Sheet for Leveraging Properties

Devan W.
  • Investor
  • Englewood, CO
Posted

Hi BP! Has anyone created an excel sheet that shows the benefits of using leverage to buy more properties? I'm really wanting to compare my current situation vs buying more rentals. I want to see how this would impact my net worth 10-15 years down the road.

For example: I currently have one rental worth $450k with about 5 years and $65k remaining on my loan balance. Obviously, if I keep my current loan, I would have a paid off property in 5 years that rents for $2,500/month.
What if I did a cash-out refi on my current rental and purchased say 4-5 more rental properties? I know there are a ton of variables but I'd like to have a format that allows me to plug in some different numbers. I understand the combination of using leverage and acquiring more properties would help me increase my net worth faster, but I want to see it on paper! I've spent hours in excel making different amortization schedules, etc but I think I end up making it more confusing than it should be. Can anyone help me? Thanks!

Loading replies...