The Entrepreneur Forum | Startups | Entrepreneurship | Starting a Business | Motivation | Success

REAL ESTATE Spreadsheet - Analyzing a deal

bosco

New Contributor
Dec 31, 2007
60
6
17
I was wondering if anyone had a spreadsheet they use to analyze deals. I would like to build one to help me when looking for rental units to purchase. I have some that I built carying costs and rehab, etc but am more interested in analyzing what price to purchase at. Basically what is the best way to arrive at a price to make offers at.

Can any one offer suggestions or share what you may use for this?
 

Don't like ads? Remove them while supporting the forum. Subscribe.

AroundTheWorld

Be in the Moment
Speedway Pass
Jul 24, 2007
2,909
1,867
550
.
I don't have a spreadsheet for this, but I have a quick comment.

The asking price has nothing to do with what it is worth to you. Look at the market in the area, rental rates, demographics, etc. But not asking price. Once you get to the end - - - you have decided what that property is worth to you - - - then compare that number to asking price - - but not before.

Particularly in todays market, the asking price doesn't mean much. Many sellers today will be quite flexible.
 

rcardin

Contributor
Oct 30, 2007
512
46
32
Arlington, TX
Here is a deal evaluator worksheet that my dad uses to buy his properties. I am not an expert in Excel by any means so I can't really explain it. Also attached is a cost to sell spreadsheet. Helps when you are buying subject to properties.
 

JScott

Legendary Contributor
EPIC CONTRIBUTOR
FASTLANE INSIDER
Speedway Pass
Aug 24, 2007
4,122
7,586
1,731
I posted a spreadsheet last year at some point that you can probably dig up, but I would highly recommend that you create one yourself instead of just trying to find an existing one.

I spent several weeks putting mine together (thanks to a lot of good input from others on this forum), and the exercise was priceless. By the time I was finished, I fully grasped all the concepts around financial analysis of properties, and was well on my way to understanding how each of the components contributed to the overall values of real estate investments.

Give it a try, and feel free to post it here to get feedback and suggestions.
 
OP
OP
B

bosco

New Contributor
Dec 31, 2007
60
6
17
Thanks everyone. In the end, my goal is to assemble my own sheet. I wanted to see the info that others were looking at. I guess I could have asked the question better.

During the day, I work for a commercial property management company. We look at things in a whole idfferent perspective (like costs per square foot, etc). So I know in the end what I'd like to accomplish but not sure what info is pertinent.

Thanks again for eveyones help. you are very generous.
 

Jito

New Contributor
Dec 2, 2007
147
8
21
Bay Area
Rcardin, thanks for that spreadsheet. I'm a bit of a budding excel nerd, so its always fun to have something to play around with. My question is, what in the world did investors do before the advent of spreadsheets? I certainly don't have the patience to do this stuff by hand...
 

bflbob

Bronze Contributor
Read Millionaire Fastlane
Speedway Pass
Jul 25, 2007
1,906
373
142
Endicott, New York, United States
Rcardin, thanks for that spreadsheet. I'm a bit of a budding excel nerd, so its always fun to have something to play around with. My question is, what in the world did investors do before the advent of spreadsheets? I certainly don't have the patience to do this stuff by hand...
Spreadsheets have been around for a long time!
It's just the computerized versions that are new.

Our CFO talks about the "good old days" when the auditors would tape a mess of accounting spreadsheets together on our conference table.

Everything was filled in with pencils, and the cross-checking began!

Thank goodness I never had to deal with that very much.:thankyousign:
 

ChrisS417

New Contributor
Sep 24, 2007
81
10
27
33
St. Louis, MO
Here are two spreadsheets that my brokerage uses for 4 families.

This one is a five year analysis.

And this is a one year analysis

One of the agents in the office made them. Just fill in the red or orange numbers and it spits out cap rate, cash on cash return, cashflow, etc.
 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.


Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Monthly conference calls with doers
Ideas needing execution, more!

Join Fastlane Insiders.

Sponsored Offers

  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
I really enjoyed the course actually. It's exactly what's needed to set off in the part-time freelancing direction. Taken a few courses before...
Replies
19
Views
1,002
Top Bottom