FINANCIAL Articles: Excel and Google Sheets

Whether you're a business owner, financial consultant, investment advisor, or student, you may have use of the many financial analysis functions and formulas available in Excel. In fact, this is one of the strengths of this software.  Excel provides its users with a variety of ways to perform financial calculations,...

Excel offers some great tools to work with interest. The Excel RATE function is one such tool. It is a financial function. It calculates the rate of interest for a given period of an investment or loan. In this tutorial, we will learn how to use the function RATE in...

We use the NPER function in combination with the PV, PMT and RATE functions to calculate the number of installment paid within a period. This article will walk through the process. Figure 1 – Final result of the NPER function using the PV, PMT, and RATE function. General Formula =NPER(rate,...

Excel allows a user to calculate a cumulative loan principal payment for any period using the CUMPRINC function. This step by step tutorial will assist all levels of Excel users in calculating a cumulative principal payment for a selected period. Figure 1. The result of the function Syntax of the...

The XIRR function in Excel calculates the internal rate of return for scheduled but not necessarily periodic cash flows.  This tutorial will assist all levels of Excel users in calculating the internal rate of return for cash flows occurring at irregular intervals.   Figure 1. Result of XIRR function Syntax...

You can use the Excel PV function to get the present value of an investment. The function is most fundamental when it comes to calculating the value in today’s dollars of a series of future payments. While working with this function, we assume that future payments are periodic, constant with...

If we want to calculate the net present value of an investment using a given discount rate, we can make use of the excel NPV function. This article will guide you on how to utilize this function to find the net present value. Figure 1: Using NPV function to find...

Excel allows us to calculate the principal payment for any loan using the PPMT function. This tutorial will assist all Excel users in calculating a principal portion in a loan for a given month. Figure 1. Result of PPMT function for principal payment on the 5th month Syntax of the...

Excel allows a user to calculate a cumulative loan interest, by using the CUMIPMT function. This step by step tutorial will assist all levels of Excel users in calculating a cumulative loan interest. Figure 1. The result of the CUMIPMT function Syntax of the CUMIPMT Formula The generic formula for...

Excel allows a user to get a future value of an investment using the FV function. This step by step tutorial will assist all levels of Excel users in calculating the future value of an investment. Figure 1. The result of the FV function Syntax of the FV Formula The...