Maths Mutt HOME

Utility Bills

Telephone, gas and electricity bills usually include a standing charge plus a cost for each unit used. VAT is added to the whole bill.

meter
\[ \text{Units used} = \text{Present reading} - \text{Previous reading} \] \[ \text{Charge} = \text{Units used} \times \text{Cost per unit} \]

VAT is payable on the whole bill.

Loans

Secured Loans – Your house is at risk if you default.
Unsecured Loans – Goods are yours; house is safe.
Hire Purchase – Goods become yours after final payment.
Mortgages – Secured loans for houses, ships, etc.

Example

Joe Bloggs wishes to borrow £10,000. Which option is cheapest?

loan1
loan2
fred

EasyLoan costs £17,343 over 15 years.
Loans R Us costs £11,122.56 over 3 years (unprotected).

Fred’s Finance:

Eqn1

Cheapest: Loans R Us (3 years, unprotected).

Hire Purchase (HP)

HP requires a deposit followed by fixed monthly payments. Goods become yours only after the final payment.

Example

A TV costs £600 cash.
HP: 10% deposit + 36 × £15.75.
How much cheaper is cash?

Eqn2
Eqn3

Cash is £27 cheaper.

Car Finance

car

Options when buying a car:

Hire Purchase (HP)

Key Features

Risks

Personal Contract Purchase (PCP)

Key Features

Risks

Leasing / PCH

Key Features

Risks

Insurance

Insurance premiums depend on the probability of an event happening. Higher risk → higher premium.

Example

Bodgit Insurance charges £3.50 per £1000 of house value.
Cost to insure a £189,000 house?

Eqn4

Bank Interest

Interest is a percentage of capital charged on loans or paid on savings.

Simple Interest

Simple interest is calculated only on the original capital.

Example

Calculate simple interest on £500 for 3 years at 6%.

Eqn5

Compound Interest

Compound interest uses interest earned to increase capital.

Example

Calculate compound interest on £500 for 3 years at 6%.

Eqn6

Using the CRy mnemonic:

Eqn7
Eqn8
Example
Eqn9

For monthly rates, convert years → months.

Example
Eqn10

More than one interest period

CRy can be chained:

Capital × rate₁term₁ × rate₂term₂ × …

Example

£5,000 placed in savings on 1 April 2022.

rates
loop

Balance = £5167.33

Effective Interest

Effective interest accounts for compounding.

effective formula
compound periods

EAR (Effective Annual Rate) is used for loans.
AER (Annual Equivalent Rate) is used for savings.

ear
Example

A loan has a nominal rate of 5%. Find EAR if compounded:

  1. Semi‑annually
  2. Monthly
  3. Daily

Worked Example (EAR)

\[ EAR = \left(1 + \frac{i}{n}\right)^{n} - 1 \] \[ = \left(1 + \frac{0.05}{2}\right)^{2} - 1 \] \[ = (1.025)^{2} - 1 \] \[ = 1.050625 - 1 \] \[ = 0.050625 \] \[ = 5.06\% \]

Explanation

1. Start with the EAR formula:
EAR tells you the “real” interest earned after compounding.

2. Substitute the values:
Interest rate \(i = 0.05\) (5%) and compounding \(n = 2\) (twice a year).

3. Work out the inside:
\(0.05 \div 2 = 0.025\), so the bracket becomes \(1.025\).

4. Square it:
\(1.025^2 = 1.050625\).

5. Subtract 1:
This removes the original amount, leaving only the interest.

6. Convert to a percentage:
\(0.050625 = 5.06\%\).

So the effective annual rate is 5.06%.

Worked Example (EAR)

\[ EAR = \left(1 + \frac{i}{n}\right)^{n} - 1 \] \[ = \left(1 + \frac{0.05}{12}\right)^{12} - 1 \] \[ = (1.004166667)^{12} - 1 \] \[ = 1.051161898 - 1 \] \[ = 0.051161898 \] \[ = 5.12\% \]

Explanation

1. Start with the EAR formula:
EAR shows the true annual return once compounding is included.

2. Substitute the values:
Interest rate \(i = 0.05\) (5%) and compounding \(n = 12\) (monthly).

3. Work out the monthly rate:
\(0.05 \div 12 = 0.004166667\).

4. Add 1:
The bracket becomes \(1.004166667\).

5. Raise to the power of 12:
This applies monthly compounding for a full year.

6. Subtract 1:
Removing the original amount leaves the interest earned.

7. Convert to a percentage:
\(0.051161898 = 5.12\%\).

So the effective annual rate is 5.12%.

Worked Example (EAR)

\[ EAR = \left(1 + \frac{i}{n}\right)^{n} - 1 \] \[ = \left(1 + \frac{0.05}{365}\right)^{365} - 1 \] \[ = (1.000136986)^{365} - 1 \] \[ = 1.051267496 - 1 \] \[ = 0.051267496 \] \[ = 5.13\% \]

Student‑Friendly Explanation

1. Start with the EAR formula:
EAR shows the true annual return after compounding is included.

2. Substitute the values:
Interest rate \(i = 0.05\) (5%) and compounding \(n = 365\) (daily).

3. Work out the daily rate:
\(0.05 \div 365 = 0.000136986\).

4. Add 1:
The bracket becomes \(1.000136986\).

5. Raise to the power of 365:
This applies daily compounding for a full year.

6. Subtract 1:
This removes the original amount, leaving only the interest earned.

