Financial Modeling
Below are samples of various financial models I've performed throughout graduate studies.
.png)
01
Real Options
Real Options Analysis using a 10-step binomial tree lattice in Excel to find the value of a real option associated with the possible future activation of unused bandwidth capacity for Cox Communications in the broadcasting/cable industry in 1999.
02
LBO & APV
Adjusted Present Value valuation analysis for a Leveraged Buy-Out of DuPont Industrial Coatings in 2011. IRR and NPV calculated for sponsor.
.png)
03
Capital Structure
Coming soon:
Estimated a beneficial capital structure for Molycorp at the end of 201X based on existing bonds issued, and capital needed to finish planned capital investments.
04
IPO Pricing
Used DCF valuation, foreign currency exchange rates, competitive landscape analysis, EBITDA multiple comps, and macro economic trends to estimate an IPO share price for Ferrari (2015).
.png)
05
FCFF & ROPI models
Coming soon:
Used balance sheet and income statement to calculate ROE, ROA, NOPAT, NOA, NNE, NNO, leverage, spread, NOPM, NOAT, inventory turnover. Completed ROPI and FCFF valuations with above metrics for several public firms. Example left is Acushnet Holdings Inc.
06
Black-Scholes & Monte Carlo Options Valuation
Coming soon.
07
Investment RE valuation
Coming soon:
Used income method, comparable method, and replacement method to value investment real estate.