Corporate Finance Spreadsheets
-
Capital Budgeting - This program allows you to do a basic capital
budgeting analysis for a project, and compute NPV, IRR and ROI.
-
Risk - 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.
-
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 - This program allows you to estimate a rating and a cost of
debt for your company from the firm's interext coverage ratio.
-
Capital Structure - This program allows you to estimate an "Optimal"
capital structure for a company using the cost of capital approach.
-
Capital Structure - This is a variant that allows you to estimate an
"Optimal" capital structure for a company whose operating income might vary
with its debt rating - for instance, financial service firms.
-
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.
-
Dividends - 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.)
Note
You will need MS Excel 97 of hire to use this spreadsheets. If you do not
have MS Excel and you are trying to open it with different Excel-like software
please note that some of the functions may not work properly.
