Learning objectives
# <br />
The spreadsheet is the main working tool for those who deal with business finance and, more generally, with financial choices. The course aims to give the student the ability to develop his/her own simulation models in the field of financial decisions. This result is pursued by improving the necessary familiarity with the spreadsheet and, in parallel, with the development of new operating models. During the initial stage of the course we will in fact concentrate on the analysis of already developed decision-making models; in the next part we will concentrate on the development of new models. This is carried out on the basis of analysis of the chosen problem and with consequent perfection of a correct strategy for fully exploiting the technology's potential.
Prerequisites
Basic knowledge of Microsoft Office. Basic level knowledge of corporate finance problems and methods.
Course unit content
<br />The logics of financial modelling and business simulation. <br />
Development and validation of models for financial choices: analysis of already available models regarding important cases. <br />
Development and validation of models for financial choices: analysis of new problems and the perfection of new models. <br />
The more complex functionalities offered by the spreadsheet.
Full programme
- - -
Bibliography
Guida ad Excel per la finanza aziendale <br />
L'utilizzo del foglio di calcolo nei principali problemi di analisi finanziaria <br />
by Giulio Tagliavini <br />
Milano, Alphatest, 2005 <br />
ISBN 88-483-0556-3
Teaching methods
Traditional classroom lectures. Simulation session in the computer classroom. The examination consists of developing your own simulation model.
Assessment methods and criteria
- - -
Other information
- - -
