equity

Hello, Currently I have the following formula which works great: {=LARGE(IF($Z$1:$Z$10000="EQUITY",$AA$1:$AA$10000),J23)} If I then wanted to include other candidates for large, with different text values than "EQUITY", all in column Z, how would I expand the above to include these?. Been...

Hi, is it possible two have two keys for each value? Here's the problem I'm facing with. I have some balance sheets for different people with different dates in different worksheets and files. I want to extract certain data such as the numbers of equity or debt from balance sheet, and rearrange...

Hi all, Hopefully an easy one. =SUMPRODUCT(($C:$C="Equity")*($E:$E)*(B:$B)) Essentially want to multiply and sum Column E and B together if C = "Equity" Columns E and B contain empty cells, which appears to be the root of the problem. Any ideas? Thanks, John

I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...

I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...

<colgroup><col><col><col><col><col><col></colgroup><tbody> Calc Type ExpRatio Holding% FundCost Mixed $36,233 equity 0.69% 9.35% $250 $29,026 mixed 0.60% 7.49% $174 0.38 $41,933 fixed 0.97% 10.82% $407 $32,045 equity 0.77% 8.27% $247 $9,934 mixed 0.63% 2.56% $63 0.51 $8,761 equity...

Hello, I am starting to learn how to extract data from pivot tables. However, I have found some easy examples online but unfortunately I have a complex pivot table that constantly changes of number of rows and columns due to the month and year periods changing. Thus, I need to extract specific...

Hi guys, I wanna sum the cells of each row in "Rentabilité 2" range and have the result in the column right next to it. Here's the code i made so far, i managed to select the range under "Rentabilité 2", but don't know how to sum each row, do i need a for loop? Sub sum() Dim lngLastRow...

Hello I am having a problem with what appears to be a type of Absolute vs. Relative references - but I am not too sure. Using Excel 2016 I have created two tables. Table 2 is a Summary of Table 1. Table 1: <tbody> A B C D 1 Fiscal Period 2006 2007 2008 2 Book Value 1.668 2.380 3.596...

Anyone have suggestions on which formulas to use / how to do a presentation of a Statement of Changes in Equity on Microsoft Excel?

I am looking for help with the following: Assume this example: Internal Rate of Return $-5,000, $2,000,$2,000,$2,000,$2,000,$2,000 using =IRR(above sequence) I get an IRR =29% What I am hoping for is to use "Solver / or a formula" to achieve the following. I would like to find out what % to be...

Hi, I am looking out for some good excel template, which can help me to keep track of my equity investments. Thanks a lot in advance Vijay