Page Navigation

Module Descriptors

This page displays the selected Module Descriptor.

Printer friendly version Printer friendly version

Session: 2022/23

Last modified: 30/09/2021 11:46:57

Title of Module: Financial Modelling and Research Methodology

Code: LNDN11007 SCQF Level: 11
(Scottish Credit and Qualifications Framework)
Credit Points: 20 ECTS: 10
(European Credit Transfer Scheme)
School:School of Business & Creative Industries
Module Co-ordinator:David  Leung

Summary of Module

This module equips you with the knowledge to build financial statement models for a variety of business planning purposes. These include for example: raising capital, making acquisitions, growing the business, budgeting and forecasting, valuing a business, ratio analysis and management accounting. Using popular software such as Microsoft Excel, you will learn to build income statements, balance sheets, and cash flow forecasts; develop more complex models involving discounted cash flows and sensitivity analysis; and to use charts and graphs for professional presentations.

This module will also provide you with the research knowledge and skills that you will need for your Strategic Business Project or the Developing Professional Practice module. It will require you to examine methods, strategies and data (both quantitative and qualitative). You will be exposed to various methodological paradigms/philosophies and provided with guidance on those which are most suited to your potential research topics. Research design and planning will be considered. You will learn how to design suitable methods for collecting data and be introduced to qualitative and quantitative research methods, and primary, secondary and tertiary data sources. The module will also examine how data can be interpreted and presented.

 


Module Delivery Method
Face-To-FaceBlendedFully OnlineHybridCHybridOWork-based Learning
check mark

Face-To-Face
Term used to describe the traditional classroom environment where the students and the lecturer meet synchronously in the same room for the whole provision.

Blended
A mode of delivery of a module or a programme that involves online and face-to-face delivery of learning, teaching and assessment activities, student support and feedback. A programme may be considered “blended” if it includes a combination of face-to-face, online and blended modules. If an online programme has any compulsory face-to-face and campus elements it must be described as blended with clearly articulated delivery information to manage student expectations

Fully Online
Instruction that is solely delivered by web-based or internet-based technologies. This term is used to describe the previously used terms distance learning and e learning.

HybridC
Online with mandatory face-to-face learning on Campus

HybridO
Online with optional face-to-face learning on Campus

Work-based Learning
Learning activities where the main location for the learning experience is in the workplace.


Campus(es) for Module Delivery
The module will normally be offered on the following campuses / or by Distance/Online Learning: (Provided viable student numbers permit)
Paisley:Ayr:Dumfries:Lanarkshire:London:Distance/Online Learning:Other:

 

 

 

 

check mark

 

 

Term(s) for Module Delivery
(Provided viable student numbers permit).
Term 1

 

Term 2

 

Term 3

 

[Top of Page]


Learning Outcomes: (maximum of 5 statements)

On successful completion of this module the student will be able to:

L1. Explain the objectives of financial modelling and the characteristics of financial data.

L2. Build financial statement models for a range of business planning purposes.

L3. Synthesise and present financial models and research in a professional manner.

L4. Identify and apply the key philosophies that underpin research in the field of accounting and finance and assess their use in practice.

L5. Critically evaluate the strengths and weaknesses of the main research methods used in accounting and finance research.

Employability Skills and Personal Development Planning (PDP) Skills
SCQF Headings During completion of this module, there will be an opportunity to achieve core skills in:
Knowledge and Understanding (K and U) SCQF Level 11.

Demonstrate and/or work with:
- Knowledge that covers and integrates most of the main areas of the subject, including their features, boundaries, terminology and conventions.
- A critical understanding of the principal theories, concepts and principles.

Practice: Applied Knowledge and Understanding SCQF Level 11.

Apply knowledge, skills and understanding:
- In using a significant range of the principal professional skills, techniques, practices and/or materials associated with the subject.
- In using a range of specialised skills, techniques and practices.

Generic Cognitive skills SCQF Level 11.

- Apply critical analysis, evaluation and synthesis to issues that are informed by forefront developments in the subject.
- Critically review, consolidate and extend knowledge, skills, practices and thinking in the subject.

Communication, ICT and Numeracy Skills SCQF Level 11.

Use a wide range of routine skills and a range of advanced and specialised skills as appropriate to a subject, for example:
- Use a wide range of ICT applications to support and enhance work at this level and adjust features to suit purpose.
- Undertake critical evaluations of a wide range of numerical and graphical data.

Autonomy, Accountability and Working with others SCQF Level 11.

Exercise substantial autonomy and intitiative in activities.
- Take responsibility for own work and/or significant responsibility for the work of others.

