J
Jason
How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michael
Hi Jason
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
J
Jason
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
add B.500, and then A+B+4%, and so on
M
Michael
Sorry
In A2 put =C1+500.......then copy down as far as needed.
HTH
Michael
In A2 put =C1+500.......then copy down as far as needed.
HTH
Michael
J
Jason
that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year
M
Michael
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
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
D
Duke Carey
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
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