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

It is not expected to acquire the knowledge gained since the seminar is only attended by the seminar (which is registered by signing the seminar signature at the end of the seminar), and the teacher directly proceeds to the seminar's verbalization.

Alternatively, students who do not want or can not attend the seminar can support, during ordinary exams, an application test on financial functions in Excel. This semi-structured test examines and verifies the applied knowledge of the use of financial functions of the Excel Spreadsheet in business applica- tion relating to finance, and in particular the assessment of the convenience of alternative investment or financing operations, cost or of the actual return on financial transactions, or in the computerized formulation of loan amortization plans according to the French method. Exceeding the test is obtained by building a minimal software template in Excel environment on the application that is required.

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 1rst 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.