capital market line and sharpe ratio in excel
Download excel file: http://www.codible.com/pages/86
Compute Sharpe ratio using Excel Solver, to draw the capital market line and determine the optimal two-stock portfolio to combine with a risk-free asset.
Some good books on Excel and Finance:
Financial Modeling - by Benninga:
http://amzn.to/2tByGQ2
Principles of Finance with Excel - by Benninga:
http://amzn.to/2uaCyo6