| A | B | C | D | |
|---|---|---|---|---|
1 | Date | Amount | Cash flow | Date |
2 | 7-Jan-2025 | $55.00 | -$55.00 | 7-Jan-25 |
3 | 1-Jul-2025 | -$50.14 | 50.14 | 1-Jul-25 |
4 | XIRR() | -17.55% | ||
5 | Investment 1 | $55.00 | ||
6 | Return 1 | $50.14 | ||
7 | Profit 1 | -$4.86 | ||
8 | Return on Investment (ROI) 1 | -8.84% | ||
9 | Days | 175 | ||
10 | Weight | 100 | ||
11 | INVESTMENT 1 | INVESTMENT 1 | ||
12 | ||||
13 | PFE Final XIRR() | -17.55% | ||
14 | PFE Total Investments | $55.00 | ||
15 | PFE Total Return | $50.14 | ||
16 | PFE Total profit | -$4.86 | ||
17 | PFE Return on Investment (ROI) | -8.84% | ||
18 | Days | 175 | ||
19 | Weight | 20.47% |