I want to calculate the amount of interest which would be earned over a

number of years. I will be starting with a base amount (say $25,000) which

will earn 8% interest compounded annually. I tried using the ACCRINTM

formula, but it isn't giving me the correct amount (which I figured out

manually).

My manual calculation showed that $25,000 earning 8% interest compounded

annually over 9 years would earn a total of $24,975 of interest. What

formula can I use to get Excel to do the calculation for me?

## Bookmarks