I haven’t written anything about Excel for a long time, and today I’ve chosen the XLOOKUP function, which I shamefully haven’t described here yet. The function was officially introduced in September 2019, initially in Office 365 versions, and gradually became a standard part of Excel, including older versions. The main reason for introducing XLOOKUP is… Read More »
The PMT function in Excel is used to calculate the loan repayment amount (annuity payment). It doesn’t matter whether we are talking about mortgages, consumer loans, or non-bank loans — in most cases, the repayment amount is calculated using the principle of annuity repayment. Formula for the PMT function Before we look at an example, let’s… Read More »
The NPER function belongs to the simpler financial functions used in financial mathematics and interest calculations. With this function, we can easily determine how long we will be repaying a loan, given (i) the loan amount, (ii) the interest rate, and (iii) the annuity payment (PMT). In this article, we’ll demonstrate how the function works… Read More »
The RATE function in Excel belongs to the group of financial functions commonly used in financial mathematics and interest rate calculations or/and in finance analysis. Along with several other functions, it is typically used to determine the parameters of a loan. In the previous article, we explained how to use the NPER function and demonstrated… Read More »
The Present Value (PV) function is primarily used in financial calculations. The theory of present value is important in finance and financial modeling, especially in investment decision-making. This function helps account for the time value of money – receiving 1 USD today is more valuable than receiving 1 USD tomorrow, because you can invest it… Read More »
Internal Rate of Return (IRR – internal rate of return) is a widely used concept in finance. It is mainly used to evaluate the profitability of an investment that generates cash flows over time (which often have to be estimated). Every company or investor must decide whether it makes sense to commit an initial investment… Read More »
Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out if a certain condition is met. Often used function IF belongs to logical functions, except for this function, you will most often use functions AND and… Read More »
SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, minimum/maximum and another statistic values using SUBTOTAL function. What’s more, we can limit whether we want to calculate even with hidden values which were hidden manually. All under roof of one function. SUBTOTAL –… Read More »
There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may have needed to extract some certain parts of the data of date and time data types, for example month. All functions have identical and absolutely simple… Read More »
You have a huge table with many date entries in it. You need to find out which date is after 20th week of the year or if a certain date is Friday. MS Excel will help by three functions – WEEKNUM, ISOWEEKNUM,WEEKDAY . It is definitely more effective than searching in calendar. More so if… Read More »