All
Members
Companies
Blog
Forums
Podcast
Webinars
    User Log in  /  Sign up
  • Start here
  • Education
    Forums

    Learn from and contribute to 660K+ real estate discussions

    BiggerPockets Podcast

    Listen to weekly interviews with investors & entrepreneurs

    BiggerPockets Blog

    Delve into 8,800+ articles by experienced investors

    Member Blogs

    Read original articles by BiggerPockets members

    Guides

    Master the ins and outs of fundamental real estate topics

    The Money Show

    Listen to weekly interviews that will help get your financial house in order

    Webinars

    Sign up for this week's free webinars hosted by experienced investors or view previously-held webinar recordings in the Archives

    Videos

    Browse our library of real estate related video content

    Free Course

    Experience The Financial Independence Blueprint video series - a free four-part video series

    Topics
    Property Management Property Types Finance Strategy Finding Deals Business Operations
  • Network
    Members

    Search over 1,270,000 members across BiggerPockets

    Companies

    Explore over 31,000 real estate-related companies

    Real Estate Agents

    Find an investor-friendly agent near you

    Hard Money Lenders

    Pinpoint lenders near you with our nationwide database

    Events

    Find upcoming real estate events and meetups near you

    Jobs

    Browse real estate job opportunities in your area

  • Tools

    Calculators

    • Fix and Flip
    • Rental Property
    • BRRRR
    • Rehab Estimator
    • Wholesaling
    • Mortgage Payment
    • 70% Rule
    • Airbnb Calculator

    Services

    Find a Contractor Get a Mortgage Loan Tenant Screening External Link

    Additional Tools

    FilePlace

    Download presentations, spreadsheets, contracts & more

    REI Resources

    Dig into thousands of curated real estate tools & resources

    Calculators
  • Marketplace
    Properties For Sale

    Buy and sell real estate deals or seek out partners, financing, etc.

    Find Foreclosures External Link

    Search this comprehensive database of nationwide foreclosures

    Ads, Jobs, and Other

    Advertise your real estate business, deals, financing & more

  • Bookstore

    Featured Book

    Recession-Proof Real Estate Investing book cover

    Recession-Proof Real Estate Investing

    This easy-to-follow guide will show you how to make money during all of the market’s twists and turns! Accomplished investor J Scott dives into the theory of economic cycles and the real-world strategies for harnessing them to your advantage.

    Get the book now

    Real Estate Books

    • Flipping and Estimating Bundle
    • How to Invest in Real Estate
    • How to Sell Your Home
    • See All Books
    Real Estate Books

    Shop books covering real estate investing and personal finance.

    Lease Agreement Package New

    Don't spend $1,000 on a lawyer!

    Real Estate Forms

    Lease Agreement Package New

    Don't spend $1,000 on a lawyer!

  • Plans
