Excel Applications for Financing (5 cr)
Code: LD00EH42-3003
General information
- Enrollment
-
04.12.2023 - 07.01.2024
Registration for the implementation has ended.
- Timing
-
15.01.2024 - 31.07.2024
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Mode of delivery
- On-campus
- Unit
- (2019-2024) School of Business
- Campus
- Leiritie 1
- Teaching languages
- Finnish
- Seats
- 20 - 35
- Degree programmes
- Economics and Business Administration
- Teachers
- Taru Haajanen
- Teacher in charge
- Anne Perkiö
- Groups
-
LXD22S1_L1LXD22S1_L1
-
LXD22S1_L2LXD22S1_L2
- Course
- LD00EH42
Implementation has 14 reservations. Total duration of reservations is 37 h 45 min.
| Time | Topic | Location |
|---|---|---|
|
Mon 22.01.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 29.01.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 05.02.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 12.02.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 26.02.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 04.03.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 11.03.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 18.03.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 25.03.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 08.04.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 15.04.2024 time 14:00 - 17:00 (3 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
MMC314
IT-Tila
|
|
Mon 22.04.2024 time 14:00 - 16:15 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 Kurssitentti |
MMC314
IT-Tila
|
|
Mon 29.04.2024 time 14:00 - 14:30 (0 h 30 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 |
Tentin läpikäynti
|
|
Mon 06.05.2024 time 14:30 - 16:30 (2 h 0 min) |
Rahoituksen Excel-sovellukset LD00EH42-3003 Uusintatentti 1 |
MMC314
IT-Tila
|
Objective
Upon completion of the course students will be familiar with practical cash flow statements and how to interpret them critically. The student will be able to apply the pricing models used in financing and assess their sensitivity. The student will be familiar with Excel’s most common financial functions.
Content
- Practical Excel cash flow statements
- Sensitivity analysis of pricing models and cash flow statements
- How to use the most common financial functions
Evaluation scale
0-5
Assessment criteria, satisfactory (1)
The student has achieved the course objectives fairly. The student will be able to identify, define and use the course subject area’s concepts and models. The student understands the criteria and principles of the expertise development.
Assessment criteria, good (3)
The student has achieved the course objectives well, even though the knowledge and skills need improvement on some areas. The student is able to define the course concepts and models and are able to justify the analysis. The student is able to apply his/her knowledge in leisure, study and work situations. The student understands the importance of expertise in the field of business and is able to analyze his/her own expertise.
Assessment criteria, excellent (5)
The student has achieved the objectives of the course with excellent marks. The student masters commendably the course subject area’s concepts and models. The student is able to make justified and fluent analysis and to present concrete development measures. The student is well prepared to apply his/her knowledge in leisure, study and work situations. The student is able to analyze the business sector expertise and the development of his/her own expertise.
Assessment criteria, approved/failed
The student has achieved the course objectives fairly. The student will be able to identify, define and use the course subject area’s concepts and models. The student understands the criteria and principles of the expertise development.
Qualifications
Finance and IT Tools or equivalent competences
Objective
Upon completion of the course students will be familiar with practical cash flow statements and how to interpret them critically. The student will be able to apply the pricing models used in financing and assess their sensitivity. The student will be familiar with Excel’s most common financial functions.
Content
- Practical Excel cash flow statements
- Sensitivity analysis of pricing models and cash flow statements
- How to use the most common financial functions
Qualifications
Finance and IT Tools or equivalent competences