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 …
Read More
Read More
EXCEL FUNCTIONS-DOLLARFR
INTRODUCTION DOLLARFR function comes under the FINANCIAL FUNCTIONS category in Excel. DOLLARFR function converts a dollar expressed in DECIMAL FORM …
Read More
Read More
EXCEL FUNCTIONS-DOLLARDE
INTRODUCTION DOLLARDE function comes under the FINANCIAL FUNCTIONS category in Excel. DOLLARDE function converts a dollar expressed in fraction into …
Read More
Read More
EXCEL FUNCTIONS-DDB
INTRODUCTION DDB function comes under the FINANCIAL FUNCTIONS category in Excel. DDB returns the depreciation of an asset for a …
Read More
Read More
EXCEL FUNCTIONS-DB
INTRODUCTION DB function comes under the FINANCIAL FUNCTIONS category in Excel. DB returns the depreciation of an asset for a …
Read More
Read More
EXCEL FUNCTIONS-CUMPRINC
INTRODUCTION CUMPRINC function comes under the FINANCIAL FUNCTIONS category in Excel. CUMPRINC returns the cumulative principal paid on a loan …
Read More
Read More
EXCEL FUNCTIONS-CUMIPMT
INTRODUCTION In our lives, we always come through ups and downs mentally, physically and financially too. When it comes to …
Read More
Read More
EXCEL FUNCTIONS-COUPPCD
INTRODUCTION COUPPCD function comes under the FINANCIAL FUNCTIONS category in Excel. COUPPCD returns a number that represents the previous coupon …
Read More
Read More
EXCEL FUNCTIONS-COUPNUM
INTRODUCTION COUPNUM function comes under the FINANCIAL FUNCTIONS category in Excel. COUPNUM returns the number of coupons payable between the …
Read More
Read More
EXCEL FUNCTIONS-COUPNCD
INTRODUCTION COUPNCD function comes under the FINANCIAL FUNCTIONS category in Excel. COUPNCD returns the next coupon date after the settlement …
Read More
Read More