What is the ACCRINT Function? The ACCRINT Function is an Excel Financial function. The function will calculate the accrued interest for a security that pays interest on a periodic basis. ACCRINT helps users calculate the accrued interest on a security, such as a bond, when that security is sold or is transferred to a new…
What is the CEILING.PRECISE Function? The CEILING.PRECISE Function is categorized under Excel Math and Trigonometry functions. It will round up a number to the nearest integer or multiple of significance. As a financial analyst, we can use CEILING.PRECISE in setting the pricing after currency conversion, discounts, etc. When preparing financial models, it helps us round…
What is the CEILING.MATH Function? The CEILING.MATH Function is categorized under Excel Math and Trigonometry functions. it will return a number that is rounded up to the nearest integer or multiple of significance. The function was introduced in MS Excel 2013. As a financial analyst, we can use the CEILING.MATH function in setting the pricing…
What is the PROB Function? The PROB Function is categorized under Excel Statistical functions. It will calculate the probability that is associated with a given range. In financial analysis, the PROB function can be useful in estimating business losses. It can also be used by a risk manager to carry out financial probability analysis. Formula…
What is the ISO.CEILING Function? The ISO.CEILING Function is an Excel Math and Trigonometry function. It is one of the fifteen rounding functions of MS Excel. The function returns a number rounded up to the nearest integer or to the nearest multiple of significance. It works regardless of whether the number given is positive or…
What is the COMBINA Function? The COMBINA Function is an Excel Math and Trigonometry function. It will calculate for a given number of items the number of combinations, along with repetitions. The function was introduced in MS Excel in 2013 and hence not available in earlier versions. Formula =COMBINA(number, number_chosen) The COMBINA function uses the…
What is the DSUM Function? The DSUM Function is categorized under Excel Database functions. The function helps to calculate the sum of a specific field/column in a database for selected records based on user-specified criteria. DSUM was introduced in MS Excel 2000. As a financial analyst, if we need to find out the total number…
What is the DOLLARFR Function? The DOLLARFR Function is an Excel Financial function. DOLLARFR helps in converting a dollar value in decimal notation into a dollar value expressed in fractional notation. The function was introduced in MS Excel 2007. DOLLARFR is very useful when dealing with financial reports and stock market quotes. Financial analysts often…
What is the MDURATION Function? The MDURATION Function is categorized under Excel Financial functions. It will calculate the duration of a security using the Modified Macauley method. In financial analysis, we often evaluate a bond and develop a strategy that will match the duration of assets and liabilities. This is done to minimize the impact…
What is the BASE Function? The BASE Function is available under Excel Mathematical and Trigonometric functions. The function returns a text representation of the calculated value and will convert a number into the supplied base (radix). BASE was introduced in Excel 2013 and is unavailable in earlier versions. Formula =BASE(number, radix, [min_length]) The BASE function…
