Find Jobs
Hire Freelancers

How do I create an XIRR function based on unique names and between certain dates?

$10-30 CAD

Closed
Posted over 5 years ago

$10-30 CAD

Paid on delivery
I'm trying to create an XIRR function that will calculate the return based on an unique investment names and corresponding cash flows between certain dates. For example, I want to calculate the IRR for Investment A between 01/16/2018 to 5/20/2018 with the following cash flows: Investments Dates Amounts A 01/15/18 ($55) B 01/18/18 ($20) B 01/19/18 $9 B 04/06/18 $6 A 04/08/18 $24 A 05/20/18 $40 B 05/21/18 $7 A 05/23/18 ($5) Start 01/16/18 End 05/20/18 The challenge I am having is skipping past the Investment B cash flows and only calculating Investment A. This is a simplified version of what I’m trying to do. The full version has about 50 investment names spread over about 1000 rows. Any suggestions would help. I’ve tried using fncs INDEX, MATCH, OFFSET, COUNTIF.
Project ID: 17557160

About the project

6 proposals
Remote project
Active 6 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
6 freelancers are bidding on average $24 CAD for this job
User Avatar
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$40 CAD in 1 day
4.9 (263 reviews)
7.0
7.0
User Avatar
Greetings! I have worked on the requirements and now have a working formula that does return XIRR for specific investment. The formula is a bit complex. If you can award the project, I can share the formula immediately. Have a Great Day! Srinivasan
$20 CAD in 1 day
5.0 (215 reviews)
6.9
6.9
User Avatar
Hello, Both are your formulas are correct. Just sort your Table A:C by the first column (column "A" - "Investments"). Best regards, Duong
$25 CAD in 1 day
4.9 (50 reviews)
6.5
6.5
User Avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable
$25 CAD in 1 day
4.9 (56 reviews)
5.8
5.8
User Avatar
I am a professional Financial Analyst and Excel expert and can easily help you in creating that functions with different parameters and criteria. I will be happy to discuss in detail.
$25 CAD in 1 day
4.7 (102 reviews)
6.2
6.2
User Avatar
Being a n investment banker, making presentation and financial models are central to our professional life. Therefore, I am advance user of MS Excel and Ms Power point. For more details kindly contact me
$10 CAD in 1 day
4.5 (25 reviews)
3.9
3.9

About the client

Flag of CANADA
Canada
0.0
0
Member since Aug 12, 2018

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)
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.