Compound Interest (growth rate) help needed

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

Guest

I want to have a function to help me with this problem. I want to input into a cell A1 a growth rate, say 100% per year, and have it give me in cell A2 what I need to grow each month. If I need to use more cells than this that is fine...thanks for the help. I can be reached at (e-mail address removed)
 
Hi Matthews01!

Use:

=(1+A1)^(1/12)-1

Or using the RATE function

=RATE(12,0,-1,1+A1,0,0)
 
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

Reduction in Growth 4
Impact of Fees on Growth Rate 1
Calculating Compounded Growth & the XIRR Function 4
Compound Interest Rate or Growth Rate 2
Compound Annual Growth Rate 2
Worksheet function--Compounded Growth Rate? 1
calculating compound growth 4
Compounded Interest Rates 1

Back
Top