Agents Online Real Estate Forums, Discussion, Realtors Marketing Tips

Follow AgentsOnline on Twitter

Click Here to display our logo on your site and link to us!
AgentsOnline Real Estate Discussion Forums Logo

Topic Options
Rate This Topic
#318509 - 12/18/09 11:11 PM Cash Flow Analysis Worksheet - How is everyone running the numbers?
AREsource Offline
Member

Registered: 12/18/09
Posts: 12
Loc: G, lob, al
Hello and Welcome.

We joined this community in hopes to get some real estate questions answered as well as answer questions that we can assist with. Our first inquiries follow:

Q1. How are realtors and investors alike out there calculating what a good deal is to those that are not good deals?

Q2. Do you use a cash flow analysis worksheet?

Q3. If so, could you explain the process when running the numbers for a subject property?

Q4. Could you post your template cash flow analysis worksheet here for others learn from??


All valid responses will be taken and digested at our next focus group meeting next week.


Thank you in advance,

From the Members of Active Resources

-----
"Being a millionaire starts with a millionaire mindset."

"DST = Do Something Today!"

"Before success comes in any man's life, he's sure to meet with much temporary defeat and, perhaps some failures. When defeat overtakes a man, the easiest and the most logical thing to do is to quit. That's exactly what the majority of men do."

"Edison failed 10, 000 times before he made the electric light. Do not be discouraged if you fail a few times."

"Fears are nothing more than a state of mind."

Top
#318515 - 12/18/09 11:35 PM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: AREsource]
super realtor Offline
Major Contributor

Registered: 05/01/05
Posts: 7202
Loc: georgia
Actual numbers give for a deal have to be verified through due diligence. Often times sellers paint rosy numbers are OMIT certain important information to the transaction.

If you are buying residential homes it is more cut and dry than commercial.

Top
#318863 - 12/22/09 08:13 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: super realtor]
BusinessJohn Offline
Member

Registered: 11/04/09
Posts: 44
Loc: Northern Virginia
I find that new investors often overlook the actual cost of financing when they evaluate a deal. I look at a minimum of three different financing options when running my numbers to evaluate a deal. When running the number, I also account for an extended holding period - one that is greater than average DOM - in case the market shifts while I'm doing the deal and I have to sit on the property longer.
_________________________
Manassas House Deals
http://www.manassashousedeals.com

Top
#319199 - 12/25/09 09:17 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: BusinessJohn]
RealDealer Offline
Veteran Member

Registered: 10/29/04
Posts: 791
I like to keep it simple. A good deal consists of:

1. More income than outgo.
2. Net zero cash out of my pocket.
3. Little or no ongoing liability.

Top
#319495 - 12/29/09 02:34 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: BusinessJohn]
AREsource Offline
Member

Registered: 12/18/09
Posts: 12
Loc: G, lob, al
I like your method.
Not only is it simple in working through the numbers, which allows you to really absorb the details of the potential deal, but it also minimizes risk.
Clever.

We'll bring this one up at our next meeting.
Thanks!

Top
#319499 - 12/29/09 03:24 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: RealDealer]
AREsource Offline
Member

Registered: 12/18/09
Posts: 12
Loc: G, lob, al
Real Estate investing is not about keeping it simple. That's where many get burned. There are many factors that need to be taken under consideration and careful analysis before you go through with a deal.

In your outlined steps you forget to mention...

equity,
rent,
LTV (Loan-to-Value),
Cash-Out Refinance,
Cap rate,
Taxes,
and overall ROI

These are things that make a deal sweet or not if the numbers don't work out to your advantage, or at the very least to everyone's advantage in the transaction.

Top
#319528 - 12/29/09 01:19 PM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: AREsource]
RealDealer Offline
Veteran Member

Registered: 10/29/04
Posts: 791
AREsource,

LTV and Refi ---> I don't use credit.
Cap rate and ROI ---> I don't use cash.
Equity ---> Always nice but not necessary.
Rent ---> Not relevant to my niche.
Taxes ---> Included in 'outgo'.

So those aren't necessarily 'the things that make a deal sweet or not'. You might need to consider them but in my niche I don't.

Top
#319533 - 12/29/09 01:49 PM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: RealDealer]
BrokerInfo Offline
Member

Registered: 03/30/08
Posts: 52
Loc: USA
OK, I'll bite... What niche is this??? Anyone?

Top
#319590 - 12/29/09 09:46 PM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: BrokerInfo]
barb43 Offline
Veteran Member

Registered: 07/31/08
Posts: 579
Loc: SW Okla
I'm an investor - and I remodel & manage my own rentals. For me, 2 big things to consider is 1) how hard is this one to get ready to rent? and 2) will I have fun doing it?

I don't buy properties I would be unwilling to live in or buy in neighborhoods I would not want my family to live in.

