Pam is buying a townhome that costs $145,000. She is making a down payment of $15,000 and getting a 30-year mortgage with a 6.25% APR for the rest.
Calculate Pam's loan amount: $145,000 - $15,000 = $130,000
Now use the PMT formula in Excel to calculate Pam's monthly payment on her mortgage.
Determine the payment, interest, principle, and balance for months 1 and 16.
plz leave rating thank you
cell reference
Get Answers For Free
Most questions answered within 1 hours.