All Topics / General Property / Cash on Cash calculator….

Viewing 20 posts - 1 through 20 (of 51 total)
  • Profile photo of kelvinhkelvinh
    Member
    @kelvinh
    Join Date: 2003
    Post Count: 37

    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]

    Profile photo of PropertyGuruPropertyGuru
    Participant
    @propertyguru
    Join Date: 2003
    Post Count: 1,502

    Hi Kevin,

    Can you please email me.

    Cheers

    [:)]

    Profile photo of PropertyGuruPropertyGuru
    Participant
    @propertyguru
    Join Date: 2003
    Post Count: 1,502

    It’s Cool Kevin,

    Good work!

    [^][^][^]

    Profile photo of Fudge111Broz00Fudge111Broz00
    Participant
    @fudge111broz00
    Join Date: 2003
    Post 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.

    Fudge111[;)]

    Profile photo of kelvinhkelvinh
    Member
    @kelvinh
    Join Date: 2003
    Post Count: 37

    Yep its just a simple straight forward cash on cash calc…

    Profile photo of calroncalron
    Participant
    @calron
    Join Date: 2003
    Post Count: 78

    Hey Kevin..

    I would love to check it out too..
    cheers

    Calron the Alcamist
    Turning things into gold is fun.
    [email protected][;)]

    Profile photo of spawlsspawls
    Member
    @spawls
    Join Date: 2003
    Post Count: 3

    Kelvin could you please send us a copy.

    [email protected]

    Thanks a lot
    Steve

    Profile photo of Mama2MiaMama2Mia
    Participant
    @mama2mia
    Join Date: 2003
    Post Count: 115

    Hi Kelvin,

    Could you email me one too please [:)]

    [email protected]

    Thanks.

    Kim

    Profile photo of Pebbles_2Pebbles_2
    Member
    @pebbles_2
    Join Date: 2003
    Post Count: 37

    I would love a copy also.
    Please email to:
    [email protected]
    Thanks[8)]

    Profile photo of melbearmelbear
    Member
    @melbear
    Join Date: 2003
    Post Count: 2,429

    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
    Mel

    Profile photo of sweetiesweetie
    Member
    @sweetie
    Join Date: 2003
    Post Count: 26

    Hi Kelvin,

    Would love a copy please. Thanks in advance.[:)]

    linda_lh_khoo at hotmail.com

    regards,
    linda

    Profile photo of DevoDevo
    Member
    @devo
    Join Date: 2003
    Post Count: 28

    Hi Kelvin

    Could I please get a copy of you CoCR calulator?

    [email protected]

    Thank you kindly
    Cheers
    Steve

    Profile photo of kelvinhkelvinh
    Member
    @kelvinh
    Join Date: 2003
    Post Count: 37

    Cash on cash calc now…. now MelBear enhanced… Thanks : )

    Kelvin
    [email protected]

    Profile photo of tbarretttbarrett
    Member
    @tbarrett
    Join Date: 2003
    Post Count: 7

    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

    Profile photo of BigChurchBigChurch
    Participant
    @bigchurch
    Join Date: 2003
    Post Count: 2

    Hi Kelvin,

    I would like a copy of your CoC calculator.

    [email protected]

    Thanks
    Andrew[8D]

    Profile photo of p0sitiveCasHfl0wp0sitiveCasHfl0w
    Member
    @p0sitivecashfl0w
    Join Date: 2003
    Post Count: 133

    I’d like one too please [:D]

    j_nejal at tpg dot com dot au

    Cheers,

    Jay

    **********************************
    You must stay pOsitive
    …then the cAsHfl0w will come!
    **********************************

    Profile photo of EskapeEskape
    Member
    @eskape
    Join Date: 2003
    Post Count: 17

    Hi Kelvin,

    I would like a copy of your CoCR calculator please

    Take care

    Robert

    [email protected]

    Veni, Vidi, Vici

    Profile photo of Chris.Chris.
    Participant
    @chris.
    Join Date: 2003
    Post Count: 4

    Hi Kevin
    please send me a copy
    thanks
    chris

    [email protected]

    Profile photo of kelvinhkelvinh
    Member
    @kelvinh
    Join Date: 2003
    Post Count: 37

    tbarrett

    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]

    Profile photo of tlloydtlloyd
    Member
    @tlloyd
    Join Date: 2003
    Post Count: 7

    gday mate
    just wondering if i could have a copy

    thanking you in advance
    thomas
    [email protected]

Viewing 20 posts - 1 through 20 (of 51 total)

You must be logged in to reply to this topic. If you don't have an account, you can register here.