Excel Forum
Similar Content
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
Prevent Errors From Appearing in Excel
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for ...



Excel Finance Trick #5: PMT & FV function & Delayed Payments


See how to use the PMT & FV function together to calculate a delayed PMT payment amount.

See how to use the PMT function to calculate a payment amount when there are delayed payments. When you have to make Period payments on a loan contract and you are not required to make payments until sometime later use this trick to calculate the PMT amount.

See how to use the PMT & FV function together to calculate a delayed PMT payment amount.

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!

Formula





Got a Question? Ask it Here in the Forum.