Question

The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30 years and had an interest rate of 9% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance, that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125 % (APR).

a. What monthly repayments will be required with the new loan?

b. If you still want to pay off the mortgage in 25 years, what monthly payment should you make after you refinance?

c. Suppose you are willing to continue making monthly payments of $1422. How long will it take you to pay off the mortgage after refinancing?

d. Suppose you are willing to continue making monthly payments of $1422, and want to pay off the mortgage in 25 years. How much additional cash can you borrow today as part of the refinancing? (Note: Be careful not to round any intermediate steps less than six decimal places.)

The mortgage on your house is five years old. It required monthly payments of $1,422, had an original term of 30 years, and had an interest rate of 9% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance that is, you wil rol over the outstanding balance into a new mortgage. The new mortgage has a 30-year er require s monthly payments, and has an interest rate of 6.125% APR a. What monthly repayments will be required with the new loan? b.If you still want to pay off the mortgage in 25 years, what monthly payment should you make after you refinance? c. Suppose you are willing to continue making monthly payments of $1,422. How long will it take you to pay off the mortgage after refinancing? d. Suppose you are willing to continue making monthly payments of $1,422, and want to pay off the mortgage in 25 years. How much additional cash can you borrow today as part of the refinancing? (Nofe: Be carsful not to round any intermediate sfeps less than six decimal places.) a. What monthly repayments will be required with the new loan? The monthly repayments with the new loan will be S Round to the nearest cent.)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 conditional Format . Cell Insert Delete Format Paste Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard IS302 IK Alignment Number Cells IM IN IO IP IQ IR Is IU 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 PMT TERM RATE NO OF PERIODS IN A YEAR 1422 30 9% 12 YEARS NO OF YEARS LEFT 25 LOAN BALANCE AFTER 5 YEARS 169447.83 [EXCEL PV(I10287/10288,10290 I0288,-10285)] REFINANCING RATE PMT ON NEW LOAN 6.125% 1029.58 [EXCEL PMT(I0294/10288,I0286 I0288,-I0291)] YEARS PMT ON NEW LOAN 25 1104.74 [EXCEL PMT (IO294/I0288,I0297 10288,-I0291)] PMT NO OF MONTHS TO REPAY THE LOAN NO OF YEARS TO REPAY THE LOAN 1422 184.0547715 [EXCEL-NPER(I0294/12,-l0300,I0291)] 15.34 [EXCEL I0301/10288] CALCULATOR | LOAN OPTIONS fv. ann CAP STRU VALUE BOX DILUTION DOLLAR COST AVG MORTGAGE EXPO SheetiSheet2Shell 福 130%Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy. Σ AutoSum Wrap Text General в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard IN315 IK Font Alignment Number Styles Cells Edting IL IM IN I0 IP ia IR Is IT IU 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 PMT YEARS RATE NO OF PERIODS IN A YEAR LOAN AMOUNT SHOULD BE 1422 25 6.25% 12 215562.53 [EXCEL PV (I0306/10307,I0305*0307,-I0304) ADDITIONAL CASH THAT CAN BE BORROWED $46,114.70 (215562.53 -169447.83) CALCULATOR | LOAN OPTIONS fv. ann CAP STRU VALUE BOX | DILUTION DOLLAR COST AVG MORTGAGE . . EXPO ( Sheet1 . Sheet2. Shell-

Add a comment
Know the answer?
Add Answer to:
The mortgage on your house is five years old. It required monthly payments of $ 1,422,...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The mortgage on your house is five years old. It required monthly payments of $ 1,422,...

    The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30​ years, and had an interest rate of 9 % ​(APR). In the intervening five​ years, interest rates have fallen and so you have decided to refinance long dash that ​is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a​ 30-year term, requires monthly​ payments, and has an interest rate of 6.125...

  • The mortgage on your house is five years old. It required monthly payments of $ 1...

    The mortgage on your house is five years old. It required monthly payments of $ 1 422 , had an original term of 30 years, and had an interest rate of 9 % (APR). In the intervening five years, interest rates have fallen and so you have decided to refinancelong dashthat is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.625...

  • The mortgage on your house is five years old. It required monthly payments of SEK 12,000,...

    The mortgage on your house is five years old. It required monthly payments of SEK 12,000, had an original term of 30 years, and had an interest rate of 6.5% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance - that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 3.5% (APR). (a)...

  • The mortgage on your house is five years old. It required monthly payments of $1,450, had an original term of 30 years, and had an interest rate of 8% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance

    The mortgage on your house is five years old. It required monthly payments of $1,450, had an original term of 30 years, and  had an interest rate of 8% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance—that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125% (APR). a. What monthly repayments will be required with...

  • The mortgage on your house is five years old. It requiredmonthly payments of $1,450​, had...

    The mortgage on your house is five years old. It required monthly payments of $1,450, had an original term of 30 years, and had an interest rate of 10% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance — that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.625% (APR).a. What monthly...

  • Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of...

    Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of 3% APR compounded monthly. The mortgage is a standard fixed rate mortgage with equal monthly payments over the life of the loan. What are the monthly fixed mortgage payments on this mortgage (i.e., the minimum required monthly payments to pay down the mortgage in 30 years)? What is the remaining loan balance immediately after making the 120th monthly payment (i.e., 10 years after initially...

  • Five years ago you borrowed $230,000 to finance the purchase of a $290,000 house. The interest...

    Five years ago you borrowed $230,000 to finance the purchase of a $290,000 house. The interest rate on the old mortgage is 5.5%. Payment terms are being made monthly to amortize the loan over 30 years. You have found another lender who will refinance the current outstanding loan balance at 3.5% with monthly payments for 25 years. There are no prepayment penalties associated with either loan. You feel the appropriate refinancing cost is 5% of the new loan amount. a....

  • Suppose you are two years into a 30-year mortgage at 4.125%. Your minimal monthly payment is $710...

    Suppose you are two years into a 30-year mortgage at 4.125%. Your minimal monthly payment is $710.79 and your remaining balance on the loan is $141,500. You've been offered a deal to refinance to a 15 year mortgage at 3.125% with no closing costs. To determine if you should refinance, answer the following. (A) What is the monthly payment on a 15 year mortgage for $141,500 at 3.125% interest? (B) If you were to make the minimum monthly payments on...

  • When Gustavo and Serrana bought their home, they had a 5.9% loan with monthly payments of...

    When Gustavo and Serrana bought their home, they had a 5.9% loan with monthly payments of $870.60 for 30 years. After making 78 monthly payments, they plan to refinance for an amount that includes an additional $35,000 to remodel their kitchen. They can refinance at 4.8% compounded monthly for 25 years with refinancing costs of $625 included with the amount refinanced. (a) Find the amount refinanced. (Round your answer to the nearest cent.) $ 167661.87 Correct: Your answer is correct....

  • Suppose your friend April is considering to refinance her mortgage. She bought her house 60 months...

    Suppose your friend April is considering to refinance her mortgage. She bought her house 60 months ago. The amount of loan equals 154,00. She paid cash to cover the 5% down payment plus all required closing costs (closing costs include application fee, appraisal fee, loan origination fees and other costs, usually about 3%-5% of the loan amount). Since she had a decent credit history and relatively stable income, her mortgage rate was 5.25% for 30 years at the time of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT