All resources related to FINANCIAL for Excel and Google Sheets.

All articles
FINANCIAL

Excel RATE Function

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...

Excel NPER Function

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,...

How to Calculate Cumulative Loan Principal Payments in Excel

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...

Excel XIRR Function

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...

Excel PV Function

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...

Excel NPV Function

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...

Calculate principal for given period

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...

Calculate cumulative loan interest

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 FV Function

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...

Excel IRR Function

Excel allows a user to get an internal rate of return of an investment using the IRR function. This step by step tutorial will assist all levels of Excel users in getting an IRR of an investment. Figure 1. The result of the IRR function Syntax of the IRR Formula...