Find Jobs
Hire Freelancers

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

$10-30 CAD

Cerrado
Publicado hace más de 5 años

$10-30 CAD

Pagado a la entrega
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.
ID del proyecto: 17557160

Información sobre el proyecto

6 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
6 freelancers están ofertando un promedio de $24 CAD por este trabajo
Avatar del usuario
"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 en 1 día
4,9 (263 comentarios)
7,0
7,0
Avatar del usuario
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 en 1 día
5,0 (215 comentarios)
6,9
6,9
Avatar del usuario
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 en 1 día
4,9 (50 comentarios)
6,5
6,5
Avatar del usuario
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 en 1 día
4,9 (56 comentarios)
5,8
5,8
Avatar del usuario
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 en 1 día
4,7 (102 comentarios)
6,2
6,2
Avatar del usuario
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 en 1 día
4,5 (25 comentarios)
3,9
3,9

Sobre este cliente

Bandera de CANADA
Canada
0,0
0
Miembro desde ago 12, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.