Hi,

There is no simple function for this, but you should look at FV. A few
points - 12% per year as yearly payouts or as monthly payouts? Most things
are done on a monthly basis. 12% of that current years value or the ending
value? Is the 12% removed before the 9% is calculated or the reverse?


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Emma Hope" wrote:

Hi All,

I want to do the following, £100,000 grows at 9% per year, 12% per year is
paid out for 10 years, what is the final value?

I know i can build this up over a number of cells but this is a very small
part of a very large and complicated set of formulae, so i need a one cell
answer, please can anyone help.

Thanks
Emma