Course Details

INTRODUZIONE ALL'USO DI EXCEL PER LA RISOLUZIONE DI PROBLEMI FINANZIARI ED AZIENDALI

EC0311

Course
INTRODUZIONE ALL'USO DI EXCEL PER LA RISOLUZIONE DI PROBLEMI FINANZIARI ED AZIENDALI
Code
EC0311
Academic Year
2024/2025
Curriculum Year
2022/2023
Degree Programme
BUSINESS AND MANAGEMENT
Curriculum
000 - CORSO GENERICO
Course coordinator
Lecturers
Credits
2
Lecture Hours
15
Scientific Disciplinary Sector (SSD)
NN - Indefinito/Interdisciplinare
Course Type
Single-subject learning activity
Course Delivery
OPZ - Opzionale
Year
3
Teaching period
Secondo Semestre
Campus
ALESSANDRIA
Teaching language
Italian
Course Contents
Use and management of a calculus sheet in order to solve firm and financial problems.
Reference Texts
Modelli finanziari. La finanza con Excel.
Simon Benninga.
Mc Graw Hill
Learning Outcomes
The student must be able to approach a firm of a financial problem on a calculus sheet and to solve it by the available instruments.
Prerequisites
Metodi matematici 2.
Teaching Methods
Laboratory.
Additional Information
Students with physical disabilities, Learning Disabilities or Special Education Needs can request specific services and tools via the Staff Sviluppo e Coordinamento Carriere e Servizi alle Studentesse e agli Studenti, consulting the University webpage: https://www.uniupo.it/en/services/servicesstudents- physical-or-learning-disabilities Students with disabilities, learning disabilities or special education needs, once they have contacted the University Staff, can refer to the tutor in charge of the course to define the examination modalities, concerning academic aspects. When dealing with ESG aspects and the sustainability objective, the importance of good corporate governance will be highlighted in the various profiles, including gender equality.

During class students can work better if they use their own laptop in addition to the one in the laboratory where they can watch the teacher's work. They are asked to download Microsoft365 which is free for UPO students.
Assessment Methods
To cope with a firm or financial problem by using Excel.
Detailed Syllabus
Building of the discount curve, NPV and internal rate of return of a financial plan. Pricing of bonds. Financial choices. Financial amortization. How to build a contract. Linear sistems and their operative use.
Expected Learning Outcomes
Being able to solve a financial or firm problem by the use of excel.
Last update:09-09-2026 00:14:31