billstew
04-01-09, 08:01 PM
Canada : Total Cumulative Debt Per Person (data needed) ...
Source : http://hireme.geek.nz/US_Debt_Guesstimates.ods
RSVP :
mhev @ netzero.net (on autoforward) if you have numbers, or here is OK
Max Keiser, moral problems -- if you don't care about the numbers:
http://blip.tv/file/1943449
Content and calculations thus far
<table border="0" cellspacing="0" cols="4" frame="void" rules="none"> <colgroup><col width="110"><col width="352"><col width="117"><col width="328"></colgroup> <tbody> <tr> <td align="center" height="19" width="110">PROTOTYPE</td> <td align="left" width="352">Known Data</td> <td align="left" width="117">
</td> <td align="center" width="328">Notes & Sources</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Total Canadian Population</td> <td sdval="32500100" sdnum="1033;0;#,##0" align="right">32,500,100</td> <td align="right">Millions of people via Canadian Census Clock</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Canadian Working Population</td> <td sdval="27625085" sdnum="1033;0;#,##0" align="right">27,625,085</td> <td align="right">Residents with tax generating income</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Canadian Tax Paying Population</td> <td sdval="24310074.8" sdnum="1033;0;#,##0" align="right">24,310,075</td> <td align="right">Residents “taxes > govt resources used”</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Removal Working Population from % pop</td> <td sdval="0.15" sdnum="1033;0;0.00%" align="right">15.00%</td> <td align="right">Remove children, elderly & poor</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Removal non-Tax Paying Pop from % Working Pop</td> <td sdval="0.12" sdnum="1033;0;0.00%" align="right">12.00%</td> <td align="right">Remove nominal tax payers</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Governmental Interest Rate Average</td> <td sdval="0.0455" sdnum="1033;0;0.00%" align="right">4.55%</td> <td align="right">Guesstimate</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Interest Rate Average (non CC)</td> <td sdval="0.085" sdnum="1033;0;0.00%" align="right">8.50%</td> <td align="right">Guesstimate excluding Credit Cards</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Interest Rate Average, housing</td> <td sdval="0.075" sdnum="1033;0;0.00%" align="right">7.50%</td> <td align="right">Guesstimate</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Interest Rate Average, non housing</td> <td sdval="0.1555" sdnum="1033;0;0.00%" align="right">15.55%</td> <td align="right">Guesstimate, mainly for credit cards</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;#,##0" align="left">
</td> <td align="left">
</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Canadian Federal Government Debt</td> <td sdval="5301010000" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,000</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Provincial Government Debt</td> <td sdval="5301010001" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,001</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Local Govt Debt (city, regional utility districts, etc)</td> <td sdval="5301010002" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,002</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Housing Debt</td> <td sdval="5301010003" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,003</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Credit Card Debt, Car Loan Debt etc...</td> <td sdval="5301010004" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,004</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Sector Debt</td> <td sdval="5301010005" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,005</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (commercial, 5 years)</td> <td sdval="2252929252.125" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$2,252,929,252</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (consumer, 7 years)</td> <td sdval="8553179640.929" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$8,553,179,641</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (governmental, 20 years)</td> <td sdval="14471757302.73" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$14,471,757,303</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Debt Total</td> <td sdval="57083926210.784" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$57,083,926,211</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Implied outcomes</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per person</td> <td sdval="1756.4230944146" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$1,756</td> <td align="right">What is owed per person</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per working person</td> <td sdval="2066.380111076" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$2,066</td> <td align="right">What is owed per working person</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per (working) tax paying person</td> <td sdval="2348.15921713182" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$2,348</td> <td align="right">What is owed per tax paying person</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per {Household} </td> <td sdval="4906.33779464391" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,906</td> <td align="right">Total owed per household (2.28 per House)</td> </tr> </tbody> </table>
Source : http://hireme.geek.nz/US_Debt_Guesstimates.ods
RSVP :
mhev @ netzero.net (on autoforward) if you have numbers, or here is OK
Max Keiser, moral problems -- if you don't care about the numbers:
http://blip.tv/file/1943449
Content and calculations thus far
<table border="0" cellspacing="0" cols="4" frame="void" rules="none"> <colgroup><col width="110"><col width="352"><col width="117"><col width="328"></colgroup> <tbody> <tr> <td align="center" height="19" width="110">PROTOTYPE</td> <td align="left" width="352">Known Data</td> <td align="left" width="117">
</td> <td align="center" width="328">Notes & Sources</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Total Canadian Population</td> <td sdval="32500100" sdnum="1033;0;#,##0" align="right">32,500,100</td> <td align="right">Millions of people via Canadian Census Clock</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Canadian Working Population</td> <td sdval="27625085" sdnum="1033;0;#,##0" align="right">27,625,085</td> <td align="right">Residents with tax generating income</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Canadian Tax Paying Population</td> <td sdval="24310074.8" sdnum="1033;0;#,##0" align="right">24,310,075</td> <td align="right">Residents “taxes > govt resources used”</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Removal Working Population from % pop</td> <td sdval="0.15" sdnum="1033;0;0.00%" align="right">15.00%</td> <td align="right">Remove children, elderly & poor</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Removal non-Tax Paying Pop from % Working Pop</td> <td sdval="0.12" sdnum="1033;0;0.00%" align="right">12.00%</td> <td align="right">Remove nominal tax payers</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Governmental Interest Rate Average</td> <td sdval="0.0455" sdnum="1033;0;0.00%" align="right">4.55%</td> <td align="right">Guesstimate</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Interest Rate Average (non CC)</td> <td sdval="0.085" sdnum="1033;0;0.00%" align="right">8.50%</td> <td align="right">Guesstimate excluding Credit Cards</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Interest Rate Average, housing</td> <td sdval="0.075" sdnum="1033;0;0.00%" align="right">7.50%</td> <td align="right">Guesstimate</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Interest Rate Average, non housing</td> <td sdval="0.1555" sdnum="1033;0;0.00%" align="right">15.55%</td> <td align="right">Guesstimate, mainly for credit cards</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;#,##0" align="left">
</td> <td align="left">
</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Canadian Federal Government Debt</td> <td sdval="5301010000" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,000</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Provincial Government Debt</td> <td sdval="5301010001" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,001</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Local Govt Debt (city, regional utility districts, etc)</td> <td sdval="5301010002" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,002</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Housing Debt</td> <td sdval="5301010003" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,003</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Credit Card Debt, Car Loan Debt etc...</td> <td sdval="5301010004" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,004</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Sector Debt</td> <td sdval="5301010005" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$5,301,010,005</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (commercial, 5 years)</td> <td sdval="2252929252.125" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$2,252,929,252</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (consumer, 7 years)</td> <td sdval="8553179640.929" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$8,553,179,641</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (governmental, 20 years)</td> <td sdval="14471757302.73" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$14,471,757,303</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Debt Total</td> <td sdval="57083926210.784" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$57,083,926,211</td> <td align="right">Constant (2009) CAD</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">
</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Implied outcomes</td> <td sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="left">
</td> <td align="right">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per person</td> <td sdval="1756.4230944146" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$1,756</td> <td align="right">What is owed per person</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per working person</td> <td sdval="2066.380111076" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$2,066</td> <td align="right">What is owed per working person</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per (working) tax paying person</td> <td sdval="2348.15921713182" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$2,348</td> <td align="right">What is owed per tax paying person</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Debt per {Household} </td> <td sdval="4906.33779464391" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,906</td> <td align="right">Total owed per household (2.28 per House)</td> </tr> </tbody> </table>