-
On Excel we see
month | Payment | Interest |
Principal | Loan Balance |
120 | $58.18 |
$0.38 | $57.80 | ($0.63) |
What is the total amount paid on the loan? [NOT the total interest]
- $58.18
- $6981.60
- $6980.97
- other that can be derived from the given info
- no way to tell without more info
- In the derivation of the loan formula, we used:
- the bank earns interest on the lump sum amount while we pay it back
via the periodic payment formula so that our payments plus resulting interest
equals the lump sum amount plus interest.
- algebra of fractions, multiply, distibute, reciprocal and negative power
where x=(1+rate)n
- c) neither a) nor b)
- d) both a) and b)
-
When the loan is set up so that there is a 0 balance in the Excel chart
the last month, then we can calculate the total interest via two of the three methods:
- (monthly payment)(# payments) - (original loan)
- add the monthly interest for each and every month
- (original loan)(monthly rate)(#payments)
Which is incorrect?
- method 1
- method 2
- method 3
- If we take out a $100 loan at 700% compounded monthly for 2 months,
the monthly payment would be
- 100 (1 + 7/12)2
- 100((1 + 7/12)(2*12) - 1 ) / (7/12)
- 100 (7/12) / (1 - (1 + 7/12)(-2))
- other
Answer the question and then write out a scenario for each of the other choices.
-
If we pay an extra $20 each month on a loan then we will pay
- less total interest and I have a good reason why
- less total interest but I am unsure of why
- more total interest but I am unsure of why
- more total interest and I have a good reason why
- the same amount of interest