The business finance course has the following objectives:
- Strengthen the skills for the correct diagnosis of company financial problems;
- Make available models and logical assessment of financial solutions for businesses in different competitive environments;
- Strengthen the skills associated with the construction of valuation models.
Basic knowledge of spreadsheet analysis
General program of corporate finance
Course contents summary
The first point involves several issues pertaining creditworthiness valuation. It is important to understand what is the evaluation logic adopted by lender.
The second point concerns the identification of circumstances involving the powers of the financial executives. Each circumstance should be analyzed with regard to availability and to the critical tools to bring under control.
The third point relates rather to the fact that the spreadsheet is the main tool of those who deal with corporate finance and, more generally, with financial choice. This course module aims to enable students can develop their own simulation models in the field of financial decisions. This result is achieved by improving the necessary familiarity with the spreadsheet and, in parallel with the development of new operational achievements. In the initial phase of the module there is in fact concentrated on the analysis of decision models already developed, the next part we focus instead on developing new models. This is accomplished on the basis of the problem chosen and the subsequent development of a correct strategy to fully exploit the potential of the technology.
A - Analysis of credit
The tools of assessment and analysis of financial strength. The analysis of the maximum level of debt bearable. Possible imbalances in financial management.
B - Financial policy and objectives to be pursued: improvement of the rating, risk management, hedge, the generation gap, the fiscal situation of crisis, acquisition strategies, management of governance, the recovery of profit margins and development.
C - Valuation models
The logic of financial modeling and business simulation. The development and validation of models for financial decisions.
A - Credit Analysis
Tools of assessment and analysis of financial firm strength. Analysis of the maximum level of debt bearable. Possible imbalances in financial management.
B - Financial policy and objectives to be pursued: improvement of rating, risk management, hedge, generation gap, iscal situation of crisis, acquisition strategies, management of governance, recovery of profit margins and development.
C - Valuation models
The logic of financial modeling and business simulation. Development and validation of models for financial decisions.
G.Tagliavini (a cura di), Excel per la finanza e il management, 2010