Skip to content
×
Pro Members Get Full Access
Succeed in real estate investing with proven toolkits that have helped thousands of aspiring and existing investors achieve financial freedom.
$0 TODAY
$32.50/month, billed annually after your 7-day trial.
Cancel anytime
Find the right properties and ace your analysis
Market Finder with key investor metrics for all US markets, plus a list of recommended markets.
Deal Finder with investor-focused filters and notifications for new properties
Unlimited access to 9+ rental analysis calculators and rent estimator tools
Off-market deal finding software from Invelo ($638 value)
Supercharge your network
Pro profile badge
Pro exclusive community forums and threads
Build your landlord command center
All-in-one property management software from RentRedi ($240 value)
Portfolio monitoring and accounting from Stessa
Lawyer-approved lease agreement packages for all 50-states ($4,950 value) *annual subscribers only
Shortcut the learning curve
Live Q&A sessions with experts
Webinar replay archive
50% off investing courses ($290 value)
Already a Pro Member? Sign in here
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
x

Brandon Turner's Spreadsheet - Rental/Flip/Hybrid Calculator

17.5 KB

File Size

34K

Downloads

N/A

Rating

This is the spreadsheet I use to analyze property. The password, if you need to change something, is "realestate" Hope this helps!

Download File
Disclaimer: Safety of files uploaded to the BiggerPockets FilePlace cannot be guaranteed. Download at your own risk.
Rate this file
Pick a rating between 1 and 5 stars

Comments

Thanks for the spreadsheet and the podcasts, Brendan. In the spreadsheet I do not see why "Their closing costs" is subtracted from my profit.

John McGehee | over 3 years ago  

@edgar garnys "Does anyone know what the (W/S/G/PUD/etc) next to holding costs mean? Edgar Garnys | about 2 months ago " w - water / s - sewer / g - gas / pud - public utilites...not sure of the "d"... this would be my logical assumption. Hope that helps a bit! Kevin

Kevin Mohr | almost 4 years ago  

Does anyone know what the (W/S/G/PUD/etc) next to holding costs mean?

Edgar Garnys | almost 4 years ago  

It seems it's a protected file and cannot be edited. I don't have enough space when entering a 1M price tag lol... editable version?

Derrick StClair | over 4 years ago  

The calculator is very handy for me when being at a potential property. It allows me to quickly analyze the deal.

James Francis | about 5 years ago  

Using this for my first "real" potential deal. I wish it had a better separation of "types of potential funding" built in. However, it's been invaluable in overcoming my spouse's anxiety about REI. Yes, yes Brandon/Josh - I'll give your podcast the rating it deserves - excellent info (and entertainment)

Robert Morneweck | almost 7 years ago  

@Angie Lehnert - For the purpose of this example and spreadsheet 100% of the Purchase Price was financed so the 'Down Payment' was simply the total of Closing Costs, Repairs, Holding Costs. Its a great spreadsheet but may need to be fine tuned for our specific needs.

JG Phillips | over 7 years ago  

Thank you for this spreadsheet. Question: why do you leave out the downpayment when adding up the numbers to get your total investment and then the cash on cash return? Am I missing something? Thank you!

Angie Lehnert | over 7 years ago  

Great spreadsheet. I edited the hard money part so I could see the hard money costs including points and interest over different holding times. LOVE IT!

Kevin Kohler | almost 8 years ago  

This spreadsheet is great. As an investor friendly broker I'm also using it with buyers. Instead of them looking at what the flipper paid and what the list price is now and feeling taken advantage of, they can see the costs that went into the project and understand what they're paying for.

Account Closed | over 10 years ago  

I love the detail and ease of use. I have been trying to ascertain if first MH deal is worth the investment. This has helped me view both the now and into the future.

Jonathan Casillas | about 11 years ago