Find Jobs
Hire Freelancers

VBA Macro and Functions

$10-30 USD

Completed
Posted about 7 years ago

$10-30 USD

Paid on delivery
1) Create function, that calculates the IRR of a set of cash flows. It should not use the native IRR functions and if possible not the native NPV function. 2) I have a list of hard-coded figures with the average of a subset of them, but I don't know on what companies the average is based on. What I do know is that the average is taken from a set of adjacent companies within the list. I need a macro that lists the companies on which the average is based. If the Macro works in a range that is non-adjacent I would be more than happy, but that would only be a bonus which will be rewarded with a little extra.
Project ID: 13443778

About the project

18 proposals
Remote project
Active 7 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
Awarded to:
User Avatar
Dear Sir/Madam, I have 4 years experience in Excel VBA programming most of which I spent at a company called InvestorForce. I would need more details regarding your project. Could you please share the file that contains the data you are using? Regards, Balint Kolosi
$40 USD in 1 day
5.0 (127 reviews)
7.0
7.0
18 freelancers are bidding on average $47 USD for this job
User Avatar
A proposal has not yet been provided
$140 USD in 2 days
4.9 (366 reviews)
8.0
8.0
User Avatar
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last few MONTHS , I have spent at least 225 HOURS on automation in Excel every month. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Have a Great Weekend! Srinivasan Krishnamoorthi
$50 USD in 2 days
5.0 (220 reviews)
7.0
7.0
User Avatar
Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed Thanks in anticipation Looking forward for this projext positively U can also review my profile for my clients reviews of my excel skills
$20 USD in 0 day
5.0 (24 reviews)
4.3
4.3
User Avatar
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement. Over 10 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay
$30 USD in 1 day
4.8 (11 reviews)
4.2
4.2
User Avatar
i have a 5 years of VBA experience. I am also an Acca and Cfa level 3 candidate.. i understand all thr dynamics of this topic. looking for ur response
$29 USD in 1 day
5.0 (18 reviews)
3.8
3.8
User Avatar
Hi there, I'm an Excel expert with rich VBA / macro programming experiences. I can help you complete the job well. Feel free to contact me and discuss more details. Best Regards, VL
$30 USD in 1 day
4.9 (11 reviews)
3.7
3.7
User Avatar
I have five years of experience in vba macros development. I can complete your project in a day. Please award me the project.
$35 USD in 1 day
4.1 (7 reviews)
4.4
4.4
User Avatar
I define myself as a perfectionist. Who competes to beat his very own performance and then celebrates. This is something that brings me immense pleasure in the , I used to say, "I am a business student and intend to hold a degree in finance" but now I introduce myself as a blogger or as a writer because writing is something I find myself at ease where and love doing and aim to achieve folks, this is just the beginning and there is a lot more to come!
$25 USD in 1 day
4.7 (5 reviews)
2.5
2.5
User Avatar
Hello. I can help you with these functions you need. For the first function, the best approach will be to use a numerical method to compute the value of i, as it might be impossible to isolate i from the equation. For the second function it will be an iterative approach that will give you the closest value to the provided average. Adjacent or non adjacent values will be a parameter of the function that tou will be able to choose. Please do not hesitate to contact me so we can further discuss the details. Best regards.
$50 USD in 5 days
4.2 (3 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Duisburg, Germany
5.0
16
Payment method verified
Member since Oct 9, 2013

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.