BUSINESS SCHOOLSClick on the links below to immediately download these spreadsheets. If you have a spreadsheet that you would like to upload to this section, please use the "Sell your Spreadsheets" button to the left. If you would like for it to be free, just enter a "0" in the price field. This program allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI. Provided by Aswath Damodaran-NYUrisk.xls 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. Provided by Aswath Damodaran-NYU levbeta.xls 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. Provided by Aswath Damodaran-NYU ratings.xls This program allows you to estimate a rating and a cost of debt for your company from the firm's interext coverage ratio. Provided by Aswath Damodaran-NYU adjustedpresentvalue.xls This program allows you to estimate an "Optimal" Capital Structure for a company using the Adjusted Present Value Approach. Provided by Aswath Damodaran-NYU capitalstructure.xls This program allows you to estimate an "Optimal" Capital structure for a company using the cost of capital approach. Provided by Aswath Damodaran-NYU Macroeconomicvariables.xls 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. Provided by Aswath Damodaran-NYU Dividends.xls 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. Provided by Aswath Damodaran-NYU dcfval.xls 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.) Provided by Aswath Damodaran-NYU |



