Last version published: 04/05/2017 14:31
Publication number: ELQ-45240-3
View all versions & Certificate
Portfolio Variance Model
A simple model to learn and play with portfolio variance in Excel
It can be simple to calculate portfolio variance when you have two assets. However, when you're given 10, 15 or even hundreds of assets - it is a different story.
The sample spreadsheet below has 6 assets, with given respective standard deviation and correlation.
With the given values, we can calculate the portfolio volatility with any set of weights, additionally to calculating the sharpe ratio.
With the spreadsheet, we can see how values change according to different risk variables and returns, as well as also being able to calculate an efficient portfolio (this is for you to try out!)
- Risk Prep & Mukul Pareek, 2009
This business tool includes
1 Excel File
Risk Prep offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's sharefinancebetacapmcapital asset pricing modelregression analysisslope methodvariancecovariance formula375 remove_red_eye
Estimating a beta (Corporate Finance)Compute and estimate a beta for a firm's stock/market indexperformanceriskfinancestocksensitivitybetaestimatingjensen's alphamarket index686 remove_red_eye
Estimating the value of the option to abandon a project or investmentDetermine whether a project or investment should be abandonedstrategyriskfinanceproject managementplanning145 remove_red_eye
BCG Growth Matrix and Auto Graphing Excel ModelThe BCG Growth Matrix automatically propagates in all the information for up to 10 different investments.strategymatrixinvestingportfoliobcgboston consulting groupdescision makinggrowth-share114 remove_red_eye$15.00by Benjamin J. Boyle
Likelihood that a Troubled Firm Will FailThis model quantifies the probability of failure for troubled firms.riskfinancetroubled firmfailureprobability76 remove_red_eye
The Business Model PortfolioExplanation alongside prototype created to aid companies in vision and management of business model portfolio.investmentriskbusiness modelinvestorsprofitabilityportfoliosustainability84 remove_red_eye
Weighted Average Cost of Capital (WACC)A model for calculating Weighted Average Cost of Capital using beta's for equityfinanceequitycapitalwacc357 remove_red_eye
Matrix Technology/ MarketsShow the value of disruptive technologies meeting specific marketsmarketvaluestrategytechnologymarketscrossroadsmatrixdisruptivetechnologiesinnovationcombinationuniqueporfolioanalysisinvestmentsinvestment575 remove_red_eye
Personal Finance ToolkitManage and control your personal finance to stay wealthyfinancepersonal financewealth managementincome planincome chartbalance planbalance chartcash planplanned net worth330 remove_red_eye
Two-Stage Free Cash Flow for the Firm (FCFF) Discount ModelValue a firm with two stages of growth on the basis of free cashflows to firmfinancevaluationfree cash flow for the firmfcfftwo-stage growth781 remove_red_eye
Any questions on Portfolio Variance Model?
The user community and author are here to help. Go ahead!