| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Date | Amount | Total | Cash flow | Date | ||
2 | 7-Jan-2025 | 55.00 | 55.00 | -55.00 | 7-Jan-25 | ||
3 | 1-Jul-2025 | -50.14 | 4.86 | 50.14 | 1-Jul-25 | ||
4 | XIRR() | -0.175483367506643000000000000000 | |||||
5 | Investment 1 | 55.00 | |||||
6 | Return 1 | 50.14 | |||||
7 | Profit 1 | -4.86 | |||||
8 | ROI 1 | -8.84 | |||||
9 | Yearly profit projection | -10.14 | |||||
10 | Yearly performance projection | -18.43 | |||||
11 | Days | 175 | |||||
12 | Weight | 100 | |||||
13 | INVESTMENT 1 | INVESTMENT 1 | |||||
14 | |||||||
15 | Yearly performance average | -18.43% | |||||
16 | Total profit | -$4.86 | |||||
17 | Total profit per day | -$0.03 | |||||
18 | XIRR() performance average | -0.175483367506643000000000000000 | |||||
19 | Days | 175 | |||||
20 | Weight | 20.98321343 |