F
Frustrated
Hi,
I need to create either a spreadsheet or a database which will allow me to
calculate expenses allocated based on monthly asset size ratios ( ratios
changes monthly) and accross various funds and classes (sometimes just 3
funds and sometimes all 29 funds) amongst the various expense categories. I
currently doing these calculations via a really manual excel spreadsheet.
Say other 5 specific Fund incurred $5000 LEGAL fees, and the fee needs to be
allocated based on the assets within each fund as of a certain months ratios.
Any ideas on how (if possible) I could create this via Access?
I hope this makes sense. Any help would be greatly appreciated.
I need to create either a spreadsheet or a database which will allow me to
calculate expenses allocated based on monthly asset size ratios ( ratios
changes monthly) and accross various funds and classes (sometimes just 3
funds and sometimes all 29 funds) amongst the various expense categories. I
currently doing these calculations via a really manual excel spreadsheet.
Say other 5 specific Fund incurred $5000 LEGAL fees, and the fee needs to be
allocated based on the assets within each fund as of a certain months ratios.
Any ideas on how (if possible) I could create this via Access?
I hope this makes sense. Any help would be greatly appreciated.