103-001-IO2 Financial Modeling
Study program: | International Finance (M.Sc.) |
Academic level and semester: | Master, 1st semester |
ECTS credits/workload per semester: | 2 / 50 |
Contact hours per week/contact hours per semester: | 2 / 25 |
Type/Teaching method: | Lecture |
| Language of instruction: | English |
Frequency: | Winter semester |
Lecturer: | Prof. Dr. Dr. Dietmar Ernst |
Content: | Why are spread sheet modeling skills so important? Spread Sheet Modeling skills are fundamental for a successful career in finance.The spread sheet modeler knows how the central tasks in financial practice can be professionally solved using Excel and VBA. Which skills does a spread sheet modeler have? A spread sheet modeler can … efficiently and transparently prepare decisions, model practical problems clearly and in a well-structured way, use Excel and VBA programming to efficiently simplify complex subjects, present results in a professional manner, apply financial modeling to any question in finance Will I be able to work without basic knowledge in spread sheet modeling? On an international level, leading universities have added the subject spread sheet modeling to their curricula in order to respond to the requirements in financial practice. We assume that in the medium-term, the principles of orderly spread sheet modeling will be the cornerstones of finance that everyone will have to respect. Who needs well-founded knowledge in spread sheet modeling? All graduates and practitioners in finance should have a well-founded knowledge in spread sheet modeling. However, experience shows that the majority of financial experts does not have or only have rudimentary financial modeling skills. Currently, many banks, financial service providers and other companies are looking desperately for people with in-depth Excel modeling and VBA skills. Financial modeling knowledge is a sort of unique selling point offering the best opportunities to enter the professional financial world and to climb the career ladder. Course content: Based on a very basic investment case study students learn the broad variety of professional spread sheet modeling. Prerequisite for that course is that each student works with his /her own laptop in class. Excel 2010 is appreciated. |
Textbooks: | Benninga, S.: Financial Modeling, MIT Press, 2008• Ernst D., Häcker, J. (2017, editors): Financial Modeling - Business excellence in FinancialManagement, Corporate Finance, Portfolio Management and Derivatives, Basingstoke(England) and New York (US) |
Recommended for: | Undergraduates, graduates |
Prerequisites: | Background in Business/Economics, Finance and Investment, Excel |
Restrictions: | None |
Assessment: | Paper |