Question: how to do ipmt in excel?
Answer: rate - The interest rate per period.
per - The payment period of interest.
nper - The total number of payment periods.
pv - The present value, or total value of all payments now.
fv - [optional] The cash balance desired after last payment is made. Defaults to 0.
type - [optional] When payments are due.