Friday, September 24, 2021
To calculate the correct growth rate for your data you need to be clear about what you want your growth rate to signify. Here's how to work it out.

How to Calculate BOTH Types of Compound Growth Rates in Excel

If you search the web to learn how to calculate a compound growth rate in Excel, you’ll likely find instructions for calculating only one...
The Internal Rate of Return calculation has very real problems, no matter where it's calculated. But with its MIRR function, Excel could offer a solution.

How Excel’s MIRR Function Can Fix the IRR Function

The calculation of an Internal Rate of Return is very appealing...at first glance. When you know the IRR of a prospective investment, you seem to...
Here's how to set up Future- and Present-Value formulas that allow compounding by using an interest rate and referencing cash flows and their dates.

Find Future and Present Values from Scheduled Cash Flows in Excel

"I would like a Future Value command similar to the XIRR and XNPV functions, which allow compounding by using an interest rate and referencing...
The Rule of 72 is a guesstimate of how long it will take an investment at a specific interest rate to double in value. But how accurate is it? Ask Excel.

Excel and the Rule of 72

I recently learned that my son—who's an avid amateur investor—had never heard of the Rule of 72. The rule of 72, I texted him, says...
Both IPMT and ISPMT return the interest payment for a given period for a loan or investment. But Microsoft's help topics haven't made their differences clear. Here's what you need to know about these two financial functions.

How to Create Even-Payment and Straight-Line Amortization Tables in Excel

When you borrow money for a fixed period with periodic payments, you could have two types of loans: even-payment or straight-line. Microsoft recognizes those loan...
Most loans and many investments are annuities, which are payments made at fixed intervals over time. Here's how to use Excel to calculate any of the five key unknowns for any annuity.

Excel’s Five Annuity Functions

“Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
Mortgage lenders give you many options for your interest rate and amortization period. This workbook helps you to choose from among them.

Compare Loan Payment Options in Excel

When you’re comparing your payment options for mortgage loans, your choices can be overwhelming... When in St. Ives, I found a home, Then looked at seven...
Term loans can have a variety of repayment periods, interest rates, amortizing methods, and so on. Here's how to calculate amortization schedules for the two most common types of amortizing loans.

How to Use Excel Formulas to Calculate a Term-Loan Amortization Schedule

"How do I calculate cumulative principal and interest for term loans? I have scoured the web for a function that will perform this task,...

Latest Articles

Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

How I Set Up SEARCH and FIND Formulas on Steroids

I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
Use this unique Excel dashboard to track the general rate of inflation, your personal rate, and the rate of the goods and services you buy.

Inflation Tracker Excel Dashboard with Consumer Prices

U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats." However, a rising inflationary tide does not lift...
Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

Eight Great Tools for Your Quick Access Toolbar

I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...
Advertisement
Advertisement