Similar Content
PV Function - Get the Present Value in Excel
Tutorial: The Present Value (PV) function in Excel will return the current value of an investment.Â...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...

# Excel Finance Trick #1: FV PV & Time Value Of Money

FV = Future Value. PV = Present Value. Learn about the Time Value of Money. See how the concept of "Time Value of Money" is a fundamental idea in Finance.

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.