Thanks:  0
Likes:  0

Thread: repeat discounting X amount of times

1. I can't figure out how to repeat a calculation X amount of times. Specifically, i want to discount 2,020 by 10% X amount of times. So it should look like this (if X=3):
((2,020-(1-.1))(1-.1))(1-.1)
which should equal 1472.58

any suggestions?

=2020*(1-i)^x

Where i = 10% and x = 3

3. Hi,

Are you sure you are applying the discount correctly?

Adam's suggestion is correct, but if you are using this in a financial calculation (IRR, NPV, etc.), you would use:

Amount/(1+rate)^number of periods

=2020/(1.1^3) = 1517.66.

I think you want Adam's answer, but this is another understanding of discount rates.

Bye,
Jay

4. On 2002-04-09 13:30, Jay Petrulis wrote:
Hi,

Are you sure you are applying the discount correctly?

Adam's suggestion is correct, but if you are using this in a financial calculation (IRR, NPV, etc.), you would use:

Amount/(1+rate)^number of periods

=2020/(1.1^3) = 1517.66.

I think you want Adam's answer, but this is another understanding of discount rates.

Bye,
Jay
My bet is that princesslisa is in retailing, and she's marking down her inventory.

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•