Spreadsheet - Analyzing a deal

[bosco]

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?

 

Dislike ads? Remove them and support the forum: Subscribe to Fastlane Insiders.

[AroundTheWorld]

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]

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.

 

[bosco]

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.

 

Dislike ads? Remove them and support the forum: Subscribe to Fastlane Insiders.

[Jito]

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]

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]

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.

 

Dislike ads? Remove them and support the forum: Subscribe to Fastlane Insiders.