IPMT function - Microsoft Support
https://support.microsoft.com/en-us/office/ipmt-function-5cce0ad6-8402-4a41-8d29-61a0b054cb6f
Years of loan. $8,000. Present value of loan. Formula. Description. Live Result =IPMT(A2/12, A3, A4*12, A5) Interest due in the first month for a loan with the terms in A2:A5. ($66.67) =IPMT(A2, 3, A4, A5) Interest due in the last year for a loan with the same terms, where payments are made yearly. ($292.45)
DA: 49 PA: 62 MOZ Rank: 86