Compounding Interest

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Sorry
In A2 put =C1+500.......then copy down as far as needed.
HTH
Michael
 
that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year
 
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 -

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Running Balance in Access 1
Variance between two cells only if... 5
Vlookup and multiple data 5
Excel 2002: How to identify row of data ? 4
Subtract Min() from MAX() 2
in need of a formula 9
If 2
To find the same price in another sheet 2

Back
Top