Friday, November 27, 2020
Home Formulas & Functions Financial Functions

# Financial Functions

Worksheet functions that deal with the time value of money.

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

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

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

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

### An Introduction to Excel Data Plumbing

Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...

### How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...

### Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...