Excel Forum
Similar Content
Filter Data to Show the Top X Number of Items in Excel - AutoFilter
Macro: This Excel macro filters a data set to display only the top X number of items in that data...
Easier Table References in Excel
Tutorial: Some simple tips to make table references easier in Excel, even when you don't remember t...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Finance Trick #17: Amortization Table w x Column


See how to create an Amortization Table with an Additional Payment Column. Learn how an Amortization Table shows you how much of each payment (PMT) is consumed by Interest and how much is left for the Principal Reduction.

See a trick for inventing complicated formulas. See how to correct formulas that do not evaluate to correct solutions. See how to edit complicated formulas. See how to use the IF function to fix an amortizations table problem.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!

The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!

Excel Formula





Got a Question? Ask it Here in the Forum.