rate of return

  1. jayad

    Rate of Return on Stock purchased on one date and sold on another

    Hello Is there an easy formula to compute the rate of return of a stock purchased on one date and sold on another? For example BUYDATE SELLDATE HOLD DAYS SYMBOL #shares BOUGHT FOR SOLD FOR 3-Jun 15-Jun 12 ABC 100 1,460.0000 1,565.4900 3-Jun 15-Jun 12 DEF 99 1,534.0000 1,718.6400...
    • jayad
    • Thread
    • rate of return return on stock purchase
    • Replies: 11
    • Forum: Excel Questions
  2. J

    Computing benchmark return daily

    Hi, I'm trying to calculate a 1 month benchmark return for an investment portfolio. I've encountered an issue where by using the daily index rate of return to compute a 1 month rate of return and multiplying that by the allocation does not give me the same result as calculating each days index...
  3. J

    Apparent discrepancy between FV and XIRR results

    I use the XIRR function / formula a lot when I research stocks and mutual funds to get a feel for how the investments are doing over time. I don't just accept the printed return; I do my own research. I don't use the FV function a lot, but today as I was looking at the difference in the...
  4. L

    MIRR results increase then decrease with constant cash flows the longer the life

    I have been preparing business plans recently using the MIRR formula in Excel 2007. The results of the MIRR function will increase initially then begin to decrease as time continues. We use the assumption of an initial investment(no other investments going forward) and while the cash flows are...
  5. G

    Coefficient of Variance in Excel

    Hello, I am trying to figure out how to calculate the coefficient of variation in excel but cant figure it out. Any help would be appreciated. Stocks Expected Return Probability of Occurring -20% .20 -10% .25 25%...
    • gahooja
    • Thread
    • coefficient of variation expected return rate of return standard deviation
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top