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

Get Empowered With Critical Leadership Skills That Drive Change →
Promoted: XLRI Leadership & Change Management
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

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →






About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server