All resources related to FINANCIAL for Excel and Google Sheets.

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

Annual compound interest schedule in Excel

Excel allows a user to create an annual compound interest schedule, using the simple formula. This step by step tutorial will assist all levels of Excel users in creating annual compound interest schedule Figure 1. The result of the formula Syntax of the Formula The generic formula is: =initial_balance +...

Calculate COMPOUND Interest

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

How to Calculate an Original Loan Amount in Excel

We can calculate an original loan amount by using the Present Value Function (PV) if we know the interest rate, periodic payment, and the given loan term. This function tells the present value of an investment.The steps below will walk you through the process of calculating an original loan amount....

Excel CUMPRINC Function

When paying off a loan, we often wonder how much of the principal amount have we paid off already. There is a financial function in Excel that calculates the cumulative principal paid over a period of time, the CUMPRINC function. This step by step tutorial will assist all levels of...

The Interest Rate Function in Excel

Figure 1. of Interest Rate Calculation in Excel. The Interest Rate Function in Excel allows us to calculate per period of a loan. In this post, we are going to walk through the usage and formula syntax of the Rate Function in Excel. Generic Formula =PMT(rate,periods,-amount) The components of the...

How to Calculate Payment For a Loan in Excel

While taking a loan from a bank or a financial institution, our primary concern is how much we have to make periodic payment (monthly, quarterly, annually) to pay back that loan on a given interest rate and in the total number of payments. Using the Excel PMT function we calculate...

Learn How to Use the Excel PPMT Function

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

How to Calculate Simple Interest in Excel

There is a formula in Excel which calculates simple interest by multiplying the principal, the rate, and the term. Calculate simple interest in Excel Consider the example demonstrated below in which the formula in C5 is =C2*C3*C4 In order to do a simple interest calculation in Excel using the COUNTA...

Calculate interest for given period

Excel allows us to calculate the interest payment for any loan using the IPMT function. This step by step tutorial will assist all levels of Excel users in calculating the interest paid for a given period. Figure 1. Final result: Calculate interest for given period using IPMT function Final...