| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Date | Amount | Cash flow | Date | Cash flow | Date | Cash flow | Date |
2 | 12-Nov-2024 | 148.82 | -148.82 | 12-Nov-24 | -146.22 | 19-Nov-2024 | -17169.99 | 24-Jul-2025 |
3 | 18-Nov-2024 | -138.36 | 138.36 | 18-Nov-24 | 153.47 | 1-Jul-2025 | -22154.33 | 20-Jul-2026 |
4 | 19-Nov-2024 | 146.22 | XIRR() | -0.988102184872905000000000000000 | XIRR() | 0.082054690367467800000000000000 | 46800.13 | 25-Sep-26 |
5 | 1-Jul-2025 | -153.47 | Investment 1 | 148.82 | Investment 2 | 146.22 | XIRR() | 0.308119009128737000000000000000 |
6 | 24-Jul-2025 | 17169.99 | Return 1 | 138.36 | Return 2 | 153.47 | Investment 3 | 39,324.32 |
7 | 20-July-2026 | 22154.33 | Profit 1 | -10.46 | Profit 2 | 7.25 | Return 3 | 46,800.13 |
8 | 25-Sep-26 | -46800.13 | ROI 1 | -7.03 | ROI 2 | 4.96 | Profit 3 | 7,475.81 |
9 | Yearly profit projection | -636.01 | Yearly profit projection | 11.81 | ROI 3 | 19.01 | ||
10 | Yearly performance projection | -427.38 | Yearly performance projection | 8.08 | Yearly profit projection | 6,375.40 | ||
11 | Days | 6 | Days | 224 | Yearly performance projection | 16.21 | ||
12 | Weight | 0.9118541033 | Weight | 34.04255319 | Days | 428 | ||
13 | INVESTMENT 1 | INVESTMENT 1 | INVESTMENT 2 | INVESTMENT 2 | Weight | 65.04559271 | ||
14 | INVESTMENT 3 | INVESTMENT 3 | ||||||
15 | Yearly performance average | 9.40% | ||||||
16 | Total profit | $7,472.61 | ||||||
17 | Total profit per day | $11.36 | ||||||
18 | XIRR() performance average | 0.219341297021542000000000000000 | ||||||
19 | Days | 658 | ||||||
20 | Weight | 78.89688249 |