PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-COUPNUM

INTRODUCTION

COUPNUM function comes under the FINANCIAL FUNCTIONS category in Excel.

COUPNUM returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.

PURPOSE OF COUPNUM IN EXCEL

COCOUPNUM returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.

PREREQUISITES TO LEARN COUPNUM

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: COUPNUM

The Syntax for the function is

=COUPNUM(SETTLEMENT DATE, MATURITY DATE,NUMBER OF COUPON PAYMENTS, BASIS)

SETTLEMENT DATE is the security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

MATURITY DATE   is the security’s maturity date. The maturity date is the date when the security expires.

NUMBER OF COUPON PAYMENT(FREQUENCY)   is the number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

BASIS is the type of day count basis to use.

BasisDay count basis
0 or omittedUS (NASD) 30/360
1Actual/actual
2Actual/360
3Actual/365
4European 30/360

THE DATES SHOULD BE PUT USING THE DATE FUNCTION

=DATE(YYYY,MM,DD) OTHERWISE IT’LL RETURN AN ERROR.

EXAMPLE:COUPNUM IN EXCEL

DATA SAMPLE

The settlement date for the example is 19.01.2019

Maturity date is 1.09.2019

Freq of payout is 2

and basis is 1.

 

COUPNUM EXCEL FUNCTION
EXCEL COUPNUM FUNCTION EXAMPLE

STEPS TO USE COUPNUM

The data is put in the cells from F8 TO F11.
For the result
we put the formula in F13 as

=COUPNUM(F8,F9,F10,F11)

The result comes out to be 2 which is the number of interest payments between settlement date and maturity date.

CONFUSION CLARIFICATIONS

NUMBER OF DAYS CALCULATION

We should always be having knowledge about the working of a function. Otherwise we may be stuck in a situation where we never know whether the answer is correct or not.

These formulas are doing nothing but playing with the dates.

MS Excel is converting the date to a number first. Number is the number of days after JAN 1 1900.

After converting to number it subtracts to find out the number of days between any two dates.

The same procedure is being followed up in these financial formulas.

These can be done with the simple calculations also but when we have a ready function, we can always take help.

 

COUPNUM simply tells us the number of interest payments between settlement date and maturity date.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

OTHER WAYS TO REACH THIS ARTICLE

  • COUPNUM FUNCTION, CALCULATE NUMBER OF PAYOUTS BETWEEN SETTLEMENT DATE AND MATURITY DATE, COUPNUM FUNCTION IN EXCEL, FINANCIAL FORMULAS IN EXCEL

YOU MAY LIKE

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Leave a Reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: