1. Catalog
  2. Finance
  3. Valuation Models
  4. Intro to Excel Financial Present Value Functions
  • Intro to Excel Financial Present Value Functions
  • Intro to Excel Financial Present Value Functions
  • Intro to Excel Financial Present Value Functions
Originally published: 12/01/2018 16:51
Last version published: 02/03/2018 15:42
Publication number: ELQ-85455-2
View all versions & Certificate
certified

Intro to Excel Financial Present Value Functions

This video goes over basic excel financial function.

Prof. Norm Miller PhDby Prof. Norm Miller PhD
Professor & Chair in Real Estate Finance @ University of San DiegoFollow 150
University of San Diegowith University of San Diego
The youngest private university among the top 100 in the nationFollow
145 views|Start the discussion!|Bookmark
financeexcelspreadsheetfinancialsbasicstutorialfinancial functionvalue functions
Description
In this video, Prof. Norm Miller reviews some essential present value calculations using excel. Formulas as well as function keys are used here. You will be shown how Prof. Miller has obtained the future value, the payment, and the present value presented in the spreadsheet using a screen-sharing method.

You will be walked through a basic introduction to excel financial function as well as IRR & Sinking Fund Factor, Vlookup & Hlookup, Mortgage Constant and If statement.

Length: 12 minutes 50 seconds

This Best Practice includes
1 Video File

Add to bookmarks

Did Prof. Norm Miller PhD's Best Practice help you? You can make a small financial contribution to support the author.

helpSupport


0.0 / 5 (0 votes)

please wait...