MICROSOFT EXCEL FUNCTIONS- FINANCIAL

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

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

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

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

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

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

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

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

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

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