Question
Use PMT
to determine the regular payment amount, rounded to the nearest cent. The cost of a
home is financed with a
20-year fixed-rate mortgage at
.
a. Find the monthly payments and the total interest for the loan.
b. Prepare a loan amortization schedule for the first three months of the mortgage.
home is financed with a
a. Find the monthly payments and the total interest for the loan.
b. Prepare a loan amortization schedule for the first three months of the mortgage.
Ask by Pope Garza. in the United States
Mar 23,2025
Upstudy AI Solution
Tutor-Verified Answer
Answer
a. Monthly Payment and Total Interest
- Monthly Payment: $1,201.30
- Total Interest Over 20 Years: $98,312
b. Loan Amortization Schedule for the First Three Months
Month | Payment ($) | Interest ($) | Principal ($) | Balance ($) |
---|---|---|---|---|
1 | 1,201.30 | 712.50 | 488.80 | 189,511.20 |
2 | 1,201.30 | 710.67 | 490.63 | 189,020.57 |
3 | 1,201.30 | 708.83 | 492.47 | 188,528.10 |
Solution
a. Calculating the Monthly Payment and Total Interest
Given the formula
we have:
- Principal:
- Annual interest rate:
- Number of compounding periods per year:
- Term (years):
-
Determine the monthly interest rate and total number of payments:
-
Substitute into the PMT formula:
-
Compute the denominator:First, compute
: Raise to the power: Using a calculator or logarithms, one finds that
, so Therefore, -
Calculate the numerator:
-
Determine the monthly payment:So, the monthly payment is approximately $1,201.30.
-
Calculate the total interest:The total amount paid over 240 months is:Therefore, the total interest is:The total interest paid over the life of the loan is approximately $98,312.
b. Loan Amortization Schedule for the First Three Months
For each month, the interest portion is
and the principal repayment is
Let the starting balance be
.
Month 1:
- Interest:
- Principal:
- New Balance:
Month 2:
- Interest:
- Principal:
- New Balance:
Month 3:
- Interest:
- Principal:
- New Balance:
The following table summarizes the first three months:
Month | Payment ($) | Interest ($) | Principal ($) | Balance ($) |
---|---|---|---|---|
1 | 1201.30 | 712.50 | 488.80 | 189,511.20 |
2 | 1201.30 | 710.67 | 490.63 | 189,020.57 |
3 | 1201.30 | 708.83 | 492.47 | 188,528.10 |
Summary:
- Monthly Payment: Approximately
. - Total Interest Over 20 Years: Approximately
. - Amortization Schedule (First 3 Months): As detailed in the table above.
Answered by UpStudy AI and reviewed by a Professional Tutor
Like
error msg


The Deep Dive
To determine the regular payment amount (PMT) with the given formula, let’s break down the parameters:
-
(loan amount) -
(annual interest rate) -
(number of payments per year) -
(loan term in years)
Now, input these values into the formula:
-
Calculate
: -
Calculate
: -
Plug these values into the PMT formula:First, calculate
: Therefore, the expression becomes:
So, the monthly payment (rounded to the nearest cent) is approximately
.
To find the total interest over the life of the loan:
-
Calculate total payments:
-
Calculate total interest:
The total interest paid over the loan term is approximately
.
Now, for the loan amortization schedule for the first three months:
Month 1:
- Beginning Balance:
- Payment:
- Interest:
- Principal:
- Ending Balance:
Month 2:
- Beginning Balance:
- Payment:
- Interest:
- Principal:
- Ending Balance:
Month 3:
- Beginning Balance:
- Payment:
- Interest:
- Principal:
- Ending Balance:
In summary, after three months, each month’s interest and principal payments have been calculated to create a small glimpse into your mortgage journey!