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 ...
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




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.