Excel Format For Budget Purpose

sash789
Hi,
This is my first post.
I am in budgeting department and responsible for preparing budgets for the organisation.It is an investment banking company.
We are using excel to prepare the budget.
I am facing problems in preparing the income side. difficulty in calculating the closing valie of a fund. I ma attaching the current format used.
Can somebody improvise the same and give me a better format.
Please help me with this.:?:
An improvisation is needed.
If anybody is using a better format, it is welcome.
Thanks and regards,
sash789
Yes i know I tried twice but i did not succeed.
But if can give me some inputs regards the format(excel)
we are showing as:
opening balance
+ additions
-redemptions
-------------
Closing balance
Average capital
Gross Investment returns(calculated on the basis of the avg capital)
Dividend Income
Realized, Unrealized Income/(Loss)
This is done on a quarterly basis.
Please can you assist me in this. if you have a better way to show this in excel please guide me and add the sheet showing the calculation:confused:
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute