Hi guys,
I have a problem I can't really figure out, and I am turning to you for guidance, help, and a solution.
The table I have and the Value column is the desired output.
Company name | Round | Round type | Investment | Shares issued from existing convertible instrument | Price per share | Has shares converted | Date of Conversion | Value |
x | 1 | Convertible | 100 000 | Yes | 11/10/2022 | 100k | ||
x | 2 | Convertible | 100 000 | Yes | 11/10/2022 | 100k + 100k | ||
x | 3 | Convertible | 100 000 | Yes | 11/10/2022 | 100k + 100k + 100k | ||
x | 4 | Equity | 200 000 | 30 000 | 3 | 200 k*3 | ||
x | 5 | Convertible | 100 000 | Yes | 14/10/2022 | 200k*3 +100k | ||
x | 6 | Convertible | 100 000 |
| Yes | 14/10/2022 | 200k*3+100k+100k | |
x | 7 | Equity | 100 000 | 20 000 | 2 |
| 20k*2+30k*3 | |
y | 1 | Convertible | 100 000 |
| No | 100k | ||
y | 2 | Convertible | 100 000 |
| No | 100k+100k |