Market Risk Premium Template

Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course. Start Free

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:

Market Risk Premium Template Screenshot

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!

0 search results for ‘