lucky_5008
New Member
- Joined
- Sep 17, 2020
- Messages
- 4
- Office Version
- 2010
- Platform
- Windows
I am working in an financial institution. I have given yearly targets for "Average Deposits" and my company share daily progress in which they show me my progress.
Please tell such formula in which I can calculate figures.
Example.
I have Target for year to maintain average deposits $500 Million at year end.
Today I received my progress in which averages deposits was $300 M & Yesterday It was $310 M. It changes on daily basis.
I want to calculate that How much deposit is required to achieve my target of "averages"?
I have the following data:
Date:
Total Deposit:
Total Average till that specific date:
Year End Target of averages:
Please tell such formula in which I can calculate figures.
Example.
I have Target for year to maintain average deposits $500 Million at year end.
Today I received my progress in which averages deposits was $300 M & Yesterday It was $310 M. It changes on daily basis.
I want to calculate that How much deposit is required to achieve my target of "averages"?
I have the following data:
Date:
Total Deposit:
Total Average till that specific date:
Year End Target of averages: