Idle Funds Aging

Hello all, can someone help me understand how am I able to find the aging for idle funds. For example, if my opening balance for first day is 10 no debit but credited 5 so closing balance is 5. Now next day opening balance is 5 debit again zero but credit 3 so closing balance is 2 , next day closing balance is 2 and so on. Now I want to find out how much days it took for the first day amount of 10 to be invested. Attached is the sample for the same. Please help.

Idle_ fund_sample.xlsx

Datasets

Help

Predictive Analysis

Accepted answers

All comments

mceleavey

Hi @Vapour02 ,

what do you mean "invested"?

Relate it to the data and columns you have provided.

Do you mean debited? So in your example data, your first line start with 0 then gets 10 credited, so how many rows until the debits add up to ten?

Vapour02

Hi @mceleavey , sorry for the confusion. Yes invested as in debited. So if I have a 10 as opening balance it should be debited next day. If not how much days it took to debit the amount 10 is what I'm looking for. Also even if a new amount is credited next day. I need to know first how much days it took for 10 to be debited completely and then move to the next credited amount.

Vapour02

mceleavey

@Vapour02 ,

A good place to start with Iterative Macros is HERE.

Hope this helps,

Vapour02

Thank you! I'll give this a try.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335