Min and Max Functions for Modelling Revolving Credits

Поділитися
Вставка
  • Опубліковано 12 вер 2024

КОМЕНТАРІ • 9

  • @ogundelevictor6744
    @ogundelevictor6744 4 роки тому +3

    This is the best revolver explanation have seen.
    Well explained. Excellent

  • @kevinassang3158
    @kevinassang3158 Рік тому

    Very good, thanks

  • @teniola5536
    @teniola5536 4 роки тому

    This video was very helpful. But i am wondering why the borrowings didn't flow into the cash balances like the interest payments.

    • @high5tutorials135
      @high5tutorials135  4 роки тому +1

      Teniola, Thanks very much for watching and commenting. You observation correct and was an omission I must admit. That would have involved a circular reference issue but that can be tamed with interactions activated and an IF function to trap irreversible errors. Thanks very much.

  • @Justin508
    @Justin508 2 роки тому

    Very clear. Great explanation!
    Is the balance usually paid in full at the end of each year, or does it vary depending on the credit agreement? I’m building a LBO model and trying to determine how our borrowings are amortized, if at all. Any insight would be greatly appreciated.

    • @high5tutorials135
      @high5tutorials135  2 роки тому

      Thanks for the compliment. As you have rightly inferred, agreement defines the mode of payment. Usually, quarterly

  • @theatmp97
    @theatmp97 2 роки тому

    Shouldnt you include the effect of the tax shield?

  • @visheshgupta5948
    @visheshgupta5948 2 роки тому

    Can I get this file?