One important part of managing company operational activities is managing the cash flow activities where an accountant or any people responsible in financial issue has to make sure that the company manage its cash flow properly and any department have to make sure that the company income and expenses is in balance. This spreadsheet is intend to guide you on this issue.
This spreadsheet allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI.
This model brings a micro economical point of view to credit risk modeling. The logic behind the model is that in its fundamental, all the money that makes it available to pay the outstanding debt is driven from the total revenue figure. The model is pretty basic and straightforward that it captures the risks arousing from the variations in income statement items pretty well.
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.