Question

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87. Interest rates are at an all-time low, and Dave and Jana are thinking of refinancing to a new 15-year fixed loan. Their bank has made the following offer: 15-year term, 3.0%, plus out-of-pocket costs of $2,937. The out-of-pocket costs must be paid in full at the time of refinancing. Build a spreadsheet model to evaluate this offer. The Excel function:

Answer 1

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87. Interest rates are at an all-time low, and Dave and Jana are thinking of refinancing to a new 15-year fixed loan. Their bank has made the following offer: 15-year term, 3.0%, plus out-of-pocket costs of $2,937. The out-of-pocket costs must be paid in full at the time of refinancing. Build a spreadsheet model to evaluate this offer. The Excel function: New monthly payment PMT(3%/12, 15*12, 208555.87, 0, 0) = $1,440.25 Now, we need find the additional amount.

What is Interest rates?

The amount of interest due each period expressed as a percentage of the amount lent, deposited, or borrowed is known as an interest rate (called the principal sum). The total interest on a loaned or borrowed sum is determined by the principal amount, the interest rate, the frequency of compounding, and the period of time the loan, deposit, or borrowing took place.

The interest rate over a year is known as the annual interest rate. Other interest rates are applicable over shorter time frames, such a day or a month, but they are typically annualized.

According to one definition, the interest rate "is an indication of the preference for a dollar of present [income] over a dollar of future income."

To learn more about interest rate from the given link:

brainly.com/question/886396

#SPJ4