Excel Forum
Similar Content
Calculate the Future Value (FV) of Compound Interest in Excel - UDF Macro
Macro: This UDF (user defined function) calculates the Future Value of Compound Interest in E...
FV Function - Get the Future Value in Excel
Tutorial: The Future Value function (FV) in Excel will return the future value of an investment ba...
Introducing Logic into Formulas and Functions in Excel
Tutorial: In this tutorial I am going to introduce the idea of Logic in Formulas. A Logic test is a ...



Highline Excel Class 50: Value Asset: PV NPV & XNPV function


See how to value an asset, Discounted Cash Flow Analysis, with the Excel functions PV NPV & XNPV:
1.Periodic equal payments use the PV Excel function
2.Periodic unequal payments use the NPV Excel function
3.Not periodic time periods and unequal payments use the XNPV Excel function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Present Value, Discounted Cash Flow Analysis for valuing assets.





Got a Question? Ask it Here in the Forum.