Math Problem Statement

Suppose you took out an upfront loan of $25,000 that you will pay in yearly installments over a 12 year period. If the interest rate on the loan is 11.5%, use the Excel file below to calculate the following:

Note: provide your answers to two decimal places. Do not include any commas ( , ) or dollar signs ( $ ) in your answers.

The annuity repayment amount repaid each year for the life of the loan = $

The amount of interest paid in year 10 = $

The total amount paid back to the bank over the life of the loan = $

Solution

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Annuities
Interest Rates
Loan Repayment

Formulas

Annuity repayment formula: A = P * [r(1 + r)^n] / [(1 + r)^n - 1]
Interest payment in year x: Interest = Remaining principal * Annual interest rate
Total repayment: Total = Annuity repayment * Number of years

Theorems

Annuity repayment calculation
Amortization schedule

Suitable Grade Level

College Level or Advanced High School (Grades 11-12)