Struggling with Budgeting in Excel? Need Help Calculating Fund Closing Values!

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.

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. 😕