Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate

Поделиться
HTML-код
  • Опубликовано: 3 дек 2024

Комментарии • 6

  • @alexxgalindo8557
    @alexxgalindo8557 2 месяца назад +1

    Wow this lesson was gold. I didn't know anything about that. Thank you sir for this amazing class

    • @excelisfun
      @excelisfun  2 месяца назад

      Yup! This is a important one : )

  • @Clifffffffffford
    @Clifffffffffford 6 лет назад

    Thanks !

  • @ishwetajain
    @ishwetajain 10 лет назад

    Hey Ur Vidoes are awesomme. I always want to learn all these. U r a great Teacher !!
    The only Thing is i m not able to search and download BUSN 233 excel sheet.. its nowhere in the link..PLease help for this

  • @resulabbasov3727
    @resulabbasov3727 3 года назад

    How about if the loan is 2 years and compounded 12 months? what is EAR? and how to calculate it? Is it just the same with the calculation of 1 year EAR and then do we have to multiply it with the number of years?. Such as EAR=0.195618 as in the lecture and should we write it as 2 * EAR=2 * 0.195618= 0.391236343 ?

    • @tech4028
      @tech4028 3 года назад

      i = 10% (for instance)
      n = 12 (monthly)
      x = 2 (years)
      nper = 12*2 = 24
      EAR = (1+0.1/24)^24-1 = 10.49 %