Math

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.

asked by Tyreice
  1. 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 time-line.
    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

    posted by Reiny

Respond to this Question

First Name

Your Response

Similar Questions

  1. 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
  2. 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
  3. 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? b) What’s the annual interest rate? c) How many payments do you make in
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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:
  10. Finance - Loans problem

    Reiny the answer 307.33 you posted at the bottom is coming up incorrect. please if you can help i would be very grateful. A company borrows $170000, which will be paid back to the lender in one payment at the end of 5 years. The

More Similar Questions