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…
[email protected]PropertyGuruParticipant@propertyguruJoin Date: 2003Post Count: 1,502
Can you please email me.
PropertyGuruParticipant@propertyguruJoin Date: 2003Post Count: 1,502
It’s Cool Kevin,
[^][^][^]Fudge111Broz00Participant@fudge111broz00Join Date: 2003Post Count: 245
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.
Yep its just a simple straight forward cash on cash calc…calronParticipant@calronJoin Date: 2003Post Count: 78spawlsMember@spawlsJoin Date: 2003Post Count: 3Mama2MiaParticipant@mama2miaJoin Date: 2003Post Count: 115Pebbles_2Member@pebbles_2Join Date: 2003Post Count: 37melbearMember@melbearJoin Date: 2003Post Count: 2,429
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.
MelsweetieMember@sweetieJoin Date: 2003Post Count: 26
Would love a copy please. Thanks in advance.
linda_lh_khoo at hotmail.com
lindaDevoMember@devoJoin Date: 2003Post Count: 28tbarrettMember@tbarrettJoin Date: 2003Post Count: 7
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 BarrettBigChurchParticipant@bigchurchJoin Date: 2003Post Count: 2p0sitiveCasHfl0wMember@p0sitivecashfl0wJoin Date: 2003Post Count: 133
I’d like one too please 
j_nejal at tpg dot com dot au
You must stay pOsitive
…then the cAsHfl0w will come!
**********************************EskapeMember@eskapeJoin Date: 2003Post Count: 17Chris.Participant@chris.Join Date: 2003Post Count: 4
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 : )