Course overview
To refine students understanding of spreadsheet design and construction, and to develop their abilities to critically evaluate the roles, uses and limitations of spreadsheet-based modelling techniques in finance and investment decision-making.
Course learning outcomes
- Demonstrate a knowledge of important financial models in the areas of corporate finance, financial statement simulation, portfolio analysis and management, option valuation and interest rate risk
- Select spreadsheet models that are appropriate to different financial problems
- Explain how financial models can be constructed and solved numerically using Microsoft Excel or similar spreadsheet software
- Implement a variety of models used in finance and investment
- Recognise and be able to discuss the limitations associated with the structure and estimation, or simulation results, of each financial model studied during the course