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.