| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | Amount | Cash flow | Date | Cash flow | Date | Cash flow | Date | Cash flow | Date |
2 | 12-Apr-2024 | $250.00 | -$250.00 | 12-Apr-24 | -$2,083.76 | 28-Jun-2024 | -$100.00 | 4-Jul-2025 | -$2,547.32 | 7-Aug-2026 |
3 | 16-Apr-2024 | $1,750.00 | -$1,750.00 | 16-Apr-24 | -$1,500.00 | 30-Jul-2024 | -$1,343.65 | 12-Sep-2025 | -$2,670.15 | 31-Aug-2026 |
4 | 7-May-2024 | $500.00 | -$500.00 | 7-May-24 | -$2,317.82 | 3-Sep-2024 | -$1,907.77 | 1-Oct-2025 | $5,174.54 | 14-Oct-2026 |
5 | 14-May-2024 | $500.00 | -$500.00 | 14-May-24 | -$550.35 | 1-Oct-2024 | -$1,228.76 | 2-Dec-2025 | XIRR() | -5.27% |
6 | 15-May-2024 | $500.00 | -$500.00 | 15-May-24 | -$1,662.03 | 1-Nov-2024 | -$3,149.35 | 2-Jan-2026 | Investment 4 | $5,217.47 |
7 | 24-Jun-2024 | -$3,500.00 | $3,579.79 | 24-Jun-24 | -$1,493.14 | 29-Nov-2024 | -$2,835.66 | 9-Feb-2026 | Return 4 | $5,174.54 |
8 | 28-Jun-2024 | $2,000.00 | XIRR() | 15.19% | -$791.24 | 7-Jan-2025 | -$2,873.11 | 2-March-2026 | Profit 4 | -$42.93 |
9 | 30-Jul-2024 | $1,500.00 | Investment 1 | $3,500.00 | -$752.90 | 4-Feb-2025 | -$1,011.53 | 7-Apr-2026 | Return on Investment (ROI) 4 | -0.82% |
10 | 3-Sep-24 | $2,317.82 | Return 1 | $3,579.79 | -$5,000.00 | 5-May-2025 | -$1,809.60 | 4-May-2026 | Days | 68 |
11 | 1-Oct-24 | $550.35 | Profit 1 | $79.79 | $16,908.72 | 2-Jul-25 | $16,887.71 | 23-Jun-2026 | Weight | 7.87% |
12 | 1-Nov-24 | $1,662.03 | Return on Investment (ROI) 1 | 2.28% | XIRR() | 8.23% | XIRR() | 9.05% | INVESTMENT 4 | INVESTMENT 4 |
13 | 29-Nov-2024 | $1,493.14 | Days | 73 | Investment 2 | $16,151.24 | Investment 3 | $16,259.43 | ||
14 | 7-Jan-2025 | $791.24 | Weight | 8.45% | Return 2 | $16,908.72 | Return 3 | $16,887.71 | ||
15 | 4-Feb-2025 | $752.90 | INVESTMENT 1 | INVESTMENT 1 | Profit 2 | $757.48 | Profit 3 | $628.28 | ||
16 | 5-May-2025 | $5,000.00 | Return on Investment (ROI) 2 | 4.69% | Return on Investment (ROI) 3 | 3.86% | ||||
17 | 2-Jul-25 | -$16,908.72 | Mutual Funds Final XIRR() | 8.20% | Days | 369 | Days | 354 | ||
18 | 4-Jul-2025 | $100.00 | Mutual Funds Total Investments | $41,128.14 | Weight | 42.71% | Weight | 40.97% | ||
19 | 12-Sep-2025 | $1,343.65 | Total profit | $1,422.62 | INVESTMENT 2 | INVESTMENT 2 | INVESTMENT 3 | INVESTMENT 3 | ||
20 | 1-Oct-2025 | $1,907.77 | Total profit per day | $1.65 | ||||||
21 | 2-Dec-2025 | $1,228.76 | Days | 864 | ||||||
22 | 2-Jan-2026 | $3,149.35 | ||||||||
23 | 9-Feb-2026 | $2,835.66 | ||||||||
24 | 2-March-2026 | $2,873.11 | ||||||||
25 | 7-Apr-2026 | $1,011.53 | ||||||||
26 | 4-May-2026 | $1,809.60 | ||||||||
27 | 23-Jun-2026 | -$16,887.71 | ||||||||
28 | 7-Aug-2026 | $2,547.32 | ||||||||
29 | 31-Aug-2026 | $2,670.15 | ||||||||
30 | 14-Oct-2026 | -$5,174.54 |