billstew
04-01-09, 08:22 PM
<hr style="color: rgb(153, 255, 153);" size="1">Australia & NZ : 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 (Australia)
<table border="0" cellspacing="0" cols="4" frame="void" rules="none"> <colgroup><col width="111"><col width="357"><col width="112"><col width="333"></colgroup> <tbody> <tr> <td align="center" height="19" width="111">PROTOTYPE</td> <td align="left" width="357">Known Data</td> <td align="left" width="112">
</td> <td align="center" width="333">Notes & Sources</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Total Australian Population</td> <td sdval="22500100" sdnum="1033;0;#,##0" align="right">22,500,100</td> <td align="right">Millions of people via Australian Census Clock</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Australian Working Population</td> <td sdval="19125085" sdnum="1033;0;#,##0" align="right">19,125,085</td> <td align="right">Residents with tax generating income</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Australian Tax Paying Population</td> <td sdval="17021325.65" sdnum="1033;0;#,##0" align="right">17,021,326</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.11" sdnum="1033;0;0.00%" align="right">11.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">Australian Government Debt</td> <td sdval="7301010000" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,000</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">State Government Debt</td> <td sdval="7301010001" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,001</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Local Govt Debt (city, regional utility districts, etc)</td> <td sdval="7301010002" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,002</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Housing Debt</td> <td sdval="7301010003" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,003</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Credit Card Debt, Car Loan Debt etc...</td> <td sdval="7301010004" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,004</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Sector Debt</td> <td sdval="7301010005" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,005</td> <td align="right">Constant (2009) AUD</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="left">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (commercial, 5 years)</td> <td sdval="3102929252.125" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$3,102,929,252</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (consumer, 7 years)</td> <td sdval="11780179640.929" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$11,780,179,641</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (governmental, 20 years)</td> <td sdval="19931757302.73" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$19,931,757,303</td> <td align="right">Constant (2009) AUD</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="left">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Debt Total</td> <td sdval="78620926210.784" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$78,620,926,211</td> <td align="right">Constant (2009) AUD</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="3494.24785715548" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$3,494</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="4110.87983194762" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,111</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="4618.96610331194" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,619</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="9708.23533526309" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$9,708</td> <td align="right">Total owed per household (2.28 per House)</td> </tr> </tbody> </table>
Content and calculations thus far (NZ)
<table border="0" cellspacing="0" cols="4" frame="void" rules="none"> <colgroup><col width="109"><col width="354"><col width="116"><col width="331"></colgroup> <tbody> <tr> <td align="center" height="19" width="109">PROTOTYPE</td> <td align="left" width="354">Known Data</td> <td align="left" width="116">
</td> <td align="center" width="331">Notes & Sources</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Total NZ Population</td> <td sdval="4200123" sdnum="1033;0;#,##0" align="right">4,200,123</td> <td align="right">Millions of people via NZ Census Clock</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total NZ Working Population</td> <td sdval="3591105.165" sdnum="1033;0;#,##0" align="right">3,591,105</td> <td align="right">Residents with tax generating income</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total NZ Tax Paying Population</td> <td sdval="3192492.491685" sdnum="1033;0;#,##0" align="right">3,192,492</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.145" sdnum="1033;0;0.00%" align="right">14.50%</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.111" sdnum="1033;0;0.00%" align="right">11.10%</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.0425" sdnum="1033;0;0.00%" align="right">4.25%</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.081" sdnum="1033;0;0.00%" align="right">8.10%</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.072" sdnum="1033;0;0.00%" align="right">7.20%</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.151" sdnum="1033;0;0.00%" align="right">15.10%</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">NZ Government Debt</td> <td sdval="4301010000" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,000</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Local Govt Debt (city, regional utility districts, etc)</td> <td sdval="4301010002" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,002</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Housing Debt</td> <td sdval="4301010003" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,003</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Credit Card Debt, Car Loan Debt etc...</td> <td sdval="4301010004" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,004</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Sector Debt</td> <td sdval="4301010005" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,005</td> <td align="right">Constant (2009) NZD</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="left">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (commercial, 5 years)</td> <td sdval="1741909052.025" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$1,741,909,052</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (consumer, 7 years)</td> <td sdval="6713876615.74" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$6,713,876,616</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (governmental, 20 years)</td> <td sdval="7311717001.7" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,311,717,002</td> <td align="right">Constant (2009) NZD</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="left">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Debt Total</td> <td sdval="37272552683.465" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$37,272,552,683</td> <td align="right">Constant (2009) NZD</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="8874.15741954819" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$8,874</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="10379.1314848517" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$10,379</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="11675.063537516" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$11,675</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="24538.9590998411" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$24,539</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 (Australia)
<table border="0" cellspacing="0" cols="4" frame="void" rules="none"> <colgroup><col width="111"><col width="357"><col width="112"><col width="333"></colgroup> <tbody> <tr> <td align="center" height="19" width="111">PROTOTYPE</td> <td align="left" width="357">Known Data</td> <td align="left" width="112">
</td> <td align="center" width="333">Notes & Sources</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Total Australian Population</td> <td sdval="22500100" sdnum="1033;0;#,##0" align="right">22,500,100</td> <td align="right">Millions of people via Australian Census Clock</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Australian Working Population</td> <td sdval="19125085" sdnum="1033;0;#,##0" align="right">19,125,085</td> <td align="right">Residents with tax generating income</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total Australian Tax Paying Population</td> <td sdval="17021325.65" sdnum="1033;0;#,##0" align="right">17,021,326</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.11" sdnum="1033;0;0.00%" align="right">11.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">Australian Government Debt</td> <td sdval="7301010000" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,000</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">State Government Debt</td> <td sdval="7301010001" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,001</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Local Govt Debt (city, regional utility districts, etc)</td> <td sdval="7301010002" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,002</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Housing Debt</td> <td sdval="7301010003" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,003</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Credit Card Debt, Car Loan Debt etc...</td> <td sdval="7301010004" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,004</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Sector Debt</td> <td sdval="7301010005" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,301,010,005</td> <td align="right">Constant (2009) AUD</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="left">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (commercial, 5 years)</td> <td sdval="3102929252.125" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$3,102,929,252</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (consumer, 7 years)</td> <td sdval="11780179640.929" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$11,780,179,641</td> <td align="right">Constant (2009) AUD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (governmental, 20 years)</td> <td sdval="19931757302.73" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$19,931,757,303</td> <td align="right">Constant (2009) AUD</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="left">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Debt Total</td> <td sdval="78620926210.784" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$78,620,926,211</td> <td align="right">Constant (2009) AUD</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="3494.24785715548" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$3,494</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="4110.87983194762" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,111</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="4618.96610331194" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,619</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="9708.23533526309" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$9,708</td> <td align="right">Total owed per household (2.28 per House)</td> </tr> </tbody> </table>
Content and calculations thus far (NZ)
<table border="0" cellspacing="0" cols="4" frame="void" rules="none"> <colgroup><col width="109"><col width="354"><col width="116"><col width="331"></colgroup> <tbody> <tr> <td align="center" height="19" width="109">PROTOTYPE</td> <td align="left" width="354">Known Data</td> <td align="left" width="116">
</td> <td align="center" width="331">Notes & Sources</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Total NZ Population</td> <td sdval="4200123" sdnum="1033;0;#,##0" align="right">4,200,123</td> <td align="right">Millions of people via NZ Census Clock</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total NZ Working Population</td> <td sdval="3591105.165" sdnum="1033;0;#,##0" align="right">3,591,105</td> <td align="right">Residents with tax generating income</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total NZ Tax Paying Population</td> <td sdval="3192492.491685" sdnum="1033;0;#,##0" align="right">3,192,492</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.145" sdnum="1033;0;0.00%" align="right">14.50%</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.111" sdnum="1033;0;0.00%" align="right">11.10%</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.0425" sdnum="1033;0;0.00%" align="right">4.25%</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.081" sdnum="1033;0;0.00%" align="right">8.10%</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.072" sdnum="1033;0;0.00%" align="right">7.20%</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.151" sdnum="1033;0;0.00%" align="right">15.10%</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">NZ Government Debt</td> <td sdval="4301010000" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,000</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Local Govt Debt (city, regional utility districts, etc)</td> <td sdval="4301010002" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,002</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Housing Debt</td> <td sdval="4301010003" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,003</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Credit Card Debt, Car Loan Debt etc...</td> <td sdval="4301010004" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,004</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Commercial Sector Debt</td> <td sdval="4301010005" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,301,010,005</td> <td align="right">Constant (2009) NZD</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="left">
</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (commercial, 5 years)</td> <td sdval="1741909052.025" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$1,741,909,052</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (consumer, 7 years)</td> <td sdval="6713876615.74" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$6,713,876,616</td> <td align="right">Constant (2009) NZD</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (governmental, 20 years)</td> <td sdval="7311717001.7" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$7,311,717,002</td> <td align="right">Constant (2009) NZD</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="left">
</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Debt Total</td> <td sdval="37272552683.465" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$37,272,552,683</td> <td align="right">Constant (2009) NZD</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="8874.15741954819" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$8,874</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="10379.1314848517" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$10,379</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="11675.063537516" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$11,675</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="24538.9590998411" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$24,539</td> <td align="right">Total owed per household (2.28 per House)</td> </tr> </tbody> </table>