SFH Rental Analysis

Category: Spreadsheets
Size: 28 KB
Uploaded by: Tiny 1448323426 avatar jasonscott J Scott
Time uploaded: over 7 years ago
Downloaded: 20230 times
File Type: Spreadsheet

Download File

Disclaimer: Safety of files uploaded to the Szikov FilePlace cannot be guaranteed. Download at your own risk.

Rating: 5


  • Small 1485914825 avatar gpmichal

    I just noticed a disagreement between @J Scott ‘s SFH_Rental_Analysis and @Brandon Turner ‘s Four Square method for calculating the cash-on-cash return. It may just be me overlooking something but J Scott doesn’t include the cost of the rehab in the calculation where Brandon does. Unless the rehab cost will be included in the loan I feel it should be included in the calculation. I really want to understand how this is supposed to be calculated so I do it properly when analyzing properties. Anyone have any insight?

    Gary Michalske, 10 months ago

  • Small 1478186548 avatar jesseh35

    Great spreadsheet! Very helpful since I'm not a pro member and don't have unlimited use of the calculators yet. One thing I noticed: no matter what values I put in for for purchase price, loan amount, etc, the equity accrued row does not change so it always shows 64k as the total equity accrued after 30 years

    Jesse Holshouser, 10 months ago

  • No avatar

    Should this spreadsheet be used if i am paying cash for the property? I realize I can leverage. I want to pay cash. When I list downpayment is 100% and update the rest of that H column, Cash flow section no longer returns values. Is there a better spreadsheet for cash purchases?

    Brian S., 11 months ago

  • Small 1475272101 avatar geon1

    Thank you I will use this from now on. Also, take a look at Fixed cost PM for cell F30. Shouldn't that be changed to =E30?

    Geo Nakis, over 1 year ago

  • Small 1439264563 avatar christinem11

    Thank you for sharing.

    Christine M., over 1 year ago

  • Small 1470191882 avatar kalew1

    Alex - You wouldn't calculate ROI for year 1 by H9 because you are just looking for YOUR return on investment, not including the financed portion.

    Kale Waite, over 1 year ago

  • Small 1454263133 avatar alexfilipe

    Hello, I know this calculator came out a while ago but I got a question pertaining to Total ROI. I want to make sure I have these understood correctly and don't want to make a mistake calculating rental expenses. According to your spreadsheet you have Total ROI for year 1 being calculated by =F44/H9. Why wouldn't it be calculated =F44/D8. You'd also have to set annual revenue increase and annual operating cost to 0 as this throws off calculations in the future Total ROI.

    Alex Filipe, over 1 year ago

  • No avatar

    Awesome Sauce !

    Account Closed, about 2 years ago

  • Small 1427900239 avatar dedmoroz

    Very easy to use. Thank you for great tool

    Sergey S., over 2 years ago

  • Small 1409839535 avatar montywent

    Yeah multi family would be nice to have! And thanks for the SFH sheet too.

    William Wentzel, over 3 years ago

  • No avatar

    Thanks for this!

    Would this also be suitable for 2-4 unit properties?

    If not, do you have a similar spreadsheet for multifamily properties? Or what would I need to alter to account for multifamily homes?

    Account Closed, over 3 years ago

  • No avatar

    Thanks! Just what I was looking for!

    Janna Rubright, over 3 years ago

  • Small 1457526329 avatar timlockk

    Mark is right. I had to change that cell to factor in potential HOA fees.

    Thank you J, this is an excellent tool that I have been using to evaluate all my potential deals.

    Tim L., over 3 years ago

  • Small 1399732152 avatar mark in phx

    Thanks for sharing this -- great tool. I think it might need one small correction. Should cell F32 be "=E32*12" since D32 specifies a monthly expense as opposed to an annual expense?

    Mark Nugent, over 3 years ago

  • Small 1399768488 avatar cheslra

    This is fabulous! Thank you!

    Rhonda Chesley, over 3 years ago

  • No avatar

    ELVIN KALEMERA, about 4 years ago

  • Small 1399710468 avatar megk

    Ok...how on earth do i use the spreadsheet? Excel challenged!

    Meg K., over 4 years ago

  • No avatar

    I'm having trouble opening the file.

    Nicholas Webb, over 4 years ago

  • Small 1440142845 avatar mehrank

    Great spreadsheet, I use it to evaluate all my deals right now.

    Thanks J

    Mehran K., over 4 years ago

  • Small 1399691480 avatar julie2326

    Straight forward and very helpful! Using this tool to compare potential purchases. Thank you for sharing!

    Julie P., over 4 years ago

  • Small 1448323426 avatar jasonscott

    Actually, PM *does* stand for Property Management. You can enter a percentage of gross rent or a fixed monthly amount (lines 29 or 30).

    J Scott, over 5 years ago

  • No avatar

    looks very good. glad you put the effort to do this.

    John Wing, over 5 years ago

  • No avatar

    Thanks for the neat handy tool J, really appreciate it.

    Bala P., over 5 years ago

  • No avatar

    PM stands for Profit Margin. Variable Cost are costs that change in proportion to the rent (i.e. variable operating expenses). Fixed Costs are those that remain the same no matter the rent (i.e. a recurring bill like property taxes). The VC PM and FC PM = Rent Revenue - (VC or FC).

    Mike Pantages, almost 6 years ago

  • Small 1399550486 avatar robmcd

    I'm guessing PM is Property Management. Thanks for the spreadsheet!

    Rob McDonald, over 6 years ago

  • Small 1399458236 avatar dewaynej

    this is neat thanks for the tool

    Sammy Johnson, over 7 years ago

  • Small 1399459051 avatar amenegay

    Such a wonderful tool. Thank you so much for sharing!

    Angie Menegay, over 7 years ago

  • Small 1422917375 avatar blueskyhomes

    Thanks--I think I'll be able to make very good use of this. Do you use it primarily to assess a potential rental property, or to track a rental you already own? Also, what are these fields: Variable Cost PM and Fixed Cost PM? I've been racking my brain, but can't figure it out. I'm sure it's something ridiculously simple. :)

    Thanks again!

    Terri Pour-Rastegar, over 7 years ago

  • Small 1399287529 avatar crosswind

    What a great tool! Thanks for sharing.

    James Ward, over 7 years ago