| Course Unit Code | 151-0318/07 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Choice-compulsory |
|---|
| Level of Course Unit * | First Cycle, Second Cycle |
|---|
| Year of Study * | |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | English |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| FUN01 | Mgr. Taťána Funioková, Ph.D. |
| Summary |
|---|
| The aim is to acquaint the students with the fundamentals of saving and investing that are of long-life practical use. These include savings accounts, annuities, loans, certificates of deposit, and buying and selling bonds or stocks including a bond portfolio target date immunization and an introduction to stock portfolio optimization. For all the problems a mathematical background, as well as an implementation using Microsoft Excel is introduced. |
| Learning Outcomes of the Course Unit |
|---|
| The main objective of the course is to help students understand the current concepts of finance, by solving specific problems. After completing this course the student will be able to classify and develop its current knowledge of valuation not only of various securities and get acquainted with issues of bond portfolio immunization, practical portfolios risk measurement and diversification. We focus on application of basic financial decision-making procedures based on the concept of time value of money with use of the MS Excel spreadsheet, including its Solver Add-in. |
| Course Contents |
|---|
Subject’s Syllabus:
• Simple interest, some of the short-term securities
• Compound interest
• The time value of money and investment decision-making
• Money saving
• Income
• Debt redemption
• Models of income and loans
• Introduction to securities analysis
• Introduction to (financial) risk |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
FUNIOKOVÁ, Taťána. Introduction to financial mathematics. Ostrava: VŠB-TU Ostrava, 2017. ISBN 978-80-248-4081-9.
LOVELOCK, David, Marilou MENDEL a A. Larry WRIGHT. An introduction to the mathematics of money: saving and investing. New York: Springer, c2010. ISBN 978-1-4419-2232-8.
BENNINGA, Simon a Benjamin CZACZKES. Financial modeling. 3rd ed. Cambridge: MIT Press, c2008. ISBN 978-0-262-02628-4. |
CIPRA, Tomáš. Praktický průvodce finanční a pojistnou matematikou. Vydání III., v Ekopressu II. Praha: Ekopress, 2015. ISBN 978-80-87865-18-7
CIPRA, Tomáš. Finanční a pojistné vzorce. Praha: Grada, 2006. Finanční trhy a instituce. ISBN 80-247-1633-X.
FUNIOKOVÁ, Taťána. Introduction to financial mathematics. Ostrava: VŠB-TU Ostrava, 2017. ISBN 978-80-248-4081-9.
|
| Recommended Reading: |
|---|
BREALEY, Richard A., Stewart C. MYERS a Franklin ALLEN. Principles of corporate finance. 11th global ed. Maidenhead: McGraw-Hill Education, c2014. McGraw-Hill series in finance, insurance, and real estate. ISBN 978-0-07-715156-0.
BENNINGA, Simon; MOFKADI, Tal. Principles of finance with excel. New York, NY: Oxford University Press, 2006. ISBN 978-0190296384.
DAY, Alastair. Mastering Financial Mathematics in Microsoft Excel 2013: A Practical Guide To Business Calculations. Pearson UK, 2015. ISBN 9780273730330. |
CIPRA, Tomáš. Matematika cenných papírů. Praha: Kamil Mařík - Professional Publishing, 2013. ISBN 978-80-7431-079-9.
RADOVÁ, Jarmila, Petr DVOŘÁK a Jiří MÁLEK. Finanční matematika pro každého. 8., rozš. vyd. Praha: Grada, 2013. Finance (Grada). ISBN 978-80-247-4831-3.
BENNINGA, Simon; MOFKADI, Tal. Principles of finance with excel. New York, NY: Oxford University Press, 2006. ISBN 978-0190296384.
Elektronické studijní materiály dle aktuální nabídky kurzu na webu
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Tasks are not Defined |