Spreadsheet 123 Corporate Finance in Excel

Capital Budgeting Excel Worksheet - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc.

Macro Economic Duration - This program allows you to estimate the duration of a firm's assets and its sensitivity to other macro economic variables. It may be useful in the design of debt.

Betas and Leverage - This program allows you to enter the current beta, tax rate and the debt equity ratio for your stock, and obtain a table of betas at different debt ratios.

Ratings Model - This program allows you to estimate a rating and a cost of debt for your company from the firm's interest coverage ratio.

Capital Structure - This program allows you to estimate an "Optimal" capital structure for a company using the cost of capital approach.

Excel Risk Model - This program 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.

Dividends Model - This program compares the dividends paid to what a firm could have paid, by estimating the free cash flow to equity (the cash flow left over after net debt payments, net capital expenditures and working capital investments.

Discounted Cashflow Valuation - This program computes the value of equity in a firm using a two-stage dividend discount and FCFE model. (For more extensive choices on valuation, look at the programs under the valuation section below.)