Skip to main content

I am trying to build a metric to forecast interest income on corporate cash. To do so, I’d like to reference our forecasted cash balance from the balance sheet & cash flow statement. This becomes circular since our interest income rolls into net income which then drives our indirect cash flow statement.

 

I believe I could accomplish it by using the previousbase() function but the various metrics are all across different applications. The interest income & revenue metrics sits in a revenue application that feeds into a nexus in the data hub which then feeds the cash flow statement in a financial reporting application.

 

Does anyone know a way to create this metric given the above criteria?

I think this may be challenging without seeing the exact metrics and calculation but here are some thoughts on how I’ve solved similar issues in the past.
Metric to Metric copy → you could copy Interest Income and Revenue from a “live” metric to a “static” metric so it’s not truly circular anymore.
Repeat calculation → repeat the calculation back to source in various places, so everything sources Cash directly from Cash Flow and the Indirect Cash Flow will not reference Net Income but rather the recalcualtion of Net Income (and rather than adding Interest Income to this it would add Interest Income as Cash * 😵.

Either way - pull all the results into a single application first (Revenue) using Pull metrics (ie. Pull_CashFlow, Pull_Revenue). Having all the pieces in a single application helps. 

I hope this helps get you started. If you have further details you’d like to share let me know.

Reply


Ask your question here!

Terms & ConditionsCookie settings