| CODE | BKF2060 | |||||||||
| TITLE | Financial Modelling 1 | |||||||||
| UM LEVEL | 02 - Years 2, 3 in Modular Undergraduate Course | |||||||||
| MQF LEVEL | Not Applicable | |||||||||
| ECTS CREDITS | 4 | |||||||||
| DEPARTMENT | Banking and Finance | |||||||||
| DESCRIPTION | Microsoft Excel is perhaps the most popular spreadsheet software that is used in the business world. This study-unit will introduce the fundamentals and concepts of building a financial model using Excel. This is a practical study-unit in which students will develop the skills to build their own financial model which can be taken away for future reference. The study-unit will teach students how Excel works, and shows how to use Excel's tools to answer real-world questions. Study-unit Aims: The study-unit aims to covers a range of topics involving Excel and finance to assist students familiarize themselves with the use of Excel in general and in Finance. Learning Outcomes: 1. Knowledge & Understanding: By the end of the study-unit the student will be able to: - Select which formulas are appropriate in different situations; - Use absolute and relative cell referencing for modelling; - Identify common errors in modelling; - Use techniques to prevent model errors; - Document model assumptions; - Link and change variables; - Prevent data from being changed by protecting your model; - Build and use drop-down boxes. 2. Skills: By the end of the study-unit the student will be able to: - Understand how Excel can be used in finance; - Grasp different functions that are used in Excel; - Develop a financial model. Main Text/s and any supplementary readings: Some of the text/s that will be used in the lectures include but are not limited to: - Fairhurst, Danielle Stein, 2012, Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals (Wiley Finance). - Sengupta, Chandan, 2009, Financial Analysis and Modelling using Excel and VBA (Wiley Finance). - Jackson, Mary and Staunton, Mike, 2001, Advanced Modelling in Finance using Excel and VBA (Wiley Finance). - Berk, Kenneth and Carey, Patrick, 2010, Data Analysis with Microsoft Excel (Brooks/Cole Cengage Learning). |
|||||||||
| ADDITIONAL NOTES | Co-requisite Study-unit: BKF4310 | |||||||||
| STUDY-UNIT TYPE | Lecture and Tutorial | |||||||||
| METHOD OF ASSESSMENT |
|
|||||||||
| LECTURER/S | Paul Zaren Magro |
|||||||||
|
The University makes every effort to ensure that the published Courses Plans, Programmes of Study and Study-Unit information are complete and up-to-date at the time of publication. The University reserves the right to make changes in case errors are detected after publication.
The availability of optional units may be subject to timetabling constraints. Units not attracting a sufficient number of registrations may be withdrawn without notice. It should be noted that all the information in the description above applies to study-units available during the academic year 2023/4. It may be subject to change in subsequent years. |
||||||||||