Newbie real estate investor from Meridian, Idaho

2 Replies

My name is Ben Kerfoot and I am an accountant/bookkeeper starting to get into real estate investing. So far I have teamed up with my parents who currently own a rental free and clear. I plan to use the rental for a line of credit to help purchase the first potential property (buy and hold /brrr). My rental analysis spreadsheet is from If anyone knows of a rental analysis spreadsheet that more accurately calculates CCR that would be awesome. My current formula won't allow for 0% closing within the property acquisition costs to more accurately account for zero out of pocket down. Also, if anyone has any advice or knows how to more accurately account for the assumed two different interest rates (1. line of credit for investing capital and 2. conventional mortgage on newly acquired property) within the analysis formula please let me know. Thx! Looking forward to hearing some insight. Love BP already!

Hi @Ben Kerfoot

I use an excel spreadsheet, that could be of assistance to you, simply because it is so much easier to customize than other templates. You could easily add a row for your second credit line, copying and pasting the formulas, and make adjustments to closing costs. 

DM me with your email address if you'd like me to send it your way. 

Warmly , 


Free eBook from BiggerPockets!

Ultimate Beginner's Guide Book Cover

Join BiggerPockets and get The Ultimate Beginner's Guide to Real Estate Investing for FREE - read by more than 100,000 people - AND get exclusive real estate investing tips, tricks and techniques delivered straight to your inbox twice weekly!

  • Actionable advice for getting started,
  • Discover the 10 Most Lucrative Real Estate Niches,
  • Learn how to get started with or without money,
  • Explore Real-Life Strategies for Building Wealth,
  • And a LOT more.

We hate spam just as much as you