Thursday, December 7, 2023
Home Formulas & Functions Financial Functions

# Financial Functions

Worksheet functions that deal with the time value of money.

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

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

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

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

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

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

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

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

### Here’s How Inflation Could Affect the Value of Your Home

November 5, 2021 Inflation is rising in the U.S. And that made me wonder how a higher rate of inflation could affect the price of...

### How Fast Is Too Fast?

(Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...

### How to Smooth Data by Using the TREND Function

Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...

### Consumer Sentiment Suggests a 2022 Recession

In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...