What is the TRUNC Function? The TRUNC Function is an Excel Math and Trigonometry function. It removes the fractional part of a number and, thus, truncates a number to an integer. It was introduced in MS Excel 2007. In financial analysis, the function can be used to truncate a number to a given precision. It…
What is the SUMPRODUCT Excel Function? The SUMPRODUCT Function is categorized under Excel Math and Trigonometry functions. The function will multiply the corresponding components of a given array and then return the sum of the products. It is used to calculate a weighted average. As a financial analyst, SUMPRODUCT is a very handy function, as…
What is the SQRT Function? The SQRT Function is an Excel Math and Trigonometry function. It will provide the square root of a positive number. The function was introduced in MS Excel 2010. Formula for the SQRT Function =SQRT(number) The SQRT function uses the following argument: Number (required argument) – This is the number for…
What is the ROUNDUP Function? The ROUNDUP Function is categorized under Excel Math and Trigonometry functions. The function will round up a number away from zero. As a financial analyst, the ROUNDUP function is useful as it helps round a number and eliminates the least significant digits, simplifying the notation but keeping close to the…
What is Synthetic Position? A synthetic position is a trading option used to simulate the features of another comparable position. More specifically, a synthetic position is created to simulate a similar reward or risk profile as that of a comparable position. In the field of options trading, a synthetic position is developed in two ways….
What is the PDURATION Function? The PDURATION Function is an Excel Financial function. It helps the user calculate the time or the specific number of periods required for an investment made to reach a particular value. In simple terms, it will answer the question: Suppose we invested $1,000,000 at 4% per annum – how long…
What is the DISC Function? The DISC Function is an Excel Financial function. It will calculate the rate of discount for a bond. It helps to know the discount rate when we know the other details about the bond. Formula =DISC(settlement, maturity, pr, redemption, [basis]) The DISC function uses the following arguments: Settlement (required argument)…
Beneish M Score Calculator The Beneish M Score calculator is used to determine whether or not the company has manipulated its reported earnings in its financial statements. This Beneish M Score calculator takes financial data that can be found on the company’s financial statements as inputs and calculates eight different financial ratios. It then applies…
What is the DB Function? The DB Function is an Excel Financial function. This function helps in calculating the depreciation of an asset. The method used for calculating depreciation is the Fixed Declining Balance Method for each period of the asset’s lifetime. Formula =DB(cost, salvage, life, period, [month]) The DB function uses the following arguments:…
What is the QUARTILE.INC Function? The QUARTILE.INC Function is categorized under Excel Statistical functions. It will return the quartile of a given data set based on percentile values from 0.1, inclusive. The function bases its calculation on a percentile range of 0 to 1, inclusive. As a financial analyst, QUARTILE.INC can be used to find…