Not sure any of that is quantifiable.
_________________________
Remodeling houses & helping tenants get ahead in life since 1983. Licensed Realtor since 2005. Addicted to BPOs and working to expand.

LIMITATIONS: Until You Spread Your Wings, You'll Have No Idea How Far You Can Walk. - despair.com

Top
#319623 - 12/30/09 08:26 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: BrokerInfo]
RealDealer Offline
Veteran Member

Registered: 10/29/04
Posts: 791
Originally Posted By: BrokerInfo
OK, I'll bite... What niche is this??? Anyone?

Options.

Top
#319624 - 12/30/09 08:38 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: RealDealer]
Vermont Offline
Major Contributor

Registered: 04/12/08
Posts: 2498
Loc: Vermont's North-East Kingdom
Originally Posted By: RealDealer
Originally Posted By: BrokerInfo
OK, I'll bite... What niche is this??? Anyone?

Options.
Well then, wouldn't you say that the Purchase Price we pay for the Option (Put or Call) is the equivalent of "Rent" we pay for the right to participate in the movement (appreciation or depreciation) of the Subject Commodity or Stock for the stated life of the Option?

Seems to be analogous to Interest which is a diminishing asset that we pay to "Rent" someone else's money; or better yet - "Rent" that they pay me to use my money.
_________________________
Dale C. Hittle of GOLDEN RULE PROPERTIES in Glover, Vermont
Where We're Always Striving To Put Together "THE FAIR DEAL"

Top
#319645 - 12/30/09 10:27 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: RealDealer]
BrokerInfo Offline
Member

Registered: 03/30/08
Posts: 52
Loc: USA
That was the only thing that came to my mind (options that is), just thought I may be missing something. Probably am, many "somethings" in this world...


Edited by BrokerInfo (12/30/09 03:27 PM)

Top
#319717 - 12/30/09 07:00 PM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: BrokerInfo]
RealDealer Offline
Veteran Member

Registered: 10/29/04
Posts: 791
Vermont, that doesn't sound like something I would say, much too complicated wink

BrokerInfo, options are the only thing that come to my mind that fit the bill as well. I've done pretty much every kind of investing from traditional to creative and settled on options, specifically the option to buy and the option to rent, as my tool of choice for the reasons I pointed to...

1. Simple
2. Low risk
3. Flexible

And you can draft any kind of agreement in the form of an option, so you're not limited in the kind of deals you can put together.

I know far too many investors who complicate things no end, especially in the creative arena. Their ideas sound interesting but getting Joe Public to agree to them is a whole other story.

Top
#319935 - 01/02/10 12:09 AM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: RealDealer]
Viktor Offline
Veteran Member

Registered: 09/23/07
Posts: 861
Loc: Dallas, TX
I always run a CMA first and determine the ARV. I never take the highest. Try to determine the closing cost as much exact as you can. it will ever some difference, but I have always been a around $200 margin. I always extend the holding period with a month.
_________________________
Viktor Taushanov
William Davis Realty
Dallas, TX
http://homes4saleindallas.com
http://planorealty.blogspot.com
Viktor.RealtyBG@gmail.com
http://www.linkedin.com/in/viktortaushanov


I love referrals!

Top
#328001 - 02/22/10 08:11 PM Re: Cash Flow Analysis Worksheet - How is everyone running the numbers? [Re: Viktor]
VAInvestor Offline
Member

Registered: 01/13/09
Posts: 41
Loc: VA and NY
My 2 cents: Any half-decent investor I know (myself included) doesn't buy at market value - so 1) knowing your ARV (after-repair value) and knowing what % of that ARV max you want your cost basis to be at is crucial.

2) I don't care what you invest in, even if you buy options, you should know your cash on cash return. If you put your own money to work, you need to know how much that money earns you, on an annual basis and the total return when you sell the asset.

Top


Moderator:  Promise Land, RockSolid 
Newest Members
markobonol, olidublu, PaREO, RivaCom, happycaro2009
15957 Registered Users
Who's Online
31 registered (Brad, Badunkadunk, BPObigolly, AgentHolmes, Brad - W4BJM, 7 invisible), 71 Guests and 4 Spiders online.
Key: Admin, Global Mod, Mod
Search

Shout Box

Good Ideas
Nusetlock.com




BPO Automation




Realtor Websites




Sponsors

Top Posters (30 Days)
Pine 311
Doin' bpose 123
Vermont 114
super realtor 92
Grampa 85
Perky_REALTOR 82
....J~ 81
maui realtor 80
OverTheEdge 79
BoneFish 79
REODayton 77
TB in TX 76
ColoBroker 75
estatereal 74
PA Roadkill 70
Featured Member
Registered: 06/04/07
Posts: 771

How To Advertise Here


This site presented by RNC Internet Services