Skip to main content

Business Mathematics and ExcelLaajuus (5 cr)

Code: TE00CK13

Credits

5 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

Enrollment

01.12.2023 - 15.01.2024

Timing

22.01.2024 - 01.04.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 - 40

Degree programmes
  • Degree Programme in Industrial Management Engineering
Teachers
  • Virpi Raivonen
Groups
  • MTUTAMK23
    Degree Programme in Industrial Management Engineering, Sales

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

Enrollment

02.08.2023 - 31.08.2023

Timing

15.08.2023 - 04.01.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Industrial Management Engineering
Teachers
  • Virpi Raivonen
Groups
  • PTUTAS22A
    PTUTAS22A
  • LIPATMODTekninenKauppa
  • PTUTAS22B
    PTUTAS22B

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

Enrollment

02.08.2023 - 31.08.2023

Timing

15.08.2023 - 04.01.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Industrial Management Engineering
Teachers
  • Virpi Raivonen
Groups
  • LIPATMODInsinööriajattelu
    LIPAT Insinööriajattelu
  • PTUTAMS22
    PTUTAMS22

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