クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

MD&A Cash Flow Flux Formula

0

コメント

1件のコメント

  • Michael Baranowski

    We have 2 columns, one for the "decrease" and "increase" language, one for the actual dollar change.  The formula in our dollar change column is pretty simple (CY less PY).  A sample of formula from the language column looks like this:

    =IF(E8="[X]","[X]",IF(OR(ABS(E8)=ABS(G8),E8*G8<0),"[ERROR]",IF(ABS(E8)>ABS(G8),"an increase","a decrease")))

    Where in this example:

    - E8 is the current year value,

    - G8 is the prior year value, and

    - "[X]" is our initial roll-forward condition for all CY values before we fill in actuals.

    If you wanted to use different terminology, you could always replace the "an increase" and "a decrease" language with something like "provided by" and "used in", but make sure to tailor those to each line (our increase/decrease discussion is pretty generic).  In other words, if you are interested in this formula, make sure to review for your own situation and test it with inputs specific to your setup.

    I hope this helps - happy formula writing!

    1

サインインしてコメントを残してください。