Join our investing community

Detailed Holding Costs Excel File 2016-09-15

Detailed Holding Costs Excel File

  1. DaveA
    Hey guys,

    just thought id share this with you all.

    Runs through holding costs for year 1-15 for IPs.

    Majority formula based so use the front page for most of the cals.l If you want to add something particular in go to the IP Calulations Page and put it in under the year and correct spot. It will automatically calculate the value for the following year, so you will need to delete all the cells after that in the row if you want. Otherwise on the front page there is a once off expense which will only go for the year

    Using 06-07 tax rates and works out the tax liability for cgt in discount method.

    Only works for IO currently, thinking of the best way to do P&I

    PERSONAL USE ONLY. IF YOU WANT TO USE IT IN A BUSINESS/PERSONAL DISTRIBUTION PLEASE PM ME

    Any questions/quaries/mistakes pm me but its pretty straight forward. But some feedback would be great.

    Thanks to MichaelWhyte and Mark C (from SS) for the initial concepts.