Excel Applications for Financing (5 cr)

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

Location and time

According to the schedule on Myyrmäki campus

Materials

Lecturers' materials in Moodle.

Teaching methods

Interactive lecture
Assignments
Project

Exam schedules

No exam

Completion alternatives

N/A

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

Tuition in Finnish only.

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 % of the course grade:
• Applications of finance 50%
• Quantitative analysis 50 %

Qualifications

Finance and IT Tools or equivalent competences