Financial Modeling

Lesson 1 - Cash Flow Model

After completing this lesson you will be able to:

 

         Identify key objectives of why financial models are created

         Establish a hurdle rate for an investment

         Apply three different approaches to discounting

         Create a formula in Microsoft Excel for calculating Net Present Value

         Create a formula in Microsoft Excel for calculating Rate of Return

         Create a financial function in Microsoft Excel for computing the payback period

         Create a formula in Microsoft Excel for calculating Equivalent Annual Annuity

 

 

This lesson also includes a self-study workbook to assist you. Click Here to download the workbook.

Lesson 1 Learning Objectives