In: Finance
Sheet 5: Mortgage Payments
This is a simplified version of a payment calculator. The purpose is to use the payment (PMT) function to illustrate various monthly payments on a mortgage loan with a 4% interest rate.
USA Loan Company | ||
Monthly Payment Table | ||
Percentage Rate | 4.000% | |
Mortgage in Years | ||
15 Years | 30 Years | |
X | X | |
12 Payments/Yr | 12 Payments/Yr | |
180 | 360 | |
Payments | Payments | |
Principal | 15 Years | 30 Years |
150000 | ||
175000 | ||
200000 | ||
225000 | ||
250000 | ||
275000 | ||
300000 | ||
325000 | ||
350000 | ||
375000 | ||
400000 |