Do some advanced Excel Work for a Financial Spreadsheet
$8-15 AUD / hour
Closed
Posted over 8 years ago
$8-15 AUD / hour
I have a sophisticated Excel Spreadsheet that is used in the Australian Financial Advice industry. It is used for research and analysis on a couples financial situation and allows for recommendations off the back of the analyisis.
One of the next features to add on is the ability to hold a database of managed funds/investments. Each fund would have detail of its fees (ICR and MER), asset allocation, buy/sell spread, and potentially performance figures.
We would expect to have a list of around 500 managed funds with all this detail.
There are a number of places that we will need to be able to select various managed funds, and the % that would go into each fund to produce a portfolio. The portfolio would then need the weighted total figures for each of the different variables.
Also, we would need a way to be able to analyse transaction fees for rebalancing a portfolio. ie it would need to work out the buy sell spread fees on the different rebalances.
This will make a lot more sense once I show you 2 spreadsheets that we have. However, given the size of the spreadsheet already - we need someone with the skills to make sure that it all works very efficiently and easily.
Lastly - I require someone who is very detail oriented and ensures that they then test their work and make sure that it works how it should. I don't want to have to test it all again after each edit to make sure that it works as intended.
Once Complete - there is a second project that will deal with financial projections over time. It would require quite a bit of work and will put you in good stead to get this job as well.
Hello, my name is Fitra Rahmamuliani.
I understand well about Excel Work for Financial Spreadsheet because I ever be a treasurer and now I study at Informatics Engineering (Computer Science).
Contact me more if you want to know me well.
I am looking for a position that would recognize my talent and provide me an opportunity to put in my best for the benefit of the company. I am an experienced Data Entry Operator and Data Processing Assistant and feel my skills will greatly benefit your jobs. I have also worked as a Email Handling and a Excel Specialist throughout my career. If hired by you I will put in my best work. I am ready to be hired by you and start work on your jobs.
My name is Samantha Fitzpatrick. I am interested in your offer regarding the Excel Work for your Financial Spreadsheet. I have worked in a Administrative role throughout my career and have experience in compiling excel spreadsheets concerning financial and sales figures. My attention to detail is brilliant and I take pride in my work done. I am currently at home during the day and will have the hours to complete the spreadsheet in the time of 1 - 4 weeks as recommended. My cost per hour is $10 AUD negotiable. Should you be interested in my proposal, you are more than welcome to contact me.
Kind regards,
Samantha Fitzpatrick
Im a computer Engineer,i love doing things related with the course i took.i love learning and improving my skills cause i know that it will be my stepping stone in achieving my goals in life.
Why i am a good choice for this project?
I did masters in mathematics (missed gold medal by a whisker)
Second masters in computer science.
Passionate about data mining.
Things i promise :
I like to keep things professional. If you take time to specify your requirements clearly. I will complete it without you having to say a word.
Pay me when you think you are satisfied
proficiency in excel spreadsheet will give me an advantage together with the good background knowledge of financial documents like cash flow statements, balance sheets and income statements
Hi,
I have worked with a global top 3 management consulting firm for over 5 years building complex excel models and data analytics. I have also worked with a top investment bank structuring equity and credit derivatives.
I have recently signed up with Freelancer and already been awarded a financial modeling project:
https://www.freelancer.com/projects/Excel/Financial-Modelling-Expert-Debt-8527852/
I have significant experience in building complex excel models and interactive tools and can do any given piece of work quickly and accurately.
I have taken a look at your requirement and I will be able to do build a robust and accurate model for you in the least amount of time.
Looking forward to a positive response.
Warm regards,
Anita
Based on the information you have provided it seems your project would be done via MS Access which would link your excel file as table and based on your requirement jet queries need to be designs which will give you required result and they result will be given in a separate excel or generated via reports. I am having experience of such kind of project where we have done the automation of demand supply reports and analysis of a MNc. I am having around 5 years of IT experience and I am new here ( freelancer) but I would lose to assure you that your work will be done with super quality and regression testing.
Please have a chat before finalizing the project. Looking positive to work with you.