Find Jobs
Hire Freelancers

Analyze some Data

£20-250 GBP

In Progress
Posted about 9 years ago

£20-250 GBP

Paid on delivery
I am trying to calculate the interest due to some regular monthly investments. I have a spreadsheet (see sample attached) that lists the payments received into the account. However, they are for differing volumes and amounts. I need each column totalled and then the interest attributable to them calculated. The problem i have is calculating the totals received for each group. On the example I have provided some examples. The actual file has around 600 groups that need calculated. One the example, the following values are: £900 - total received per investor £5,000,000 - total received to bank 0.018% - investors share of total bank received (900/5000000) £100 - total interest received on bank account £0.0180 - interest attributable to that investor So, I need to know the 'interest attributable' to each client, Ideally it will need to be presented in a better format that my example
Project ID: 7087166

About the project

28 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
28 freelancers are bidding on average £107 GBP for this job
User Avatar
Hello! I'm an Excel expert and an economist as well. Please check my profile and contact me to discuss further details. Regards.
£50 GBP in 1 day
5.0 (502 reviews)
8.0
8.0
User Avatar
Hello Sir / Madam, I had previous experience in Excel * Web Search * Web Scraping * Word * PDF & so on. Please consider my bid. Thank you.
£40 GBP in 4 days
5.0 (145 reviews)
6.9
6.9
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
4.9 (171 reviews)
6.5
6.5
User Avatar
I am expert of this kind of work, I checked your file and ready to finish this for you in 1 hour from accepting my bid. Looking forward to receive your reply Regards Peter
£23 GBP in 1 day
5.0 (7 reviews)
6.0
6.0
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
£100 GBP in 3 days
4.9 (18 reviews)
5.7
5.7
User Avatar
A proposal has not yet been provided
£100 GBP in 3 days
4.6 (16 reviews)
5.0
5.0
User Avatar
Hi, I've worked in finance and I am an expert with Excel. I have also worked with reporting (living in London for 10 years) Please send me a message and we can start working on your project Regards Morris
£100 GBP in 3 days
4.8 (6 reviews)
3.5
3.5
User Avatar
Hi, i have tried your sample and get the following results: Investor - Interest Due 1005 - £ .0180 10068 - £ .0171 1008 - £ .0300 10194 - £ .0612 1042 - £ .1080 I hope you can consider my bid. I can get the total investment and interest due for the 600 accounts within the day for £30 or lower. I can provide you a summary sheet of share and interest per investor with nice format. Please message me to discuss further details. I can also send you screen shot of the sample if you would like. Thank you very much.
£30 GBP in 0 day
4.9 (6 reviews)
2.8
2.8
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
4.8 (2 reviews)
2.4
2.4
User Avatar
Hello, I am already for multiple clients on Data Entry. I have already worked for multiple clients on Data Entry and Excel Related Projects. Data Entry is my passion; I have more than 3 years of experience in this area and can do this task in the best way using my Data Entry Skills and experience. I am looking for long term relation with you; I can deliver it on time and can assure 100% satisfaction in this task. Please hire me now and then I can start the work now itself.
£192 GBP in 20 days
5.0 (1 review)
1.0
1.0
User Avatar
I have created a sample EXCEL output of what you might need. Just figuring out how to send it to you to check whether it is what you expected.
£150 GBP in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
La propuesta todavía no ha sido proveída
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are having great experience of working on Data Entry, Web Research, Virtual Assistant, Project Management, Data Management, Ms-office, admin support jobs. Every job I handle whether a small task or a large project with accuracy and time frames.
£55 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am on the verge of being a chartered accountant and this falls under my expertise of work..will be able to deliver the project within the agreed time frame while adhering to requisite quality standards
£50 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Propunerea nu a fost încă furnizată
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I work on Excel on a Regular Basis, i check your attachment and it seem to be one of the simplest work have ever seen, the excel fine can be well modified to look better than that, Please consider discussing further with me on this, will be glad to do this for you and get paid i could really you some cash right now...Thanks Am open to your offers of payment.
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a financial analyst by profession so I look into such data on daily basis. In case, you like my offer, get in touch with me so we can discuss the terms. Open to negotiate.
£29 GBP in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
I have some experience working on data entry and data processing projects. I am also good with Microsoft office and am familiar with Excel spreadsheets. I have worked on spreadsheets in the past and are familiar with the cell formulas required. If given an opportunity, I will do a good job and you will like my work.
£166 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Pretty good at excel. Knows most of it and have worked a lot on it. Be assured of the results and am sure you would like my work.
£150 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do it in a day after your confirmation. I can handle it in pivot table or in the same sheet as think easy.
£20 GBP in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Bolton, United Kingdom
5.0
4
Payment method verified
Member since Apr 25, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.