Question

In: Finance

A homeowner takes a 15-year fixed-rate mortgage for $110,000 at 7.3 percent. After three years, the...

A homeowner takes a 15-year fixed-rate mortgage for $110,000 at 7.3 percent. After three years, the homeowner sells the house and pays off the remaining principal. How much is the principal payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Principal Payment: ________

Solutions

Expert Solution

Calculations-

Here,
Fv is the future value of loan
rate is the periodic interest rate
nper is no. of periods
pmt is the periodic payments
Pv is the present value of loan
type = 0 if the amount is paid at the end of the year ,1 if it is paid at the beginning.

Please upvote if the ans is helpful.In case of doubt,do comment.thanks.


Related Solutions

A homeowner takes a 30-year fixed-rate mortgage for $150,000 at 7.9 percent. After eleven years, the...
A homeowner takes a 30-year fixed-rate mortgage for $150,000 at 7.9 percent. After eleven years, the homeowner sells the house and pays off the remaining principal. How much is the principal payment?
Consider a 15-year, $110,000 mortgage with an interest rate of 5.75 percent. After two years, the...
Consider a 15-year, $110,000 mortgage with an interest rate of 5.75 percent. After two years, the borrower (the mortgage issuer) pays it off. How much will the lender receive?
Consider a 15-year, $110,000 mortgage with an interest rate of 5.75 percent. After two years, the...
Consider a 15-year, $110,000 mortgage with an interest rate of 5.75 percent. After two years, the borrower (the mortgage issuer) pays it off. How much will the lender receive? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Lender Receives:
A homeowner takes out a $257,000, 20-year fixed-rate mortgage at a rate of 6.00 percent. What...
A homeowner takes out a $257,000, 20-year fixed-rate mortgage at a rate of 6.00 percent. What are the monthly mortgage payments? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Monthly Payment: ________
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is NOT invested? please answer in excel format
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 3.25 percent with...
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 3.25 percent with monthly payments. How much principal and interest will she pay in the 27th monthly payment?
Consider a 15-year, $130,000 mortgage with an interest rate of 5.95 percent. After six years, the...
Consider a 15-year, $130,000 mortgage with an interest rate of 5.95 percent. After six years, the borrower (the mortgage issuer) pays it off. How much will the lender receive? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
a homeowner can obtain a 500,000 thirty year fixed rate mortgage at a rate of 3.0%...
a homeowner can obtain a 500,000 thirty year fixed rate mortgage at a rate of 3.0% with zero points or at a rate of 2.75% with 2 points. if you will keep the mortgage for 30 years what is the net present value of paying the points to the nearest dollars 1.)9,475 2.)8,360 3.) 6,366 4.)7,616 5.) 5,240
A homeowner can obtain a 250,000, 30 year fixed rate mortgage at a rate of 6.0%...
A homeowner can obtain a 250,000, 30 year fixed rate mortgage at a rate of 6.0% with zero points or at a rate of 5.5% with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is not invested?
A homeowner takes out a 15-year mortgage in the amount of $400,000, fully amortized, monthly compounded,...
A homeowner takes out a 15-year mortgage in the amount of $400,000, fully amortized, monthly compounded, monthly payable, with an interest rate of 4.8% p.a. What is the remaining balance of the mortgage after 8 years (i.e., after the 96th payment)? (in %, 2 decimal places)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT