excel format for budget purpose

sash789 · #1 (**permalink**) 16-09-2008, 04:10 PM

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,

vini ram · #2 (**permalink**) 16-09-2008, 04:48 PM

Sorry,Friend..i cudn't find ur attachment..?

Regards,
vini

sash789 · #3 (**permalink**) 17-09-2008, 03:42 PM

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode