PPMT Function

PPMT Function

The Excel PPMT function is a Financial formula that calculates and returns the principal amount of the payment of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the PPMT function and also go over some tips and...
Excel EFFECT Function

Excel EFFECT Function

The Excel EFFECT function is a Financial formula that calculates and returns the effective annual interest rate, for a given nominal annual interest rate and number of compounding periods per year. The effective annual interest rate is used to compare financial loans...
Function: DURATION

Function: DURATION

The DURATION Excel function is a Financial formula that calculates and returns the annual duration of a security based on the Macauley duration formula. In this guide, we’re going to show you how to use the DURATION function and also go over some tips and error...
Excel YIELD Function

Excel YIELD Function

The Excel YIELD function is a Financial formula that calculates and returns the yield on a security that pays a periodic interest. A common use case for the YIELD function is calculating bond yields. In this guide, we’re going to show you how to use the Excel YIELD...
Function: PRICEMAT

Function: PRICEMAT

The Excel PRICEMAT function is a Financial formula that calculates and returns the price per $100 face value of a security that pays interest at maturity. In this guide, we’re going to show you how to use the PRICEMAT function and also go over some tips and error...
Function: PRICE

Function: PRICE

The Excel PRICE function is a Financial formula that calculates and returns the price per $100 face value of a security that pays periodic interest. In this guide, we’re going to show you how to use the PRICE function and also go over some tips and error handling...
Function: RRI

Function: RRI

The Excel RRI function is a Financial function that calculates and returns the equivalent interest rate for the growth of an investment. When given a present value, a future value, and the number of periods for an investment, you can calculate the rate of return for...
Function: RATE

Function: RATE

The Excel RATE function is a Financial formula that calculates and returns the interest rate for a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel RATE function and also go over some tips and error...
Function: FV

Function: FV

The FV Excel function is a Financial formula that calculates and returns the future value of a loan or an investment, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel FV function and also go over some tips and...