3 ways to calculate CAGR in Microsoft Excel
You’ve come across the term CAGR and want to know how to calculate it in Excel? This post gives you three different ways to do so in Microsoft Excel. But, first, let’s understand what CAGR is.
You’ve come across the term CAGR and want to know how to calculate it in Excel? This post gives you three different ways to do so in Microsoft Excel. But, first, let’s understand what CAGR is.
Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we’ll use VLOOKUP to find a value from the table. Firstly, let’s create the above table in Excel.
Payback period in capital budgeting refers to the period of time required for the return on an investment to “repay” the sum of the original investment. For example, a $1000 investment which returned $500 per year would have a two year payback period. The time value of money is not taken into account.
In my last Excel Tutorial, I covered using SUMIFS and SUMPRODUCT. Data Tables is also an advanced topic in Microsoft Excel that falls under the category of What-If Analysis. What-If or Sensitivity Analysis is carried out to study the variation of the output to changes in the input variable.
In the last two posts, you learnt the basics of Net Present Value (NPV) and how to calculate NPV using formulae. However, Microsoft Excel makes it easy for you with two inbuilt functions. The first is NPV (surprise!) and the second is XNPV (my favourite). NPV From the official help article, NPV takes the following…
Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we’ll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.
Three weeks back I covered creating Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variable data table. This tutorial assumes that you have read the earlier one and are comfortable with creating a single variable data table.
Excel has several lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH.
In it’s portfolio, Google has a large set of free useful services. One that is most frequently used is Google Drive, which is used for storing and sharing digital data. This service is used by almost everyone because it is free and it integrates with other Google services. A feature that many users like is…
Welcome to the downloads section here on Techtites. Find below a collection of downloads written by me and some of the other writers here on Techtites. Excel Files Division with SUMPRODUCT example Excel File containing VLOOKUP example Excel File containing INDEX MATCH example Excel File containing Goal Seek example Excel File containing One Variable Data…