Explore BrainMass

Explore BrainMass

    Portfolio Questions

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Attached is an excel sheet on a portfolio.

    What is the current yield on the equities portfolio?
    a. 2.02 b. 2.03 c. 2.06 d. 2.86
    CY = annual income / price
    I tabulated Annual Inc/Share = 5.145
    I then divided by the price of all equities = 69.9.
    5.145/69.9 = .073 - Way off of the list of answers. Please advise.
    Do I need to take the annual income * shares / divide by the FMV = .042?

    What is the weighted geometric average return of the equities in portfolio?
    a. -1.4 b. 3.22 c. 3.71 d. 4.22 e. 7.61
    I need to take the square root of the 2011 returns
    √(1-[-.05])(1+[-.06])(1+[.01])(1+.03)(1+.02) = .9529 - once again, not close to answers. Please advise.

    What is the weighted beta of portfolio?
    Add FMV = 134000
    Divide individual Cost Basis by 134000
    Mult those answers by beta
    Add those figures = 1.08

    Find Treynor performance measure index and rank from highest to lowest. (Using the geometric average return over the 5 year period.)
    What I am unable to calculate is the geometric average over the 5-yr period. Please advise.
    From there, T = r(p)-r(free)/Beta
    Wouldn't Risk free rate be .0006? - 3month t-bill?

    What is the YTM of the Texas Instruments Bond?
    P = pmt/(1+i)^n
    I need to find the payment. I don't know how to do that. From there, I think I can find it. Is this correct?

    © BrainMass Inc. brainmass.com March 7, 2023, 2:46 pm ad1c9bdddf


    Solution Preview

    Below is your tutorial.
    Note that I reformatted the Excel file for easier computation. I highlighted the cells I changed with GREY.

    Question 1. What is the current yield on the equities portfolio?
    2.02 b. 2.03 c. 2.06 d. 2.86
    Current yield = Annual income/Current price
    Since we are computing for the current yield of the equities portfolio, we replace annual income per share with Total Annual Income for the entire portfolio which I computed and highlighted with YELLOW in the Excel file. The current price is to be replaced by the portfolio's fair market value
    Given this the formula for the current yield is
    CY = $5,667/$134,000 = 4.23%

    Now, may I ask where you got the data - FMV and Annual Income Per Share - from?
    I checked the price of the stocks at the end of December 31, 2011 and the values in the FMV are not the market values of these stocks at the end of 2011. For example, on December 31, 2011 Boeing has a market price per share of $70.80 which translates to an FMV of $28,320 for 400 shares

    Please verify your input data. If FMV are different, you only need to change these figures and the current yield, highlighted in ORANGE, ...

    Solution Summary

    The current yield on the equities portfolio are analyzed.