Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

yearly distribution of an amount 1

Status
Not open for further replies.

deedar

Programmer
Aug 23, 2007
45
PK
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.
 
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]
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top