Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MGST 217 > Week 7 > Flashcards

Week 7 Flashcards

1
Q

Effective Interest Rate

A

-Calculated from APR
-What the APR rate looks like based on number of Payments you are making

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

APR Rate

A

-Annual percentage rate for the loan
-Shows the interest rate for a whole year rather than monthly payments/rate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ERate formula:

A

(1+APR Rate/Comp Periods)^(Comp Periods/Payment Periods)-1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Canadian Mortgage Quirk:

A

Semi annually compounded!!! twice in a year

but still payed monthly (USUALLY) but can be bi-weekly(26) or semi monthly (24)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Canadian Mortgage Erate: IF PAYED MONTHLY

A

(1+APR Rate/2)^(2/12)-1
This is just a version of:

(1+APR Rate/Comp Periods)^(Comp Periods/Payment Periods)-1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Loan Payments are normally paid

A

Monthly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Loan Payments E-rate (2)

A

(1+APR Rate/Comp Periods)^(Comp Periods/Payment Periods)-1

so…

(1+APR Rate/12)^(12/12)-1
APR Rate/12

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Credit Card Monthly Payments compounded?

A

DAILY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Credit Card Erate formula

A

(1+APR Rate/Comp Periods)^(Comp Periods/Payment Periods)-1

so…

(1+APR Rate/365)^(365/12)-1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How many compounding periods are there for each?
Canadian Mortgage
Credit Card
Loan

A

Semi Annually (2 times in a year)
Daily (365)
Loan (12)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Daily
Monthly
Quarterly
Semi Annually
Semi Monthly
Annually
bi-weekly

A

365
12
4
2
24
1
26

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

When do you use APR rate in the formula?

A

When calculating Erate for Canadian Mortgages, Loans, Credit Cards

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the number of payments in the calculating Erate functions?

A

Always 12!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

IMPORTANT FOR PMT FUNCTION!

A

Do NOT make anything NEGATIVE!!!! BECAUSE payment is money going out of account so pmt has to be negative itself!!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Ammortization Schedlue

A

Shows what monthly payments look like broken down by payments that go towards the principle and payments that pay down interest

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Ammortization:
Principle Pymt Function

A

=PPMT(Erate,period we are in, #periods,pv)

-Use the Erate (ABS REF)
-Per is the period we are currently in (MIXED REF)
-#Periods is Years*Payments (ABS REF)
-PV is the total valye of the loan rn (ABS REF)

17
Q

Ammortization:
Interest Payment Function

A

=IPMT(Erate,period we are in, #periods,pv)

-Use the Erate (ABS REF)
-Per is the period we are currently in
-#Periods is Years*Payments (ABS REF)
-PV is the total valye of the loan rn (ABS REF)

copy across and jus change the P to an I

18
Q

Ammortization:
Total Payment, how to calculate this and to check if it is right?

A

=PPMT+IPMT
Check if this value is the same as the PMT calculated that you will pay monthly!

19
Q

Ammortization

Balance

A

You are checking what balance you have remaining on the loan!!!

=Loan Principle+sum(PMT range)
Loan Principle: ABS REF!
Sum: must use sum function!!!!!
PMT RANGE: first cell will be like ($F$3:F3)

EXAMPLE: $C$4+SUM($F$3:F3)

20
Q

How to check if you did Ammortization right?

A

The total value of balance at the final period should be 0.00

21
Q

As years of loan go on what happens?

A

Interest payment values decrease
Principle payment values increase

22
Q

Two way data table sensitivity analysis

A

What does the payment look like at different terms and different apr rates?

23
Q

How to do the two way data table analysis

A

Top left is the pmt
See what vbl is in the rows, (term) put it in the row input cell
See what vbl is in the columns, (apr rate) put it in the column cell

check with the calculated apr and term to see if the table is done correctly

24
Q

IMPORTANT THING TO NOTE: BIWEEKLY VS SEMI MONTHLY

A

BIWEEKLY EVERY TWO WEEKS 26 PAYMENTS

SEMIMONTHLY TWICE A MONTH 24

25
Q

Trade in Value questions

A

Trade in value is the amount that a car dealer will PAY you to trade in your car

So if you are using this to calculate a loan value
Loan value= Car price- Downpayment-Trade in Value

26
Q

Total Paid questions?

A

=Down Payment+ (Total Payment)

NOTE: signs can be - depending on if total payment is -

Total payment= payment per month*number of month

27
Q

PMT function

A

=PMT(RATE, NPER, PV OR FV)

rate=erate
nper= number of months*payments per month
BASICALLY THIS IS THE TOTAL AMOUNT OF TIMES YOU MAKE PAYMENTS!

PV OR FV= dont put negative sign in front because

PMT VALUE HAS TO BE NEGATIVE

28
Q

Total Interest Paid formula:

A

=(- Value of Payments per month*Number of Months)-Loan Amount

Calculating in total what you paid, subtracting it from the original cost of the loan

29
Q

Difference between Loan Payment and Payment per month

A

Loan Payment= one individual payment
Payment per month= Loan payment *Payment per month

LETS SAY if you have to do 2 loan payments per month, your total payment in one month would be Loan payment*2

30
Q

Nper

A

of years * #payments per year

MGST 217 (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions