ULMS Electronic Module Catalogue |
The information contained in this module specification was correct at the time of publication but may be subject to change, either during the session because of unforeseen circumstances, or following review of the module at the end of the session. Queries about the module should be directed to the member of staff with responsibility for the module. |
Title | PRINCIPLES OF FINANCE WITH EXCEL | ||
Code | ACFI315 | ||
Coordinator |
Dr X Fu Finance and Accounting Xi.Fu@liverpool.ac.uk |
||
Year | CATS Level | Semester | CATS Value |
Session 2023-24 | Level 6 FHEQ | First Semester | 15 |
Pre-requisites before taking this module (other modules and/or general educational/academic requirements): |
Modules for which this module is a pre-requisite: |
Programme(s) (including Year of Study) to which this module is available on a required basis: |
Programme(s) (including Year of Study) to which this module is available on an optional basis: |
Teaching Schedule |
Lectures | Seminars | Tutorials | Lab Practicals | Fieldwork Placement | Other | TOTAL | |
Study Hours |
24 |
6 |
30 | ||||
Timetable (if known) | |||||||
Private Study | 120 | ||||||
TOTAL HOURS | 150 |
Assessment |
||||||
EXAM | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
CONTINUOUS | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
Assessment 2: Coursework 2 Assessment Type: Coursework Size: 2000 words Weighting: 50% Reassessment Opportunity: Yes Penalty for Late Submission: Standard UoL penalty applies Anonymous | 0 | 50 | ||||
Assessment 1: Coursework 1 Assessment Type: Coursework Size: 2000 words Weighting: 50% Reassessment Opportunity: Yes Penalty for Late Submission: Standard UoL penalty applies Anonymous | 0 | 50 |
Aims |
|
The aim of the module is to provide a greater awareness of the capability of Excel in the financial environment. |
Learning Outcomes |
|
(LO1) Students will be aware of the capabilities of Excel as a financial modelling tool |
|
(LO2) Students will be able to undertake sophisticated portfolio modelling using Excel |
|
(LO3) Students will use Excel to quantify and manage risk |
|
(LO4) Students will be able to use Excel to analyse and appraise real investment decisions |
|
(S1) Problem solving skills |
|
(S2) IT skills |
|
(S3) Numeracy |
|
(S4) Written communication skills |
|
(S5) Commercial awareness |
|
(S6) Organisational skills |
|
(S7) Lifelong learning skills |
Teaching and Learning Strategies |
|
Teaching Method: Lecture Teaching Method: Seminar Self-Directed Learning Hours: 120 Costs Information: Skills/Other Attributes Mapping Skills / attributes: Problem solving skills Skills / attributes: IT skills Skills / attributes: Numeracy Skills / attributes: Written communication skills Skills / attributes: Commercial awareness Skills / attributes: Organisational skills Skills / attributes: Lifelong learning skills |
Syllabus |
|
1. An introduction to the Excel environment and Excel functions for dealing with textual data, |
Recommended Texts |
|
Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module. |