Capital Valuation Paper
THIS IS A LIST OF EXCEL PROGRAMS THAT YOU MIGHT FIND USEFUL. THEY ARE NOT COPY PROTECTED. FEEL FREE TO MODIFY THEM TO YOUR OWN NEEDS.
Corporate Finance Spreadsheets 1. capbudg.xls: This program allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI. (For Macintosh version) 2. risk.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.(For Macintosh version) 3. capstru.xls: This program allows you to estimate an "Optimal" Capital structure for a company using the cost of capital approach , the differential return approach and the APV approach. (For Macintosh version) 4. capstruo.xls: 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. (For Macintosh version) 5. 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.(For Macintosh version) 6. 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.)(For Macintosh version) 7. lboval.xls: This program analyzes the value of equity and the firm in a leveraged buyout. (For Macintosh version) 8. synergy.xls: This program estimates the value of synergy in a merger. (For Macintosh version)
Equity Valuation Spreadsheets 1. readme1s.xls: This file describes the programs in this section and provides some insights into their usage. (For Macintosh version) 2. model.xls: This program
Corporate Finance Spreadsheets 1. capbudg.xls: This program allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI. (For Macintosh version) 2. risk.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.(For Macintosh version) 3. capstru.xls: This program allows you to estimate an "Optimal" Capital structure for a company using the cost of capital approach , the differential return approach and the APV approach. (For Macintosh version) 4. capstruo.xls: 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. (For Macintosh version) 5. 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.(For Macintosh version) 6. 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.)(For Macintosh version) 7. lboval.xls: This program analyzes the value of equity and the firm in a leveraged buyout. (For Macintosh version) 8. synergy.xls: This program estimates the value of synergy in a merger. (For Macintosh version)
Equity Valuation Spreadsheets 1. readme1s.xls: This file describes the programs in this section and provides some insights into their usage. (For Macintosh version) 2. model.xls: This program