Log In Sign up
User
Quick search links
Podcast Hard Money Lenders Books Washington
ForumsArrowReal Estate Deal Analysis and AdviceArrowFree Property Analysis Worksheet
  • Newest Posts Arrow Down Light
    • Newest Posts
    • Unanswered Discussions
  • Trending Arrow Down Light
    • Top Discussions
    • Trending Discussions
  • Reviews & Feedback Arrow Down Light
    • Local Real Estate Forums

      Real Estate Forums near you

      • Maryland Real Estate Q&A Discussion Forum 2.6K Posts 389 Discussions
      • Norfolk Real Estate Forum 350 Posts 35 Discussions
      • New York City Real Estate Forum 1.3K Posts 192 Discussions
      • Norwalk Real Estate Forum 7 Posts -1 Discussions

      View all Local Real Estate forums

    • General Info
      • New Member Introductions 489K Posts 56K Discussions
      • BiggerPockets Exclusive PRO Area 16K Posts 3.0K Discussions
      • Real Estate Not-So-Successful Stories 523 Posts 41 Discussions
      • BiggerPockets Summer Reading List 92 Posts 14 Discussions
      • Real Estate Quizzes 696 Posts 21 Discussions
      • BiggerPockets Money Podcast 675 Posts 50 Discussions
      • FAQ Forum 132 Posts 9 Discussions
      • BiggerPockets Webinar Discussion Forum 459 Posts 15 Discussions
      • Questions About BiggerPockets and Official Site Announcements 42K Posts 4.1K Discussions
      • Real Estate Success Stories 77K Posts 3.7K Discussions
    • General Real Estate
      • Buying & Selling Real Estate Discussion 424K Posts 58K Discussions
      • Renters Discussion 44K Posts 5.1K Discussions
      • Construction & Remodeling Diaries 6.1K Posts 1.0K Discussions
      • Do it Yourself 32K Posts 3.5K Discussions
      • Military Investing 5.4K Posts 532 Discussions
      • Get Foreclosure Help - Stop Foreclosure Forum 6.6K Posts 910 Discussions
      • Home Owner Association (HOA) Issues & Problems Forum 6.2K Posts 910 Discussions
      • Completed Deal Diaries 5.8K Posts 2.0K Discussions
      • Investor Deal Diaries 17K Posts 862 Discussions
    • Reviews & Feedback
      • Ask About A Real Estate Company 24K Posts 2.7K Discussions
      • Real Estate Deal Analysis and Advice 131K Posts 19K Discussions
      • Real Estate Guru, Book & Course Reviews and Discussions 28K Posts 2.9K Discussions
    • Investor Basics
      • Starting Out 291K Posts 42K Discussions
      • Real Estate Investor Marketing Help & Advice 46K Posts 6.5K Discussions
      • General Real Estate Investing 145K Posts 19K Discussions
      • Investor Psychology 21K Posts 1.6K Discussions
    • Landlord & Tenant Forums
      • Landlord Forums & Rental Property Questions 359K Posts 39K Discussions
      • Mobile Homes & Mobile Home Park Investing 19K Posts 2.3K Discussions
    • Foreclosures
      • General Foreclosure & Pre-Foreclosure Forums 33K Posts 5.2K Discussions
      • HUD, VA, and Tax Sales 10K Posts 1.5K Discussions
      • REOs 17K Posts 2.2K Discussions
      • Short Sales Questions 17K Posts 2.1K Discussions
    • Real Estate Strategies
      • Real Estate Wholesaling Questions & Answers 137K Posts 18K Discussions
      • Tax Liens, Notes, Paper, & Cash Flows Discussion 34K Posts 3.9K Discussions
      • Rent to Own a.k.a. Lease Purchase, Lease Options 15K Posts 2.3K Discussions
      • Real Estate Development & New Home Construction 19K Posts 2.6K Discussions
      • Rehabbing and House Flipping 110K Posts 13K Discussions
      • Innovative Strategies 27K Posts 3.4K Discussions
      • Short-Term and Vacation Rental Discussion 22K Posts 2.0K Discussions
      • 1031 Exchanges 8.7K Posts 1.4K Discussions
    • Commercial Real Estate
      • Commercial Real Estate Investing Forum 36K Posts 4.8K Discussions
      • Multi-Family and Apartment Investing Forums 97K Posts 10K Discussions
    • Business Basics
      • Goals, Business Plans & Entities 26K Posts 3.5K Discussions
    • Real Estate Technology and the Internet
      • Real Estate Technology, Social Media & Blogging 16K Posts 2.3K Discussions
    • Loans, Mortgages, Credit Lines
      • Creative Real Estate Financing Forum 51K Posts 7.5K Discussions
      • Private Lending & Conventional Mortgage Advice 105K Posts 14K Discussions
      • Real Estate Crowdfunding Forums 5.6K Posts 384 Discussions
    • Financial, Tax, and Legal
      • Tax, Legal Issues, Contracts, Self-Directed IRA 100K Posts 15K Discussions
      • Property Insurance Questions & Discussions 11K Posts 1.8K Discussions
      • Personal Finance Forum 18K Posts 2.0K Discussions
    • Real Estate Professionals
      • Bankers, Lenders, and Mortgage Brokers 12K Posts 1.9K Discussions
      • Real Estate Agent Forums 47K Posts 7.1K Discussions
      • Contractors 18K Posts 3.7K Discussions
    • Real Estate Marketplace
      • Real Estate Events and Happenings 57K Posts 12K Discussions
      • Marketplace 227K Posts 88K Discussions
    • Off Topic
      • BiggerPockets Real Estate Investing Summit 2.0K Posts 107 Discussions
      • Off-Topic 43K Posts 5.3K Discussions
      • Housing News & Real Estate Market Discussions 15K Posts 1.8K Discussions
Start a Discussion

Free Property Analysis Worksheet

133 Replies

  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
Rotate Log in or sign up to reply
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
Joshua Dorkin
  • 16K posts
  • 5.0K votes

Joshua Dorkin
from Denver, Colorado

posted about 10 years ago

