Aviso: Se está a ler esta mensagem, provavelmente, o browser que utiliza não é compatível com os "standards" recomendados pela W3C. Sugerimos vivamente que actualize o seu browser para ter uma melhor experiência de utilização deste "website". Mais informações em webstandards.org.

Warning: If you are reading this message, probably, your browser is not compliant with the standards recommended by the W3C. We suggest that you upgrade your browser to enjoy a better user experience of this website. More informations on webstandards.org.

Sub Menu
ISCTE-IUL  >  Education  >  LE , LG

Financial Modelling and Business Plan (2 º Sem 2016/2017)

Code: L6047
Acronym: L6047
Level: 1st Cycle
Basic: No
Teaching Language(s): Portuguese, English
Friendly languages:
Be English-friendly or any other language-friendly means that UC is taught in a language but can either of the following conditions:
1. There are support materials in English / other language;
2. There are exercises, tests and exams in English / other language;
3. There is a possibility to present written or oral work in English / other language.
1 6.0 0.0 h/sem 36.0 h/sem 0.0 h/sem 0.0 h/sem 0.0 h/sem 0.0 h/sem 1.0 h/sem 37.0 h/sem 113.0 h/sem 0.0 h/sem 150.0 h/sem
Since year 2016/2017
Pre-requisites None
Objectives 1- Building and using the key documents for financial planning, namely Income Statements; Cash-Flow Statements; Financial Statements and Balance Sheets. Simulating the firm?s future situation.
2- Analysing specific issues of operational and financial planning with implications for the corporate value, and the flexibility value.
3- Valuing financing alternatives according to the financial equilibrium and value implications.


Program 1.Introduction
Importance of the Financial Plan; Sources of Positive NPV; Business Plan: parts, sources and objectives.

2.Financial Planning
Pro-Forma Financial Plan: Income Statement; Cash-Flow Statements; Cost of Capital Computing; Project Evaluation; Pro Forma Financial Statements and Balance Sheets; Sensitivity Analysis and Equilibrium Analysis.

3.Specificities of the Financial Plan
Equipment Substitution; Residual Value; Future Value; Forms of Computing the Real Parameters of the Market (Bloomberg and Datastream); Real Options.

4.Financing
Analysis of impact of the different alternatives of financing (bank credit; bank credit in foreign exchange; leasing; bonds?) on the business plan; Computation of the Adjusted Present Value.


Evaluation Method During the semester:
- Classroom attendance and participation;
- Group Project Assignment: delivery of the financial plan developed in group (30%).
- Mid-term individual test(40%).
- The Final Assessment consists of Final Test (30%) or Exam (100%).

A final grade above 16 may have to be confirmed in an oral exam.
Teaching Method Financial Modelling and Business Planning classes have mainly a practical content.

In this course an intensive use of spread sheets will be carried out. Nevertheless, small examples and cases will be used for introduction to the core topics. The main discussion will be centered on the students? financial planning of their Project.

Observations None
Basic Bibliographic Duarte C e Esperança, J. (2012) Empreendedorismo e Planeamento Financeiro, Edições Sílabo

Esperança, J. e F. Matias (2009, 2ª Ed.), Finanças Empresariais, Texto Editora

Dias Curto, J.J. (2002), Excel para Economia e Gestão, Ed.Sílabo

Gomes Mota, A., Nunes, J.P., Ferreira, M., Barroso,C. (2007), Finanças Empresariais ? Teoria e Prática, Ed. Publisher Team

Carvalho das Neves, J. (2002), Avaliação de Empresas e Negócios, Ed. Mc. Graw-Hill



Complementar Bibliographic Scott Proctor, K. (1999), Building Financial Models with Micosoft Excel, Ed. Wiley Finance

Sahlman, W. (1997)  How to Write a Great Business Plan, Harvard Business Review, Jul.- Ago., pp. 98-108.

Sandiás, A., Jainaga, T. (2008), Modelización Financiera Aplicada, Ed. Delta Publicaciones

Benninga, S. (1999), Financial Modeling, Ed. MIT Press