In: Finance
You've saved up to buy a house and will put $60,000 down on a $350,000 home. You're stated interest rate is 4.3%, and you'll make monthly payments for 30 years. What will be your mortgage payment?
Monthly mortgage payment is calculated using the PMT function as follows:-
=PMT(rate,nper,pv)
=PMT(4.3%/12,30*12,350000-60000)
=1435.13