Michael Rogers of Chandler Properties provided the following Excel Worksheet for BiggerPockets to share with all of our members.

REI Property Analyzer

We hope you all find it comes in handy.

NOTE: If anyone else has their own worksheet that they'd like to share, please get in touch.

Account Closed
  • 290 posts
  • 10 votes

Account Closed

replied about 10 years ago

Ahhh...this is just what I need. Thank you.

Corey Smith
  • 79 posts
  • 23 votes

Corey Smith
from Houston, Texas

replied about 10 years ago

Thanks Josh! This is just what the Doctor ordered.

Stephanie Tautkus
  • 23 posts
  • 0 votes

Stephanie Tautkus
Real Estate Investor from Seligman, Arizona

replied about 10 years ago

I came to this forum looking for exactly this! Wow, what a great surprise!

Joshua Dorkin
  • 16K posts
  • 5.0K votes

Joshua Dorkin
from Denver, Colorado

replied about 10 years ago

I'm glad everyone is finding it helpful.

Josh Gaddy
  • 27 posts
  • 0 votes

Josh Gaddy
Real Estate Agent from Myrtle Beach, SC

replied about 10 years ago

This is great! Could you explain the depreciation portion to me? I put in a rental property that I am considering and It looked to cashflow until depreciation put it into the negatives. Is this a good thing. What is the real life scenario that plays out here?

Account Closed
  • 805 posts
  • 55 votes

Account Closed

replied about 10 years ago

Depreciation is a phantom deduction, it does not reduce your cash flow.

Barry Robbins
  • 25 posts
  • 13 votes

Barry Robbins
from Denver, Colorado

replied about 10 years ago

Hey Josh, to answer your question in more depth, you are allowed to depreciate your building (not the land) over a 27.5 year period. The advantage of this is that on paper it makes it so you look like you took a net loss when you really (hopefully) took a net gain. The IRS will give you a portion of your losses back. Lets say you make a net income of $2400 a year and your depreciation is $100,000 / 27.5 = $3636. It actually looks like you lost $1236 that year. The IRS will you give you back a nice chunk of this. If you start to make over $100,000 from your job and you are a part-time real estate investor, benefits like these will start to go away and they will go away completely at $150,000. However, those numbers are based on your "modified adjusted gross income" so if you contribute to your 401k or pre-tax medical plan it will look like you make less money.

Dave Toelkes
  • 1.7K posts
  • 761 votes

Dave Toelkes
Investor from Pawleys Island, South Carolina

replied about 10 years ago

Barry,

I think there is a better explanation.

Depreciation expense is how the IRS lets you recover the cost of the building that is supposedly wasting away. The depreciation expense is the IRS allowance for the portion of the building's value that has been eroded through use in a rental activity.

The depreciation expense is not an actual out of pocket expense, but it still offsets my net rental income making my taxable rental income even lower. lf the depreciation expense is greater than my net rental income, then I have net rental loss for tax purposes, even though the property may have generated a positive cash flow.

Provided I meet the income limitations, I am allowed to use my net passive losses to reduce the amount of income tax I might have to otherwise pay on my other ordinary income. If I don't meet the income limitations, I can save the net rental loss for next year and try again or wait until the property is sold to claim my net rental losses.

Barry Robbins
  • 25 posts
  • 13 votes

Barry Robbins
from Denver, Colorado

replied about 10 years ago

Thanks Dave, I do believe your explanation was more accurate and also augmented my explanation. I had inaccurately stated that on paper the depreciation makes it look like you took a net loss when you really took a net gain when this is not always the case. When you say you can "save them for next year and try again", do you mean by attempting to adjust your gross income to meet the requirements? If so, do the previous years combine to give you the total benefits that you would have received had you been eligible from the get go? Thanks.

Barry Robbins
  • 25 posts
  • 13 votes

Barry Robbins
from Denver, Colorado

replied about 10 years ago

I had a question of my own concerning this worksheet. What is the purpose of adding back the principal payments and why does it affect taxable net income? Does this change year by year depending on how much each mortgage payment is contributing to paying down the principal?

Michael Rogers
  • 279 posts
  • 146 votes

Michael Rogers
Certified Public Accountant from Chattanooga, Tennessee

replied about 10 years ago

Hey Barry,

The purpose of adding back the principal payments is that you are going from an analysis on a purely "cash flow" basis to a "Net Income" basis. The principal portion of your loan payment has no effect on net income; just the interest portion. Line 26 (Annual Debt Service) includes both interest and principal. The principal piece must be backed out to determine taxable net income.

