NEW: BP Podcast 66: Flips, Apartments, & Protecting Yourself From Professional Tenants with Michael Blank

Hide this
Files / J Scott's FilePlace / SFH Rental Analysis

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet SFH Rental Analysis

Category: Spreadsheets
Size: 28 KB
Owner: J Scott
Uploaded: almost 4 years ago
Downloaded: 6161 times
Type: Spreadsheet

Download File

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

Rating: 5


  1. Colleague_thumb_1378775594-avatar-crosswind_

    James Ward, almost 4 years ago

    What a great tool! Thanks for sharing.

  2. Colleague_thumb_avatar-blueskyhomes

    Terri Pour-Rastegar, almost 4 years ago

    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!

  3. Colleague_thumb_avatar-amenegay

    Angie Menegay, over 3 years ago

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

  4. Colleague_thumb_avatar-dewaynej

    Sammy Johnson, over 3 years ago

    this is neat thanks for the tool

  5. Colleague_thumb_avatar-robmcd

    Rob McDonald, almost 3 years ago

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

  6. StarStarStarStarStar No_avatar_colleague_thumb

    Mike Pantages, about 2 years ago

    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).

  7. Colleague_thumb_avatar-sailakfan

    Bala P., almost 2 years ago

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

  8. No_avatar_colleague_thumb

    John Wing, almost 2 years ago

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

  9. Colleague_thumb_1378730783-avatar-jasonscott

    J Scott, over 1 year ago

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

  10. Colleague_thumb_avatar-julie2326

    Julie P., 10 months ago

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

  11. Colleague_thumb_avatar-mehrank

    Mehran Kamari, 10 months ago

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

    Thanks J

  12. No_avatar_colleague_thumb

    Nicholas Webb, 9 months ago

    I'm having trouble opening the file.

  13. Colleague_thumb_1375836219-avatar-megk

    Meg Kangai, 8 months ago on earth do i use the spreadsheet? Excel challenged!

  14. No_avatar_colleague_thumb

    ELVIN KALEMERA, 6 months ago

  15. Colleague_thumb_1393695719-avatar-cheslra

    Rhonda Chesley, 26 days ago

    This is fabulous! Thank you!

  16. Colleague_thumb_1396214456-avatar-mark_in_phx

    Mark Nugent, 18 days ago

    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?

Share via email