The adjusted premium added to the risk-free rate is the difference in the expected market return times the beta of the asset. This formula can be calculated in Microsoft Excel as shown below.

These 46 Pro Excel Tips Will Transform You Into a Spreadsheet Magician Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.