Yes, the amount of principal being backed out should increase each year (assuming you have a standard amortizing loan).

I hope this helps.

Dave Toelkes
  • 1.7K posts
  • 761 votes

Dave Toelkes
Investor from Pawleys Island, South Carolina

replied about 10 years ago

Originally posted by Barry Robbins:
When you say you can "save them for next year and try again", do you mean by attempting to adjust your gross income to meet the requirements? If so, do the previous years combine to give you the total benefits that you would have received had you been eligible from the get go? Thanks.


The "them" I referred to seemed vague when I reread my post so I edited it for clarity. I am talking about the net rental loss that you could not use to reduce your other ordinary income because your income was too high.

Rental loss is a passive loss As a general rule, you can only use passive losses to offset passive income. The one exception to this rule is called a "net passive loss allowance". When your passive loss is from a real estate rental activity in which you actively participate, the IRS will allow you to use up to $25K in net rental losses to offset other ordinary (active) income, subject to income limitations.

If you have a net passive loss that you can not use, the loss is suspended and carried forward to the next tax year, where is it used to offset rental income, income from other passive income activities, and lastly other ordinary income if allowed within the income limits.

If you sell the property, any suspended passive losses can be taken in full without regard to the net passive loss allowance income limitations.

Did this help?

Michael backs out the principal contribution because it is not a deductible expense on your tax return. You have to pay it if you have an amortizing mortgage loan, and it does reduce your cash flow, but it is not counted as a deduction when computing your taxable rental income.

If you look closely at Michael's spreadsheet formulas, you may notice that the amount of principal he backs out is understated, making the taxable rental income slightly lower than it really is, or a taxable rental loss slightly higher than it really is.

This is not really a problem for a quick and dirty cash flow analysis because the number that is really important to you is the net cash flow before taxes. That number for a property you might be thinking about buying needs to be in your "ball park" of acceptable cash flow for you to even proceed further.

Yes, the principal portion of your amortizing loan annual debt service will change each year, as will most of the expenses you are allowed. Property taxes, insurance premiums, repair costs usually increase each year, but hopefully your rental income increased faster.

Angie Wiggins
  • 1 posts
  • 1 votes

Angie Wiggins

replied about 10 years ago

:D Thank you! Thank you! This spreadsheet is wonderful. I just joined BiggerPockets, and already, I am thrilled.

Jon Klaus
  • 8.6K posts
  • 3.9K votes

Jon Klaus
Investor from Garland, Texas

replied about 10 years ago

What a great tool! Thanks Michael and Joshua.

Danielle R
  • 9 posts
  • 0 votes

Danielle R
from SC

replied about 10 years ago

this was really helpful :)

Robin Singh
  • 9 posts
  • 0 votes

Robin Singh
from Union City, ca

replied about 10 years ago

Thanks for the spreadsheet. It is very helpful.

Marcus Lee
  • 17 posts
  • 0 votes

Marcus Lee
Real Estate Consultant from Centennial, Colorado

replied about 10 years ago

Question on the worksheet: If I just bought a duplex for 100K, closing costs of 5K, repairs 15K., 20K down-payment, How do put that into the Cost Information section? Do I just put 100K for Building Cost, 20K for Land cost (closing and repairs)?

Frances L.
  • 60 posts
  • 0 votes

Frances L.
Homeowner from Abington

replied almost 10 years ago

I tried to put my number in. It did not work so well in my situation.i have second mortgage.

Dave Toelkes
  • 1.7K posts
  • 761 votes

Dave Toelkes
Investor from Pawleys Island, South Carolina

replied almost 10 years ago

Originally posted by Marcus Lee:
Question on the worksheet: If I just bought a duplex for 100K, closing costs of 5K, repairs 15K., 20K down-payment, How do put that into the Cost Information section? Do I just put 100K for Building Cost, 20K for Land cost (closing and repairs)?


Marcus,

There are only a few fields on this spreadsheet you need to fill in,

For your example, enter $100K in the "Acquitision" cost field (highlighted in yellow).

Your $20K downpayment is 20% of your purchase price. If you will have an interest only loan, then go to the Loan Details section and enter 20% in the "Down Payment (%)" field under Interest Only 1st Balance, otherwise, enter 0% in this field..

If you will have an amortizing loan, enter 20% in the next column P&I 1st Balance. Then for the"Principal" enter $0 in the Interest Only 1st Balance column and enter $80000 in the P&I 1st Balance column. You also need to enter the annual interest Rate you are being charged on your financing.