Pre-requisites: Before undertaking this module the student should have undertaken the following:
Module Code:
Module Title:
Other:
Co-requisitesModule Code:
Module Title:

* Indicates that module descriptor is not published.

[Top of Page]


Learning and Teaching
The module employs hybrid learning approaches. Students will be exposed to core concepts and ideas through the use of asynchronous, online activities designed to allow students to engage with the material in a flexible manner. Face-to-face, synchronous sessions will concentrate on interactive learning designed to allow students to engage with staff and classmates and deepen their understanding of the subject material. The social learning platform will be used to share key information and provide opportunities for interaction with staff and other students.
Learning Activities
During completion of this module, the learning activities undertaken to achieve the module learning outcomes are stated below:
Student Learning Hours
(Normally totalling 200 hours):
(Note: Learning hours include both contact hours and hours spent on other learning activities)
Asynchronous Class Activity12
Tutorial/Synchronous Support Activity24
Independent Study164
200 Hours Total

**Indicative Resources: (eg. Core text, journals, internet access)

The following materials form essential underpinning for the module content and ultimately for the learning outcomes:

Day, A.L. (2012) Mastering Financial Modelling in Microsoft Excel, A Practitioner’s Guide to Applied Corporate Finance. 3rd edn. Harlow: FT Publishing

Fairhurst, D.S. (2019) Using Excel for Business and Financial Modelling: A Practical Guide. 3rd edn. Chichester: Wiley

Saunders, M., Lewis, P. and Thornhill, A. (2018) Research Methods for Business Students. 8th edn. Harlow: Pearson

(**N.B. Although reading lists should include current publications, students are advised (particularly for material marked with an asterisk*) to wait until the start of session for confirmation of the most up-to-date material)

Engagement Requirements

In line with the Academic Engagement Procedure, Students are defined as academically engaged if they are regularly engaged with timetabled teaching sessions, course-related learning resources including those in the Library and on the relevant learning platform, and complete assessments and submit these on time. Please refer to the Academic Engagement Procedure at the following link: Academic engagement procedure

Where a module has Professional, Statutory or Regulatory Body requirements these will be listed here:
As per UWS procedures.

[Top of Page]


Supplemental Information

Programme BoardAccounting, Finance and Law
Assessment Results (Pass/Fail) No
Subject PanelAccounting and Finance
ModeratorTBC
External ExaminerTBC
Accreditation Details
Version Number

1

[Top of Page]


Assessment: (also refer to Assessment Outcomes Grids below)
Group Report - Financial modelling, 50% weighting
Report - Research methodology, 50% weighting
(N.B. (i) Assessment Outcomes Grids for the module (one for each component) can be found below which clearly demonstrate how the learning outcomes of the module will be assessed.
(ii) An indicative schedule listing approximate times within the academic calendar when assessment is likely to feature will be provided within the Student Handbook.)

Assessment Outcome Grids (Footnote A.)

Component 1
Assessment Type (Footnote B.) Learning Outcome (1) Learning Outcome (2) Learning Outcome (3) Learning Outcome (4) Learning Outcome (5) Weighting (%) of Assessment ElementTimetabled Contact Hours
Report of practical/ field/ clinical workcheck markcheck markcheck mark  500

Component 2
Assessment Type (Footnote B.) Learning Outcome (1) Learning Outcome (2) Learning Outcome (3) Learning Outcome (4) Learning Outcome (5) Weighting (%) of Assessment ElementTimetabled Contact Hours
Report of practical/ field/ clinical work   check markcheck mark500
Combined Total For All Components100% 0 hours

Footnotes
A. Referred to within Assessment Section above
B. Identified in the Learning Outcome Section above

[Top of Page]

Note(s):
  1. More than one assessment method can be used to assess individual learning outcomes.
  2. Schools are responsible for determining student contact hours. Please refer to University Policy on contact hours (extract contained within section 10 of the Module Descriptor guidance note).
    This will normally be variable across Schools, dependent on Programmes &/or Professional requirements.

Equality and Diversity
The Equality, Diversity and Human Rights policy underpins student engagement. We aim to make UWS a fair and equal place to study an institution which addresses specific issues covering all aspects of equality, diversity and human rights. Where required module assessment will be adapted to meet student requirements.
UWS Equality and Diversity Policy
UWS Equality and Diversity Policy
(N.B. Every effort will be made by the University to accommodate any equality and diversity issues brought to the attention of the School)

2014 University of the West of Scotland

University of the West of Scotland is a Registered Scottish Charity.

Charity number SC002520.