Re: Calculating ROI in Excel

H

hgrove

Rich wrote...
...
I am trying to find a function formula that will allow me to
calculate the annually compounded interest I will gain if I invest
$40 for ten years and have a total of $100,000 after the ten
year period. No payments are made during the period and the
compounded interest is added to the principal yearly.
Click to expand...

Read about the RATE function in online help. Note: unless you mean $4
PER MONTH over 10 years, your annual interest rate would be well ove
100%. Good luck finding any investments anywhere close to that level o
return
 

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

Saving for College 1
FV function 2
calculating the future value of a present value 2
mortgage payment calculation 12
Annuity Payments From A Present Amount 2
What will be Rate of Interest (ROI) ? 3
How do you calculate an interest only loan 2
Formula to calc. semi-annual int. only pmt. with balloon in 10 yr 2

Top