help with excel
in [Design]
|
From: Tim Wescott on 15 Jun 2010 16:19 On 06/15/2010 12:44 PM, amdx wrote: > "Tim Wescott"<tim(a)seemywebsite.now> wrote in message > news:K5-dnXgLtJzYW4rRnZ2dnUVZ_tudnZ2d(a)web-ster.com... >> On 06/15/2010 10:37 AM, amdx wrote: >>> "amdx"<amdx(a)knology.net> wrote in message >>> news:a8165$4c17abfe$18ec6dd7$32269(a)KNOLOGY.NET... >>>> I want to multiply all the numbers in column A by .07 and put the >>>> answers >>>> in column B. >>>> Then add all the numbers in B for total and put that in C1. >>>> I am at home but it's not homework. >>>> Mike >>> Thanks guys, I realized I didn't do what I wanted. >>> I have in column A1 thru A39 the SS taxes I paid. >>> I want to find the value of A1 compounded at 7% interest >>> over 39 years. >>> Then A2 compounded at 7% interest over 3 years, >>> and A3 compounded at 7% interest over 36 years, >>> etc. >>> Then I want add them all to find what the total as is if I had >>> put all my SS payments into an account earning 7% compounded annually. >>> Any help? >>> >>> >> >> present value this year = 1.07 * present value last year + this year's >> contribution. >> >> So, if you have the contributions in column A starting at A1, cell B1 >> would be '=A1', then cell B2 would be '=1.07 * B1 + A2', and you could >> copy cell B2 down through the rest of the sheet. >> >> If you're doing this to be pissed off at the government, you should at >> least be fair and keep in mind that an account that earns 7% interest in a >> 7% inflation year gains no real value it all -- i.e. you should depreciate >> past values by inflation. >> >> -- >> Tim Wescott >> Control system and signal processing consulting >> www.wescottdesign.com > > I'm just following thru with the numbers thought up by Bill Bowden > in the Hey Larkin, "how about something new" thread. He said the following, > "Yes, but if they paid in say $50,000 over 40 years, the investment > would double every 10 years at a 7% return. So, figuring the average > amount of $25,000 doubling every 10 years for 40 years you get > $400,000 and maybe 15k benefit which is less than a 5% return. Should > last forever. So, you probably won't get back what you paid in, unless you > paid very > little in, in which case you win the game." > But the battering effect inflation can have on the buying power of your SS > dollars > is important. I'll add that into the equation, after I find out where the > government has > put all the interest that I have been earning on my SS. :-) The rule of thumb is that if you have a chunk of money earning interest of x%, with x in the single digits, it'll double every 70/x years. That rule of thumb doesn't apply if there's money going in -- then you gotta do the math. -- Tim Wescott Control system and signal processing consulting www.wescottdesign.com
From: mpm on 15 Jun 2010 21:21 On Jun 15, 3:01 pm, Joerg <inva...(a)invalid.invalid> wrote: > Tim Wescott wrote: > > On 06/15/2010 10:37 AM, amdx wrote: > >> "amdx"<a...(a)knology.net> wrote in message > >>news:a8165$4c17abfe$18ec6dd7$32269(a)KNOLOGY.NET... > >>> I want to multiply all the numbers in column A by .07 and put the > >>> answers > >>> in column B. > >>> Then add all the numbers in B for total and put that in C1. > >>> I am at home but it's not homework. > >>> Mike > >> Thanks guys, I realized I didn't do what I wanted. > >> I have in column A1 thru A39 the SS taxes I paid. > >> I want to find the value of A1 compounded at 7% interest > >> over 39 years. > >> Then A2 compounded at 7% interest over 3 years, > >> and A3 compounded at 7% interest over 36 years, > >> etc. > >> Then I want add them all to find what the total as is if I had > >> put all my SS payments into an account earning 7% compounded annually. > >> Any help? > > > present value this year = 1.07 * present value last year + this year's > > contribution. > > > So, if you have the contributions in column A starting at A1, cell B1 > > would be '=A1', then cell B2 would be '=1.07 * B1 + A2', and you could > > copy cell B2 down through the rest of the sheet. > > > If you're doing this to be pissed off at the government, you should at > > least be fair and keep in mind that an account that earns 7% interest in > > a 7% inflation year gains no real value it all -- i.e. you should > > depreciate past values by inflation. > > Oh, and this here distinguished newsgroup would surely like to know > where to find a risk-free interest bearing account that will > consistently generate 7% :-)) > > Ok, social security ain't totally risk-free either, as evidenced by the > pushing up of retirement ages in many countries. Except maybe Greece but > I bet that's about to change ... > > Other than that I am with Tim, try this on an MS-Office spreadsheet. > Doesn't matter much which version. Even MS-Works has a compound interest > function and that software comes standard with many PCs. OpenOffice > might, check under "IMPT". > > -- > Regards, Joerg > > http://www.analogconsultants.com/ > > "gmail" domain blocked because of excessive spam. > Use another domain or send PM.- Hide quoted text - > > - Show quoted text - My, you're in a generous mood tonight. Somedays I'd settle for 0.7% (0.007), or at least anything in positive territory. :)
From: Robert Baer on 16 Jun 2010 04:13 amdx wrote: > I want to multiply all the numbers in column A by .07 and put the answers in > column B. > Then add all the numbers in B for total and put that in C1. > I am at home but it's not homework. > Mike > > Symple; put equation in B1 0.7*A1 and copy to B1..B999(whatever), then in C1 enter the equation =SUM(B1:B999) or whatever the last one is.
From: Archimedes' Lever on 16 Jun 2010 12:31 On Wed, 16 Jun 2010 01:13:27 -0700, Robert Baer <robertbaer(a)localnet.com> wrote: >amdx wrote: >> I want to multiply all the numbers in column A by .07 and put the answers in >> column B. >> Then add all the numbers in B for total and put that in C1. >> I am at home but it's not homework. >> Mike >> >> > Symple; put equation in B1 0.7*A1 and copy to B1..B999(whatever), >then in C1 enter the equation =SUM(B1:B999) or whatever the last one is. SUM(B:B) works just fine.
From: JosephKK on 18 Jun 2010 15:04
On Tue, 15 Jun 2010 14:44:04 -0500, "amdx" <amdx(a)knology.net> wrote: > >"Tim Wescott" <tim(a)seemywebsite.now> wrote in message >news:K5-dnXgLtJzYW4rRnZ2dnUVZ_tudnZ2d(a)web-ster.com... >> On 06/15/2010 10:37 AM, amdx wrote: >>> "amdx"<amdx(a)knology.net> wrote in message >>> news:a8165$4c17abfe$18ec6dd7$32269(a)KNOLOGY.NET... >>>> I want to multiply all the numbers in column A by .07 and put the >>>> answers >>>> in column B. >>>> Then add all the numbers in B for total and put that in C1. >>>> I am at home but it's not homework. >>>> Mike >>> Thanks guys, I realized I didn't do what I wanted. >>> I have in column A1 thru A39 the SS taxes I paid. >>> I want to find the value of A1 compounded at 7% interest >>> over 39 years. >>> Then A2 compounded at 7% interest over 3 years, >>> and A3 compounded at 7% interest over 36 years, >>> etc. >>> Then I want add them all to find what the total as is if I had >>> put all my SS payments into an account earning 7% compounded annually. >>> Any help? >>> >>> >> >> present value this year = 1.07 * present value last year + this year's >> contribution. >> >> So, if you have the contributions in column A starting at A1, cell B1 >> would be '=A1', then cell B2 would be '=1.07 * B1 + A2', and you could >> copy cell B2 down through the rest of the sheet. >> >> If you're doing this to be pissed off at the government, you should at >> least be fair and keep in mind that an account that earns 7% interest in a >> 7% inflation year gains no real value it all -- i.e. you should depreciate >> past values by inflation. >> >> -- >> Tim Wescott >> Control system and signal processing consulting >> www.wescottdesign.com > >I'm just following thru with the numbers thought up by Bill Bowden >in the Hey Larkin, "how about something new" thread. He said the following, >"Yes, but if they paid in say $50,000 over 40 years, the investment >would double every 10 years at a 7% return. So, figuring the average >amount of $25,000 doubling every 10 years for 40 years you get >$400,000 and maybe 15k benefit which is less than a 5% return. Should >last forever. So, you probably won't get back what you paid in, unless you >paid very >little in, in which case you win the game." > But the battering effect inflation can have on the buying power of your SS >dollars >is important. I'll add that into the equation, after I find out where the >government has >put all the interest that I have been earning on my SS. :-) > Mike > By the way, please see the Wikipedia article: http://en.wikipedia.org/wiki/Social_Security_%28United_States%29 Sources are as stated: this was built in OOo Calc and converted to formatted text: long lines mind the wrap, and the paste ruined the column alignments. Data before 1940 or after 2008 may not reflect reality. CPI base year is 1984. http://www.taxpolicycenter.org/taxfacts/content/pdf/ssrate_historical.pdf http://www.taxpolicycenter.org/taxfacts/displayafact.cfm?Docid=227 http://www.bls.gov/cpi/#data Table 24 year OASDI OADSI HI HI Max MC in CPI Rate ceiling Rate ceiling Contrib. const. $ annual 1935 2 3000 0 60 437.96 13.7 1936 2 3000 60 431.65 13.9 1937 2 3000 60 416.67 14.4 1938 2 3000 60 431.65 13.9 1940 2 3000 60 428.57 14 1941 2 3000 60 408.16 14.7 1942 2 3000 60 368.1 16.3 1943 2 3000 60 346.82 17.3 1944 2 3000 60 340.91 17.6 1945 2 3000 60 333.33 18 1946 2 3000 60 307.69 19.5 1947 2 3000 60 269.06 22.3 1948 2 3000 60 248.96 24.1 1949 2 3000 60 252.1 23.8 1950 3 3000 90 373.44 24.1 1951 3 3600 108 415.38 26 1952 3 3600 108 407.55 26.5 1953 3 3600 108 404.49 26.7 1954 4 3600 144 535.32 26.9 1955 4 4200 168 626.87 26.8 1956 4 4200 168 617.65 27.2 1957 4.5 4200 189 672.6 28.1 1958 4.5 4200 189 653.98 28.9 1959 5 4800 240 824.74 29.1 1960 6 4800 288 972.97 29.6 1961 6 4800 288 963.21 29.9 1962 6.26 4800 300.48 994.97 30.2 1963 7.16 4800 343.68 1123.14 30.6 1964 7.16 4,800.00 343.68 1108.65 31 1965 7.16 4,800.00 343.68 1091.05 31.5 1966 7.7 6,600.00 0.7 $6,600.00 554.4 1711.11 32.4 1967 7.8 6,600.00 1 $6,600.00 580.8 1738.92 33.4 1968 7.6 7,800.00 1.2 $7,800.00 686.4 1972.41 34.8 1969 8.4 7,800.00 1.2 $7,800.00 748.8 2040.33 36.7 1970 8.4 7,800.00 1.2 $7,800.00 748.8 1929.9 38.8 1971 9.2 7,800.00 1.2 $7,800.00 811.2 2002.96 40.5 1972 9.2 9,000.00 1.2 $9,000.00 936 2239.23 41.8 1973 9.7 10,800.00 2 $10,800.00 1263.6 2845.95 44.4 1974 9.9 13,200.00 1.8 $13,200.00 1544.4 3132.66 49.3 1975 9.9 14,100.00 1.8 $14,100.00 1649.7 3066.36 53.8 1976 9.9 15,300.00 1.8 $15,300.00 1790.1 3146.05 56.9 1977 9.9 16,500.00 1.8 $16,500.00 1930.5 3185.64 60.6 1978 10.1 $17,700.00 2 $17,700.00 2141.7 3284.82 65.2 1979 10.16 $22,900.00 2.1 $22,900.00 2807.54 3867.13 72.6 1980 10.16 $25,900.00 2.1 $25,900.00 3175.34 3853.57 82.4 1981 10.7 $29,700.00 2.6 $29,700.00 3950.1 4345.54 90.9 1982 10.8 $32,400.00 2.6 $32,400.00 4341.6 4499.07 96.5 1983 10.8 $35,700.00 2.6 $35,700.00 4783.8 4803.01 99.6 1984 11.4 $37,800.00 2.6 $37,800.00 5292 5093.36 103.9 1985 11.4 $39,600.00 2.7 $39,600.00 5583.6 5189.22 107.6 1986 11.4 $42,000.00 2.9 $42,000.00 6006 5479.93 109.6 1987 11.4 $43,800.00 2.9 $43,800.00 6263.4 5513.56 113.6 1988 12.12 $45,000.00 2.9 $45,000.00 6759 5713.44 118.3 1989 12.12 $48,000.00 2.9 $48,000.00 7209.6 5814.19 124 1990 12.4 $51,300.00 2.9 $51,300.00 7848.9 6005.28 130.7 1991 12.4 $53,400.00 2.9 $125,000.00 10246.6 7523.2 136.2 1992 12.4 $55,500.00 2.9 $130,200.00 10657.8 7596.44 140.3 1993 12.4 $57,600.00 2.9 $135,000.00 11057.4 7652.18 144.5 1994 12.4 $60,600.00 2.9 1,000,000.00 36514.4 24638.6 148.2 1995 12.4 $61,200.00 2.9 1,000,000.00 36588.8 24008.4 152.4 1996 12.4 $62,700.00 2.9 1,000,000.00 36774.8 23438.37 156.9 1997 12.4 $65,400.00 2.9 1,000,000.00 37109.6 23121.25 160.5 1998 12.4 $68,400.00 2.9 1,000,000.00 37481.6 22994.85 163 1999 12.4 $72,600.00 2.9 1,000,000.00 38002.4 22810.56 166.6 2000 12.4 $76,200.00 2.9 1,000,000.00 38448.8 22327.99 172.2 2001 12.4 $80,400.00 2.9 1,000,000.00 38969.6 22004.29 177.1 2002 12.4 $84,900.00 2.9 1,000,000.00 39527.6 21971.98 179.9 2003 12.4 $87,000.00 2.9 1,000,000.00 39788 21623.91 184 2004 12.4 $87,900.00 2.9 1,000,000.00 39899.6 21122.08 188.9 2005 12.4 $90,000.00 2.9 1,000,000.00 40160 20563.24 195.3 2006 12.4 $94,200.00 2.9 1,000,000.00 40680.8 20178.97 201.6 2007 12.4 $97,500.00 2.9 1,000,000.00 41090 19817.5 207.34 2008 12.4 $102,000.00 2.9 1,000,000.00 41648 19343.9 215.3 2009 12.4 $106,800.00 2.9 1,000,000.00 42243.2 19690.4 214.54 2010 12.4 $109,500.00 2.9 1,000,000.00 42578 2011 12.4 $114,000.00 2.9 1,000,000.00 43136 2012 12.4 $118,500.00 2.9 1,000,000.00 43694 |