Prev: Hey Larkin? How about something new?
Next: The right box
From: Archimedes' Lever on 15 Jun 2010 15:03
On Tue, 15 Jun 2010 12:37:56 -0500, "amdx" <amdx(a)knology.net> 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?
>
There are interest compounding templates on MS' office web site.
From: mpm on 15 Jun 2010 15:29
On Jun 15, 12:37 pm, "amdx" <a...(a)knology.net> 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?

Excel has an Accrued Interest at Maturity function.
Seach Help for "ACCRINTM"




From: amdx on 15 Jun 2010 15:44

"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


From: Joerg on 15 Jun 2010 16:01
Tim Wescott wrote:
> 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.
>

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.
From: Archimedes' Lever on 15 Jun 2010 16:17
On Tue, 15 Jun 2010 13:01:06 -0700, Joerg <invalid(a)invalid.invalid>
wrote:

>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% :-))


Maybe his name is Madoff.
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: Hey Larkin? How about something new?
Next: The right box