Time Value of Money

1. Basic Time Value of Money Computations
2. Estimate the present value of a growing annuity.

Bond & Stock Valuation

1. Value a bond.
2. Value a stable growth dividend paying stock, using a dividend discount model.
3. Value a dividend paying stock, using a 2-stage dividend discount model.

Portfolio Theory & Cost-of-Capital

1. This spreadsheet allows you to estimate the implied equity premium in a market.
2. Run a regression of stock returns against market returns and estimate risk parameters.
3. Estimate the unlevered beta for a firm and compute the betas as a function of the leverage of the firm.
4. This spreadsheet allows you to estimate the synthetic rating and cost of debt for any firm.
5. This spreadsheet allows you to convert book values of debt into market values.
6. Estimate the accounting beta on a division or firm.

Capital Budgeting

1. Estimate the cash flows to the firm on a project.
2. Estimate the average return on capital, NPV and IRR on a project
3. Estimate the cash flows to equity on a project.
4. Compare projects with different lives, using the equivalent annuity approach.
5. This spreadsheet allows you to analyze a replacement decision.

Valuation of a Firm

1. Convert R&D expenses from operating to capital expenses.
2. Convert operating leases from operating expenses to financial expenses.
3. Value the options outstanding in a firm, allowing for the dilution effect.
4. Compute the value of a firm and the value of equity per share. It has built into it, converters for operating leases and research and development expenses.
5. Value the equity in a firm directly, using cash flows to equity and a cost of equity.
6. Value the equity in a firm, using the dividend discount model.
7. Estimate the equity multiples for a firm, given its fundamentals.
8. Estimate the firm value multiples for a firm, given its fundamentals.