Resources Archive

NPV Function

What is the NPV Function? The NPV Function is an Excel Financial function that will calculate the Net Present Value (NPV) for a series of cash flows and a given discount rate. It is important to understand the Time Value of Money, which is a foundational building block of various Financial Valuation methods. In financial modeling, the NPV function…

N Function

What is the N Function? The N Function is categorized under the Text functions in Excel. It will return a number when we provide a value. The function can be used to convert logical values TRUE and FALSE into 1 and 0, respectively. As a financial analyst, the N function offers limited use, as MS…

MATCH Function

What is the MATCH Function? The MATCH Function is categorized under Excel Lookup and Reference functions. It looks up a value in an array and returns the position of the value within the array. For example, if we wish to match the value 5 in the range A1:A4, which contains values 1,5,3,8, the function will…

NETWORKDAYS Function

How to Calculate Working Days in Excel The NETWORKDAYS Function calculates the number of workdays between two dates in Excel. When using the function, the number of weekends are automatically excluded. It also allows you to skip specified holidays and only count business days. It is categorized in Excel as a Date/Time Function. You can use…

XIRR Function

What is the XIRR Function? The XIRR Function is categorized under Excel financial functions. It will calculate the Internal Rate of Return (IRR) for a series of cash flows that may not be periodic. It does this by assigning specific dates to each individual cash flow. The main benefit of using the XIRR Excel function…

T Function

What is the T Function? The T Function is categorized under Excel Text functions. It will test if the value provided is text or not. If it is text, then the function will return the text. Otherwise, it will return an empty text string. T is one of two functions in Excel that contains only…

IF Function

What is an Excel IF Statement? The Excel IF Statement tests a given condition and returns one value for a TRUE result and another value for a FALSE result. For example, if sales total more than $5,000, then return a “Yes” for Bonus; otherwise, return a “No” for Bonus. We can also use the IF…

TEXT Function

What is the Excel TEXT Function? The Excel TEXT Function is used to convert numbers to text within a spreadsheet. Essentially, the function will convert a numeric value into a text string. TEXT is available in all versions of Excel. Formula =Text(Value, format_text) Where: Value is the numerical value that we need to convert to text…

TREND Function

TREND Function – Forecast & Extrapolate in Excel The TREND Function is an Excel Statistical function that will calculate the linear trend line to the arrays of known y and known x. The function extends a linear trend line to calculate the additional y-values for a new set of x-values. This guide will show you…

MINIFS Function

What is the MINIFS Function? The MINIFS Function is categorized under Excel Statistical functions. It will return the smallest numeric value that meets one or more criteria in a given range of values. In financial analysis, the MINIFS function can be used to extract a minimum numeric value. For example, we can get the minimum…

« Prev 1 … 505 506 507 508 509 … 606 Next »

Archives: Resources