- This topic has 5 replies, 4 voices, and was last updated 1 year, 9 months ago by .
-
Topic
-
Hi All,
We need to update our capital works 10 year plan [ we are a strata in NSW], we currently use a complex excel spreadsheet that is out of date.
Is there any software we could use to manage & record capital works programme, ideally recording past, current and planned works that calculates future capital levies etc., ?
thanks in advance
-
Replies
-
Inmyopinion, the calculation of the 10 year plan is an inexact science
Having disassembled a few professionally prepared plans , it surprises me of the simplicity of their method.
I believe they just use a spreadsheet
Getting a list of capital items is simple especially if you already have starting point.
Make a guess when they need to be replaced. Make a guess as to the replacement cost
Make guess for inflation
The 10 year CW plan is more for guidance than exactitude
As time passes you will find you have too much or too little money in the account. Make adjustments yearly to the levies.
Have a look at our sponsors Stratabox.com.au which has an interface which tracks proposed and actual expenditure in an easy-to-understand format
If you want to be alerted when anyone replies to your posts or responds to this topic, please register and login, then you will be able to subscribe to the topic. The opinions offered in these Forum posts and replies are not intended to be taken as legal advice. Readers with serious issues should consult experienced strata lawyers. NB: Longer threads may spill over to additional pages - look for the numbers on the bottom right, under the last post.
You can never have exact calculation for something you want to do in the future. When the time comes to do the job, you have to find a contractor to provide a quote. Everything in the capital works plan is a guess of what the work will cost (adjusted for inflation).
kaindub has the right idea. The capital works plan is simply a list of works you hope to complete in the next ten years. Beside each work, you guess how much it will cost. Since you won’t be doing everything in the next twelve months, you would assign some jobs for 2025, some for 2026, some for 2027 etc. The cost for jobs beyond 2025 have to be adjusted for inflation. Again, you have to guess the inflation rate.
I have already set up such a spreadsheet. next to each piece of work, I write the number 1, 2, 3 etc to show how many years into the future we want to do that work. That number helps me to adjust my cost for inflation one, two or three years away. Then I set up a second sheet to take a total of all the work I plan for each year. That would be a list of years 2025-2034 with how much we expect to spend.
I can adjust the estimated cost and the year I want to do the work. The capital works plan worksheet recalculates itself.
If you really want more info, I can explain the cell formulae in the spreadsheet.
I have already set up such a spreadsheet.
I know some very smart people for whom a spreadsheet might as well have been written in Klingon with an abacus interface. I would go with software that does all the work for you – after all, you may not be an officer of the strata committee forever.
If you want to be alerted when anyone replies to your posts or responds to this topic, please register and login, then you will be able to subscribe to the topic. The opinions offered in these Forum posts and replies are not intended to be taken as legal advice. Readers with serious issues should consult experienced strata lawyers. NB: Longer threads may spill over to additional pages - look for the numbers on the bottom right, under the last post.