Excel Spreadsheets

This spreadsheet allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI.

This spreadsheet allows you to use past returns on a stock and a market index to analyse its price performance (Jensen’s Alpha), its sensitivity to market movements (Beta) and the proportion of its risk that can be attributed to the market.