copy_of_capm.xlsx

CAPM

Documentation: The purpose of this model is to calculate required rate of return on a stock using CAPM
Inputs:
Risk Free Rate 7.0%
Beta of Stock 1.50
Return on Market 11.0%
Formula/Output:
Required Return on Asset 13.0%

Sheet2 (2)

Sheet2

Sheet3