Understanding Percentages
Article Index
Understanding Percentages
Spreadsheets and percentages
Percentage change
Examples
Simple tax relief
Key points

Simple tax relief

If you take out a loan at I% interest what is the effective rate if the interest payments are subject to 25% tax relief? In other words, what rate of interest would result in the same repayments without the tax relief?

We will ignore for the moment questions of repayment, what term the loan is for and the frequency of interest payments. If the loan is for M the interest due each period is simply

   M*I

If the interest is tax free T% of it would have been paid to the tax authority anyway and so does not represent an additional outgoing. This reduces the interest payment by T% and makes the effective interest paid only

    M*I*(1-T)

and so the effective rate of interest is I*(1-T) i.e. the rate is reduced by T%.

It is interesting to examine the way tax relief changes interest rates and so a simple spreadsheet is called for.

Starting from an empty spreadsheet enter the labels as shown in Figure 4 and the following formulas and values:

5%             A5
=A5+0.01 A6
=A5*(1-$B$1) B5

Copy the formula in A6 into A7..A20 and the formula in B5 into B6..B20. Finally format B1 and A5..B20 as percentages.

Note: the use of $B$1 is an absolute cell reference that copying the formula will not alter it.

You can see a sample table in Figure 4 for a 25% rate of tax. You can, of course enter any tax rate you want to into cell B1.

fig4

Figure Four - Tax relief

 

Negative percentages

Although we could carry on dealing with percentage increase and decrease as separate cases, it is much simpler to adopt the convention that a positive percentage is an increase and a negative percentage a decrease. In this case to increase/decrease a value by P% you simply multiply by (1+P) and let the positive and negative signs take care of themselves. So remember from now on

  • a negative percentage corresponds to a percentage decrease and a positive percentage to a percentage increase and in either case we multiply by (1+P).

To see how this simplifies things you only have to look at the formula for the actual percentage which now becomes

  (1+P)*(1+Q)-1

for both an increase and a decrease.

Banner

Why do we use percentages?

The use of percentages in many financial situation is so natural that is is worth spending a few moments considering why this is so.

If you need to divide something up into portions so that each person gets an appropriate share of the whole then percentages are a good way to go about it.

If a pie is divided into two parts so that A gets twice as much as B then the appropriate percentages are 66.66% and 33.33%. As long as the pie is shared out into these percentages the two-to-one ratio will be maintained. When relative importance is gauged as a ratio then a percentage allocation is appropriate. However notice that as the total amount to be divided increases the absolute gap between what A and B receive increases.

This property of a percentage increase/decrease of keeping ratios fixed is less arguably appropriate when what is being shared is less obvious. For example. if A and B work for an hourly rate of $20 per hour and $10 per hour then a percentage wage rise of 10% will keep the two-to-one payment the same at $22 per hour and $11 per hour. However the differential between the two rates of pay has jumped from $10 to $11. If a percentage increase is repeatedly applied the differential between the hourly rates goes on steadily rising even though the two-to-one ratio remains unchanged. This isn’t necessarily wrong but it is important that all concerned understand that a percentage increase or decrease keeps existing ratios fixed but changes absolute differences.

<ASIN: 0471267686>

<ASIN:9087905726>



 
 

   
RSS feed of all content
I Programmer - full contents
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.