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
