You want to buy an apartment priced at $300,000. You have saved a deposit of $30,000. The bank has agreed to lend you the $270,000 as a fully amortising loan with a term of 25 years. The interest rate is 12% pa and is not expected to change.
What will be your monthly payments? Remember that mortgage loan payments are paid in arrears (at the end of the month).
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.12/12=0.01The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths) 270,000=Cmonthly×10.12/12(1−1(1+0.12/12)25×12) Cmonthly=270,000÷(10.12/12(1−1(1+0.12/12)25×12))=270,000÷(10.01(1−1(1+0.01)300))=270,000÷94.94655125=2,843.705184
You want to buy an apartment worth $500,000. You have saved a deposit of $50,000. The bank has agreed to lend you the $450,000 as a fully amortising mortgage loan with a term of 25 years. The interest rate is 6% pa and is not expected to change.
What will be your monthly payments?
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.06/12=0.005The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)450,000=Cmonthly×10.06/12(1−1(1+0.06/12)25×12)
Cmonthly=450,000÷(10.06/12(1−1(1+0.06/12)25×12))=450,000÷(10.005(1−1(1+0.005)300))=450,000÷155.206864=2,899.356307You want to buy an apartment worth $400,000. You have saved a deposit of $80,000. The bank has agreed to lend you the $320,000 as a fully amortising mortgage loan with a term of 30 years. The interest rate is 6% pa and is not expected to change. What will be your monthly payments?
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.06/12=0.005The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)320,000=Cmonthly×10.06/12(1−1(1+0.06/12)30×12)Cmonthly=320,000÷(10.06/12(1−1(1+0.06/12)30×12))=320,000÷(10.005(1−1(1+0.005)360))=320,000÷166.7916144=1,918.56168
You want to buy an apartment priced at $500,000. You have saved a deposit of $50,000. The bank has agreed to lend you the $450,000 as a fully amortising loan with a term of 30 years. The interest rate is 6% pa and is not expected to change. What will be your monthly payments?
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.06/12=0.005The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)450,000=Cmonthly×10.06/12(1−1(1+0.06/12)30×12)Cmonthly=450,000÷(10.06/12(1−1(1+0.06/12)30×12))=450,000÷(10.005(1−1(1+0.005)360))=450,000÷166.7916144=2,697.977363
You just signed up for a 30 year fully amortising mortgage loan with monthly payments of $2,000 per month. The interest rate is 9% pa which is not expected to change.
How much did you borrow? After 5 years, how much will be owing on the mortgage? The interest rate is still 9% and is not expected to change.
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since this is usually the case by convention and in some countries by law. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.09/12=0.0075The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=2,000×10.09/12(1−1(1+0.09/12)30×12)=2,000×10.0075(1−1(1+0.0075)360)=2,000×124.2818657=248,563.7314
To find the value of the loan in 5 years, remember that the price of any asset or liability is the present value of the future cash flows, and there are 25 years of future monthly payments. The working is nearly identical to that above:
P5yrs, fully amortising loan=PV(annuity of 25 years of future monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=2,000×10.09/12(1−1(1+0.09/12)25×12)=2,000×10.0075(1−1(1+0.0075)300)=2,000×119.1616222=238,323.2443
You just signed up for a 30 year fully amortising mortgage with monthly payments of $1,000 per month. The interest rate is 6% pa which is not expected to change.
How much did you borrow? After 20 years, how much will be owing on the mortgage? The interest rate is still 6% and is not expected to change.
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.06/12=0.005The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=1,000×10.06/12(1−1(1+0.06/12)30×12)=1,000×10.005(1−1(1+0.005)360)=1,000×166.7916144=166,791.6144
To find the value of the loan in 20 years, remember that the price of any asset or liability is the present value of the future cash flows, and there are 10 years of future monthly payments. The working is nearly identical to that above, just the number of years remaining has been changed from 30 to 10:
P20yrs, fully amortising loan=PV(annuity of 10 years of future monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=1,000×10.06/12(1−1(1+0.06/12)10×12)=1,000×10.005(1−1(1+0.005)120)=1,000×90.07345333=90,073.45333
You just signed up for a 30 year fully amortising mortgage loan with monthly payments of $1,500 per month. The interest rate is 9% pa which is not expected to change.
How much did you borrow? After 10 years, how much will be owing on the mortgage? The interest rate is still 9% and is not expected to change.
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.09/12=0.0075The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=1,500×10.09/12(1−1(1+0.09/12)30×12)=1,500×10.0075(1−1(1+0.0075)360)=1,500×124.2818657=186,422.7985
To find the value of the loan in 10 years, remember that the price of any asset or liability is the present value of the future cash flows, and there are 20 years of future monthly payments. The working is nearly identical to that above:
P20, fully amortising loan=PV(annuity of 20 years of future monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=1,500×10.09/12(1−1(1+0.09/12)20×12)=1,500×10.0075(1−1(1+0.0075)240)=1,500×111.144954=166,717.431
The above method is sometimes called the 'prospective' method of finding the loan amount owing since it present values future payments owing. Another method is the retrospective method which looks into the past and subtracts principal payments from the original amount borrowed to find the amount owing. Both methods give the same answer.
You just signed up for a 30 year fully amortising mortgage loan with monthly payments of $1,500 per month. The interest rate is 9% pa which is not expected to change.
To your surprise, you can actually afford to pay $2,000 per month and your mortgage allows early repayments without fees. If you maintain these higher monthly payments, how long will it take to pay off your mortgage?
The cash flows occur every month, so the discount rate needs to be an effective monthly rate and the time must be measured in months.
First we have to find the amount borrowed when the payments are $1,500 per month for 30 years.
V0=Cmonthly×1(rapr comp monthly12)(1−1(1+rapr comp monthly12)T)=1,500×1(0.0912)(1−1(1+0.0912)30×12)=1,500×124.2818657=186,422.7985
When the present value of the 'T' months of $2,000 payments are equal to the amount borrowed, then the loan will be paid off. So the only job left is to solve for T.
V0=Cmonthly(rapr comp monthly12)(1−1(1+rapr comp monthly12)T) 186,422.7985=2,000(0.0912)(1−1(1+0.0912)T) 186,422.79852,000(0.0912)=1−1(1+0.0912)T 1(1+0.0912)T=1−186,422.79852,000(0.0912) (1+0.0912)−T=0.300914506 ln((1+0.0912))−T)=ln(0.300914506) −T×ln(1+0.0912)=ln(0.300914506)T=−ln(0.300914506)ln(1+0.0912)=160.7235953 months=13.39363294 years
You just agreed to a 30 year fully amortising mortgage loan with monthly payments of $2,500. The interest rate is 9% pa which is not expected to change.
How much did you borrow? After 10 years, how much will be owing on the mortgage? The interest rate is still 9% and is not expected to change. The below choices are given in the same order.
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.09/12=0.0075The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=2,500×10.09/12(1−1(1+0.09/12)30×12)=2,500×10.0075(1−1(1+0.0075)360)=2,500×124.2818657=310,704.6642
To find the value of the loan in 10 years, remember that the price of any asset or liability is the present value of the future cash flows, and there are 20 years of future monthly payments. The working is nearly identical to that above:
P10yrs, fully amortising loan=PV(annuity of 20 years of future monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)=2,500×10.09/12(1−1(1+0.09/12)20×12)=2,500×10.0075(1−1(1+0.0075)240)=2,500×111.144954=277,862.3851
The above method is sometimes called the 'prospective' method of finding the loan amount owing since it present values future payments owing. Another method is the retrospective method which looks into the past and subtracts principal payments from the original amount borrowed to find the amount owing. Both methods give the same answer.
You want to buy a house priced at $400,000. You have saved a deposit of $40,000. The bank has agreed to lend you $360,000 as a fully amortising loan with a term of 30 years. The interest rate is 8% pa payable monthly and is not expected to change.
What will be your monthly payments?
Since the interest rate was not specified as an effective annual rate, we can assume that it must be an annualised percentage rate (APR) since by convention and in some countries by law, this is usually the case. Since mortgage loans usually pay interest monthly, by convention the APR can be assumed to compound per month. But to discount the monthly cash flows the effective monthly interest rate is needed, which can be calculated by dividing the annualised percentage rate compounding per month by 12.
reff mthly=rAPR comp monthly/12=0.08/12=0.00666667The loan is fully amortising and the interest rate is expected to remain constant so the monthly payments will be equal. We can assume that the payments are made in arrears, as is normal. The annuity equation can be used to discount equal payments:
P0, fully amortising loan=PV(annuity of monthly payments)=Cmonthly×1reff monthly(1−1(1+reff monthly)Tmonths)360,000=Cmonthly×10.08/12(1−1(1+0.08/12)30×12)Cmonthly=360,000÷(10.08/12(1−1(1+0.08/12)30×12))=360,000÷(10.0066667(1−1(1+0.0066667)360))=360,000÷136.2834941=2,641.552466