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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back