Math
posted by Tyreice
You plan on borrowing $14000 at 16% APR for 5 years. Use Web Loan Calculator to find the monthly payment. Find the total interest paid on this loan for the first 20 months.
Set up a spread sheet to answer. Here is an example of what it should look like. All cells in lower portion are formulas. You can use my examples numbers to test your spread sheet before you answer the questions. This is what is known as an amortization of the loan.
What is the monthly payment found on a bank web site?
$
per month. (rounded to nearest cent)
After 20 months of payments, how much total interest has been paid for this loan? Use a spreadsheet to answer, round to nearest cent.
$
of interest in the first 20 payments.

Reiny
I used
http://www.calculatorweb.com/calculators/loancalc.shtml
and got a payment of $3404.53 , but I learned nothing about the actuarial math involved.
From your data:
Present value = 140000
n = 5(12) = 60
i = .16/12 = .013333...
(ridiculously high rate for current rates, time to get a new text)
Payment = p
p(1  1.01333..^(60) )/.01333... = 140000
p(41.12170722..) = 140000
p = 3404.53
value of debt after 20 periods if no payment had been made:
140000(1.01333..)^20 = $182,462.92
amount of 20 payment at that time
= 3404.53(1.01333..^20  1)/.01333.. = $77,446.22
outstanding balance after 20 periods
= 182462.92  77446.22 = $105,016.70
actual amount paid off = 140,000  105,016.70
= $34,983.30
actual amount paid = 20(3404.53) = $68,090.60
interest = $68,090.60  $34,983.30 = $33,107.30
The last paragraph of calculations would be totally invalid and unacceptable to an actuarial mathematician, since you cannot add up monetary values that are not in the same "time spot" on a timeline.
In your spread sheet, there might be a splitup of the monthly payments into "interest" and "repayment".
The sum of the column for "interest" for 20 lines should be 33107.30
Respond to this Question
Similar Questions

mathematics
The monthly loan payment was calculated at 119 payments of $330.38 plus a final payment of $329.73 Loan balance: $25,000.00 Loan interest rate 10.0% Monthly loan payment: $330.38 Number of payments: 120 Cumulative Payments: $39,644.05 … 
Finance
You have arranged for a loan on your new car that will require the first payment today. The loan is for $32,000, and the monthly payments are $620. Required: If the loan will be paid off over the next 60 months, what is the APR of … 
Finance  Loans problem please help
A company borrows $170000, which will be paid back to the lender in one payment at the end of 5 years. The company agrees to pay monthly interest payments at the nominal annual rate of 7% compounded monthly. At the same time the company … 
Please Help me with a Finance  Loan problem
A company borrows $170000, which will be paid back to the lender in one payment at the end of 5 years. The company agrees to pay monthly interest payments at the nominal annual rate of 7% compounded monthly. At the same time the company … 
Math
The monthly loan payment was calculated at 119 payments of $348.33 plus a final payment of $347.54. Loan Balance: $30,000.00 Loan Interest Rate: 7.00% Monthly Loan Payment: $348.33 Number of Payments: 120 Cumulative Payments: $41,798.81 … 
Math
Suppose you borrowed $25,000 for a car at an APR of 8%, which you are paying off with monthly payments of $510 for 5 years. a) What’s the loan principal? 
math
Consider a student loan of $17,500 at a fixed APR of 9% for 25 years. Calculate the monthly payment, determine the total amount paid over the term of the loan, and of the total amount paid, what percentage is paid towards the principal, … 
Math  Accounting
Consider a home mortgage of 125,000 at a fixed APR of 9% for 30 years.  calculate the monthly payment  determine the total amount paid over the term of the loan  Of the total amount paid, what percentage is paid toward the principal … 
Math 201
I am having problems with this question in my math class. Consider a student loan of $25,000.00 at a fixed APR of 12% for 25 years. a. Calculate the monthly payment. The monthly payment is $263.31 b. Determine the total amount paid … 
finance
You would like to buy a Mazda Miata Convertible for a purchase price of $27,500. You will take out a loan for the entire amount. a. You have excellent credit so you can secure a loan at 5% APR for 3 years. What is your monthly payment?