

Teacher: Jozef Glova, Leoš Šafár
Contact: jozef.glova@tuke.sk, leos.safar@tuke.sk
Dear students,
The subject builds on the methods, reasoning and skills acquired during the
bachelor's studies in the field of finance, banking and investing, especially
in accounting, statistics and informatics (working with financial mathematics,
using functions in MS Excel, etc.). To thoroughly master the principles of
capital budgeting, it is necessary to combine work in MS Excel, as well as with
specialised statistical software (add-ons) for MS Excel (or other software). After
completing the course, the student should:
- be able to process the financial plan of capital investment in the company as
well as process its evaluation with possible recommendations,
- be able to create and apply a suitable investment evaluation tool, to
understand its advantages and disadvantages,
- understand the attributes of the project implementation environment, related
to, for example, taxation, changes in the price level, creation of the level of
required profitability or risks applied,
- understand modifications of the designed tool using analytical approaches to
take uncertainty conditions into account,
- master the MS Excel environment and its add-ons for processing individual
calculations and analyses in capital planning and investment project decision
making.
In the subject, students acquire financial reasoning, learn to process and
model financial data and make estimates of the development of certain projects
and cash flows. The acquired knowledge and skills are necessary for the
analysis and processing of data within the company and the preparation of its
investment projects, especially in the field of financial management.
Your final grade will consist of three partial quizes, 30, 30 and 40 points throughout the semester.
Thank you for your participation in the course!
Using formulas and information from the presentation, calculate and solve the following tasks in the _empty excel sheet:
Below you find your first quiz (30% of your final grade):
Using formulas and information from the presentation, calculate and solve the following tasks in the _empty excel sheet:
Using formulas and information from the presentation, calculate and solve the following tasks in the _empty excel sheet:
Using formulas and information from the presentation, calculate and solve the following tasks in the _empty excel sheet:
Below you find your second quiz (30% of your final grade):
Using formulas and information from the presentation, calculate and solve the following tasks in the _empty excel sheet:
Complete all necessary calculations in .xls file with aim to answer questions stated in each sheet.
For this seminar, also feel free to prepare questions regarding the previous topics.
Below you find your third and final quiz (40% of your final grade):