What is the OFFSET Function? The OFFSET Function is categorized under Excel Lookup and Reference functions. OFFSET will return a range of cells. That is, it will return a specified number of rows and columns from an initial range that was specified. In financial analysis, we often use Pivot Tables and Charts. The OFFSET function…
What is the WEEKDAY Function? The WEEKDAY Function is an Excel DATE and TIME Function. The function will return an integer that is a representation of the day of the week for a given date. WEEKDAY is quite useful in financial analysis. Suppose we wish to determine the time required to complete a certain project…
What is the ROWS Function? The ROWS Function is an Excel Lookup/Reference Function. The function is used to look up and provide the number of rows in each reference or array. Thus, the function, after receiving an Excel range, will return the number of rows that are contained within that range. in financial analysis, we…
What is the RATE Function? The RATE Function is an Excel Financial function that is used to calculate the interest rate charged on a loan or the rate of return needed to reach a specified amount on an investment over a given period. For a financial analyst, the RATE function can be useful to calculate the…
What is the FREQUENCY Function? The FREQUENCY Function is categorized under Excel Statistical functions. The function will calculate and return a frequency distribution. We can use it to get the frequency of values in a dataset. In financial modeling, FREQUENCY can be useful in calculating the frequency of a value within a range of values….
What is the REPT Function? The REPT Function is categorized under Excel Logical functions. The function will repeat characters a given number of times. In financial analysis, we can use the REPT function to fill a cell or pad values to a certain length. We can also build histograms, a chart commonly used in financial…
What is Tactical Asset Allocation (TAA)? Tactical asset allocation (TAA) refers to an active management portfolio strategy that shifts asset allocations in a portfolio to take advantage of market trends or economic conditions. In other words, tactical asset allocation refers to an investment style in which asset classes such as stocks, bonds, cash, etc. are…
What is the QUARTILE Function? The QUARTILE Function is categorized under Excel Statistical functions. The function will return the quartile of a given data set. As a financial analyst, QUARTILE can be used to find out, for example, a specific percentage of incomes in a population. The function is very useful in revenue analysis. Formula…
What is the FIXED Function? The FIXED Function is categorized under Excel TEXT functions. It will provide a text representation of a number rounded to the specified number of decimal places. While doing financial analysis, we often import data from external sources. The FIXED function helps convert numbers into text. Formula =FIXED(number, [decimals], [no_commas]) The…
What is the PV Function? The PV Function is a widely used financial function in Microsoft Excel. It calculates the present value of a loan or an investment. In financial statement analysis, PV is used to calculate the dollar value of future payments in the present time. For multiple payments, we assume periodic, fixed payments and…
