# Why does the present value of a deposit decrease when the APR increases? [closed]

When calculating a down payment in excel, I noticed that by increasing my rate from 3.7% to 6.25%, the money I supposedly have to pay today decreases. Why is that?

Thanks a lot :)

• Can you give us some more information about what exactly you are trying to calculate in Excel, and what formulas/functions you are using? Maybe include a screenshot of your spreadsheet? – Ben Miller - Remember Monica Jan 23 '17 at 20:00

First, assuming you are making payments for a savings deposit. The present value of the deposit is the sum of the all the payments discounted to present value. In this case they would be discounted by the rate of inflation: £100 deposited next year is worth less than £100 today because it will be eroded by inflation. With a higher rate of inflation the payments are discounted more heavily, so the present value decreases. A deposit, or annuity due (see Calculating the Present Value of an Annuity Due), can be expressed mathematically like so:-

``````s = present value of the annuity
n = number of periods
d = periodic payment
r = periodic inflation rate
``````  So for example, the following annuity has a present value of £1,136.76

``````n = 12 months
d = £100
r = 0.01 = 1% per month

s = (d (1 + r - (1 + r)^(1 - n))) / r = £1,136.76
``````

The total amount that will be paid for the annuity is `12 x £100 = £1,200`.

With a higher rate of inflation, say 2% per month, and with the same `12 x £100` payments, the present value of the annuity decreases.

``````r = 0.02 = 2% per month

s = (d (1 + r - (1 + r)^(1 - n))) / r = £1,078.68
``````

In Excel

``````=PV(0.02,12,100,0,1)
``````

(£1,078.68)

A similar case is that for a loan, or ordinary annuity (see Calculating the Present Value of an Ordinary Annuity), except the discounting factor is the loan interest rate rather than inflation and repayments are made at the end of each period rather than at the start.

The present value of a loan is the value of the all the future repayments discounted to present value. With a higher interest rate the payments are discounted more heavily, so the present value decreases. A loan can be expressed mathematically like so:-

``````s = present value of loan
n = number of periods
d = periodic payment
r = periodic interest rate
``````  So for example, the following values fulfill a loan worth £1,125.51

``````n = 12 months
d = £100
r = 0.01 = 1% per month

s = (d - d (1 + r)^-n) / r = £1,125.51
``````

The total amount that will be paid for the loan is `12 x £100 = £1,200`.

With a higher rate of interest, say 2% per month, and the same `12 x £100` repayments, the present value of the loan that can be obtained decreases.

``````r = 0.02 = 2% per month

s = (d - d (1 + r)^-n) / r = £1,057.53
``````

In Excel

``````=PV(0.02,12,100,0,0)
``````

(£1,057.53)