yearly distribution of an amount 1

[deedar]

I have an amount that I have to distribute over 3 years. Distribution needs to be such that there is an amount for Year 1, Year 2 amount will be 10% of Year 1 amount and Year 3 amount will be 10% of Year 2 amount.

An example is:
Cell D2 contains 3,310

I need to display the following in cells A2, B2 and C2:
A2 = 1,000
B2 = 1,100
C2 = 1,210

Right now, I am doing it with trial and error but it would be great and safe if Excel has any functionality for this.

 

[macropod]

Hi deedar,

Here's a formula you could use:
=PMT(0.1,3,-$D$2,0)/1.1^(4-ROW())
insert into A1 & copy down to A3.

Cheers

[MS MVP - Word]

 

[deedar]

Thanks a lot.

It worked perfectly in my scenario. Slightly modified the formula to display results in columns A, B and C:

Entered the following in A2:
=PMT(0.1,3,-$D2,0)/1.1^(4-COLUMN())

and copied to B2 and C2