7. Convert to a percentage:
\(0.051267496 = 5.13\%\).

So the effective annual rate is 5.13%.

Changing between interest periods

Interest Rate Conversion Formula

\[ i_{\text{new}} = \left(1 + i_{\text{old}}\right)^{\frac{C_{f,\text{old}}}{C_{f,\text{new}}}} - 1 \]

Student‑Friendly Explanation

1. What this formula does:
It converts an interest rate from one compounding frequency to another.

2. \(i_{\text{old}}\):
The interest rate you already have.

3. \(i_{\text{new}}\):
The equivalent rate using a different compounding frequency.

4. \(C_{f,\text{old}}\):
How many times per year the old rate compounds.

5. \(C_{f,\text{new}}\):
How many times per year the new rate compounds.

6. Why the exponent is a fraction:
It adjusts the growth factor so both rates represent the same annual effect.

7. Subtract 1 at the end:
This removes the principal, leaving only the interest portion.

This formula ensures both rates produce the same effective annual growth.

Source: LibreTexts Mathematics

To convert annual effective → monthly effective:

Annual → Monthly Rate Conversion

\[ i_{\text{month}} = \left(1 + i_{\text{year}}\right)^{\frac{1}{12}} - 1 \]

Student‑Friendly Explanation

1. What this formula does:
It converts a yearly interest rate into the equivalent monthly rate.

2. \(i_{\text{year}}\):
The annual interest rate you start with.

3. Why we use the power of \(1/12\):
Because we want the monthly rate that, when compounded 12 times, gives the same annual growth.

4. Add 1 first:
This turns the interest rate into a growth factor.

5. Raise to the power of \(1/12\):
This finds the “one‑month” version of the annual growth.

6. Subtract 1:
This removes the principal, leaving only the monthly interest.

The result is the true monthly rate that matches the annual rate exactly.

Do NOT divide by 12!

Example
Excel example 1
Excel example 2

The monthly effective interest rate is 0.31% (1 d.p.).

Use in Loan Schedules

Example

A loan of £10,000 is borrowed over 3 years. The annual effective interest rate is 7.1%.

loan setup

Enter the formula =(1+C5)^(1/12)-1 into cell C6 to calculate the monthly effective interest rate.

monthly rate

The Excel function PMT calculates payments based on a constant interest rate and number of periods.

PMT function

Here:

PMT result

This gives a fixed monthly payment of £308.22.

Set up a loan schedule with these headings:

headings

Enter =$C$4 into F12 (type =C4 then press F4).

Extend the table down to 36 months.

loan table start

Repayment is C8, so enter =$C$8 in C13.

Interest content: =ROUND($C$6*F12,2)

Capital repaid: =C13-D13

New balance: =F12-E13

loan formulas

Copy down to the final row.

loan mid
loan full

The final payment differs. Enter =F47 + D48 into C48.

final payment
final detail

Summary:

summary

This can be represented by the recurrence relation:
\[ U_{n+1} = 1.0057U_n - 308.22 \]

From the graph, after 15 months the outstanding loan is approximately £6,000.

recurrence graph

Comparing Loans

The effective monthly rate can be used to compare loan offers quickly.

Example

A TV advert offers short‑term loans with a typical annual interest rate of 1271%.

  1. Create a loan schedule for £100 over 6 months.
  2. Calculate the cost of the loan.
  3. Express the cost as a percentage of the original loan.
  4. Comment on your findings.
tv example

1. Total repaid = £200.41
2. Cost = £200.41 − £100 = £100.41
3. Percentage = (£100.41 ÷ £100) × 100% = 100.41%
4. The cost of borrowing exceeds the original loan!

summary table

Excel formula view:

formula view
formula summary
Example

£10,000 loan over 3 years. Compare providers:

Loan information boxes:

bank1
bank2
bank3

Comment on findings:

comparison1
comparison2
comparison3

Clearly, the loan from Own Bank is cheapest.
Internet Bank B’s monthly effective rate is higher than Own Bank’s annual rate!

Nominal interest rate from effective rate

If given EAR/AER, the nominal rate can be found by changing the subject of the formula .

formula rearranged

So:

nominal formula

where i = nominal rate, r = effective annual rate, n = compounding periods.

Example

EAR = 9%, compounded monthly. Find nominal rate.

nominal example

Alternatively:

alt method

Nominal rate = 8.6% (1 d.p.)

Example

Annual rate = 61.94%. Find effective monthly rate.

monthly effective

Effective monthly rate = 4.1% (1 d.p.)

Alternatively:

alt1
alt2

Substituting:

solution

APR (Annual Percentage Rate)

APR is the interest rate paid each year on a loan. It includes fees and charges but does not include compounding.

APR

Foreign Exchange

Exchange rates

Converting currency is an application of ratio .

Converting into another currency

Example

Fred converts £150 into US dollars.
Rate: £1 = $1.67.
How many dollars does he get?

Eqn15

£150 × 1.67 = $250.50

Using the rule of 3:

Eqn13

Converting back

Fred converts $75 back into pounds.
Rate: £1 = $1.67.
How many pounds?

Eqn16

$75 ÷ 1.67 = £44.91

Using rule of 3:

Eqn14

Joe converts $150 into Euros and receives €108.09.
No commission. What was the exchange rate?

Eqn17

or

Eqn18
Scruffs logo © Alexander Forrest