Advanced Financial Functions Of Power BI

Introduction

 
Here in this article you will see some more financial functions. I have already explained some basic financial functions in my previous article.
 
These functions are also very useful for financial calculation. Below is the list of rest financial functions of Power BI.
 

Functions and Their Description

 

AMORLINC

 
Return the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.
 
Syntax – AMORLINC (Cost, Date_purchased, First_period, Salvage, Period, Rate, [Basic])
 
Cost – The cost of the asset.
 
Date_purchased – The date of the purchase of the asset.
 
First_period – The date of the end of the first period.
 
Salvage – The salvage value at the end of the life of the asset.
 
Period – Any period value.
 
Rate – The rate of depreciation.
 
Basic –It is optional. Default value is 0 if omitted.
 
 

COUPDAYBS

 
Returns the number of days from the beginning of a coupon period until its settlement date.
 
Syntax – COUPDAYBS (Settlement, Maturity, Frequency, [Basis])
 
Settlement –Settlement date of security.
 
Maturity – Maturity or expiry date of settlement.
 
Frequency – The number of coupon payments per year.
 
Basis - It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

COUPDAYS

 
Returns the number in the coupon period that contains the settlement date.
 
Syntax – COUPDAYS (Settlement, Maturity, Frequency, [Basis])
 
Settlement – Settlement date of security.
 
Maturity – Maturity or expiry date of settlement.
 
Frequency – The number of coupon payments per year.
 
Basis - It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

COUPDAYSYN

 
Returns the number of days from the settlement date to the next coupon date.
 
Syntax – COUPDAYSYN (Settlement, Maturity, Frequency, [Basis])
 
Settlement – Settlement date of security.
 
Maturity – Maturity or expiry date of settlement.
 
Frequency – The number of coupon payments per year.
 
Basis - It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

COUPNCD

 
Returns the next coupon date after the settlement date.
 
Syntax – COUPNCD (Settlement, Maturity, Frequency, [Basis])
 
Settlement – Settlement date of security.
 
Maturity – Maturity or expiry date of settlement.
 
Frequency – The number of coupon payments per year.
 
Basis - It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

COUPNUM

 
Returns the number of coupon payable between
 
Syntax – COUPNUM (Settlement, Maturity, Frequency, [Basis])
 
Settlement – Settlement date of security.
 
Maturity – Maturity or expiry date of settlement.
 
Frequency – The number of coupon payments per year.
 
Basis - It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

COUPPCD

 
Returns the previous coupon date before the settlement date.
 
Syntax – COUPPCD (Settlement, Maturity, Frequency, [Basis])
 
Settlement – Settlement date of security.
 
Maturity – Maturity or expiry date of settlement.
 
Frequency – The number of coupon payments per year.
 
Basis - It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

CUMIPMT

 
Returns the cumulative interest paid on a loan between start_period and end_period.
 
Syntax – CUMIPMT (Rate, Nper, Pv, Start_period, End_period, Type)
 
Rate – Interest rate.
 
Nper – total number of payment period.
 
Pv – Present value.
 
Start_period – The first period in the calculation.
 
End_period – The last period in the calculation.
 
Type –It can be 0 or 1. 0 means payment at the end of the period. 1 means payment at the starting of the period.
 
Advanced Financial Functions of Power BI
 

DB

 
Returns the depreciation of an asset for a specified period using the fixed declining balance method.
 
Syntax – DB (Cost, Salvage, Life, Period, [Month])
 
Cost –The initial cost of the asset.
 
Salvage –The value at the end of the depreciation. It can be 0.
 
Life –The number of periods over which the asset is being depreciated
 
Period –The period for which you want to calculate the depreciation.
 
Month – any number of month from 1 to 12. It is optional.
 
Advanced Financial Functions of Power BI
 

DURATION

 
Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield.
 
Synatax – DURATION (SettlementDate, MaturityDate, Coupon, Yld, Frequency, [Basis])
 
SettlementDate – The settlement date of security.
 
MaturityDate – The maturity date of security.
 
Coupon – Annual coupon rate of security.
 
Yld – annual yield of security
 
Frequency – The number of coupon payment per year.
 
Basis – It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

EFFECT

 
Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
 
Syntax – EFFECT(Nomial_rate, Npery)
 
Nominal_rate – The nominal interest rate.
 
Npery – The number of compounding periods per year.
 
Advanced Financial Functions of Power BI
 

MDURATION

 
Returns the modified Macauley duration for a security with an assumed per value of $100.
 
Syntax – MDURATION (SettlementDate, MaturityDate, Coupon, Yld, Frequency, [Basis])
 
Synatax – DURATION (SettlementDate, MaturityDate, Coupon, Yld, Frequency, [Basis])
 
SettlementDate – The settlement date of security.
 
MaturityDate – The maturity date of security.
 
Coupon – Annual coupon rate of security.
 
Yld – annual yield of security
 
Frequency – The number of coupon payment per year.
 
Basis – It is optional. Default value is 0 if omitted.
 
Advanced Financial Functions of Power BI
 

NOMINAL

 
Returns the nominal annual interest rate, given the effective rate and the number of compounding period per year.
 
Syntax – NOMINAL(Effect_rate, Npery)
 
Effective_rate – The effective interest rate
 
Npery – The number of compounding periods per year
 
Advanced Financial Functions of Power BI
 

NPER

 
Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
 
Syntax –NPER (Rate, Pmt, Pv, [Fv], [Type])
 
Rate – The interest rate per period.
 
Pmt – The payment made each period.
 
Pv – The present value.
 
Fv – Future value. It is optional.
 
Type – It can be 0 or 1. 0 means payment at the end of the period. 1 means payment at the starting of the period.
 
Advanced Financial Functions of Power BI
 

PMT

 
Calculate the payment for a loan based on constant payments and a constant interest rate.
 
Syntax – PMT (Rate, Nper, Pv, [Fv], [Type])
 
Rate – The interest rate for the loan
 
Nper – The total number of payment for the loan
 
Pv – The present value.
 
Fv – Future value. It is optional.
 
Type– It can be 0 or 1. 0 means payment at the end of the period. 1 means payment at the starting of the period.
 
Advanced Financial Functions of Power BI
 

RRI

 
Returns an equivalent interest rate for the growth of an interest.
 
Syntax – RRI(Nper, Pv, Fv)
 
Nper – The number of periods for the investment.
 
Pv – The present value of the investment.
 
Fv –The future value of the investment.
 
Advanced Financial Functions of Power BI