All Topics / The Treasure Chest / Analysis Spreadsheet

Viewing 8 posts - 1 through 8 (of 8 total)
  • Profile photo of Graham1Graham1
    Member
    @graham1
    Join Date: 2003
    Post Count: 1

    Hi all,

    I have found this site looking on the net for some spreadsheets to help do some cashflow analysis etc on purchasing investment property. I enjoy working with spreadsheets, weird hey! I’m looking for a basic spreadsheet that will do some cashflow analysis on investment proporties based on investmetn models ie so I can enter in my income, value of investment property, rental income etc and find out the cashflow position, tax benefit etc.

    Can anyone help?
    Graham

    Profile photo of scratchmescratchme
    Member
    @scratchme
    Join Date: 2002
    Post Count: 56

    Hi Graham,

    I have nearly finished a spreedshet that does (i think) everything you are looking for.

    It is called APDM (Australian Property Decision Maker.) If you would like to test it with me I would be more than happy to let you use it, however it must be used on a “use at your own risk” basis.
    I developed it using openoffice calc. (Since it is free.) I will try and make a port to excel.

    OK let me work on it and I should have it finished by late tonight.

    *************
    APIM coming very soon …
    APDM coming soon …

    *************

    Profile photo of OzbrokerOzbroker
    Member
    @ozbroker
    Join Date: 2003
    Post Count: 16

    Hi APIM

    If you’re looking for people to beta test your spreadsheet, I’d be happy to participate.

    Warm regards and great investing..

    Profile photo of AdministratorAdministrator
    Keymaster
    @piadmin
    Join Date: 2013
    Post Count: 3,225

    quote:


    Hi APIM

    If you’re looking for people to beta test your spreadsheet, I’d be happy to participate.

    Warm regards and great investing..


    Ditto…

    Count me in if you’re looking for more beta testers…

    You can mail me on [email protected]

    Cheers,

    Graeme (Spelt the right way [;)])

    Profile photo of walkernickwalkernick
    Participant
    @walkernick
    Join Date: 2002
    Post Count: 68

    hey ppl,

    i have created a spreadsheet that does quite detailed analysis on a property’s profitability..

    includes cash on cash analysis, cashflow, interest only and p+I loans, etc.

    I would be interested in having a look at what other ppl have created and I’m happy to share my work. Shoot me a mail at [email protected] if anyone is interested in having a look

    cheers
    -nick

    Profile photo of Graham1Graham1
    Member
    @graham1
    Join Date: 2003
    Post Count: 1

    Happy to test your spreadsheets. I work on spreadsheets heavily in my job so I’m happy to help.

    Graham

    Profile photo of YoungGunYoungGun
    Member
    @younggun
    Join Date: 2003
    Post Count: 18

    I’d love to try them out too.

    I’ve tried to design my own, but theres always something missing (lack of knowledge I’m sure)

    Thanks

    [email protected]

    Always set your goals further than you can reach
    – Then stretch that little bit further

    Profile photo of scratchmescratchme
    Member
    @scratchme
    Join Date: 2002
    Post Count: 56

    OK here is the link http://www.apim.com.au/apdm.aspx

    You will find the download links at the bottom of the page.
    I have put an example in already so that you will know how it works.
    Report any bugs to [email protected]
    Enjoy!

    *************
    APIM coming very soon …
    APDM coming soon …

    *************

Viewing 8 posts - 1 through 8 (of 8 total)

The topic ‘Analysis Spreadsheet’ is closed to new replies.