In the Initial Cost of Investment section at the bottom left, enter $5000 for Closing Costs to Buy and $15000 for Cost of Additional Repairs

You are done.

Jack Fremont
  • 17 posts
  • 4 votes

Jack Fremont
Developer from Frederick, Maryland

replied almost 10 years ago

This is a very good basic worksheet. For a more sophisticated model that works with all forms of commercial real estate, try using [REMOVED]

It's not free ($39) but it is a whole lot cheaper than ARGUS.

Albert Alcala
  • 1 posts
  • 0 votes

Albert Alcala
Real Estate Investor from Los Angeles, California

replied almost 10 years ago

Thank you Joshua this is what I've been looking for. I appreciate it.

Craig Grella
  • 151 posts
  • 44 votes

Craig Grella
Commercial Real Estate Broker from Nashville, Tennessee

replied almost 10 years ago

Someone posted a comment about this not working for more mortgages.

For those with two or more mortgages you can use a weighted average for all the loans and enter them in as one payment. This will suffice, even if the terms are not the same, because you are analyzing on an as-is basis.

If you want to analyze out further, or work in present value analysis for weighing a choice between two investments, you might want to step up to a more sophisticated spreadsheet.

Dave Toelkes
  • 1.7K posts
  • 761 votes

Dave Toelkes
Investor from Pawleys Island, South Carolina

replied almost 10 years ago

Craig,

It appears that the spreadsheet does accomodate a first and second mortgage.

Account Closed
  • 21 posts
  • 0 votes

Account Closed

replied over 9 years ago

The depreciation expense is not an actual out of pocket expense, but it still offsets my net rental income making my taxable rental income even lower

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6

Related Discussions

  • MarketplaceFree Prospective Property Analysis Spread Sheet / WorksheetApr 16 2018, 07:23
  • Real Estate Success StoriesSuccesful House HackMay 12 2017, 09:43
  • Real Estate Deal Analysis and AdviceBuilding vs. Land CostsJun 12 2015, 09:54

Related Blog Posts & Podcasts

  • Due Diligence Gone Wrong: Lessons Learned from a Tragic TaleFeb 20 2019, 13:30
  • Doing Due Diligence on a 74-Unit Apartment Complex [Real-Life Example!]Feb 13 2019, 13:30
  • Rental Property Risks: Don’t Fall for These Shenanigans!Feb 19 2019, 10:00

Top Contributors

Dennis M.
Dennis M.
Erie, pa
9.29
Score
Will Gaston
Will Gaston
Columbia, SC
6.5
Score
Adam Scheetz
Adam Scheetz
Staten Island, NY
5.24
Score
Jaysen Medhurst
Jaysen Medhurst
Greenwich, CT
4.98
Score
Robert Leonard
Robert Leonard
NH
3.85
Score

Trending Discussions

  • YOUR biggest hurdle to buying an APARTMENT COMPLEX in 2019 is...
    58 Replies
  • LLC - Must have or nice to have?
    89 Replies
  • $15/Hour Illinois minimum wage
    48 Replies
  • Convincing tenants to use electronica payment
    41 Replies
  • California to make "Solar "mandatory for new Homes!!!!!!
    209 Replies
"
Close Thin

Create Lasting Wealth Through Real Estate

Join the millions of people achieving financial freedom through the power of real estate investing

Start here

Already have an account? Click here to log in

Log in Sign up

Log in

Forgot password?

If you signed up for BiggerPockets via Facebook, you can log in with just one click!

Log in with Facebook

Let's get started

We just need a few details to get you set up and ready to go!

Use your real name

Use at least 8 characters. Using a phrase of random words (like: paper Dog team blue) is secure and easy to remember.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.

Why create an account?

Receive a free digital download of The Ultimate Beginner's Guide to Real Estate Investing.

Connect with 1,000,000+ real estate investors!

Find local real estate meetups and events in your area.

Start analyzing real estate properties, we do the math for you.

It's free!

Explore

  • Membership
  • Community
  • Education
  • Marketplace
  • Tools
  • Perks
  • iOS App
  • Android App

Company

  • About Us
  • Press
  • Advertising
  • Careers
  • Stats
  • Contact Us

Important

  • Terms of Use
  • Rules
  • Privacy
  • FAQ

Social

  • Facebook
  • Twitter
  • Google+
  • YouTube
  • Instagram
© 2004-2019 BiggerPockets, LLC. All Rights Reserved.