Course detail
Economic practicum
FP-KepPAcad. year: 2022/2023
This course introduces students to managerial calculations and economic analyses using a spreadsheet program MS Excel 2002. All areas of practical examples will be solved by the form of case studies.
Language of instruction
Czech
Number of ECTS credits
3
Mode of study
Not applicable.
Department
Learning outcomes of the course unit
The student applies the theoretical knowledge gained from the previous study of economic subjects in bachelor study and is able to solve practical economic and managerial tasks using computer technology.
Prerequisites
Knowledge of economic subjects obtained in one’s study to date, especially from the subject of Business economics, computer skills, and knowledge of the spreadsheet program of Microsoft Excel 2010 are expected.
Co-requisites
Not applicable.
Planned learning activities and teaching methods
Exercises promote the practical mastery of subject presented in lectures or assigned for individual study with the active participation of students.
Assesment methods and criteria linked to learning outcomes
Course curriculum
Content of the course:
1) Introduction to the subject. Utilization of MS Excel for the solution of managerial and economic calculations.
2) CVP analysis. Sensitivity analysis.
3) Calculation of full costs.
4) Product and production program evaluation.
5) Economic evaluation of investment efficiency - static methods.
6) Economic evaluation of investment efficiency - dynamic methods.
7) MS Excel tools and functions used in financial reporting
8) Trend analysis and percentage analysis of financial statements.
9) Analysis of profit and profitability indicators and their graphical presentation.
10) Analysis of indicators of liquidity, activity, capital structures and their graphical presentation.
11) Indicator systems, indexes and prediction models.
12) Intercompany comparison.
13) Credit test.
1) Introduction to the subject. Utilization of MS Excel for the solution of managerial and economic calculations.
2) CVP analysis. Sensitivity analysis.
3) Calculation of full costs.
4) Product and production program evaluation.
5) Economic evaluation of investment efficiency - static methods.
6) Economic evaluation of investment efficiency - dynamic methods.
7) MS Excel tools and functions used in financial reporting
8) Trend analysis and percentage analysis of financial statements.
9) Analysis of profit and profitability indicators and their graphical presentation.
10) Analysis of indicators of liquidity, activity, capital structures and their graphical presentation.
11) Indicator systems, indexes and prediction models.
12) Intercompany comparison.
13) Credit test.
Work placements
Not applicable.
Aims
Aim of the course is to deepen students' ability to classify, analyze, and present information in response to specific decision-making tasks. This subject directly relates to the knowledge that students gained in the economically-oriented subjects within their studies. After a successful completion of this course, students will be able to use MS Excel for the purposes of managerila calculations and economic analyses.
Specification of controlled education, way of implementation and compensation for absences
The participation on concentration trainings.
The continuous preparation for concentration trainings (self study from literature.
Working on the exercises.
The continuous preparation for concentration trainings (self study from literature.
Working on the exercises.
Recommended optional programme components
Not applicable.
Prerequisites and corequisites
Not applicable.
Basic literature
BROŽ, M. Microsoft Excel 2007 pro manažery a ekonomy. 1.vyd. Praha: CP Books, 2009. 435 s. ISBN 978-80-251-2116-0.
KOCMANOVÁ, A. Ekonomické řízení podniku. Praha: Linde Praha, 2013, 358 s. ISBN 978-80-7201-932-8.
SYNEK, M.; KOPKÁNĚ, H.; KUBÁLKOVÁ, M. Manažerské výpočty a ekonomická analýza. V Praze: C.H. Beck, 2009, xviii, 301 s. : il. 1 CD-ROM. ISBN 978-80-7400-154-3.
SYNEK, M. Manažerská ekonomika. 5.vyd. Praha: Grada Publishing, 2011. 471 s. ISBN 978-80-247-3494-1.
KOCMANOVÁ, A. Ekonomické řízení podniku. Praha: Linde Praha, 2013, 358 s. ISBN 978-80-7201-932-8.
SYNEK, M.; KOPKÁNĚ, H.; KUBÁLKOVÁ, M. Manažerské výpočty a ekonomická analýza. V Praze: C.H. Beck, 2009, xviii, 301 s. : il. 1 CD-ROM. ISBN 978-80-7400-154-3.
SYNEK, M. Manažerská ekonomika. 5.vyd. Praha: Grada Publishing, 2011. 471 s. ISBN 978-80-247-3494-1.
Recommended reading
BÁRTA, Z. Finanční gramotnost: výpočty v Excelu. Praha: Wolters Kluwer, 2014, 370 s. ISBN 978-80-7478-483-5.
Classification of course in study plans
- Programme BAK-EP Bachelor's 2 year of study, summer semester, elective