Açık

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

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.

Beceriler: Excel

Daha fazlasını gör: conditional xirr, xirr multiple ranges, xirr non contiguous cells, xirr formula math, xirr starting with zero, calculate xirr, excel xirr dynamic range, xirr ignore blanks, how can i create a website for free, how can i create a website, how can i create my facebook page that people can join or sign up, how can i create my own logo, how can i create website, tipa how i answer of home based online data encoder, how can i create a company logo, how can i create a freelance account when am still in university or college, how can i create a logo, how can i create a logo on my own, how i create a logo, how i create a website

İşveren Hakkında:
( 0 değerlendirme ) Canada

Proje NO: #17557160

Bu iş için 6 freelancer ortalamada $22 teklif veriyor

ksriniravi

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 immediat Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(148 Değerlendirme)
6.6
Tanmoy236

"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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(132 Değerlendirme)
6.3
The24CarrotsInc

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(53 Değerlendirme)
5.7
daniyal3214

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(33 Değerlendirme)
5.1
Baderah

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(4 Değerlendirme)
1.7
evanfot

This task can be accomplished in a single cell with an array formula. I have created a formula in your sample sheet that works (I verified the result manually)

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(0 Değerlendirme)
0.0