Question

(a) After making payments of $911.10 for 6 years on your 30-year loan at 8.1%, you...

(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.)

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
After making payments of $899.10 for 8 years on your 30-year loan at 8.1%, you decide...
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:...
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...
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...
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...
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 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...
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 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. -....
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...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT