Hochschule München

HM Business School (FK 10)

Modulbeschreibung

Stand: SoSe 2023

Name Financial Modeling
Katalog-Nummer FK 10#FIN#BF.6
Zugehörigkeit zu Curriculum
Bachelor Betriebswirtschaft | 5.4.3 | 5 Leistungspunkte
Bachelor Betriebswirtschaft | 6.4.3 | 5 Leistungspunkte
Modulverantwortung
Häcker, Joachim (Prof. Dr. Dr.)
Lehrende
Prüfung(en)
Lehr- und Lernform(en)
| 4 SWS | SU - wird nicht angeboten
Arbeitsaufwand
Präsenzzeit: 0 Stunden
Selbststudium, Vor- und Nachbereitung, Prüfungsvorbereitung: 0 Stunden
Voraussetzungen
Verwendbarkeit
Inhalt / Lernziele
Qualifications targeted:

With regard to the qualification category of expertise, the course participants are able to:
- provide an overview of the most important valuation methods and compare these.
- Relate corporate finance to other modules such as financial management, portfolio management and derivatives
- Relate corporate planning to corporate valuation and to describe the linkages in their own words

With regard to the qualification category of methodological competence, the course participants are able to:
- use their knowledge about planning and valuation methods to develop a professional standard model for corporate valuation which incorporates the principles of financial modeling
- obtain the data necessary for a corporate valuation which incorporates the principles of financial modeling.
- Independently structure complex task in corporate valuation and to develop independent modules to solve these tasks.
- Critically evaluate the results of the corporate valuation and to clarify any differences.
- Interpret the results of the corporate valuation and to independently draw conclusions for corporate finance transactions
- Review the structure of the valuation model and the results of the corporate valuation with the help of a model review
With regard to the qualification category of self-competence, the course participants are able to:
- transfer the results from the corporate valuation to other modules such as financial management, portfolio management and derivatives and to combine them with these modules.
- manage a project in the field of corporate valuation and to develop proprietary solutions in a team of valuation experts
- compile a transparent and comprehensive documentation of assumptions and methods for a given valuation project.
- structure the process of corporate valuation and to apply the standards of professional financial modeling
- master theoretical and empirical challenges of corporate valuation.
- apply their knowledge to specific valuation projects and to adjust it to actual valuation situations
- critically challenge the assumptions, algorithms and results of every valuation approach.
- present and defend the valuation results

With regard to the qualification category of social competence, the course participants are able to interact in groups and present their results in front of experts.
Methods of teaching and study:
Literature study, case studies on the implementation of a corporate valuation exercise as well as Excel-based exercises. The cases studies help to implement the valuation methods for a given task in a model-based and applied fashion. The self-study of the participants is supported via e-learning.

Content:

- Discounted cash flow method
- Market cap
- Book value
- Trading multiples
- Transaction multiples
- Deriving the valuation range
- Risk
- Return
- Financial Modeling Standards

Literature/ Study materials
- Häcker, J., Ernst, D. (2017): Financial Modeling – An Introductory Guide to Excel and VBA Applications in Finance, 1st edition, New York, MacMillan.
- Tjia, J. (2009): Building financial models, the complete guide to designing, building, and applying projection models, 2nd edition, New York, McGraw-Hill).