Investment tracking sheet for doing up houses

[northernladuk]

Anyone got or seen a spreadsheet for the financial aspects of buying and doing up houses to sell but not actual build costs in detail? Something to track all costs such as mortgage, fees, interest for time to renovate though to sale, fees and tax giving an ROI in the end? It's more to find out how much potential profit, ROI and how much to budget for the build and so on rather than track the costs of the actual renovation.

Anyone seen anything like this?

[SteelyDan]

Anyone got or seen a spreadsheet for the financial aspects of buying and doing up houses to sell but not actual build costs in detail? Something to track all costs such as mortgage, fees, interest for time to renovate though to sale, fees and tax giving an ROI in the end? It's more to find out how much potential profit, ROI and how much to budget for the build and so on rather than track the costs of the actual renovation.

Anyone seen anything like this?

Have you tried searching?

[northernladuk]

Have you tried searching?

Goddamit, forgot the caveat on my original post. I have asked my accountant and it does appear I am not cut out for this.

All the ones I can find detail the actual costs of the build. I want to know ROI rather than track costs.

[darrylmg]

Just get a spreadsheet for building a house, then take off the costs of digging the hole and that should be about right.

I'm assuming you need it to cover every possibility, like needing walls repaired, sewerage repairs etc.

[northernladuk]

Just get a spreadsheet for building a house, then take off the costs of digging the hole and that should be about right.

I'm assuming you need it to cover every possibility, like needing walls repaired, sewerage repairs etc.

It's not going to be that level. Just light renovation with a contingency for a damp. Not going for a full rebuild.

The ones that factor in the actual cost of building don't go in to detail about cost to get mortgage, interest cost and tax implications after. They are more like budget trackers rather than ROI type things. Just wanted to make sure there weren't other factors I had missed. So many people talk about buy for 100, spend 20 sell for 140 and its 20k profit which is so far from the truth of the matter.

[ASB]

Its not really relevant to your question, but consider repairs. Eg replacing windows with dg is a repair. As such it is chargeable against Income. However if it is done before letting then it is simply part of the capital cost. There is info on hmrc as to what is repairs not improvements.