Home / Courses
Financial Modelling
UoS Code FINC6019
Credit points 6
Offered Semester 1
Prerequisites FINC5002 or FINC6000
Corequisites
Prohibitions
Assumed Knowledge
Additional Information
Lectures 3 hrs per week
Assessment Laboratory task; Group assignment; Final exam
Description It is important for practitioners of finance, at all levels, to be able to evaluate the applicability of a range of models for a given problem and to effectively implement and use the model that is selected. This unit will present methods for model design, implementation and evaluation in the context two fundamental financial models; the discounted cash flow valuation model and the portfolio selection model. Spreadsheet engineering methods for designing, building, and testing spreadsheet models and for performing model-based analysis will be presented. There will be a concise coverage of optimization, sensitivity analysis and simulation featuring a strong spreadsheet orientation and a modeling emphasis.