Top 10 formulas that help the student of financial Modelers to learn
Top 10 formulas that help the student of financial Modelers to learn
SUMIFS
The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.
IFERROR
IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.
XIRR
XIRR or extended internal rate of return is a single rate of return that provides the current value of the entire investment when applied to each systematic investment plan (SIP). It is used where many transactions happen during a period.
XNPV
Returns the net present value for a schedule of cash flows that is not necessarily periodic.
PMT
PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.
SLOPE
The slope is a value that indicates the rate at which the y value of a line rises or falls as the x value increases.
XLOOKUP
The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds.
INDEX & MATCH
INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. This is because INDEX and MATCH are incredibly flexible
EOMONTH
The EOMONTH is a worksheet date function in Excel that calculates the end of the month for the given date by adding a specified number of months to the arguments.
SEQUENCE
The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In the following example, we created an array that's 4 rows tall by 5 columns wide with =SEQUENCE(4,5).