Beta coefficients and the capital asset pricing model Personal Finance Problem Katherine Wilson is wondering how much risk she must undertake to generate an acceptable return on her porfolio. The risk-free return currently is 5%.

The return on the overall stock market is 9%.

Use the CAPM to calculate how high the beta coefficient of Katherine's portfolio would have to be to achieve a portfolio return of 16%. Must be answered in excel spreadsheet.

You must MUST use at least one of the following Excel functions to answer at least one part of the question: FV, PV, PMT, RATE, NPER, NPV, AVERAGE, STDEV, and IRR.