Business mathematics and Excel (4 cr)
Code: TE00BS94-3003
General information
Enrollment
02.07.2022 - 07.09.2022
Timing
01.08.2022 - 31.12.2022
Number of ECTS credits allocated
4 op
Virtual portion
1 op
Mode of delivery
75 % Contact teaching, 25 % Distance learning
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Teachers
- Virpi Raivonen
Groups
-
PTUTAMS21
-
PTUTAS21BPTUTAS21B
-
LIPATMODTekninenKauppa
-
PTUTAS21APTUTAS21A
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
Evaluation scale
H-5
Qualifications
Basics of Excel
Equations
System (pair) of equations
Functions
Matrix calculation
Derivatives