PPMT function Financial functions (reference) POISSON.DIST function, POISSON function Statistical functions (reference), Compatibility functions (reference) RAND function Math and trigonometry functions (reference) STDEV.S function, STDEV function Statistical functions (reference), Co...
Financial Excel Functions PV Function FV Function PMT Function IPMT Function PPMT Function Loan Amortization Schedule MIRR Function RATE Function RRI Function XIRR Function XNPV Function YIELD Function Statistical Excel Functions COUNTA Function COUNTIF Function COUNTIFS Function Logical Excel Functions ...
Choosing cell ranges by mouse for editable formula is available also for other sheets than the edited one. Editable formulas are updated after moving cell ranges in the same way as in MS Excel. Added some other minor extensions and corrected various bugs. List of all changes 5th Mar2023 New...
If you're planning on financing a capital expenditure, you can use the PMT, IPMT, and PPMT functions in Excel to quickly develop an amortization table. The first is to use the PPMT function: =PPMT($B$4/12,$A9,$B$3,-$B$2). Excel: calculating loan amortization The 2- glass pre- ...