Compounding Interest
 

How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =

Hi Jason
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
"Jason" wrote:

How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =

that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than
add B.500, and then A+B+4%, and so on

"Michael" wrote:

Hi Jason
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
"Jason" wrote:

How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =

Sorry
In A2 put =C1+500.......then copy down as far as needed.
HTH
Michael

"Jason" wrote:

that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than
add B.500, and then A+B+4%, and so on

"Michael" wrote:

Hi Jason
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
"Jason" wrote:

How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =

that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year


"Michael" wrote:

Sorry
In A2 put =C1+500.......then copy down as far as needed.
HTH
Michael

"Jason" wrote:

that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than
add B.500, and then A+B+4%, and so on

"Michael" wrote:

Hi Jason
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
"Jason" wrote:

How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =

Jason
You did ask for 4% each month in you initial post !!
In C1 put =A1*1.0033333 and copy down
after 30 years you will have $348,178.96

HTH
Michael

"Jason" wrote:

that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year


"Michael" wrote:

Sorry
In A2 put =C1+500.......then copy down as far as needed.
HTH
Michael

"Jason" wrote:

that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than
add B.500, and then A+B+4%, and so on

"Michael" wrote:

Hi Jason
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
"Jason" wrote:

How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =

Jason -

Look at the function FV() in Excel's help file.

Enter your payments as negatives (outflows) and you'll get a positive number
as the result.

Duke

"Jason" wrote:

that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year


"Michael" wrote:

Sorry
In A2 put =C1+500.......then copy down as far as needed.
HTH
Michael

"Jason" wrote:

that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than
add B.500, and then A+B+4%, and so on

"Michael" wrote:

Hi Jason
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
"Jason" wrote:

How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =