- Transactions: Add each transaction with date and amount. Use negative for investments (outflow) and positive for redemptions / current value (inflow).
ఉదా: -50,000 (investment), +1,60,000 (current value) - Add a final row for current value: If you hold the fund today, add today’s date with current market value as a positive amount so XIRR is calculated correctly.
- Click “Calculate”: Results you will see —
• Total Invested (sum of negative amounts)
• Final / Current Value (last positive amount)
• Absolute Return (Final − Invested)
• XIRR (annualized return for irregular cashflows)
• CAGR (shown when there is a single initial investment and single final value) - Use “Sample” to try: Add sample transactions to see how the calculator behaves, then replace with your real cash flows.
- Export / Share: You can export transactions as CSV or download the results as JSON; use Copy to share quickly on WhatsApp or email.
Tip: XIRR works best when you include all cashflows with correct dates. If you only have a single initial investment and a single redemption/current value, CAGR will be shown and is easier to interpret.
Quick Tips — చిట్కాలు
Accuracy: Dates must be correct — XIRR is date-sensitive.
Multiple purchases: Add each SIP or lump-sum separately for precise XIRR.
Final value: For ongoing holdings add current NAV × units as a positive amount.
One-liner to show above calculator:
“Add all transactions (negatives for investments, positives for redemptions/current value) → Click Calculate to see XIRR, CAGR & returns.”
Shareable line (WhatsApp):
“MF Return Calculator: Add dated cash flows (investments as –ve, current value as +ve) — get XIRR (annualised), CAGR & absolute return. (Estimates only)”