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

Chapter 18 : Computation of beta


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 20 : Modified duration of a bond

Chapitre 20 : Duration of a bond

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

Chapitre 22 : The Bates formula

Chapitre 22 : The Holt formula

Chapitre 23 : Black-Scholes formula

Chapitre 31 : DCF valuation

Chapitre 49 : Wilson formula