1
$\begingroup$

I have a base value of 100 and I apply a +10% and a + 7% increase to it. To get the calculated value, I do:

100 * 1.1 = 110
110 * 1.07 = 107

100 + 10 + 7 = 117

Now, to get back to 117, I was initially doing:

117 / 1.1 = 106.363636363636

106.363636363636 / 1.07 = 99.4052676295664 which is obviously not the original value of 100.

I then realized that I needed to apply the calculations in reverse order in which they were applied to get back to the original value, so:

117 / 1.07 = 110
110 / 1.1 = 100

Is there a way to do it so I get back to my original value (100 in this case) from 117 by going in the same order I used to get to 117 (that is, applying 10% first and then 7%

Here is a more detailed example which I calculated already and it appears to be correct, but I just want to make sure, so here is the setup:

My base value is 100 and I have a +10% and +7% compounded percentages and I have a +5% and +3% non-compounded perntages, so to first get my adjusted value, I do:

I have a variable adjustedValue which I will use to store the variables along the way, it is intially set to the total (100).

adjustedTotal = adjustedTotal * 1.1 = 110

adjustedTotal = adjustedTotal * 1.07 = 117.7

adjustedTotal = adjustedTotal + (value * 0.05) = 117.7 + 5 = 122.7

adjustedTotal = adjustedTotal + (value * 0.03) = 122.7 + 3 = 125.7

To get back to 100 from 125.7, I do:

adjustedTotal = adjustedTotal - (value * 0.03) = 125.7 - 3 = 122.7

adjustedTotal = adjustedTotal - (value * 0.05) = 122.7 + 5 = 117.7

adjustedTotal = adjustedTotal / 1.07 = 110

adjustedTotal = adjustedTotal / 1.1 = 100

Is the above the correct way to approach it?

The example below uses a base of 1000 and 3 rates (10%, 5%, and 3%).

If 10%, 5%, and 3% are compounded and they are all added to the base, I do:

1000 * 1.1 * 1.05 * 1.03 = 1189.65

To get back to 1000 from 1189.65, I do:

1189.65 / 1.1 / 1.05 / 1.03

If 10%, 5%, and 3% are non-compounded and they are all added to the base, I do:

1000 * (1 + 0.1 + 0.05 + 0.03) = 1180

To get back to 1000 from 1180, I do:

1180 / (1 + 0.1 + 0.05 + 0.03)

All of the above is well and works fine, the problem is when I need to mix and add rates, for example:

Assume I stick with my base of 1000, but my rates are all non-compounded and they are added and subtracted, hence(+10%, -5%, +3%). I know I can do this:

1000 * (1 + 0.1 - 0.05 + 0.03) = 1080 and to get back I do:

1080 / (1 + 0.1 - 0.05 + 0.03) = 1000

In the above, the confusing part to me is that no matter if I go up or down with the rates, will I always use division, basically, will I always do:

1080 / (1 + 0.1 - 0.05 + 0.03) and just change the signs in the parentheses. Here is an example:

1000 * (1 - 0.1 - 0.05 - 0.03) = 820

820 / (1 - 0.1 - 0.05 - 0.03) = 1000

In the above, will it always be 820 / ... when going backwards or will it ever be 820 * ...

  • 0
    Ok, Willie, I will take note of that. I was thinking that the other questions got lost in translation because I hardly saw any activity.2011-04-18

1 Answers 1

3

Suppose that there is a highway that goes from Los Angeles to San Francisco, then to Portland, then to Seattle. You have travelled on that highway from Los Angeles, through San Francisco and Portland. Schematically, LA to SF to P to S. To get back to LA, you need to visit your previous cities in reverse order, S to P to SF to LA. Roughly speaking that is why you have found that the "undoing" has to be done in reverse order.

If you have bumped into matrices, there is a corresponding phenomenon. In general let $U^{-1}$ be the inverse of the matrix $U$. Then then (if the specified inverses exist) $(AB)^{-1}=B^{-1}A^{-1}$ Note again the reversal of order.

But back to the problem that I have already seen posted a number of times. You have computed the result of applying $10$ percent interest to $100$, then applying $7$ percent interest, again to $100$, getting a total of $117$, and you want to recover certain numbers, presumably $110$, $107$, and $100$.

The simple minded way of doing this is to note that since there is no compounding, the combined rate is $17$ percent. So one recovers the initial sum by dividing by $1.17$, and then recomputes the $110$ and $107$. Why is this procedure, of which you are undoubtedly aware, not satisfactory? Any formula that recovers the $110$ first will be essentially equivalent to the procedure I suggest, it will have to use both interest rates. From $117$ you cannot recover the $110$ without using information about both interest rates.

If there were compounding, with the $10$ percent assessed first, then you would need to divide by $1.07$, then by $1.10$, or equivalently by $(1.07)(1.10)$. If there is compounding with the $7$ percent taken first, recovery involves in the same way dividing by $(1.10)(1.07)$. Note that the two results are the same. When there is compounding, the order in which the rates are assessed makes no difference, something that is perhaps not intuitively obvious.

  • 0
    Look at this previous answer (http://math.stackexchange.com/questions/32854/adding-and-removing-non-compounded-percentages-does-not-produce-the-same-result/32865#32865) to a post I did, particularly this answer with the poster is adding 1. Does this mean that I only need to add 1 if it is only non-compounded, but if it is a mixture(compound and non-compound), I don't need to do that2011-04-19