Business mathematics and ExcelLaajuus (4 cr)
Code: TE00BS94
Credits
4 op
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
Qualifications
Basics of Excel
Equations
System (pair) of equations
Functions
Matrix calculation
Derivatives
Enrollment
30.05.2024 - 30.08.2024
Timing
02.09.2024 - 18.12.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Seats
0 - 60
Degree programmes
- Degree Programme in Industrial Management Engineering
Teachers
- Virpi Raivonen
- COS Opettaja
Groups
-
PTUTAS23APTUTAS23A
-
PTUTAS23BPTUTAS23B
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
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