New tool for Corporate Finance

NPV (Net Present Value) of an investment

Ecrire ce que rapporte ou coûte l'investissement chaque année, si ça s'arrête avant l'année 5, mettre 0 pour le reste.

Year 0:
Year 1:
Year 2:
Year 3:
Year 4:
Year 5:

Interest rate (in %):

Net Present Value:

Perpetuity or Growing perpetuity

For example:

How much you need to give in Year 0 to pay an amount of money, growing or not, each year forever
What is the present value of placing a constant or growing amount of money into stocks each year forever

Cash flow on year 1 (C):
How much is the amount (C) growing each year (in %):
Interest rate (in %):

Net Present Value:

Annuity or Growing Annuity

Cash flow on year 1 (C):
How much is the amount (C) growing each year (in %):
Interest rate (in %):
Number of years:

Net Present Value:
Future Value:

FCF (Free Cash Flows) of a company for year X

Rentrer les données de l'entreprise pour l'année demandée. La partie "Increase in Net Working Capital" est parfois intrinsèque: si on vous dit par exemple qu'il y a des dettes/créances à hauteur de X % du chiffre d'affaires c'est que le NWC augmente mais seulement la première année de ce montant:

%_of_receivables * sales - %_of_payables * cogs.

Data on Year X

Revenues/Sales:
COGS:
General & Administrative:
Depreciation:
Increase in NWC (can also be %_of_receivables * sales - %_of_payables * cogs, but only year 1):
Capital expenditures on Year X only:

To get the Cash flow at time 0, fill this for Year 0:

On Year 0, Buying new things that will be depreciated later:
On Year 0, R&D Expenditures:

Don't forget the tax rate

Corporate tax rate (in %):

Cash flow year 0:
Unlevered Net Income:
Free Cash Flows year X:

Beta and CAPM (Capital Asset Pricing Model) calculator

Beta

Pour calculer le Beta d'une action X par rapport au marché, on a besoin de:

la covariance de l'action X avec le porte-feuille marché
la variance du porte-feuille marché

Covariance of stock X with market portfolio:
Variance of market portfolio:

Beta for stock X:

Expected Return

Pour calculer l'expected return avec le CAPM, on utilise le beta calculé précédemment.

Beta:
Riskless Expected Return OR T Bills Expected Return:
Market Portfolio Expected Return:

CAPM for stock X:

WACC (Weighted Average Cost of Capital)

Financed by debt (in %):
Financed by equity (in %):
Cost of debt (in %):
Cost of equity (in %):
Tax rate (in %):

WACC:

Bonne chance!