Cash on Cash calculator….
After reading Steves book, Ive bumbled through one… in excel…
Its pretty raw and based on a few general assumptions but I hope it helps some of you… or can be modified/corrected for your own needs…If you would like a copy drop me an email and I can send it might make some of those calcs of +ve or or –ve a little easier…
Regards
Kelvin
[email protected]Hi Kevin,
Can you please email me.
Cheers
[
]It’s Cool Kevin,
Good work!
[^][^][^]
It’s not too bad Kelvin, but it fails to take tax into account, still it is a good rough indicator, and you are not restricted on your loan term like mine.
Fudge111[
]Yep its just a simple straight forward cash on cash calc…
Hey Kevin..
I would love to check it out too..
cheersCalron the Alcamist
Turning things into gold is fun.
[email protected][]I would love a copy also.
Please email to:
[email protected]
Thanks[]Kelvin
Agreed, I like the look of i. To make it simpler for yourself though, I would make the cells that are variable for the IO = to the same ones for the P&I. That way it saves inputting twice.
Fudge, you don’t need to add tax to this one – it’s just a matter of CoC Return. And tax is always different for everybody, so if you want it, it’s easy to add it in yourelf.
Cheers
MelHi Kelvin,
Would love a copy please. Thanks in advance.[
]linda_lh_khoo at hotmail.com
regards,
lindaHi Kelvin
Could I please get a copy of you CoCR calulator?
Thank you kindly
Cheers
SteveCash on cash calc now…. now MelBear enhanced… Thanks : )
Kelvin
[email protected]Kevin –
Can you advise what you have factored into the “closing costs” so I know what costs I am allowing for.
Also – does MelBear enhanced mean there is another version? Could you email it through.
Thanks – it’s a really useful tool.
Tim Barrett
I’d like one too please [
]j_nejal at tpg dot com dot au
Cheers,
Jay
**********************************
You must stay pOsitive
…then the cAsHfl0w will come!
**********************************Hi Kelvin,
I would like a copy of your CoCR calculator please
Take care
Robert
Veni, Vidi, Vici
Hi Kevin
please send me a copy
thanks
christbarrett
The closing costs are calculated by:
IF deposit is greater than or equal to 20% of purchase price then the closing cost Ive put down is 5%, if the deposit is less then its 2.5% of the purchase price…
Pretty general…but good for a rough guide.
BTW its Kelvin not kevin : )
Regards
Kelvin
[email protected]gday mate
just wondering if i could have a copythanking you in advance
thomas
[email protected]
]
]
]
]
You must be logged in to reply to this topic. If you don't have an account, you can register here.
