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.