What is the F.DIST.RT Function? The F.DIST.RT Function is categorized under Excel Statistical functions. It will calculate the (right-tailed) F probability distribution. It measures the degree of diversity between two data sets. For example, we can use the function if we wish to find out the variability in the test scores of female employees in…
What is the PHI Function? The PHI Function is an Excel Statistical function. It will return the value of the density function for a standard normal distribution for a supplied number. The function was introduced in MS Excel 2013 and hence unavailable in earlier versions. Formula =PHI(x) The PHI function uses the following argument: X…
What is the Home Equity Line of Credit (HELOC) Calculator? The Home Equity Line of Credit (HELOC) calculator can calculate the maximum line of credit available for a homeowner. A HELOC is similar to a mortgage, as both types of loans use a house as collateral. However, there are no fixed principal repayments or pre-set…
What is Delta? Delta is a risk sensitivity measure used in assessing derivatives. It is one of the many measures that are denoted by a Greek letter. The series of risk measures that use such letters are fittingly referred to as the Greeks. They are often also called risk measures, hedge parameters, or risk sensitivities….
What is the GROWTH Function? The GROWTH Function is categorized under Excel Statistical functions. The function helps calculate predicted exponential growth by using existing data. In financial analysis, GROWTH helps in preparing annual plans or forecasting revenues for a company. Let’s assume the CEO expects annual revenues to reach $1,500,000. The function can help us…
What is the ACCRINTM Function? The ACCRINTM Function is an Excel Financial function. ACCRINTM was introduced in MS Excel 2007 and hence not available in earlier versions. When we invest in an interest-paying security, we will receive interest payments that are paid either at once or periodically. The function will calculate the accrued interest for…
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…
