Search TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
TE
Home
Video Tutorials
Free Macros
Keyboard Shortcuts
Forum
Contact
Main Menu
  • Home
  • Video Tutorials
    • Arrays
    • Charts & Graphs
    • Financial Functions &
    • Models
    • Formatting
    • Formulas
    • Data Analysis Tools
    • Import / Export / Link
    • Lists & Forms
    • Macros
    • Printing
    • Security
    • Tips & Tricks
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Forum
  • Contact/About
Tips
Create your first Formula
Create your first Chart or Graph
Password protect your Workbook
Hide Rows, Columns, and Tabs
Using Conditional Formatting
Tutorials: Financial Functions & Models

Net Present Value / Discounted Cash Flow Calculations

This video tutorial shows you how to compute the net present value and the present value of a project, projected cash flows, or future payments. The NPV() function is used in this tutorial; you are shown how to use it and also its limitations. This can also be considered a simple example of a discounted cash flow calculation.

Topics Covered
     Net Present Value Calculations
     NPV() Function
     Discounted Cash Flow Analysis
     Real & Nominal Interest Rates        Conversion
   Difficulty:         Intermediate
   Video:               Yes
   Spreadsheet:     Yes      Download
Got a Question? Ask it Here in the Forum.
Most Recent Tutorials
Nov. 25
Group and Ungroup Cells in Excel (Easily Hide and Unhide Data)
Absolute and Relative Cell References & INDIRECT() Function
Sep. 20
Bond Pricing and Valuation
Calculate the Future Value of a Retirement or Savings Plan
Calculate the Net Present Value of Future Cash Flows
Build a Loan/Mortgage Payment Calculator
Calculate Interest and Principal Payments on a Loan
Sep. 10
FIND() LEN() Functions - Extract Text from Cells - Intermediate
FIND() LEN() Functions - Extract Text from Cells - (2 Parts) - ADVANCED
VLOOKUP() Between Separate Worksheets and Workbooks
Contact | Privacy Policy | Disclaimer
Copyright© 2009 TeachExcel.com