investment | My Fiddling with Investment Strategies and tools | Portfolio library

I have 4 arrays of data where I need a some product but with few conditions.

I'm unable to solve that and I'm not good at creating VBA functions as well.

Can anyone please help?

Apologies for the lack of clarity.

I'll try to give more details here. Please refer the below workbook.

https://drive.google.com/file/d/1XVEe4Sjw6ZeAh-7jyeLDs7Tp5RRQD20i/view?usp=sharing

Investment value is Row 2 * Row 3. This value is carried across all the months after amortization given in row 4. 5th row is converting the yearly value into monthly value (1/12).

So, in the first month 50 is invested and the value at the beginning of the month after amort of 100%, So 50 is available for month 1. This is further converted into monthly values with the help of row 5. So, the result for month 1 will be 100 * 50% * 100% * 8.33% = 4.1667 [Cell I9]

For the month 2, the value available is,

Value carried from month 1 after amort (100 * 50% * 99%) + New amount in month 2 (102 * 50% * 100%)

The above value is converted into the monthly value again with the help of row 5.

Result for month 2 => Cell I10 = (100 * 50% * 99% * 8.33%) + (102 * 50% * 100% * 8.33%) = 8.375

Similarly, for month 3 the value will be,

Month 1's investment (100*50%*98%*8.33%) + Month 2's investment (102*50%*99%*8.33%) + Month 3's investment (104*50%*100%*8.33%)

I need the above calculation to happen in single cell for all the months. I tried sumproduct with offset. But I couldn't.

I am working on a project in R. I created a data frame for the table of all projects implemented by an Institutions. The data frame table includes a Country column with a name of the country in which the project is implemented

looks something like this with more than 20,000 rows

Currently doing a project for a course in C++, where I need to make a table of a deposited amount, interest earned on the amount, and total interest earned increased by each year.

I'm not getting the output I'm looking for. It just gives me the same output for each year. I am sure my problem lies in my for loop statements, but I need a fresh set of unbiased eyes as I am new to this. first is .cpp

I am getting the error

1. I am seeking to understand why my code doesn't work, please explain the logic behind my algorithm being flawed.

2. why on the solution code the nested-if statement knows to continue adding from the loss on day 7 on without specifing to add the investment amount.

You put 1000 dollars into a new cryptocurrency. Good luck!
Over ten years, the value of the investment increases by 5% each year.
In the seventh year, the investment loses 75% instead of increasing. Eeek!
Use a for loop to log how many years it has been and how much the investment is worth for each year.

let investment = 1000;

/// MY SOLUTION ///

I'm trying to map trough my context in React but it won't render anything. (No error messages either). My app is wrapped with the context provider.

My context

I want to get a list of values updated whenever its value is changed through a hook setState function, however I am getting an error I don't know why... I am getting a .map is not a function TypeError

Down bellow is my code and I also have a codesandbox link: https://codesandbox.io/s/fervent-satoshi-zjbpg?file=/src/Incomes.js:23-1551

I have two dataframes (growth and investment) that I have split using the group_split() function into 40 dataframes (split per COROP region in the Netherlands). My aim is to merge the split dataframes for each COROP, which can be done using the following code:

I have three Groups - CAPITAL, FIXED ASSET & CURRENT ASSET (pink color), If the row has another row under it, then it will become a parent(orange color).

When I add a new row (level 1) at the bottom of the group, it will sum the value to the parent and group. But actually it should only sum to the group as it is in level 1 and it has no child under it.

The X meaning the amount should not appear at the row. It should not sum to the parent as it is not the child of the parent. How do I make the level 1 always sum to the group only?