ACM009-Financial Management: Cases and Excel Modelling Applications

Module Provider:
Number of credits: 20 [10 ECTS credits]
Level:7
Terms in which taught: Spring term module
Pre-requisites:
Non-modular pre-requisites:
Co-requisites: MMM041 Business Finance
Modules excluded:
Current from: 2023/4

Module Convenor: Dr Dan Zhou
Email: dan.zhou@henley.ac.uk

Type of module:

Summary module description:

This is designed as a module which aims to develop and apply knowledge, understanding and skills acquired in previous studies and to develop competency in the use of finance technology (Excel modelling).

Aims:

This module aims to develop knowledge, understanding and skills in financial reporting, management accounting, business finance and finance technology (Excel modelling) through their application to real-world business problems and case study scenarios.

Assessable learning outcomes:

This module aims to develop knowledge, understanding and skills in financial reporting, management accounting, business finance and finance technology (Excel modelling) through their application to real-world business problems and case study scenarios.

Assessable learning outcomes:

By the end of the module it is expected that students will be able to:Ìý

Ìý

Apply knowledge and skills from accounting and finance to underpin the analysis of organisational problems.Ìý

Analyse, summarise and synthesise the decisions made by and choices available to an organisation with regard to, for example: strategy implementation, performance measurement; financing decisions; executive remuneration; investment decisions; the dividend decision; cash management and working capital decisions; merger and acquisition decision.

Understand and apply business valuation models to a real company.

Use excel modelling to manipulate financial data drawn from a real company to form conclusions about valuation from different perspectivesÌý

Make recommendations based on reasoned analysis and argument.

The module also aims to encourage the development of oral communication skills, and the students’ effectiveness in group situations. Case study work will help students integrate their knowledge across modulesand topics and to apply ideas creatively.Ìý

Additional outcomes:

The module also aims to encourage the development of oral communication skills, and the students’ effectiveness in group situations. Case study work will help students integrate their knowledge across modules and topics and to apply ideas creatively.

Outline content:

The case study may require students to revisit the content of other modules. In particular, students will need to revise and develop their understanding of theory, techniques and skills from management accounting, financial reporting, business finance and strategy.

New content will include the use of business valuation models to assess the future prospects of a listed company and to evaluate its current share price.Ìý

Brief description of teaching and learning methods:

There will be an emphasis on case studies and discussion in weekly 3- hour class-based sessions. Students will work in small groups and/or individually, to dissect and analyse case study materials and to develop their skills in using their accounting and business finance knowledge.

Contact hours:

Ìý	Autumn	Spring	Summer
Lectures		12
Seminars		18
Guided independent study:	Ìý	Ìý	Ìý
Ìý Ìý Wider reading (independent)		70
Ìý Ìý Exam revision/preparation			20
Ìý Ìý Preparation for performance		10
Ìý Ìý Preparation of practical report		10
Ìý Ìý Group study tasks		60
Ìý	Ìý	Ìý	Ìý
Total hours by term	0	180	20
Ìý	Ìý	Ìý	Ìý
Total hours for module	200

Summative Assessment Methods:

Method	Percentage
Written assignment including essay	70
Practical skills assessment	30

Summative assessment- Examinations:

23-hour open book case study in the Summer term.

Summative assessment- Coursework and in-class tests:

Coursework: group assignment which will be an A3-size poster of 1,000 words for a specific topic.10% excess of word length is allowed. Coursework has a weight of 30% in the final assessment mark.

Coursework will be submitted in week 7 of the spring term.

Formative assessment methods:

Questions and discussions in practical classes and feedback on presentations.

Penalties for late submission:

The below information applies to students on taught programmes except those on Postgraduate Flexible programmes. Penalties for late submission, and the associated procedures, which apply to Postgraduate Flexible programmes are specified in the policy 'Penalties for late submission for Postgraduate Flexible programmes', which can be found here: /cqsd/-/media/project/functions/cqsd/documents/cqsd-old-site-documents/penaltiesforlatesubmissionpgflexible.pdf
The Support Centres will apply the following penalties for work submitted late:

• where the piece of work is submitted after the original deadline (or any formally agreed extension to the deadline): 10% of the total marks available for that piece of work will be deducted from the mark for each working day (or part thereof) following the deadline up to a total of five working days;
• where the piece of work is submitted more than five working days after the original deadline (or any formally agreed extension to the deadline): a mark of zero will be recorded.

The University policy statement on penalties for late submission can be found at: /cqsd/-/media/project/functions/cqsd/documents/cqsd-old-site-documents/penaltiesforlatesubmission.pdf
You are strongly advised to ensure that coursework is submitted by the relevant deadline. You should note that it is advisable to submit work in an unfinished state rather than to fail to submit any work.

Assessment requirements for a pass:

A minimum mark of 50% is required for a University pass.

Reassessment arrangements:

Reassessment by means of 23-hour open book case study; which takes place in August/September of the same year.

Additional Costs (specified where applicable):

N/A

Last updated: 26 July 2023