Stock Analysis Model – CVX –

Stock Analysis Model – CVX –

  • Excel assignment; Use the last ten years’ monthly returns (continuously compounded) on CVX stock to do the following:

    1. Compute the average monthly return.
    2. Compute the percentage of up-months.
    3. Using the average monthly return for the percent up and percent down and the percent of up-months as the probability of moving up, construct a binomial tree for four periods with the stock price at each node. Start with the recent price of CVX. You should have five possible outcomes. What is the probability of achieving the middle outcome?


0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *