Publication number: ELQ-26168-1
View all versions & Certificate
Beta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share
Step by Step Excel Template to calculate the CAPM Beta (Capital Asset Pricing Model) of MakeMyTrip. You can use this template to find Beta for other companies as well.
What is a CAPM Beta?
"Beta is a measure of the volatility, or systematic risk, of a security or a portfolio in comparison to the market as a whole. Beta is used in the capital asset pricing model (CAPM), a model that calculates the expected return of an asset based on its beta and expected market returns." (Investopedia)
This business tool includes
1 Excel Model
Dheeraj Vaidya CFA FRM offers you this business tool for free!
download for free
Add to bookmarks
- Mangesh Tirki(last updated: 10/04/2017 06:34)
People using this tool also downloaded
CEQ Method Valuation ModelValuation by the CEQ Method based on Discrete Scenario Cash Flow Forecastfinancevaluationcash flowsbetaprivate equityentrepreneurpresent valuesceqcertain equivalent1,189 remove_red_eyefreeby Kevin Hanley
Estimating a beta (Corporate Finance)Compute and estimate a beta for a firm's stock/market indexperformanceriskfinancestocksensitivitybetaestimatingjensen's alphamarket index515 remove_red_eye
Leveraged Buyout LBO Model - DCFA comprehensive LBO model in excel of business acquisitionacquisitionbusinessfinanceleveraged buyoutirrcash flowsdcfcapmlbo analysislbo model1,694 remove_red_eyefreeby Amit Tandon
Beta Coefficient | Calculate Beta in ExcelA methodology on how to calculate Beta in Excel along with a beta calculation excel worksheet.stockbetarisk premiumcapmexcelrisk free ratecost of equitybeta coefficientbeta calculationsecurityNew!
Portfolio Variance ModelA simple model to learn and play with portfolio variance in Excelmatrixriskfinancevarianceportfolioasset managementcorrelationportfolio variancefinding variance exampleprm exam practive91 remove_red_eyefreeby Risk Prep
Sensitivity Analysis Using ExcelIn this video you will learn how to carry out sensitivity analysis using Excel.analysisfinancesensitivitydcfsensitivity analysisdiscounted cash flowexcel117 remove_red_eyefreeby Finance Walk
Evaluating Financial Performance and ForecastingSet of worksheets related to financial analysis and forecastingevaluationfinancefinancial performanceforecastingfinancial analysis137 remove_red_eyefreeby Matt Evans
Cap Table TemplateThis Cap Table template perfect for first-time entrepreneurs to list a company's securities.financestartupinvestorsventure capitalraising capitalcap tableshareholdersfounderscontrol534 remove_red_eye
Implied Return on Capital (ROC) & Return on Equity (ROE) Terminal ValueCompute the ROC or ROE implied in your terminal value calculationfinanceroereturn on equityrocterminal valuereturn on capitalreinvestment615 remove_red_eye
Two-Stage Free Cash Flow to Equity (FCFE) Discount ModelValue the equity in a firm with two stages of growthfinancevaluationfcfefree cash flow to equityequitytwo-stage growth886 remove_red_eye
Any questions on Beta Calculation Worksheet?
The user community and author are here to help. Go ahead!