Market Risk Premium Template
Market Risk Premium Template
This market risk premium template will show you how to compute the market risk premium using the expected rate of return and the risk-free rate.
Below is a preview of the market risk premium template:
Download the Free Template
Enter your name and email in the form below and download the free template now!
The market risk premium is the additional return an investor will receive (or expects to receive) from holding a risky market portfolio instead of risk-free assets.
The market risk premium is part of the Capital Asset Pricing Model (CAPM), which analysts and investors use to calculate the acceptable rate of return. At the center of the CAPM is the concept of risk (volatility of returns) and reward (rate of returns). Investors always prefer to have the highest possible rate of return combined with the lowest possible volatility of returns.
The formula for Market Risk Premium is:
Market Risk Premium = Expected Rate of Return – Risk-Free Rate
Usually, a government bond yield is the instrument used to calculate risk-free assets, as it has little to no risk.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.
Excel Tutorial
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Excel Crash Course now to take your career to the next level and move up the ladder!
