Spreadsheet analysis for accounting related topics

Balance sheet analysis and key figures analysis with MS Excel, setting up and solving business management cases with MS Excel, investment accounting, weighted average cost of capital, discounted cash flow, net present value, internal rate of return, budget planning, cost centre and cost unit accounting, normal capacity, idle costs, absorption rate, simultaneous equations, financing: annuity factor, actual interest rate, cash flow, result scenarios, analysis of cost divergence, quantity deviation, price and costs deviation, graphic preparation of results with MS Excel, charting features, special bar charting with Excel formulas, Excel content, data import, creating pivot tables, structuring, calculated fields, scenario manager, goal seek, mathematical functions, references, conditions, matrix functions, financial mathematical functions, formatting, conditional formatting, short cuts, planning and designing calculation models, reorganising and reconstructing calculation models, handling work folders with complex calculation models, designing charts and presenting data

Mode of delivery

face to face

Type

compulsory

Recommended or required reading and other learning resources/tools

Klein: Controlling mit Excel, München: Vahlen, Röhrenbacher: Finanzierung und Investition mit Excel und HP, Wien: Linde

Planned learning activities and teaching methods

Practice class - Illustration of software functions and applications and immediate feedback on the preparation of cases dealing with large data sets

Assessment methods and criteria

Continuous assessment

Prerequisites and co-requisites

Financial accounting, financial management, management fundamentals

Infos

Degree programme

European Economy & Business Management (Bachelor)

Cycle

Bachelor

ECTS Credits

3.00

Language of instruction

German

Curriculum

Part-Time

Academic year

2021

Semester

4 SS

Incoming

No

Learning outcome

On successful completion of this class, students will be able to generate business calculation models. They can supply decision makers (using the well tested and widely used software Excel) with efficient and flexible solutions to demanding tasks in the areas of spread sheet analysis, financial management, production as well as cost accounting and financial controlling.

Course code

0389-11-01-BB-DE-36