FINANCIAL FUNCTIONS
FINANCIAL FUNCTIONS group comprise of the different ready to use functions for the various financial utilities such as
calculating interest for a duration, calculating cumulative interest, payments, installments and many more.
Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.
FINANCIAL FUNCTIONS
EXCEL FUNCTIONS-PMT
Table of Contents INTRODUCTION PURPOSE OF PMT IN EXCEL PREREQUISITES TO LEARN PMT SYNTAX: PMT FUNCTION EXAMPLE: PMT FUNCTION IN …
EXCEL FUNCTIONS-DOLLARFR
INTRODUCTION DOLLARFR function comes under the FINANCIAL FUNCTIONS category in Excel. DOLLARFR function converts a dollar expressed in DECIMAL FORM …
EXCEL FUNCTIONS-DOLLARDE
INTRODUCTION DOLLARDE function comes under the FINANCIAL FUNCTIONS category in Excel. DOLLARDE function converts a dollar expressed in fraction into …
EXCEL FUNCTIONS-DDB
INTRODUCTION DDB function comes under the FINANCIAL FUNCTIONS category in Excel. DDB returns the depreciation of an asset for a …
EXCEL FUNCTIONS-DB
INTRODUCTION DB function comes under the FINANCIAL FUNCTIONS category in Excel. DB returns the depreciation of an asset for a …
EXCEL FUNCTIONS-CUMPRINC
INTRODUCTION CUMPRINC function comes under the FINANCIAL FUNCTIONS category in Excel. CUMPRINC returns the cumulative principal paid on a loan …
EXCEL FUNCTIONS-CUMIPMT
INTRODUCTION In our lives, we always come through ups and downs mentally, physically and financially too. When it comes to …
EXCEL FUNCTIONS-COUPPCD
INTRODUCTION COUPPCD function comes under the FINANCIAL FUNCTIONS category in Excel. COUPPCD returns a number that represents the previous coupon …
EXCEL FUNCTIONS-COUPNUM
INTRODUCTION COUPNUM function comes under the FINANCIAL FUNCTIONS category in Excel. COUPNUM returns the number of coupons payable between the …
EXCEL FUNCTIONS-COUPNCD
INTRODUCTION COUPNCD function comes under the FINANCIAL FUNCTIONS category in Excel. COUPNCD returns the next coupon date after the settlement …