combo function of adding %

jenn · External Since: May 30, 2006 Posts: 46

I have a dollar amount of $10 that gets 2.5 percent added to it each year.
How can I make the function to say ' in 8 years the amount will be ... ' if I
had 2.5% each year?

1 2 3 4 5 6 7 8
rate 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80%
$10.00 $10.28 $10.57 $10.86 $11.17 $11.48 $11.80 $12.13
$12.47

ryguy7272 · External Since: Dec 16, 2006 Posts: 60

This is a Future Value problem:
In any cell, enter this:
=FV(0.025,8,0,-1)

The '-' is to force the result to be positive. We assume $1 is going 'out'
(negative cash flow) and in the future we are getting money 'in' (positive
cash flow).

Google around for future value, present value, and cash flows.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

"jenn" wrote:

> I have a dollar amount of $10 that gets 2.5 percent added to it each year.
> How can I make the function to say ' in 8 years the amount will be ... ' if I
> had 2.5% each year?
>
> 1 2 3 4 5 6 7 8
> rate 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80%
> $10.00 $10.28 $10.57 $10.86 $11.17 $11.48 $11.80 $12.13
> $12.47
>

Ashish Mathur · External Since: May 21, 2005 Posts: 238

Hi,

=10*(1.025^ Cool

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jenn" <jenn.RemoveThis@discussions.microsoft.com> wrote in message
news:C5FCE1A3-C26A-4EBD-965F-1C843B3FCD58@microsoft.com...
> I have a dollar amount of $10 that gets 2.5 percent added to it each year.
> How can I make the function to say ' in 8 years the amount will be ... '
> if I
> had 2.5% each year?
>
> 1 2 3 4 5 6 7 8
> rate 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80%
> $10.00 $10.28 $10.57 $10.86 $11.17 $11.48 $11.80 $12.13
> $12.47
>