Using my spreadsheet would be fairly useless as it lists items I have bought, everyones will be different.
All you need to do is list all the items you have bought and all the items you need to, have two columns ( bought, to buy ) and put a value in each as appropriate.
total each column to get the expenditure so far and the expected expenditure.
total expend + expected to get the grand total.
Add in a sales column too if you want to show that separately.
I do something similar for all my cars.
I total costs (ex petrol/tax/ins ) and mileage and work out the cost per mile. My aim on all cars is to better 10 miles per £. so a car that costs me £100 should return 1000 miles. For example my galaxy has cost so far £4298, and has done 18,854 Miles giving a MP£ rating of 4.38 . There is "Value" in the asset though which means the probable MP£ when finished with the vehicle will be much closer to GOAL.
The only car that is not on this scheme is My sapphire, but Microsoft had not even launched Windows 95 when I got that... It's probably had £4K investment and done 90K so once it's on the road i will start fresh with a buy in figure...
The roadster will move on to this scheme too, the MP£ is never going to get near to 10 but the residual value is likely to heavily offset this if I ever sell.
TT
|