Question

(a) After making payments of $911.10 for 6 years on your 30-year loan at 8.1%, you decide to sell your home. What is the loan payoff? (Round your answer to two decimal places.)

(b) A homeowner has a mortgage payment of $995.10, an annual property tax bill of $592, and an annual fire insurance premium of $280. Find the total monthly payment for the mortgage, property tax, and fire insurance. (Round your answer to the nearest cent.)

(c) Suppose you obtain a 30-year mortgage loan of $193,000 at an annual interest rate of 8.8%. The annual property tax bill is $977 and the annual fire insurance premium is $491. Find the total monthly payment for the mortgage, property tax, and fire insurance. (Round your answer to the nearest cent.)

(d) Leona Jefferson purchased a home and obtained a 20-year loan of $436,000 at an annual interest rate of 6.5%. Find the amount of interest paid on the loan over the 20 years. (Round your answer to the nearest cent.)

(e) Find the mortgage payment for a 15-year loan of $223,700 at an annual interest rate of 8.15%. (Round your answer to two decimal places.)

Answer #1

**a]**

First, we calculate the original loan amount using PV function in Excel :

rate = 8.1%/12 (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pmt = -911.10 (monthly payment)

PV is calculated to be $122,997.35

Now, we calculate the principal paid off after 6 years (72 months) using CUMPRINC function in Excel :

rate = 8.1%/12 (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pv = 122997.35 (original loan amount)

start period = 1 (We are calculating principal paid off between 1st and 72nd month)

end period = 72 (We are calculating principal paid off between 1st and 72nd month)

type = 0 (each payment is made at the end of month)

CUMPRINC is calculated to be $7,465.58

The balance loan principal outstanding after 6 years = $122,997.35 - $7,465.58 = $115,531.77

**b]**

Total monthly payment = monthly mortgage payment + monthly tax + monthly insurance

monthly tax = annual tax / 12 = $592 / 12 = $49.33

monthly insurance = annual insurance / 12 = $280 / 12 = $23.33

Total monthly payment = $995.10 + $49.33 + $23.33 = $1,067.77

**c]**

Monthly loan payment is calculated using PMT function in Excel :

rate = 8.8% / 12 (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pv = 193000 (loan amount)

PMT is calculated to be $1,525.23

Total monthly payment = monthly mortgage payment + monthly tax + monthly insurance

monthly tax = annual tax / 12 = $977 / 12 = $81.42

monthly insurance = annual insurance / 12 = $491 / 12 = $40.92

Total monthly payment = $1,525.23 + $81.42 + $40.92 = $1,647.56

**d]**

Monthly loan payment is calculated using PMT function in Excel :

rate = 6.5% / 12 (converting annual rate into monthly rate)

nper = 20*12 (20 year loan with 12 monthly payments each year)

pv = 436000 (loan amount)

PMT is calculated to be $3,250.70

Interest paid on loan over 20 years = total payments - loan amount

Interest paid on loan over 20 years = ($3,250.70 * 20 * 12) - $436,000 = $344,167.73

After making payments of $899.10 for 8 years on your 30-year
loan at 8.1%, you decide to sell your home. What is the loan
payoff? (Round your answer to two decimal places.)

Suppose you take out a 30-year mortgage for a house that costs
$496,845. Assume the following:
The annual interest rate on the mortgage is 3.9%.
The bank requires a minimum down payment of 16% at the time of
the loan.
The annual property tax is 2.1% of the cost of the house.
The annual homeowner's insurance is 0.6% of the cost of the
house.
There is no PMI
If you make the minimum down payment, what will your monthly
PITI...

As you are applying for your mortgage loan, you and the bank
agree that your total mortgage payment will not exceed $1,640 for
the loan payments and your Escrow payments, which include your
property taxes, and your insurance payments. Your annual property
taxes are $3,600 and your annual insurance bill is $480. The bank
will agree to approve your loan for 30 years at 3.45% if you agreed
to make a down payment of 5% and have your payment equal...

Rick Rueta purchased a
$82,000 home at 7.5% for 30 years with a down payment of $25,000.
His annual real estate tax is $1,752 along with an annual insurance
premium of $912. Rick’s bank requires that his monthly payment
include an escrow deposit for the tax and insurance. What is the
total payment each month for Rick? (Round your answer to
the nearest cent.)
Total monthly payment-

You hope to be able to purchase a home
within 1-3 years after graduation. You expect to have to save for
the necessary down payment and closing costs without relying on
financial help from your family or relatives. Your financial goal
is to purchase a home in the $300,000 price range and have the
available cash for the down payment and required closing costs for
the type of mortgage financing that you select and are able to
receive home mortgage...

A mortgage is a loan used to purchase a home. It is usually paid
back over a period of 15, 20, or 30 years. The interest rate is
determined by the term of the loan (the length of time to pay back
the loan) and the credit rating of the person borrowing the money.
Once a person signs the documents to borrow money for a home, they
are presented with an amortization table or schedule for the
mortgage that shows...

Rick Rueta purchased a $88,000 home at 7.5% for 30 years with a
down payment of $25,000. His annual real estate tax is $1,932 along
with an annual insurance premium of $1,092. Rick’s bank requires
that his monthly payment include an escrow deposit for the tax and
insurance. What is the total payment each month for Rick?
(Round your answer to the nearest
cent.)

The following loan is a simple interest amortized loan with
monthly payments. (Round your answer to the nearest cent.)
$170,000, 9 1/2%, 35 years
(a) Find the monthly payment.
$
(b) Find the total interest.
$

Consider a home mortgage of $150,000 at a fixed APR of 6% 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 and what percentage is paid for interest.
a. The monthly payment is what?
(Do not round until the final answer. Then round to the nearest
cent as needed.)
b. The total amount paid over the...

You borrow 410,000 to buy a home using a 30-year mortgage with
an interest rate of 3.75 percent and monthly payment. After making
your monthly payments on time for exactly 6 years calculate your
loan balance. Disregard property taxes and mortgage insurance.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 12 minutes ago

asked 21 minutes ago

asked 22 minutes ago

asked 30 minutes ago

asked 30 minutes ago

asked 34 minutes ago

asked 42 minutes ago

asked 45 minutes ago

asked 46 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 1 hour ago