Course: Financial English and Excel Calculations

» List of faculties » FZE » KDV
Course title Financial English and Excel Calculations
Course code KDV/FMATA
Organizational form of instruction Lecture + Seminar
Level of course Master
Year of study not specified
Semester Summer
Number of ECTS credits 4
Language of instruction English
Status of course unspecified
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Course availability The course is available to visiting students
Lecturer(s)
  • Šulista Marek, PhDr. Ph.D.
Course content
Basic terminology, percentages, means Progressions. Time value of money. Simple interest, bank discount, standards of interest calculations. Compound and continuous interest. Inflation, real and effective interest rate. Saving models. Loan redemption. Complex savings models. Depreciation of assets. Performance measuring. Modelling of financial products in MS Excel.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), E-learning
Learning outcomes
This course introduces students to essential terminology and concepts in Business English and Finance. Through practical examples and interactive exercises, students will gain confidence in using financial vocabulary in English and understanding key financial principles. Topics include the fundamentals of interest calculation, savings models, debt repayment strategies, and mortgage simulations. A significant part of the course is dedicated to applying these concepts in Microsoft Excel, where students will learn to build and analyze financial models, perform calculations, and interpret results effectively.

Prerequisites
unspecified

Assessment methods and criteria
Combined exam

Active participation in seminars - Continuous completion of revision tests in LMS Moodle - Successful completion of the final exam test Examination: - Time limit: 20 minutes - 4 financial problems solved using MS Excel (total: 76 points) - Professional financial vocabulary (total: 24 points) - Minimum of 51 points required to pass - Students have 3 attempts to pass the exam
Recommended literature
  • Šulista, Marek; Nýdl, Václav,; Akehurst-Moore, Gregory. Introduction to financial and actuarial mathematics. České Budějovice : EF JU: EF JU, 2006. ISBN 80-7040-919-3.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester