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,
From Kuwait, Kuwait
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,
From Kuwait, Kuwait
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:
From Kuwait, Kuwait
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:
From Kuwait, Kuwait
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Form 9 (Excel Format).xls
10 ways to format Excel data.pdf