Solve for Monthly Payments with Actual/365 and Actual/360 Loans

Calculating the monthly payment on loans with dates can be tricky, unless the loan assumes all months have 30 days and there are 12 months in a year (30/360). In that case you can use the Excel PMT function. It is more difficult however to calculate a monthly payment that will pay off a loan […]