O'Reilly logo

Tips & Tricks for Excel-Based Financial Modeling, Volume I by M.A. Mian

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 3

Excel’s Financial Functions

Excel’s financial functions, their interpretation, and correct formulation are presented in this section. A majority of these functions are routinely used in day-to-day project economics and financial modeling.

The PV, FV, and PMT Functions

For apple-to-apple comparison of cash-flows from various investments or projects it is important to convert each cash-flow into equivalent basis. The equivalence could be converting all cash-flows to present value (PV, time zero) or to sometime in the future (FV, future value) or distributed equivalently over each year (AV or AE, annual equivalent). The AV or AE in Excel are represented by PMT (periodic payment). The conversion of future cash-flows to PV is called discounting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required