Courses NonDegree Display 2014-2015
Course Description | To PDF | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Course title | Excel for Finance | |||||||||||||||||||||||||||||||||||||||
Course code | EBS2018 | |||||||||||||||||||||||||||||||||||||||
ECTS credits | 4,0 | |||||||||||||||||||||||||||||||||||||||
Assessment | None | |||||||||||||||||||||||||||||||||||||||
Period |
|
|||||||||||||||||||||||||||||||||||||||
Level | Intermediate | |||||||||||||||||||||||||||||||||||||||
Coordinator |
Pomme Theunissen For more information: p.theunissen@maastrichtuniversity.nl |
|||||||||||||||||||||||||||||||||||||||
Language of instruction | English | |||||||||||||||||||||||||||||||||||||||
Goals |
This skill reviews core concepts from Finance 1.5 within the context of Microsoft Excel software's concepts and tools.
|
|||||||||||||||||||||||||||||||||||||||
Description |
The skill covers four core concepts in finance, capital budgeting, valuation, portfolio analysis and the capital asset pricing model through the application of Microsoft Excel's software package. Students will use problems in the text to solve analytical tasks using excel. In addition, students will be taught advanced Excel tools, ranging from mastering advanced Excel functions, pivot tables, to introductory macros. Finally, each week students will test their knowledge through two examinations testing their knowledge on core concepts in finance and excel. This course prepares students for incorporating more advanced Excel knowledge for the business and accounting environment that lays ahead.
|
|||||||||||||||||||||||||||||||||||||||
Literature |
Principles of Finance with Excel by Simon Beninga.
|
|||||||||||||||||||||||||||||||||||||||
Prerequisites |
Exchange students need to have taken at least one introductory finance course
an advanced level of English |
|||||||||||||||||||||||||||||||||||||||
Teaching methods (indicative; course manual is definitive) | PBL / Presentation / Lecture / Assignment / Groupwork | |||||||||||||||||||||||||||||||||||||||
Assessment methods (indicative; course manual is definitive) | Attendance / Participation | |||||||||||||||||||||||||||||||||||||||
Evaluation in previous academic year | For the complete evaluation of this course please click "here" | |||||||||||||||||||||||||||||||||||||||
This course belongs to the following programmes / specialisations |
|