UK : Total Cumulative Debt Per Person (data needed) ...

[billstew]

UK : Total Cumulative Debt Per Person (data needed) ...

Source : http://hireme.geek.nz/US_Debt_Guesstimates.ods

RSVP :
mhev @ netzero.net (autoforwarded) 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="121"><col width="358"><col width="114"><col width="313"></colgroup> <tbody> <tr> <td align="center" height="19" width="121">PROTOTYPE</td> <td align="left" width="358">Known Data</td> <td align="left" width="114">
</td> <td align="center" width="313">Notes & Sources</td> </tr> <tr> <td align="left" height="19">
</td> <td align="left">Total UK Population</td> <td sdval="60900123" sdnum="1033;0;#,##0" align="right">60,900,123</td> <td align="right">Millions of people (UK Census 2006)</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total UK Working Population</td> <td sdval="52069605.165" sdnum="1033;0;#,##0" align="right">52,069,605</td> <td align="right">Residents with tax generating income</td> </tr> <tr> <td align="center" height="19">guesstimate</td> <td align="left">Total UK Tax Paying Population</td> <td sdval="46289878.991685" sdnum="1033;0;#,##0" align="right">46,289,879</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">UK Government Debt</td> <td sdval="24301010000" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$24,301,010,000</td> <td align="right">Constant (2009) UKP</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) UKP</td> </tr> <tr> <td align="center" height="19">estimate</td> <td align="left">Consumer Housing Debt</td> <td sdval="14301010003" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$14,301,010,003</td> <td align="right">Constant (2009) UKP</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) UKP</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) UKP</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) UKP</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (consumer, 7 years)</td> <td sdval="11753876615.74" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$11,753,876,616</td> <td align="right">Constant (2009) UKP</td> </tr> <tr> <td align="center" height="19">subtotals</td> <td align="left">Interest Incurred Debt (governmental, 20 years)</td> <td sdval="24311717001.7" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$24,311,717,002</td> <td align="right">Constant (2009) UKP</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="89312552683.465" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$89,312,552,683</td> <td align="right">Constant (2009) UKP</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="1466.54141705863" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$1,467</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="1715.25311936682" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$1,715</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="1929.41858196493" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$1,929</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="4055.30329810817" sdnum="1033;0;[$$-409]#,##0;[RED]-[$$-409]#,##0" align="right">$4,055</td> <td align="right">Total owed per household (2.28 per House)</td> </tr> </tbody> </table>

[vanvaley1]

Damn. Startin' to look like my grocery bill.

[Rajiv]

Your figures are incorrect see UK Government Debt & Deficit (http://www.statistics.gov.uk/cci/nugget.asp?ID=277)

At the end of December 2008, general government debt was £750.3 billion, equivalent to 52.0 per cent of GDP.

[billstew]

Your figures are incorrect see UK Government Debt & Deficit (http://www.statistics.gov.uk/cci/nugget.asp?ID=277)

Yes, that I knew before hand ... note the text PROTOTYPE in the corner. I should have made it red, but did not get around to it.

Still that is only government numbers ... personal and commercial debt are still missing from the data.

I am busy, so someone will need to do more chart filling out (and source listing) to allow me to make the fixes.

Total cumulative debt calculations often require lots of searching for numbers.