software

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?

=FV(8%, 9, 0, -25000)

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;mamquot; gt; wrote in message
...
gt;I want to calculate the amount of interest which would be earned over a
gt; number of years. I will be starting with a base amount (say $25,000)
gt; which
gt; will earn 8% interest compounded annually. I tried using the ACCRINTM
gt; formula, but it isn't giving me the correct amount (which I figured out
gt; manually).
gt;
gt; My manual calculation showed that $25,000 earning 8% interest compounded
gt; annually over 9 years would earn a total of $24,975 of interest. What
gt; formula can I use to get Excel to do the calculation for me?quot;mamquot; wrote:
gt; My manual calculation showed that $25,000 earning 8%
gt; interest compounded annually over 9 years would earn a
gt; total of $24,975 of interest. What formula can I use to
gt; get Excel to do the calculation for me?

=FV(8%, 9,, -25000) - 25000