Real Estate
Sponsored by

Rental property cash flow calculation help

3,215 Views | 28 Replies | Last: 5 yr ago by Diggity
Aggie Athlete Involved
How long do you want to ignore this user?
AG
Hello - hopefully I didn't miss a thread on this already. Can you help me understand what I'm missing in my calc? I'm trying to build an excel model to calculate cash flow before taxes.
Thank you!!

Monthly:

Gross Rental Income (will assume to remove the 1 month fee for leasing it to new tenant)
- ~5% vacancy reserve (or just keep $ in reserve beforehand)
- ~10% management fee/or flat fee depending on which way I go
- Property Tax
- Property Insurance
- Maint./repairs reserve (what %/amt?)
- Flood insur.

Net Operating Income
- Capital Expense reserves %/amt?

Cash Flow from operations
- Financing Costs (mortgage)

= Cash Flow after financing


Other things TBD to get to taxable income, then cash flow after taxes:
-Deduct Interest Expense
-Deduct Depreciation expense
=Taxable income
-taxes
=Cash Flow after taxes

mwp02ag
How long do you want to ignore this user?
AG
I understand making your own but if you'd like one to use or to pull formulas from I have one that I got from a statewide hard money lender. Post your email and I'll send it.
evestor1
How long do you want to ignore this user?
evestor1@gmail.com

I would be interested in seeing it if possible
mwp02ag
How long do you want to ignore this user?
AG
sent
Back2Back
How long do you want to ignore this user?
AG
Thanks!
schwack schwack
How long do you want to ignore this user?
AG
Me, too, please.

craigs217@gmail.com
mwp02ag
How long do you want to ignore this user?
AG
Sure, sent to both.
Aggie Athlete Involved
How long do you want to ignore this user?
AG
Sorry for the delay

aggieathleteinvolved@gmail.com

Thanks!
BMach
How long do you want to ignore this user?
AG
I'd love to see it

Sbmachell@yahoo.com
TexaN792
How long do you want to ignore this user?
Same

sheath441@hotmail.com
RGRAg1/75
How long do you want to ignore this user?
AG
WestTxAg16
How long do you want to ignore this user?
AG
Interested as well.

cm.investments16 at gmail dot com
mforce
How long do you want to ignore this user?
AG
Also interested...

fcpppc5457@att.net
Diggity
How long do you want to ignore this user?
AG
guys, you can find these spreadsheets on about 100 different websites.
WestTxAg16
How long do you want to ignore this user?
AG
You're right - but why not see another? Might like it more.
Aggie Athlete Involved
How long do you want to ignore this user?
AG
Thanks again


What about good property management companies in Houston area?
itsyourboypookie
How long do you want to ignore this user?
I love all of y'all. Post it in the fb group roughneck 2 real estate
Boat Shoes
How long do you want to ignore this user?
AG
mwp02ag said:

I understand making your own but if you'd like one to use or to pull formulas from I have one that I got from a statewide hard money lender. Post your email and I'll send it.


Thanks!
Mmetag10
How long do you want to ignore this user?
AG
Can i get it too?
mmetag10@gmail.com

Thanks
scrap
How long do you want to ignore this user?
AG
Me as well please
scrap@austin.rr.com
mwp02ag
How long do you want to ignore this user?
AG
Will send it out in ASAP.
dout04
How long do you want to ignore this user?
AG
I'd love to see it too, please.

Dout04@gmail.com
fishngame06
How long do you want to ignore this user?
AG
Can I get in on this too?
curt.haveman at gmail dot com
Matsui
How long do you want to ignore this user?
AG
I'd like it too

Mattgid at yahoo dot com
mtony77
How long do you want to ignore this user?
AG
mtony77 @ hotmail

Thanks!
RoofingAg
How long do you want to ignore this user?
AG
Could I see too, please?

texag1020@gmail.com
Rustys-Beef-o-Reeno
How long do you want to ignore this user?
AG
Do you mind if I get one?

Rustsbeeforeeno
At gmail
aggiehunter3
How long do you want to ignore this user?
AG
I'd like to see this as well. Could someone forward to me?

clay.dickeson at

yahoo .com
mwp02ag
How long do you want to ignore this user?
AG
Ok all I will get it out to you all tonight, sorry its a crazy market and we're busy! Might I ask, what is the reason everyone keeps typing out the email address instead of just something that can be cut and pasted?
Diggity
How long do you want to ignore this user?
AG
they think it will somehow prevent spam
Refresh
Page 1 of 1
 
×
subscribe Verify your student status
See Subscription Benefits
Trial only available to users who have never subscribed or participated in a previous trial.