Results 1 to 1 of 1

Thread: My friend's lifetime cost to government in US (all levels inclusive) : around $15,088,992.94

Threaded View

  1. #1
    Join Date
    Feb 2009
    Location
    Vancouver, BC
    Posts
    106

    Default My friend's lifetime cost to government in US (all levels inclusive) : around $15,088,992.94

    My friend's lifetime cost to government in US (all levels inclusive) :


    Around $15,088,992.94

    The spreadsheet link is here:
    http://cbc.am/Total-cost-to-goverment.ods


    Here is my model to prove this

    (I used Open Office spreadsheet in 3d mode)

    Costs 1973-1989








    Education
    Yearly Correcting

    Administration
    System



    Medical
    Costs Total

    Indirect cost % 45.50% Inflation 4.55%


    Food Indirect plus System








    Rent Costs Indirect Costs for

    Monthly Monthly Monthly Monthly Monthly Monthly Monthly Yearly Yearly Costs Inflation
    Year Core Rent Subsidized Rent Rent Subsidy Food Medical Education Total Total Subtotal Subtotal Total
    1973 $520 $0 $0 $30 $78 $76 $184 $2,208 $3,213 $5,421 $5,667
    1974 $530 $0 $0 $31 $81 $79 $191 $2,292 $3,335 $5,627 $5,883
    1975 $540 $0 $0 $32 $84 $82 $198 $2,376 $3,457 $5,833 $6,098
    1976 $550 $0 $0 $33 $87 $85 $205 $2,460 $3,579 $6,039 $6,314
    1977 $560 $80 $480 $34 $90 $88 $692 $8,304 $12,082 $20,386 $21,314
    1978 $570 $90 $480 $35 $93 $91 $699 $8,388 $12,205 $20,593 $21,530
    1979 $580 $100 $480 $35 $96 $94 $705 $8,460 $12,309 $20,769 $21,714
    1980 $590 $110 $480 $40 $99 $97 $716 $8,592 $12,501 $21,093 $22,053
    1981 $600 $120 $480 $45 $102 $100 $727 $8,724 $12,693 $21,417 $22,392
    1982 $610 $130 $480 $50 $105 $103 $738 $8,856 $12,885 $21,741 $22,731
    1983 $620 $140 $480 $55 $108 $106 $749 $8,988 $13,078 $22,066 $23,070
    1984 $630 $150 $480 $60 $111 $109 $760 $9,120 $13,270 $22,390 $23,408
    1985 $640 $160 $480 $65 $114 $112 $771 $9,252 $13,462 $22,714 $23,747
    1986 $650 $170 $480 $70 $117 $115 $782 $9,384 $13,654 $23,038 $24,086
    1987 $660 $180 $480 $75 $120 $118 $793 $9,516 $13,846 $23,362 $24,425
    1988 $670 $190 $480 $80 $123 $121 $804 $9,648 $14,038 $23,686 $24,764
    1989 $680 $200 $480 $85 $126 $124 $815 $9,780 $14,230 $24,010 $25,102








    Total Total Total Total








    $126,348 $183,836 $310,184 $324,298
    Costs 1992-2009
















    Administration
    System

    College



    Correcting

    Indirect cost % 65.50% Inflation 4.55%
    and
    Food
    Indirect System






    University
    Rent Indirect Cost Costs for

    Monthly Monthly Monthly Monthly Monthly Monthly Monthly Yearly Yearly Corrected Inflation
    Year Core Rent Subsidized Rent Rent Subsidy Food Medical Education Total Total Total Total Total
    1993 $700 $130 $570 $80 $150 $27,812 $28,612 $343,344 $224,891 $568,234 $594,089
    1994 $710 $135 $575 $83 $160 $27,812 $28,630 $343,560 $225,032 $568,592 $594,464
    1995 $720 $140 $580 $86 $170 $27,812 $28,648 $343,776 $225,173 $568,950 $594,837
    1996 $730 $145 $585 $89 $180 $27,812 $28,666 $343,992 $225,315 $569,307 $595,211
    1997 $740 $150 $590 $92 $190 $77,018 $77,890 $934,677 $612,214 $1,546,891 $1,617,275
    1998 $750 $155 $595 $95 $200 $77,018 $77,908 $934,893 $612,356 $1,547,249 $1,617,650
    1999 $760 $160 $600 $98 $210 $77,018 $77,926 $935,109 $612,497 $1,547,607 $1,618,023
    2000 $770 $165 $605 $101 $220 $77,018 $77,944 $935,325 $612,639 $1,547,964 $1,618,397
    2001 $780 $170 $610 $104 $230 $77,018 $77,962 $935,541 $612,780 $1,548,322 $1,618,771
    2002 $790 $175 $615 $107 $240 $77,018 $77,980 $935,757 $612,922 $1,548,680 $1,619,145
    2003 $800 $180 $620 $110 $250 $77,018 $77,998 $935,973 $613,063 $1,549,037 $1,619,519
    2004 $810 $185 $625 $113 $260 $77,018 $78,016 $936,189 $613,204 $1,549,394 $1,619,892
    2005 $820 $190 $630 $116 $270 $0 $1,016 $12,192 $7,987 $20,179 $21,097
    2006 $830 $195 $635 $119 $280 $0 $1,034 $12,408 $8,128 $20,536 $21,471
    2007 $840 $200 $640 $122 $290 $0 $1,052 $12,624 $8,269 $20,893 $21,844
    2008 $850 $205 $645 $125 $300 $0 $1,070 $12,840 $8,411 $21,251 $22,219
    2009 $860 $210 $650 $128 $310 $0 $1,088 $13,056 $8,552 $21,608 $22,592








    Total Total Total Total








    $8,921,257 $5,843,431 $14,764,695 $15,436,496


    The spreadsheet model is still being worked on, but I don't know how to correct model into constant 2009 dollars.



    Total cost to government
    Notes



    Costs 1973-1989 $324,297.73 Sum total costs this time frame
    Costs 1993-2009 $14,764,695.21 Sum total costs this time frame
    Costs 2009-2042 $1,122,248.48 Sum total costs this time frame (projected)



    Subtotal historical to 2009 → $15,088,992.94
    Subtotal lifetime → $16,211,241.42



    Historical / Lifetime % diff 93.0773%



    Correction 1973-1989
    Correct for inflation, make constant dollars (2009)
    Correction 1993-2009
    Correct for inflation, make constant dollars (2009)



    Corrected 1973-1989

    Corrected 1993-2009




    Total →





    Last edited by billstew; 04-21-09 at 03:26 AM.

