The free guide

Excel Financial Functions

Payment Functions ISPMT functionCalculates the amount of interest paid on a loan/ investment for a specific period. PMT functionCalculate the periodic payment for a loan. PPMT functionCalculates the principal value of an investment for a given period. CUMIPMT functionCalculates the cumulative interest paid between the start date and the end date. Interest Rate Functions INTRATE functionCalculates [...]

ISPMT function in Excel

Use ISPMT function calculates the amount of interest paid on a loan/ investment for a specific period. Syntax ISPMT(rate, per, nper, pv) Where, rate means the rate of interest per period, per means the period for which you need to calculate interest, nper means the total number of period over which loan investments will be […]

PMT function

Use PMT function is used to calculate the periodic payment for a loan, for example, for a loan of $800,000 with the payment period of 36 months (3 years) and interest rate of 16%, the PMT function calculates the monthly payment of $28,150. Syntax PMT(rate, nper, pv, [fv], [type]) Rate – The annual rate of […]

PPMT function

Use PPMT function calculates the principal value of an investment for a given period. Syntax PPMT(rate, per, nper, pv, [fv], [type]) Rate – The annual interest rate per period. Per – The number of periods that must be from 1 to nper. Nper – The total number of payment periods in an investment/ annuity. Pv […]

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved