Fifteen years ago, Meals for the Homeless bought a new building for $ 600,000. They borrowed $

Question:

Fifteen years ago, Meals for the Homeless bought a new building for $ 600,000. They borrowed $ 500,000 on a 30-year mortgage with a 6 percent fixed rate and monthly payments. The current outstanding balance on the mortgage is $ 355,000. Today, they can get a 15-year fixed-rate mortgage with an interest rate of 4.32 percent. The mortgage would require monthly payments in arrears. It will cost Meals $ 20,000 to do the refinancing. Should Meals refinance the mortgage under those terms?
Since you know Meals could use the $ 20,000 it will cost to refinance the mortgage to pay off some of the principal on its current mortgage, you have decided to use the interest rate on the existing mortgage as the for your analysis. Be sure to include the cost of refinancing in the amount you intend to borrow.
A. Solve using a spreadsheet program such as Excel.
B. Solve using a financial calculator.

Discount Rate
Depending upon the context, the discount rate has two different definitions and usages. First, the discount rate refers to the interest rate charged to the commercial banks and other financial institutions for the loans they take from the Federal...