Excel: You take a fixed-rate mortgage for $140,000 at 6.75% (annual interest rate) for 30 years,

6 Просмотры
Издатель
Join this channel to get access to perks:
https://www.youtube.com/channel/UCFhqELShDKKPv0JRCDQgFoQ/join

You take a fixed-rate mortgage for $140,000 at 6.75% (annual interest rate) for 30 years, monthly payments. At the end of year two, you unexpectedly inherit $25,000 from your favorite grandmother. You decide to apply this $25,000 to the principal balance of your loan. a. What is the mortgage monthly payment after you apply the $25,000 to the principal? b. How much interest do you save over the life of the loan by doing this assuming that the mortgage is held to maturity?

#MicrosoftExcel
#Mortgage
#Principal
#Interest
#Payments
Категория
Калькулятор кредита
Комментариев нет.