The Excel INTRATE function is a function that uses calculating the interest rate of invested securities in Excel. If you love the field of stock investment, knowing the syntax and how to use the INTRATE function is essential, especially when learning excel – office informatics.
INTRATE function example
INTRATE function, which uses the function of calculating the interest rate of invested securities in Excel
Get
Syntax:INTRATE(settlement, maturity, investment, redemption, [basis])
Where:
– Settlement: Date of settlement of securities, required parameters
– Maturity: Maturity date of securities, mandatory parameters
– Investment: The amount invested in securities, mandatory parameters
-Redemption: The amount received at maturity, mandatory parameters
– Basis: Day counting facility, optional
+ Basis = 0 or omitt: US (NASD) 30/360
+ Basis = 1: Fact/fact
+ Basis = 2: Actual/360
+ Basis = 3: Actual/365
+ Basis = 4: Europe 30/360
Consider Examples:
For the spreadsheet below, the data entered corresponds to the parameters of the INTRATE function in Excel. This function is used on Office 2013, Office
To calculate the interest rate on invested securities. Enter the formula in cell C11 =INTRATE(C6,C7,C8,C9,C10). We get the result as shown below
Through the above article, you have a better understanding of the syntax and usage of the INTRATE function in Excel. Thanks to this, calculating the interest rate on invested securities is completely at your fingertips.
Besides the INTRATE function, you should also learn the IPMT function. When you understand
https://thuthuat.taimienphi.vn/ham-intrate-trong-excel-2786n.aspx
In addition, if you want to invest in many areas other than stocks, the