Use the PMT function in Excel to compute the monthly payment on a home each month if you borrowed $150,000 at an annual interest rate of 6% over 30 years, where the interest is compounded monthly.Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type).Fv and Type are not necessary. Ignore them.Enter the amount of your monthly payment below. Do not include the dollar sign
Mathbot Says...
I wasn't able to parse your question, but the HE.NET team is hard at work making me smarter.