Thursday, January 21, 2021
When you're refinancing, this chart allows you to use the tip of your finger trade off your monthly payments and your total payments as you consider the term of your loan.

Calculate Mortgage Payments and Your ROA with an Excel CalcPlot Chart

An Excel CalcPlot Chart allows you to plot values in three dimensions, not merely two. Here are two examples. Mortgage Paments Mortgage interest rates are at...
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...
These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way.

Five Really Useful Excel Keyboard Shortcuts

Most Excel users use some of Excel's shortcuts frequently, like F9, Ctrl + C and Ctrl + V. However, Excel offers other shortcuts that are nearly as useful....
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

How to aggregate named groups of GL accounts.

How to Report GL Account Groups in Excel

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the only strategy that will work for you.

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...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

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