Financial Market models
- Compute the Beta needed for your CAPM as to calculate the expected return of a company's share93 remove_red_eye
Option Value with Black-Scholes formulaFind the value of puts, calls, and combinations of options using the Black-Scholes formula.103 remove_red_eye
Black-Scholes converted for Binomial TreeConverts the standard deviation input in the Black-Scholes model to up and down movements in the binomial tree.61 remove_red_eye
Dividend Adjusted Model to value Long Term OptionsA dividend-adjusted model for valuing long term options.60 remove_red_eye
Dividend Adjusted Model to value Short Term OptionsA dividend-adjusted model for valuing short-term options.54 remove_red_eye
movieEstimating a beta (Corporate Finance)Compute and estimate a beta for a firm's stock/market index79 remove_red_eye
Effect of a buyback on Earnings per Share (EPS) and ValueAssess how a buyback will affect EPS and Value50 remove_red_eye
movieBetas and LeverageObtain a table of betas at different debt ratios37 remove_red_eye
movieImplied Risk Premium in a MarketCalculate the implied risk premium in a market93 remove_red_eye
Option Trading WorkbookPrice options and choose the appropriate strategies. Visualise them in a graph.57 remove_red_eyefreeby Peter McFee
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components144 remove_red_eye
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.63 remove_red_eye
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables58 remove_red_eye
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index205 remove_red_eye
Terminal Value Calculation Excel TemplateCompute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet674 remove_red_eye
Working Capital Policy TemplateSee how working capital policies are established and how they influence financial needs63 remove_red_eye
Stock Analysis Excel ModelAnalyze past company performance and arrive at its intrinsic value in 30 minutes or less90 remove_red_eye
How to Calculate Volatility in ExcelA simple methodology and excel file to learn how to compute stock volatility45 remove_red_eye
Portfolio Variance ModelA simple model to learn and play with portfolio variance in Excel16 remove_red_eyefreeby Risk Prep
- Have a Financial Markets Excel Model?
Your Financial Markets ModelPublish your model
Any questions on Financial Markets?
The user community is here to help. Go ahead!