Download Excel spreadsheets
Chapter 4 : A capital-employed balance sheet
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapter 5 : Cash flow statement
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapter 9 : Profit and loss statement
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapter 11 : Working capital turnover ratios
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapter 13 : Leverage effect analysis
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapter 18 : Computation of beta
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
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
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 16 : Free cash flows present value calculation : 3-period model
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 18 : Volatility calculation
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 20 : Modified duration of a bond
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 20 : Duration of a bond
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 22 : Share value with a dividend discounting model : 3-period model
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 22 : The Bates formula
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 22 : The Holt formula
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 23 : Black-Scholes formula
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 31 : DCF valuation
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)
Chapitre 49 : Wilson formula
![](https://www.vernimmen.com/rsrc/m/bgTabOmbre.png)