Annualized Returns in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ต.ค. 2024
  • More videos at facpub.stjohns...

ความคิดเห็น • 3

  • @wirsyt
    @wirsyt 4 หลายเดือนก่อน +2

    Thank you Ronald. It will be a great help if you can perhaps maybe generalize this CAGR calculation for a more realistic scenario. With realistic scenario, I mean instead of buying a stock in just one shot, how can we calculate annualized return if we were buying chunks at regular intervals i.e. Dollar Cost Averaging). Also, is there a way to account for dividend income in this calculation?

  • @seatonluck5268
    @seatonluck5268 4 หลายเดือนก่อน

    Is this the formula used by finance/banker bros for exponential assets/gains? 353% annualized on my crypto acct seems a bit low and I need to borrow more @14%

  • @mm0dk0ur
    @mm0dk0ur 3 หลายเดือนก่อน

    Many thanks Ronald, can you please make a video showing the returns affected but adding cash and withdrawals from the account? Also for the above example is there a better way when for the same stock you have several purchases at different date ? Thanks