Cant give you a spreadsheet but can tell you owning a 2013 Alpi Pioneer Rotax 912ULS and flying around 200 hours a year ends up costing us around $70 ish hour all up including rego, licences, hanger rent $180 pm and that's wet with all servicing cost and any replacement parts so far. This does not include opportunity cost of the money, as to me that's not what life is about... some opportunities don't need measurement
You will never be able to justify buying your own aircraft based on $ alone... just like boats, houses and snow chalets, it always works out cheaper in groups...
But what you cant measure is the fact, if i feel like going flying anytime I can, I dont have too book ever, I can fly it at all the popular times, when club or shared aircraft are in demand... Take a flyin for example,good luck getting a club plane for that....
The other big plus of your own aircraft, is I know exactly every time its had even the slightest of rough landings, every time the temp has got warm and every time its had a wash etc... there are no unknowns...that's a big plus if you start flying any distance or over tiger country etc...
It scares me the way some club aircraft get landed and then the next person hops in none the wiser....
These are all the things you cant put a $ figure on....
At the end of the day you either want one or you dont... if you really want one you will find a way to afford it...and make sacrifices elsewhere...