|
|
|
||
Poslední úprava: doc. PhDr. Ing. et Ing. Petr Jakubík, Ph.D., Ph.D. (05.11.2019)
|
|
||
Poslední úprava: doc. PhDr. Ing. et Ing. Petr Jakubík, Ph.D., Ph.D. (05.11.2019)
This course is aimed to present some financial and business models and to show how they can be developed, solved or simulated using Microsoft Excel and its embedded Visual Basic for Applications (VBA) programming language. |
|
||
Poslední úprava: PhDr. Petr Bednařík, Ph.D. (15.05.2020)
BENNINGA S:. Financial Modeling. 2nd Edition. Cambridge (MA): MIT Press, 2000. |
|
||
Poslední úprava: doc. PhDr. Ing. et Ing. Petr Jakubík, Ph.D., Ph.D. (15.03.2021)
Home exercises I - excel based (after 4 weeks of classes, at least 2 weeks DL) - weight 20% Home exercises II – VBA based (after finishing all classes, at least 2 weeks DL) - weight 30% Final project (after finishing all classes, DL end-July) - weight 50% All three requirements can be a teamwork, group can contain up to three members. |
|
||
Poslední úprava: doc. PhDr. Ing. et Ing. Petr Jakubík, Ph.D., Ph.D. (28.02.2023)
MS Excel VBA Introduction
Basics finance calculation Corporate Finance Portfolio Models Option Pricing |
|
||
Poslední úprava: doc. PhDr. Ing. et Ing. Petr Jakubík, Ph.D., Ph.D. (05.11.2019)
Pre-requisites: |