BiggerPockets


SFH Rental Analysis

Category: Spreadsheets
Size: 28 KB
Uploaded by: Tiny_1412557279-avatar-jasonscott J Scott
Time uploaded: over 4 years ago
Downloaded: 9087 times
File Type: Spreadsheet


Download File

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

Rating: 5

Reviews

  • Small_1399287529-avatar-crosswind_

    What a great tool! Thanks for sharing.

    James Ward, over 4 years ago  


  • Small_1399344371-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 4 years ago  


  • Small_1399459051-avatar-amenegay

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

    Angie Menegay, over 4 years ago  


  • Small_1399458236-avatar-dewaynej

    this is neat thanks for the tool

    Sammy Johnson, over 4 years ago  


  • Small_1399550486-avatar-robmcd

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

    Rob McDonald, over 3 years ago  


  • No_avatar_small

    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 3 years ago  


  • No_avatar_small

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

    Bala P., over 2 years ago  


  • No_avatar_small

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

    John Wing, over 2 years ago  


  • Small_1412557279-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 2 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 1 year ago  


  • Small_1409007923-avatar-mehrank

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

    Thanks J

    Mehran Kamari, over 1 year ago  


  • No_avatar_small

    I'm having trouble opening the file.

    Nicholas Webb, over 1 year ago  


  • Small_1399710468-avatar-megk

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

    Meg Kangai, over 1 year ago  


  • No_avatar_small

    ELVIN KALEMERA, about 1 year ago  


  • Small_1399768488-avatar-cheslra

    This is fabulous! Thank you!

    Rhonda Chesley, 9 months 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, 9 months ago  


  • Small_1402317573-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., 5 months ago  


  • No_avatar_small

    Thanks! Just what I was looking for!

    Janna Rubright, 5 months ago  


  • Small_1399746992-avatar-cpalko100

    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?

    Chris P., 4 months ago  


  • Small_1409839535-avatar-montywent

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

    William Wentzel, 3 months ago