Study Guide

Objective

After studying the course the students understand the time value of money and is able to compare different investment alternatives. The student can estimate the profitability of an investment. He/she can optimize costs or profitability with Excel. He/she is able to use Excel in various problems of financial mathematics.

Content

Revision of Excel basics
Processing large datasets
Applying Excel for financial mathematics
Value added tax, inflation, indexes
Financing calculations
Investments
Matrix calculation
Profitability and cost optimization

Exam schedules

Mid-term and
Final exam.
Doing weekly/monthly assignments student will earn right to do mid-term and final exam.
If student doesn't do weekly/mothly task s/he will not have right to attend Mid-term or/and Final exam and course will fail.

Content scheduling

Excel basics
Processing large datasets
Applying Excel for financial mathematics
Value added tax, inflation, indexes
Financing calculations
Investments
Matrix calculation
Profitability and cost

Evaluation scale

H-5

Assessment methods and criteria

weekly assignments
Mid-term
Final exam.

Assessment criteria, fail (0)

If student doesn't do weekly/mothly task s/he will not have right to attend Mid-term or/and Final exam and course will fail.