Similar Threads

  1. The Cost of Empire (11min.)
    By LargoWinch in forum Video
    Replies: 1
    Last Post: 03-10-09, 05:51 AM
  2. Replies: 1
    Last Post: 01-27-09, 02:00 PM
  3. the cost of the bailouts
    By jk in forum News
    Replies: 14
    Last Post: 12-04-08, 07:53 PM
  4. The Hidden Cost of War
    By LargoWinch in forum Video
    Replies: 0
    Last Post: 12-03-08, 11:22 PM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Opinions expressed herein are those of the posters, not those of iTulip, Inc., its owners, or management. All material posted on this board becomes the intellectual property of the poster and iTulip, Inc., and may not be reposted in full on another website without the express written permission of iTulip, Inc. By exception, the original registered iTulip member who authored a post may repost his or her own material on other sites. Permission is hereby granted to repost brief excerpts of material from this forum on other websites provided that attribution and a link to the source is included with the reposted material.

Nothing on this website is intended or should be construed as investment advice. It is intended to be used for informational and entertainment purposes only. We reserve the right to make changes, including change in price, content, description, terms, etc. at any time without notice. By using this board you agree that you understand the risks of trading, and are solely responsible for your own investment and trading decisions. Read full legal disclaimer.

Journalists are not permitted to contact iTulip members through this forum's email and personal messaging services without written permission from iTulip, Inc. Requests for permission may be made via Contact Us.

Objectionable posts may be reported to the board administrators via Contact Us.

-->