DCU Home | Our Courses | Loop | Registry | Library | Search DCU

Module Specifications..

Current Academic Year 2023 - 2024

Please note that this information is subject to change.

Module Title Financial Modelling with Excel
Module Code MS119
School School of Mathematical Sciences
Module Co-ordinatorSemester 1: Michael Marsh
Semester 2: Michael Marsh
Autumn: Michael Marsh
Module TeachersMichael Marsh
NFQ level 6 Credit Rating 5
Pre-requisite None
Co-requisite None
Compatibles None
Incompatibles None
None
Description

Module MS119 aims to provide students with a grounding in financial modelling techniques through the use of Excel. The module will introduce students to Excel programming and data analysis. Principles of spreadsheet design and model documentation will be covered. Students will develop basic financial models using cashflow projections and will use discounted cashflow techniques to solve investment problems.

Learning Outcomes

1. Present and summarise financial data using standard Excel graphs and formulas.
2. Develop Excel models for simple financial problems incorporating best practice in the use of parameterisation, presentation, sense checks and documentation.
3. Calculate accumulated values, present values and net present values for cashflow projections.
4. Define an equation of value.
5. Develop a loan schedule for simple loan scenarios.
6. Solve simple financial equations using Excel's Goal Seek function.



Workload Full-time hours per semester
Type Hours Description
Lecture12Presentation of course material.
Laboratory12Practical computer labs in Excel - mixture of presentations and students working from supplied lab sheets.
Tutorial10Working from supplied tutorial sheets.
Independent Study91Revising course work, solving tutorial and lab sheets.
Total Workload: 125

All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml

Indicative Content and Learning Activities

Introduction to Excel
Basic excel functions - sum, average, count; Data visualisation - graphs, charts; Data manipulation - hlookup, vlookup, if function.

Excel Modelling
Spreadsheet design, parameterisation, named ranges; documentation and audit trails; sense checks.

Time Value of Money
Present and future values; accumulating and discounting payment streams.

Cashflow Projections
Net cashflows, comparison of investment projects, net present values; loan schedules

Equations of Value
Investment appraisal; Solving equations of value using Excel goal seek function.

Assessment Breakdown
Continuous Assessment50% Examination Weight50%
Course Work Breakdown
TypeDescription% of totalAssessment Date
Practical/skills evaluation2 Excel based computer lab exams50%n/a
Reassessment Requirement Type
Resit arrangements are explained by the following categories;
1 = A resit is available for all components of the module
2 = No resit is available for 100% continuous assessment module
3 = No resit is available for the continuous assessment component
This module is category 1
Indicative Reading List

    Other Resources

    None
    Programme or List of Programmes
    ACMBSc in Actuarial Mathematics
    CAFMCommon Entry, Actuarial, Financial Maths
    Archives:

    My DCU | Loop | Disclaimer | Privacy Statement