Excel Applications for Financing (5 ECTS)
Code: LD00EH42-3004
General information
- Enrollment
- 02.12.2024 - 05.01.2025
- Registration for the implementation has ended.
- Timing
- 16.01.2025 - 11.05.2025
- Implementation has ended.
- Number of ECTS credits allocated
- 5 ECTS
- RDI portion
- 1 ECTS
- Mode of delivery
- On-campus
- Unit
- Metropolia Business School
- Campus
- Leiritie 1
- Teaching languages
- Finnish
- Seats
- 20 - 35
- Degree programmes
- Economics and Business Administration
- Teachers
- Tuire Jäntti
- Taru Haajanen
- Teacher in charge
- Anne Perkiö
- Groups
-
LXD23S1_L2LXD23S1_L2
- Course
- LD00EH42
Implementation has 15 reservations. Total duration of reservations is 33 h 45 min.
Time | Topic | Location |
---|---|---|
Thu 16.01.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 23.01.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 30.01.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 06.02.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 13.02.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 27.02.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 06.03.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 EI LUENTOA. Itsenäinen työskentely |
|
Thu 13.03.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 20.03.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
Ei tunteja, itsenäinen työskentely
|
Thu 27.03.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 03.04.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 10.04.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 17.04.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Thu 24.04.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
Ei tunteja, itsenäinen työskentely
|
Thu 08.05.2025 time 08:30 - 10:45 (2 h 15 min) |
Rahoituksen Excel-sovellukset LD00EH42-3004 |
MMB253
IT-Tila
|
Learning outcomes
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
Prerequisites
Finance and IT Tools or equivalent competences
Teaching methods
Interactive lecture
Assignments
Project
Location and time
According to the schedule on Myyrmäki campus
Learning materials and recommended literature
Lecturers' materials in Moodle.
Alternative completion methods of implementation
N/A
Exam dates and retake possibilities
No exam
Student workload
Contact sessions 33 hours
Group work 41 hours
Individual work 61 h
Deadlines for assignments are included in the course schedule.
Content scheduling
Viikot 3 - 10 Luennot ja harjoitukset - Rahoituksen sovelluksista
Viikot 10-19 Luennot ja harjoitukset - Kvantitatiivinen analyysi
Huom! Aikataulu ja sisältösuunnitelma ovat alustavia. Luennot lukujärjestyksen mukaisesti.
Further information for students
Tuition in Finnish only.
Assessment methods and criteria
Assignments 100 % of the course grade:
• Applications of finance 50%
• Quantitative analysis 50 %
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.