Calculate SIP returns
calculate_sip_returnsSimulate a monthly SIP in one Indian mutual fund scheme using its actual historical NAVs: each instalment buys units at the NAV on its due date (or the next NAV date after a holiday). Returns the number of instalments, total invested, units, current value, absolute gain and XIRR, plus a year-by-year summary. Supports an optional annual step-up. Use for 'what would my SIP be worth' questions. Ignores stamp duty, exit load and tax; can't project future returns.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_date | No | Valuation date (optional; defaults to the latest NAV date). No instalments after it in YYYY-MM-DD format | |
| start_date | Yes | Date of the first instalment; later instalments fall on the same day each month in YYYY-MM-DD format | |
| scheme_code | Yes | 6-digit AMFI scheme code, e.g. 122639 (from search_mutual_funds) | |
| monthly_amount | Yes | Monthly SIP amount in rupees, e.g. 10000 | |
| annual_step_up_pct | No | Optional yearly increase in the SIP amount, in percent (0 = flat SIP) |