Excel Applications for Financing (5 cr)
Code: LD00EH42-3002
General information
- Enrollment
-
07.12.2022 - 08.01.2023
Registration for the implementation has ended.
- Timing
-
16.01.2023 - 12.05.2023
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 4 cr
- Virtual portion
- 1 cr
- Mode of delivery
- On-campus and online
- Unit
- (2019-2024) School of Business
- Campus
- Leiritie 1
- Teaching languages
- Finnish
- Seats
- 20 - 35
- Degree programmes
- Economics and Business Administration
- Teachers
- Elisabeth Schauman
- Tuire Jäntti
- Riikka Hiidenkari
- Tiina Mikkola
- Pertti Vilpas
- Tero Hujala
- Taru Haajanen
- Kevin McIntire
- Teacher in charge
- Anne Perkiö
- Groups
-
LXD21S1_L2LXD21S1_L2
- Course
- LD00EH42
Implementation has 2 reservations. Total duration of reservations is 7 h 30 min.
| Time | Topic | Location |
|---|---|---|
|
Tue 07.03.2023 time 17:00 - 20:45 (3 h 45 min) |
Rahoituksen Excel-sovellukset LD00EH42-3002 |
Linkki Zoomiin löytyy OMAn etusivulta
|
|
Tue 14.03.2023 time 17:00 - 20:45 (3 h 45 min) |
Rahoituksen Excel-sovellukset LD00EH42-3002 |
Linkki Zoomiin löytyy OMAn etusivulta
|
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
Materials
Lecture material
Excel-instructions
E-books
Teaching methods
Lectures
Online learning
Assignments
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.
Assessment methods and criteria
Assignments 100%
Qualifications
Finance and IT Tools or equivalent competences