Provide knowledge for the use of the financial functions available in Excel spreadsheet for the drafting of plans for amortization of loans in various systems (French, German, Italian, etc ..) and to evaluate the advantages and the actual return on investment the cost / effective rate of financing operations and leasing (this through the various financial methods: IRR, NPV, etc ...)

- The principal financial functions in Excel: their use and their syntax.
- The construction of an amortization schedule for a mortgage according to the French method by using the functions PMT, PPMT, INTEREST, VALATT Excel
- The use of the function VALFUT for the construction of floors of accumulation of capital
- The use of the functions VA and NPV to evaluate the advantages of investment operations or financing transaction or leasing
- The use of the functions RATE and IRR for the calculation of the effective rate of investment operations or financing or leasing

NO

Knowledge and use of the financial functions available in spreadsheets to quickly make calculations of financial mathematics and financial analyzes of assessments of investment or financing transactions

The teaching material prepared by the lecturer in addition to recommended textbooks (such as for instance slides, lecture notes, exercises, bibliography) and communications from the lecturer specific to the course can be found inside the Moodle platform › blended.uniurb.it

Exercises and case studies in the laboratory

Teaching

Front lessons and practical experiments in the laboratory

Attendance

NO

Course books

The section "Financial functions" Chapter "Functions" from the book EXCEL for Students of Economics (G. Bentivoglio, F. Petroselli, C. Nicoletti) - Editions Goliardiche, revised and supplemented in 2005

Assessment

Frequency with registration and signature of the presence at the seminar.

Alternatively, students who do not want or can not attend the seminar can attend the exam during the ordinary exam sessions a test application on financial functions in Excel.

Disabilità e DSA

Le studentesse e gli studenti che hanno registrato la certificazione di disabilità o la certificazione di DSA presso l'Ufficio Inclusione e diritto allo studio, possono chiedere di utilizzare le mappe concettuali (per parole chiave) durante la prova di esame.

A tal fine, è necessario inviare le mappe, due settimane prima dell’appello di esame, alla o al docente del corso, che ne verificherà la coerenza con le indicazioni delle linee guida di ateneo e potrà chiederne la modifica.

Attendance

NO

Course books

THE SAME FOR STUDENTS ATTENDING

Assessment

Students who will not or can not attend the seminar can attend the exam during the ordinary exam sessions a test application on financial functions in Excel.

Disabilità e DSA

Le studentesse e gli studenti che hanno registrato la certificazione di disabilità o la certificazione di DSA presso l'Ufficio Inclusione e diritto allo studio, possono chiedere di utilizzare le mappe concettuali (per parole chiave) durante la prova di esame.

A tal fine, è necessario inviare le mappe, due settimane prima dell’appello di esame, alla o al docente del corso, che ne verificherà la coerenza con le indicazioni delle linee guida di ateneo e potrà chiederne la modifica.

The seminar is held IN ONE DAY A YEAR at the end of the 2nd semester, on a date that is agreed upon with the students and that is promptly publicized both in the home page of the School of Economics and in the teacher's web page.