Hi,
This is my first post.
I am in the budgeting department and responsible for preparing budgets for the organization. It is an investment banking company.
We are using Excel to prepare the budget.
I am facing problems in preparing the income side, especially difficulty in calculating the closing value of a fund. I am attaching the current format used.
Can somebody improve the same and give me a better format?
Please help me with this.
An improvement is needed.
If anybody is using a better format, it is welcome.
Thanks and regards.
From Kuwait, Kuwait
Acknowledge(0)
Amend(0)
This is my first post.
I am in the budgeting department and responsible for preparing budgets for the organization. It is an investment banking company.
We are using Excel to prepare the budget.
I am facing problems in preparing the income side, especially difficulty in calculating the closing value of a fund. I am attaching the current format used.
Can somebody improve the same and give me a better format?
Please help me with this.
An improvement is needed.
If anybody is using a better format, it is welcome.
Thanks and regards.
From Kuwait, Kuwait
Acknowledge(0)Amend(0)
Yes, I know I tried twice but I did not succeed. But if you can give me some inputs regarding the format (Excel), we are showing as:
Opening balance
+ Additions
- Redemptions
-------------
Closing balance
Average capital
Gross Investment returns (calculated on the basis of the average capital)
Dividend Income
Realized, Unrealized Income/(Loss)
This is done on a quarterly basis. Please, can you assist me with this? If you have a better way to show this in Excel, please guide me and add the sheet showing the calculation. 😕
From Kuwait, Kuwait
Acknowledge(0)Amend(0)
Opening balance
+ Additions
- Redemptions
-------------
Closing balance
Average capital
Gross Investment returns (calculated on the basis of the average capital)
Dividend Income
Realized, Unrealized Income/(Loss)
This is done on a quarterly basis. Please, can you assist me with this? If you have a better way to show this in Excel, please guide me and add the sheet showing the calculation. 😕
From Kuwait, Kuwait
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
All PF Forms in Excel Format.xls
10 ways to format Excel data.pdf