Course syllabus FMD - Financial Modelling (ŠAVŠ - WS 2015/2016)

     Czech          English          

Course title: Financial Modelling
Semester: WS 2015/2016
Course supervisor: doc. Ing. Romana Čižinská, Ph.D.
Supervising department: Department of Finance and Accounting (ŠAVŠ)
Prerequisites for registration: none
Time allowance: full-time, 1/2 (hours of lectures per week / hours of seminars per week)
part-time, 0/12 (lectures per period / seminars per period)
Type of study: usual
Form of teaching: lecture, seminar
Mode of completion and credits: Exam (5 credits)
Course objective:
The goal of the course is to get students acquainted with the common methodological instruments used in the field of business financial management and decisions. Students will be able to use functions and features of MS Excel to solve challenges faced by modern financial managers of companies.
Course methods: -- item not defined --
Course content:
1.Financial Statements; Cash Flow and Taxes; Financial Planning (allowance 2/2)
a.Relationship Between the Accounting Statements
b.Differences Between Profit and Cash Flow
c.Net Working Capital
d.Direct and Indirect Methods of the Cash Flow Calculation
e.Additional Funds Needed Consequences

2.Financial Analysis (allowance 1/1)
b.Du Pont Chart

3.Capital Budgeting and Investment Decisions (allowance 1/1)
a.Capital Budgeting
b.Investment Appraisal Techniques
c.Net Present Value and Internal Rate of Return

4.Cost of Capital (allowance 2/2)
a.Common Stock versus Preferred Stock
b.Cost of Equity
d.Cost of Debt; WACC

5.Financial Investments; Portfolio Diversification (allowance 2/2)
a.Risk, Return and Liquidity
b.Risk and Return of Single Asset
c.Portfolio; Correlation; Portfolio Diversification; Efficient Frontier; Optimal Portfolio

6.Financial Derivatives (allowance 1/1)
a.Put and Call Option
b.Financial Futures

Learning outcomes and competences:
Upon successful completion of this course, students will be able to:
- evaluate financial health of the company, draw up financial plan and propose appropriate additional funds needed in view of WACC
- choose appropriate functions and features of MS Excel for investment decisions and portfolio management
- describe functioning of financial derivatives and make fundamental calculations in MS Excel
Teaching methods and workload (hours of workload):
Type of teaching methodDaily attendanceCombined form
Direct teaching
     Attendance of lectures12 h8 h
     Attendance of courses/seminars/tutorials12 h0 h
     Consultations with teacher (part-time form of study)0 h4 h
     Course reading and ongoing preparation30 h30 h
     Ongoing evaluation16 h14 h
     Preparation for final test14 h28 h
Total84 h84 h
Assessment methods:
Requirement typeDaily attendanceCombined form
Mid-term test(s)64 %30 %
Final test22 %40 %
Final oral exam14 %30 %
Total100 %100 %
Course completion:
Completion of the two component (midterm) tests in MS Excel is necessary. The midterm covers numerical cases according to the materials in AIS. Minimum of 60% is required to pass every single test. Total Score is 32 points for each test at the maximum (i.e. 2 x 32 points).

Final Exam:
Written test containing 3 theoretical tasks (questions). Total Score is 12 points for each question at the maximum (i.e. 3 x 12 points). Oral exam follows, but is not necessary in the case of excellent written exam. See AIS for the list of questions (tasks). Minimum of 60 % is required to pass the test and achieve final grade.
Final Grade is computed based on the following formula: Two midterm tests (maximum of 2 x 32 points = 64 points) + Final Exam (maximum of 36 points) = maximum of 100 points. The grading scale is as follows:
90 - 100 points = 1
75 - 89 points = 2
60 - 74 points = 3
59 and less = fail
Support for combined/distance forms of study:
-- item not defined --
Reading list:
KISLINGEROVÁ, E. Manažerské finance+CD. 2. přepracované a doplněné vydání. 2. vyd. Praha: C.H.BECK, 2007. 745 p. ISBN 978-80-7179-903-0.
ROSS, S A. -- WESTERFIELD, R W. -- JAFFE, J. Corporate Finance + CD. 7. vyd. New York: McGraw Hill, 2005. 942 p. ISBN 007-123844-1.

CIPRA, T. Praktický průvodce finanční a pojistnou matematikou. 2. vyd. Praha: Ekopress, 2005. 308 p. ISBN 80-86119-91-2.
VALACH, J. Investiční rozhodování a dlouhodobé financování. 2. vyd. Praha: Ekopress, 2006. 465 p. ISBN 80-86929-01-9.

Study plans:
N-EM-MP Business Administration and Operations, part-time form, initial academic year WS 2014/2015
N-EM-MAR Marketing Management in the Global Environment, part-time form, initial academic year WS 2014/2015
N-EM-FRP Corporate Finance Management in the Global Environment, part-time form, initial academic year WS 2014/2015
N-EM-GPME Marketing Management in the Global Environment, full-time form, initial academic year WS 2014/2015
Run in the period of: SS 2016/2017, WS 2016/2017, SS 2015/2016, SS 2013/2014, SS 2012/2013, SS 2011/2012   (and older)
Course tutor: doc. Ing. Romana Čižinská, Ph.D. (examiner, instructor, supervisor)
Teaching language: Czech, English
Room: Mladá Boleslav

Last modification made by Ing. Aleš Kutín on 08/31/2015.

Type of output: