A
pplied
C
orporate
F
inance: Spreadsheets
Risk Analysis
Estimating Implied Equity Premium in a Market
Estimating CAPM parameters for a firm
Unlevering and Levering Betas
Estimating Synthetic rating for a firm
Cost of Capital Estimation
Valuation
Model Chooser: Helps choose the right model for a firm
Stable Growth DDM
Two Stage DDM
Three Stage DDM
Stable Growth FCFE Model
Two Stage FCFE
Three Stage FCFE
Stable Growth FCFF
Two Stage FCFF
Three Stage FCFF
Capital Expenditure Estimator
Estimating Equity Multiples
Estimating Firm Value Multiples
Return Estimation
Estimating Cash Flows to Equity and Return Diagnostics on Project
Present Value Calculator
Valuing the Option to Delay
Valuing the Option to Expand
Valuing the Option to Abandon
Capital Structure
Optimal Capital Structure with WACC (Operating Income held constant)
Optimal Capital Stucture with WACC (Operating Income allowed to vary)
Optimal Capital Structure with APV
Dividend Policy
Analyzing Dividend Policy (looking at FCFE and Project Choice)