Spreadsheet Models
A public company spreadsheet model with financial projection and assumptions using different techniques like DCF - FCFF and FCFE, Retained Earnings model and EV calculations.
Click to Basic Public Company Valuation Model here
RYAN Air - A public company in Europe in the Airlines Industry
Click to Basic Public Company Valuation Model here
Spreadsheet 1 deals with Call-Put parity, Call Put payoff using Risk, payoffs-profit of combinations, volatility calculations, call pricing using black scholes and binomial model, black scholes and parity calculation American option and European options, implied volatility, stock call ignoring dividends.
Click to download spreadsheet 1 here
Spreadsheet 2 deals with implied volatility volatility smirk, volatility smile based on maturity, bond pricing - clean and dirty, bond pricing and calculation Z rates using solver, swaps based on LIBOR, swap fixed rate using zero prices, fair value of futurees contract
Click to download spreadsheet 2 here
Spreadsheet 3 deals equity modelling uset asset volatility and bond calculations, risk neutral and objective probabilities, CDS calculations, Porfolio Calculations - Fama french factor model, combined beta, monthly variance and covariance matrix, standard deviation of portfolio, funds alpha
Click to download spreadsheet 3 here
A COSTCO model plugged in with formulas and valuding the company using different models FCFF, FCFE, EVA, Abnormal Earnings, Financial Ratio Analysis. This is a sample plugged in model
You could download the model here