Calculate an Advance Payment using the PMT Function

Is it possible to calculate an advance payment using the PMT Function? If so, what would the formula look like?

Thanks.

PMT will calculate the payment amount given principal, interestRate, and term. How would you define "advance payment"?

- dg

PMT will calculate the payment amount given principal, interestRate, and term. How would you define "advance payment"?

- dg