# equity

1. ### LARGE IF OR question

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...
2. ### dictionary question

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...
3. ### SUMPRODUCT error when blank cell

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
4. ### Predicting an IRR

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...
5. ### Predicting an IRR

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...
6. ### SUMIF - - but I need more ...

<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...
7. ### VBA How to extract specific values from pivot table

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...
8. ### Sum cells of each row in a selected range

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...
9. ### Format Formula to not change in Table

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...
10. ### Presenting a Financial Statement

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

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...
12. ### Excel Template for Equity Stock

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