Download Excel spreadsheets

Chapter 4 : A capital-employed balance sheet

Chapter 5 : Cash flow statement

Chapter 9 : Profit and loss statement

Chapter 11 : Working capital turnover ratios

Chapter 13 : Leverage effect analysis


Use the table below to download the Bates, Bates, Black & Scholes and several other useful formulas.

These are Excel files.

Chapitre 16 : Present value of an annuity that grows at rate g for n years

Chapitre 16 : Free cash flows present value calculation : 3-period model

Chapitre 18 : Volatility calculation

Chapitre 21 : Modified duration of a bond

Chapitre 21 : Duration of a bond

Chapitre 23 : Share value with a dividend discounting model : 3-period model

Chapitre 23 : The Bates formula

Chapitre 23 : The Holt formula

Chapitre 24 : Black-Scholes formula

Chapitre 32 : DCF valuation

Chapitre 48 : Wilson formula