Hello,

I am trying to calculate the monthly payment for a loan with a fix amount, term and rate with a 90 day deferred first payment.

I've successfully used the PMT function, but that does not account for the deferred payment. Anyone know how?

Loan amount $50,000
Term: 60 months
Rate: 1.49%
Loan Open Date 9/9/15
Loan First Payment Date: 12/9/15

I should be getting a monthly payment of $867.45

Thanks for your help!