Sample Problems


Jake is buying a house for $500,000. He is making a 20% down payment with cash, and paying the balance with a mortgage. The mortgage is a 30-year loan with monthly payments, and the annual interest rate is 6%. Which of the following functions will calculate the correct monthly payment?
Solution: In Excel: =PMT(6%/12,30*12,500000*80%)