Determining the Monthly Payment of an Installment Loan - YouTube

Channel: Mathispower4u

[0]
- WELCOME TO A LESSON ON THE LOAN PAYMENT FORMULA.
[3]
THE GOAL OF THE VIDEO IS TO DETERMINE THE PAYMENT
[5]
FOR A FIXED INSTALLMENT LOAN.
[8]
INSTALLMENT BUYING IS WHEN YOU PURCHASE SOMETHING TODAY
[11]
WITH A LOAN THAT YOU PAY BACK
[12]
WITH EQUAL PAYMENTS OVER A PERIOD OF TIME,
[15]
USUALLY MONTHLY FOR A PERIOD OF YEARS.
[18]
THE TWO MOST COMMON EXAMPLES WOULD BE FOR A CAR LOAN
[21]
OR A HOME MORTGAGE LOAN,
[23]
AND WE'LL TAKE A LOOK AT AN EXAMPLE OF BOTH OF THESE.
[26]
HERE IS THE LOAN PAYMENT FORMULA
[29]
FOR FIXED AMOUNT OF EQUAL PAYMENTS
[32]
WHERE R IS THE ANNUAL NOMINAL INTEREST RATE
[35]
EXPRESSED AS A DECIMAL,
[37]
T IS THE TIME IN YEARS, N IS THE NUMBER OF COMPOUNDS PER YEAR.
[43]
P IS THE AMOUNT OF THE LOAN,
[45]
AND PMT REPRESENTS THE MONTHLY PAYMENT.
[50]
LET'S TAKE A LOOK AT WHERE THIS FORMULA COMES FROM.
[52]
IT COMES FROM THE COMPOUNDED INTEREST FORMULA
[56]
AND THE VALUE OF ANNUITY FORMULA.
[60]
SO IF YOU'RE THE BANK OR THE LENDER
[62]
YOU WOULD USE THE COMPOUNDED INTEREST FORMULA
[65]
TO DETERMINE THE RETURN ON YOUR INVESTMENT.
[68]
AND IF YOU WERE THE PERSON TAKING OUT THE LOAN
[70]
YOU COULD USE THE VALUE ANNUITY FORMULA
[73]
WHERE P IS IN REPLACE WITH PMT FOR PAYMENT
[77]
TO REPRESENT ALL THE PAYMENTS THAT YOU WOULD MAKE
[80]
TO COVER "A" YOUR LOAN AMOUNT,
[83]
PLUS ALL THE INTEREST YOU'D ALSO BE CHARGED.
[87]
SO THE LOAN PAYMENT FORMULA
[88]
COMES FROM COMBINING THESE TWO FORMULAS
[91]
OR SETTING THEM EQUAL TO EACH OTHER.
[93]
AND SINCE THESE ARE BOTH EQUAL TO "A,"
[96]
WE CAN SET THE RIGHT SIDES OF THESE EQUATIONS
[99]
EQUAL TO EACH OTHER.
[100]
AND THEN IF WE SOLVE FOR PMT OR PAYMENT,
[103]
WE SHOULD HAVE OUR LOAN PAYMENT FORMULA.
[106]
SO LET'S GO AHEAD AND TAKE A MOMENT AND DO THAT.
[121]
SO LET'S GO AHEAD AND MULTIPLY BOTH SIDES OF THE EQUATION
[123]
BY R/N.
[131]
SO IT WOULD SIMPLIFY NICELY HERE.
[135]
SO WE'D HAVE P x R/N.
[139]
I'M ACTUALLY GO AHEAD
[140]
AND MOVE THIS QUANTITY DOWN TO THE DENOMINATOR
[142]
SO IT'LL CHANGE THE EXPONENT TO -NT.
[161]
LET'S GO AHEAD AND CONTINUE THIS ON THE NEXT PAGE.
[165]
NOW, TO ISOLATE PMT I'M GOING TO DIVIDE OR MULTIPLY BY 1/1
[173]
+ R/N TO THE NT POWER - 1.
[188]
SO LOOKING AT THE RIGHT SIDE THIS WOULD SIMPLIFY OUT
[191]
AND WE'RE LEFT WITH THE PAYMENT.
[193]
SO WE ISOLATED PMT FOR PAYMENT.
[196]
LET'S SEE WHAT WE HAVE ON THE LEFT SIDE.
[199]
OUR NUMERATOR'S STILL GOING TO BE P x R DIVIDED BY N.
[206]
HERE WE'RE GOING TO MULTIPLY.
[208]
WE MULTIPLY 1 + R/N TO THE -NT POWER x 1
[213]
+ R/N TO THE +NT POWER.
[215]
WE ADD OUR EXPONENTS
[216]
AND THAT WOULD GIVE US AN EXPONENT OF ZERO.
[219]
SO THIS FIRST PRODUCT IS EQUAL TO 1,
[222]
AND THEN WE HAVE - 1 + R/N TO THE -NT.
[229]
AND THIS IS THE FORMULA THAT WE USE
[230]
TO DETERMINE THE PAYMENT AMOUNT FOR A GIVEN LOAN
[234]
IN THE AMOUNT OF P.
[237]
LET'S GO AND TAKE A LOOK AT OUR EXAMPLES.
[239]
DETERMINE THE MONTHLY PAYMENT FOR A 30 YEAR MORTGAGE LOAN
[242]
OF 150,000 WITH A 5% FIXED INTEREST COMPOUNDED MONTHLY.
[247]
THEN DETERMINE THE TOTAL INTEREST THAT WILL BE PAID
[250]
OVER THE 30 YEARS.
[254]
SO MONTHLY PAYMENT IS GOING TO BE EQUAL TO P THE LOAN AMOUNT
[262]
x R DIVIDED BY N, THAT'LL BE 0.05.
[266]
IT'S COMPOUNDED MONTHLY SO N IS 12.
[270]
AND DIVIDE ALL OF THIS BY 1 - 1 + R/N TO THE -N x T POWER.
[282]
WELL, N IS 12 AND T IS TIME IN YEARS SO IT'LL BE 30.
[287]
SO OUR EXPONENT HERE IS GOING TO BE -360.
[291]
LET'S GO AHEAD AND EVALUATE THIS.
[294]
WE'LL PUT OUR NUMERATOR IN A SET OF PARENTHESIS.
[308]
SO THERE'S OUR NUMERATOR
[310]
AND WE'LL DIVIDE THIS BY OUR DENOMINATOR.
[329]
AND WE CAN SEE THAT OUR MONTHLY PAYMENT
[330]
IS GOING TO BE APPROXIMATELY $805.23.
[338]
NOW, THE SECOND PART ASK US DETERMINE THE TOTAL INTEREST
[340]
THAT WILL BE PAID OVER THE 30 YEARS.
[343]
WELL, WE'RE GOING TO MAKE 360 PAYMENTS OF $805.23 FOR A LOAN
[349]
IN THE AMOUNT OF $150,000.
[352]
SO LETS FIRST DETERMINE HOW MUCH MONEY WE'RE PAYING
[354]
OVER THE 30 YEARS.
[356]
IT'LL BE 805.23 x 12 MONTHS A YEAR x 30 YEARS.
[368]
SO WE'RE GOING TO PAY $289,882.80 OVER THE 30 YEARS
[374]
FOR A LOAN AMOUNT OF $150,000.
[377]
SO IF WE SUBTRACT $150,000 FROM THIS AMOUNT
[381]
THE REST WILL BE THE AMOUNT OF INTEREST PAID.
[390]
SO THE TOTAL INTEREST THAT WE'LL BE PAYING OVER THE 30 YEARS
[393]
IS ALMOST $140,000 OR $139,882.80.
[406]
SO NOTICE THAT WE'RE PAYING ALMOST AS MUCH INTEREST
[408]
AS THE TOTAL LOAN AMOUNT.
[411]
NOW, FOR OUR SECOND EXAMPLE WE WANT TO COMPARE THE SAME LOAN,
[414]
BUT NOW INSTEAD OF A 30 YEAR MORTGAGE
[416]
WE'LL TAKE A LOOK AT THE DIFFERENCE IN PAYMENTS
[419]
AND INTEREST AMOUNT IF WE HAVE A 15 YEAR MORTGAGE INSTEAD.
[424]
SO EVERYTHING IS THE SAME HERE EXCEPT NOW T,
[426]
THE NUMBER OF YEARS, WILL BE 15 INSTEAD OF 30.
[434]
SO OUR EXPONENT HERE IS GOING TO BE -12 x 15 NOW INSTEAD OF 30.
[443]
SO LET'S SEE HOW THIS AFFECTS OUR MONTHLY PAYMENT,
[446]
AS WELL AS THE TOTAL INTEREST PAID OVER 15 YEARS.
[453]
HERE'S OUR NUMERATOR.
[467]
AND, AGAIN, OUR EXPONENT HERE IS GOING TO BE -180.
[477]
SO FOR A 15 YEAR MORTGAGE THE LOAN PAYMENT WOULD BE $1,186.19.
[488]
SO GOING BACK AND COMPARING THIS TO THE 30 YEAR MORTGAGE,
[491]
LOOKS LIKE OUR LOAN PAYMENT WENT UP MORE THAN $350
[497]
BUT THE PAYMENTS WOULD ONLY BE FOR HALF THE TIME.
[499]
LET'S ALSO COMPARE THE INTEREST PAID OVER 15 YEARS
[502]
COMPARED TO THE 30 YEAR MORTGAGE.
[505]
SO WE'LL BE MAKING THIS MONTHLY PAYMENT FOR 15 YEARS
[509]
OR 12 TIMES A YEAR FOR 15 YEARS.
[516]
SO HERE'S THE TOTAL AMOUNT PAID OVER THE 15 YEARS,
[520]
AND THEN WE'LL SUBTRACT OUT THE LOAN AMOUNT,
[522]
AND THAT'LL LEAVE US WITH THE AMOUNT OF INTEREST PAID.
[526]
SO WE'LL BE PAYING $63,514.20 OF INTEREST OVER THE 15 YEARS.
[535]
AGAIN, COMPARING THIS TO THE 30 YEAR MORTGAGE
[538]
WE'LL BE PAYING OVER $70,000 MORE OF INTEREST
[541]
IF WE SELECT THE 30 YEAR MORTGAGE.
[544]
LET'S GO AND TAKE A LOOK AT ONE MORE EXAMPLE
[545]
DEALING WITH A CAR LOAN.
[547]
SO DETERMINE THE MONTHLY PAYMENT OF A FIVE YEAR CAR LOAN
[549]
OF $20,000 WITH A 5.5% FIXED INTEREST COMPOUNDED MONTHLY.
[555]
SO IT'S THE SAME FORMULA THAT WE HAVE.
[557]
$20,000 x 0.055 DIVIDED BY 12 AS OUR NUMERATOR.
[566]
OUR DENOMINATOR'S GOING TO BE 1 - THE QUANTITY 1 + 0.055
[571]
DIVIDED BY 12 RAISED TO THE -NT POWER.
[577]
WELL, N IS 12 BECAUSE IT'S STILL COMPOUNDED MONTHLY.
[580]
AND IT'S FOR FIVE YEARS SO T IS 5.
[584]
SO OUR EXPONENT HERE IS GOING TO BE -60.
[589]
LET'S GO BACK TO OUR CALCULATOR.
[594]
OUR EXPONENT HERE IS GOING TO BE -12 x 5 THAT'LL BE -60,
[601]
AND THERE'S OUR DENOMINATOR.
[604]
SO OUR MONTHLY PAYMENT WOULD BE APPROXIMATELY $382.02.
[611]
THEN, AGAIN, THE TOTAL AMOUNT OF INTEREST PAID OVER FIVE YEARS,
[615]
WE'LL DETERMINE THE TOTAL AMOUNT PAID
[617]
AND THEN WE'LL SUBTRACT THE LOAN AMOUNT OF $20,000.
[620]
SO WE'LL HAVE $382.02 x 12
[625]
THAT'LL BE THE AMOUNT PAID PER YEAR x 5 YEARS,
[630]
SO $22,921.20 IS THE TOTAL AMOUNT PAID.
[634]
MINUS THE LOAN AMOUNT LEAVES US
[636]
WITH THE AMOUNT OF INTEREST PAID.
[640]
SO ALMOST $3,000 OF INTEREST OR $2,921.20.
[647]
I LIKE TO MAKE A COUPLE CLOSING COMMENTS ON MORTGAGE LOANS.
[649]
SOME MORTGAGE LOANS HAVE ORIGINATION FEES OR POINTS.
[652]
FOR EACH POINT THE BUYER MUST PAY A COST OF 1%
[655]
OF THE TOTAL LOAN.
[657]
AND SOME MORTGAGES WILL ALSO REQUIRE
[658]
AN ADDITIONAL MONTHLY PAYMENT INTO AN ESCROW ACCOUNT
[661]
TO PAY YEARLY PROPERTY TAXES AND INSURANCE.
[665]
IT'S IMPORTANT TO BE AWARE OF ALL OF THE COST
[667]
WHEN TAKING A LOAN.
[668]
I HOPE YOU FOUND THIS VIDEO HELPFUL.
[670]
THANK YOU FOR WATCHING.