Period: November 1, 2025 -- April 30, 2026 (6 months)
**Entities:** Rahul Parmar (Individual) | Parmar HUF | Savita Thakur (Individual)Prepared: May 31, 2026
Data Sources: HDFC Bank Statements (3 accounts), Federal Bank/Jupiter Statement, CAMS/KFintech CAS, Zerodha Holdings, Manual Entries (PPF/EPF/SSY/SGB/Home Loan)
1. [Executive Summary](#1-executive-summary)
2. [Income Analysis](#2-income-analysis)
3. [Expense Analysis](#3-expense-analysis)
4. [Investment Summary](#4-investment-summary)
5. [Asset Allocation](#5-asset-allocation)
6. [SIP Discipline](#6-sip-discipline)
7. [Fund Quality & Overlap](#7-fund-quality--overlap)
8. [Tax Position](#8-tax-position)
9. [Net Worth Statement](#9-net-worth-statement)
10. [Cashflow Forecast](#10-cashflow-forecast)
11. [Monthly P&L](#11-monthly-pl)
12. [Risk Flags & Recommendations](#12-risk-flags--recommendations)
13. [Data Gaps](#13-data-gaps)
| Metric | Value |
|---|---|
| Household Net Worth (ex home) | Rs 2,11,05,359 |
| Household Net Worth (incl home ~65L) | Rs 2,76,05,359 |
| Liquid Net Worth | Rs 1,73,03,528 |
| Total Gross Assets | Rs 2,21,05,359 |
| Total Liabilities | Rs 10,00,000 |
| 6-Month Household Income | Rs 62,61,436 |
| Average Monthly Income | Rs 10,43,573 |
| 6-Month Household Expenses | Rs 12,89,121 |
| Average Monthly Expenses | Rs 2,14,854 |
| 6-Month Investments | Rs 33,83,991 |
| 6-Month Savings Rate | 79% |
| 6-Month Investment Rate (% of income) | 54% |
1. Strong savings discipline. 79% savings rate over 6 months, well above the 35% freelancer benchmark. Of Rs 62.6L income, Rs 49.7L was saved, with Rs 33.8L deployed into investments.
2. Net worth at Rs 2.11 Cr (ex home). Dominated by mutual funds (Rs 1.17 Cr, 53%) and retirement instruments (Rs 38L, 17%). Home equity adds approximately Rs 55L net (Rs 65L value minus Rs 10L loan).
3. Single income source risk. Deel payments constitute 97% of household income. March 2026 saw zero Deel payouts, causing the HUF bank balance to drop to Rs 6,215 -- a near-crisis.
4. Equity underweight. At 43.2% equity allocation, the household is 12-22 percentage points below the 55-65% benchmark for age 38. Even adding REITs (10.1%) brings it to only 53.3%.
5. Portfolio complexity. 22 unique mutual fund schemes across 40+ folios, 3 entities. Rs 24.5L sits in Regular plans (paying unnecessary distributor commissions). Six debt funds serve nearly identical purposes.
6. Tax liability overdue. HUF advance tax of Rs 8.80L and Savita's Rs 1.43L were due by March 15, 2026. Interest under Sec 234B/234C is accruing at 1% per month.
7. SIP mandate restructuring. Daily/weekly SIPs were consolidated into monthly installments starting March 2026, reducing transaction frequency while maintaining comparable investment amounts.
| Entity | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | **Total** |
|---|---|---|---|---|---|---|---|
| HUF | 9,67,782 | 2,95,872 | 6,08,438 | 5,99,106 | 0 | 17,36,152 | 42,07,351 |
| Rahul | 18,555 | 1,21,345 | 722 | 2,43,667 | 232 | 1,314 | 3,85,835 |
| Savita | 5,57,248 | 0 | 2,70,799 | 2,64,893 | 2,591 | 5,72,719 | 16,68,250 |
| Household | 15,43,585 | 4,17,217 | 8,79,959 | 11,07,666 | 2,823 | 23,10,185 | 62,61,436 |
| Source | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | **Total** | **% Share** |
|---|---|---|---|---|---|---|---|---|
| Deel (HUF) | 9,59,064 | 2,95,872 | 5,96,529 | 5,88,141 | 0 | 17,29,817 | 41,69,423 | 66.6% |
| Deel (Savita) | 5,57,248 | 0 | 2,69,080 | 2,64,893 | 0 | 5,71,119 | 16,62,340 | 26.6% |
| Tax Refund | 0 | 0 | 0 | 2,25,170 | 0 | 0 | 2,25,170 | 3.6% |
| MF Redemption | 0 | 1,20,991 | 0 | 0 | 0 | 0 | 1,20,991 | 1.9% |
| REIT Dividend | 27,040 | 0 | 0 | 29,457 | 0 | 0 | 56,497 | 0.9% |
| Bank Interest | 0 | 314 | 5,499 | 0 | 217 | 6,742 | 12,772 | 0.2% |
| Zerodha Payout | 233 | 0 | 8,852 | 0 | 0 | 2,508 | 11,592 | 0.2% |
| SGB Interest | 0 | 0 | 0 | 0 | 2,591 | 0 | 2,591 | 0.0% |
| Stock Dividend | 0 | 40 | 0 | 5 | 15 | 0 | 60 | 0.0% |
| TOTAL | 15,43,585 | 4,17,217 | 8,79,959 | 11,07,666 | 2,823 | 23,10,185 | 62,61,436 | 100% |
| Metric | Amount |
|---|---|
| Total Deel income (HUF + Savita), 6 months | Rs 58,31,763 |
| Average monthly Deel income | Rs 9,71,961 |
| REIT quarterly dividend (Rahul + HUF) | Rs 28,000 approx. |
| Bank/FD interest (annualized) | Rs 25,000 approx. |
| SGB interest (annualized, Savita) | Rs 5,200 approx. |
Deel = 93.1% of core recurring income. All other sources combined provide only Rs 58,000/year.
Income is highly variable month-to-month due to irregular Deel payment timing:
The March gap and April catch-up demonstrate the fundamental timing risk: Deel payment schedules are unpredictable, creating months where the household runs on reserves.
| Category | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | **TOTAL** | **% of Total** |
|---|---|---|---|---|---|---|---|---|
| Tech - AI | 44,882 | 26,484 | 36,426 | 25,691 | 19,109 | 50,793 | 2,03,386 | 15.8% |
| Education - Kids | 41,303 | - | - | - | 1,21,700 | - | 1,63,003 | 12.6% |
| Bills - Credit Card | 15,543 | 85,613 | 3,397 | 3,397 | 44,494 | - | 1,52,444 | 11.8% |
| Household - Services | 54,950 | 62,584 | 2,326 | 1,835 | 7,586 | - | 1,29,281 | 10.0% |
| Savings - Jupiter Pot | - | 65,970 | - | - | 52,731 | - | 1,18,702 | 9.2% |
| Cash Withdrawal | - | - | 6,000 | 10,000 | 45,000 | 40,000 | 1,01,000 | 7.8% |
| Family - Gifts | 5,001 | 4,001 | - | 15,000 | 45,125 | 29,310 | 98,437 | 7.6% |
| PayPal - Services | - | - | 5,410 | 91,903 | - | - | 97,313 | 7.5% |
| Medical | 7,524 | 3,686 | 2,624 | 2,564 | 8,327 | 15,694 | 40,419 | 3.1% |
| Insurance - Life | - | - | - | 22,774 | - | - | 22,774 | 1.8% |
| Food - Restaurant | 6,698 | 3,372 | 4,631 | 410 | 4,600 | 1,100 | 20,811 | 1.6% |
| Groceries | 2,745 | 3,065 | 4,232 | 4,293 | 795 | - | 15,130 | 1.2% |
| Loans - EMI | - | - | 15,000 | - | - | - | 15,000 | 1.2% |
| Tech - Freelancing | - | 3,947 | 7,369 | 1,722 | - | - | 13,037 | 1.0% |
| Personal - Misc | - | - | - | - | 10,000 | - | 10,000 | 0.8% |
| Household - Help | 6,420 | 1,450 | 230 | 1,070 | - | - | 9,170 | 0.7% |
| Transport - Travel | - | 514 | - | 755 | - | 7,343 | 8,612 | 0.7% |
| Tech - Professional | - | - | 3,780 | - | 3,780 | - | 7,559 | 0.6% |
| Bills - Telecom | - | 475 | 1,355 | 1,704 | 1,655 | 1,355 | 6,543 | 0.5% |
| Tech - Cloud | 1,021 | 1,020 | 1,090 | 1,217 | 1,020 | 1,020 | 6,386 | 0.5% |
| Shopping - Furniture | - | - | - | - | - | 6,300 | 6,300 | 0.5% |
| Household - Local Vendor | 1,385 | 1,078 | 2,591 | 235 | 50 | 409 | 5,748 | 0.4% |
| Shopping - Delivery | - | - | 2,565 | 2,799 | - | - | 5,364 | 0.4% |
| Tech - Hosting | - | 4,285 | - | - | - | 989 | 5,274 | 0.4% |
| Shopping - General | 50 | - | 1,600 | 2,549 | 30 | 735 | 4,964 | 0.4% |
| PayPal - Other | - | 748 | 573 | 586 | 1,722 | 1,276 | 4,905 | 0.4% |
| Subscriptions - Tech | 818 | 318 | 403 | 1,496 | 513 | 468 | 4,016 | 0.3% |
| Subscriptions - Entertainment | - | 649 | 649 | 649 | 649 | 649 | 3,245 | 0.3% |
| Shopping - Footwear | 879 | - | - | 1,498 | - | - | 2,377 | 0.2% |
| Bank Charges | - | 2 | - | 1,180 | 599 | 3 | 1,785 | 0.1% |
| Entertainment | - | - | - | - | - | 1,378 | 1,378 | 0.1% |
| Transport - Fuel | - | 623 | 623 | - | - | - | 1,246 | 0.1% |
| Shopping - Electronics | - | - | 1,054 | - | - | - | 1,054 | 0.1% |
| Other (Intl, Food Delivery, Telecom, Housing, Religious) | 200 | 780 | 899 | 579 | - | - | 2,458 | 0.2% |
| GRAND TOTAL | 1,89,419 | 2,70,664 | 1,04,826 | 1,95,906 | 3,69,485 | 1,58,821 | 12,89,121 | 100% |
#### Tech - AI (Rs 2,03,386 -- 15.8% of total expenses)
The single largest expense category. AI tool subscriptions for professional work.
| Merchant | Count | Nov | Dec | Jan | Feb | Mar | Apr | Total |
|---|---|---|---|---|---|---|---|---|
| Claude/Anthropic | 32 | - | - | 36,426 | 23,660 | 19,109 | 47,810 | 1,27,006 |
| Lovable | 14 | 27,818 | 9,421 | - | - | - | - | 37,239 |
| OpenAI/ChatGPT | 6 | 17,063 | 17,063 | - | - | - | 491 | 34,618 |
| OpenRouter | 4 | - | - | - | 2,031 | - | 2,087 | 4,118 |
| Wispr | 2 | - | - | - | - | - | 405 | 405 |
Key observation: A clear shift from Lovable + OpenAI (Nov-Dec) to Claude/Anthropic (Jan-Apr) is visible. Anthropic spend ramped from zero to Rs 47,810/month by April. Combined AI spend averages Rs 33,900/month.
Monthly AI spend trend:
The April spike in Claude/Anthropic spend (Rs 47,810 from 32 transactions) suggests heavy API usage or multiple workspace subscriptions. At current trajectory, annual AI tool cost is Rs 4-5L.
#### Education - Kids (Rs 1,63,003 -- 12.6%)
| Merchant | Total |
|---|---|
| Mahalakshmi Vidya Mandir (school fees) | 1,21,700 |
| School/Academy (Nov term) | 41,303 |
Lumpy spend concentrated in Nov and Mar (school fee due dates).
#### Bills - Credit Card (Rs 1,52,444 -- 11.8%)
| Merchant | Total |
|---|---|
| Jupiter Bill Pay | 1,52,444 |
Paid via Jupiter Bill Pay in batches. December was the peak (Rs 85,613), likely covering accumulated balances. Credit card statements themselves are not available, so underlying spending is opaque.
#### Household - Services (Rs 1,29,281 -- 10.0%)
| Merchant | Total |
|---|---|
| Baskar Murugan | 1,00,300 |
| Gowse Muhaideen | 8,075 |
| Mohamed Sultan | 3,790 |
| Jaswant Singh | 3,150 |
| Dinesh Kumar (service) | 3,110 |
| Other service providers (12) | 10,856 |
Baskar Murugan accounts for 78% of this category (Rs 50,000 in Nov + Rs 50,300 in Dec). This appears to be a one-off home renovation or service engagement that concluded by December.
#### Savings - Jupiter Pot (Rs 1,18,702 -- 9.2%)
| Merchant | Total |
|---|---|
| Jupiter Pot (2 transfers) | 1,18,702 |
These are savings flows to Jupiter Pot savings accounts, not true expenses. They were not captured in the investments classification. Excluding these, actual spending drops to Rs 11,70,419.
#### Cash Withdrawals (Rs 1,01,000 -- 7.8%)
| Month | Amount |
|---|---|
| Jan-26 | 6,000 |
| Feb-26 | 10,000 |
| Mar-26 | 45,000 |
| Apr-26 | 40,000 |
Cash withdrawals accelerated significantly in March-April (Rs 85,000 combined), coinciding with Holi and family visits. No withdrawals in Nov-Dec.
#### Family - Gifts (Rs 98,437 -- 7.6%)
| Recipient | Total |
|---|---|
| Rohit Parmar | 49,001 |
| Parmjit Singh | 20,000 |
| Sandeep Singh | 8,000 |
| Jaswant Singh | 6,000 |
| Manjeet Kumar | 5,500 |
| Vandana Parmar | 5,001 |
| Komal Sharma | 3,800 |
| Others (6) | 1,135 |
March was the peak gift month (Rs 45,125) -- likely Holi gifts to family. Rohit Parmar receives monthly transfers of Rs 15,000 (Dec-Apr), totaling Rs 49,001.
#### PayPal - Services (Rs 97,313 -- 7.5%)
| Merchant | Total |
|---|---|
| PayPal Chouiref/Zineb | 91,903 |
| PayPal Run Meals | 4,901 |
| PayPal Shenduqrwea | 508 |
One large payment of Rs 91,903 to Chouiref/Zineb in February (likely a contractor or freelancer payment via PayPal). This is a significant one-off item.
#### Medical (Rs 40,419 -- 3.1%)
| Merchant | Total |
|---|---|
| Chiropractic/Medical (CUB) | 24,728 |
| Dr Sathish | 6,700 |
| AHC Chiropractic | 5,100 |
| Pharmacy/Medical | 1,565 |
| Tata 1mg | 986 |
| Others (3) | 1,340 |
Chiropractic treatment is recurring at approximately Rs 2,000/month (Rs 14,708 in April suggests multiple months paid together). Total medical spend averages Rs 6,700/month.
#### Shopping (All Sub-categories Combined)
| Sub-category | Total |
|---|---|
| Shopping - Furniture (Kapil Furniture) | 6,300 |
| Shopping - Delivery (Delhivery) | 5,364 |
| Shopping - General | 4,964 |
| Shopping - Footwear (Bata) | 2,377 |
| Shopping - Electronics (Digital Age) | 1,054 |
| Shopping GROSS | 20,059 |
| Less: Matched merchant refunds | (10,329) |
| Shopping NET | 9,730 |
Shopping is modest. Gross spend of Rs 20,059 with Rs 10,329 in refunds brings net shopping to under Rs 10,000 for 6 months.
#### Food (All Sub-categories Combined)
| Sub-category | Total |
|---|---|
| Food - Restaurant | 20,811 |
| Groceries | 15,130 |
| Food - Delivery (Swiggy) | 611 |
| Food - Local Vendor | 210 |
| Food TOTAL | 36,762 |
Average monthly food spend: Rs 6,127. Restaurants (Rs 20,811) are higher than groceries (Rs 15,130), suggesting dining out is a significant share of food spending.
#### Tech & Professional (Combined)
| Sub-category | Total |
|---|---|
| Tech - AI | 2,03,386 |
| Tech - Freelancing (Upwork) | 13,037 |
| Tech - Professional (LinkedIn) | 7,559 |
| Tech - Cloud (Google) | 6,386 |
| Tech - Hosting (Squarespace, Hostinger) | 5,274 |
| Tech - Telecom (Telnyx) | 479 |
| Tech TOTAL | 2,36,121 |
Total tech spending: Rs 2,36,121 (18.3% of expenses). The AI tools category alone is Rs 2,03,386, dwarfing all other tech costs.
#### Transport
| Sub-category | Total |
|---|---|
| Transport - Travel (IRCTC, RedBus) | 8,612 |
| Transport - Fuel (Indian Oil) | 1,246 |
| Transport TOTAL | 9,858 |
Minimal transport spend. IRCTC bookings (Rs 7,343 in April) suggest train travel, possibly a family trip.
#### Insurance
| Item | Total |
|---|---|
| ICICI Prudential Life Insurance | 22,774 |
Single annual premium payment in February. This is a term plan (no surrender value).
#### Loans - EMI
| Item | Total |
|---|---|
| Kotak Mahindra (via Jupiter) | 15,000 |
A single EMI payment in January. This appears to be a small personal loan, not the home loan (which is not visible in these statements).
| # | Merchant | Txns | Total (Rs) | Category |
|---|---|---|---|---|
| 1 | Jupiter Bill Pay | 14 | 1,52,444 | Credit Card Bills |
| 2 | Claude/Anthropic | 32 | 1,27,006 | Tech - AI |
| 3 | Mahalakshmi Vidya Mandir | 2 | 1,21,700 | Education |
| 4 | Jupiter Pot | 2 | 1,18,702 | Savings |
| 5 | ATM Withdrawal | 12 | 1,01,000 | Cash |
| 6 | Baskar Murugan | 3 | 1,00,300 | Household Services |
| 7 | PayPal Chouiref/Zineb | 2 | 91,903 | PayPal Services |
| 8 | Rohit Parmar | 4 | 49,001 | Family Gifts |
| 9 | School/Academy | 2 | 41,303 | Education |
| 10 | Lovable | 14 | 37,239 | Tech - AI |
| 11 | OpenAI/ChatGPT | 6 | 34,618 | Tech - AI |
| 12 | Chiropractic/Medical (CUB) | 7 | 24,728 | Medical |
| 13 | ICICI Pru Life | 1 | 22,774 | Insurance |
| 14 | Parmjit Singh | 1 | 20,000 | Family Gifts |
| 15 | Kotak Mahindra | 1 | 15,000 | Loans |
| 16 | Upwork | 10 | 13,037 | Tech - Freelancing |
| 17 | Annam Farms | 6 | 12,775 | Groceries |
| 18 | Other (misc) | 1 | 10,000 | Personal |
| 19 | Jaswant Singh | 3 | 9,150 | Family + Services |
| 20 | Gowse Muhaideen | 5 | 8,075 | Household Services |
Top 20 merchants account for Rs 11,60,755 (90%) of total expenses.
Matched Merchant Refunds: Rs 10,329 across 8 transactions.
| Merchant | Purchases (Rs) | Refunds (Rs) | Net (Rs) | Refund Rate |
|---|---|---|---|---|
| BATA | 2,377 | 2,247 | 130 | 94.5% |
| MYNTRA | 0 | 7,471 | (7,471) | N/A |
| SWIGGY | 611 | 611 | 0 | 100% |
| TOTAL | 2,988 | 10,329 | (7,341) |
BATA Refund Rate: 94.5% -- Of Rs 2,377 spent on footwear at Bata, Rs 2,247 was refunded, leaving only Rs 130 net. This suggests near-complete returns.
MYNTRA Refunds: Rs 7,471 -- Refunds received with no corresponding purchases in this period. These likely relate to purchases made before November 2025.
Unmatched UPI Reversals: Rs 2,32,945 across 11 transactions. These include the IT refund (Rs 2,25,170), IRCTC refund (Rs 1,295), Anthropic reversals (Rs 242), domain reversals (Rs 41), and other UPI refund codes. These are NOT netted against expenses as they represent failed transaction reversals or government refunds, not shopping returns.
Net Expenses (after merchant refunds): Rs 12,78,792
| Type | Nov | Dec | Jan | Feb | Mar | Apr | **Total** | **%** |
|---|---|---|---|---|---|---|---|---|
| Fixed/Recurring | 1,23,634 | 1,86,824 | 72,303 | 62,033 | 78,805 | 55,273 | 5,78,872 | 49.5% |
| Discretionary | 65,786 | 17,869 | 32,523 | 1,33,872 | 2,37,948 | 1,03,548 | 5,91,547 | 50.5% |
| Savings (Jupiter Pot) | 0 | 65,970 | 0 | 0 | 52,731 | 0 | 1,18,702 | - |
| TOTAL | 1,89,419 | 2,70,664 | 1,04,826 | 1,95,906 | 3,69,485 | 1,58,821 | 12,89,121 |
Excluding Jupiter Pot savings, actual spending = Rs 11,70,419
Fixed/Recurring (Rs 5,78,872 -- 49.5%) includes:
Discretionary (Rs 5,91,547 -- 50.5%) includes:
Caveats:
| Metric | Amount (Rs) |
|---|---|
| Total invested (6 months) | 33,83,991 |
| Average monthly investment | 5,63,999 |
| Investment as % of income | 54.1% |
| Total transactions | 728 |
| Entity | Transactions | Total Invested | % Share |
|---|---|---|---|
| HUF | 68 | 15,47,276 | 45.7% |
| Individual-Rahul | 660 | 18,36,715 | 54.3% |
| TOTAL | 728 | 33,83,991 | 100% |
Note: Savita's investments are routed through accounts not in the parsed statement set (Savita Jupiter, Savita SBI). Her investment activity is not captured here.
| Entity | Type | Count | Total (Rs) |
|---|---|---|---|
| HUF | FD/Pot | 3 | 1,61,076 |
| HUF | Lumpsum | 8 | 9,45,100 |
| HUF | SIP | 57 | 4,41,100 |
| Rahul | FD | 3 | 4,50,000 |
| Rahul | LIC | 5 | 23,000 |
| Rahul | NPS | 5 | 50,000 |
| Rahul | SIP | 647 | 13,13,715 |
| TOTAL | 728 | 33,83,991 |
Rahul's 647 SIP transactions reflect the daily SIP strategy (Rs 800-2,000/day across multiple funds) running through November-March before the restructuring to monthly. HUF's 57 SIP transactions are all weekly ACH mandates via Zerodha and BSE Star MF.
| Entity | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | **Total** |
|---|---|---|---|---|---|---|---|
| HUF | 6,10,886 | 3,00,100 | 80,400 | 1,25,606 | 3,15,285 | 1,15,000 | 15,47,276 |
| Rahul | 2,24,515 | 2,07,500 | 2,27,800 | 2,14,300 | 2,72,600 | 6,90,000 | 18,36,715 |
| TOTAL | 8,35,401 | 5,07,600 | 3,08,200 | 3,39,906 | 5,87,885 | 8,05,000 | 33,83,991 |
HUF investment is lumpy -- Rs 6.1L in November (includes Rs 5.65L Zerodha lumpsum) vs Rs 80,400 in January (SIPs only). Rahul's investment is more stable at Rs 2-2.7L/month (Nov-Mar), then spikes to Rs 6.9L in April (Rs 4.5L FDs + regular SIPs).
| Type | Nov | Dec | Jan | Feb | Mar | Apr | **Total** | **%** |
|---|---|---|---|---|---|---|---|---|
| SIP (all freq.) | 2,10,515 | 2,13,600 | 2,93,200 | 2,79,700 | 4,12,800 | 3,45,000 | 17,54,815 | 51.9% |
| Lumpsum (Zerodha) | 5,65,000 | 2,80,000 | 0 | 0 | 1,00,100 | 0 | 9,45,100 | 27.9% |
| Fixed Deposits | 0 | 0 | 0 | 0 | 0 | 4,50,000 | 4,50,000 | 13.3% |
| FD/Pot (Jupiter) | 45,886 | 0 | 0 | 45,206 | 69,985 | 0 | 1,61,076 | 4.8% |
| NPS | 10,000 | 10,000 | 10,000 | 10,000 | 0 | 10,000 | 50,000 | 1.5% |
| LIC | 4,000 | 4,000 | 5,000 | 5,000 | 5,000 | 0 | 23,000 | 0.7% |
| TOTAL | 8,35,401 | 5,07,600 | 3,08,200 | 3,39,906 | 5,87,885 | 8,05,000 | 33,83,991 | 100% |
| Platform | Transactions | Total | % |
|---|---|---|---|
| Zerodha (Lumpsum) | 8 | 9,45,100 | 27.9% |
| Scripbox | 30 | 6,00,000 | 17.7% |
| HDFC Bank (FDs) | 3 | 4,50,000 | 13.3% |
| HDFC MF (daily/weekly/monthly) | 404 | 2,84,700 | 8.4% |
| BSE Star MF (HUF ACH) | 29 | 2,35,300 | 7.0% |
| Zerodha MF (HUF ACH) | 28 | 2,05,800 | 6.1% |
| Jupiter (FD/Pot) | 3 | 1,61,076 | 4.8% |
| ICICI Prudential MF | 26 | 1,35,000 | 4.0% |
| PPFAS MF | 20 | 94,000 | 2.8% |
| Nippon India MF | 127 | 82,500 | 2.4% |
| Bandhan MF | 5 | 60,000 | 1.8% |
| NPS Trust | 5 | 50,000 | 1.5% |
| UTI MF | 5 | 50,000 | 1.5% |
| LIC | 5 | 23,000 | 0.7% |
| Digital Gold | 30 | 7,515 | 0.2% |
Source: Portfolio Valuation Report (May 31, 2026)
| Entity | Category | Cost (Rs) | Market Value (Rs) | Gain/Loss | Gain % |
|---|---|---|---|---|---|
| Rahul | |||||
| Equity MF | 38,82,000 | 54,71,398 | +15,89,398 | +40.9%* | |
| Debt MF | 10,81,600 | 13,40,558 | +2,58,958 | +23.9% | |
| Gold MF | 3,73,600 | 5,66,603 | +1,93,003 | +51.6% | |
| Direct Equity | 4,07,485 | 5,25,561 | +1,18,076 | +29.0% | |
| REITs | 11,53,426 | 13,48,875 | +1,95,449 | +16.9% | |
| Rahul MF + Equity Total | 68,98,111 | 92,52,995 | +23,54,884 | +34.1% | |
| HUF | |||||
| Equity MF | 7,91,100 | 7,65,565 | (25,535) | -3.2% | |
| Debt MF | 1,44,997 | 1,85,877 | +40,880 | +28.2% | |
| Gold MF | 1,60,000 | 1,86,315 | +26,315 | +16.4% | |
| Kotak Gold ETF | 6,49,347 | 8,02,380 | +1,53,033 | +23.6% | |
| REITs | 8,81,858 | 8,94,320 | +12,462 | +1.4% | |
| HUF Total | 26,27,302 | 28,34,457 | +2,07,155 | +7.9% | |
| Savita | |||||
| Equity MF | 21,64,000 | 27,83,094 | +6,19,094 | +28.6%* | |
| Gold MF | 2,91,500 | 3,72,858 | +81,358 | +27.9% | |
| Savita MF Total | 24,55,500 | 31,55,952 | +7,00,452 | +28.5% |
*Equity MF gains for Rahul and Savita are inflated by zero-cost-basis holdings (transferred-in positions). On cost-tracked holdings only: Rahul +8.8%, Savita +3.9%.
Household MF + Equity Portfolio:
| Asset Class | Market Value (Rs) | Current % | Benchmark (Age 38) | Variance |
|---|---|---|---|---|
| Equity (stocks + equity MF) | 95,45,618 | 43.2% | 55-65% | Under by 12-22pp |
| Debt (debt MF + FD + PPF + EPF + SSY) | 64,45,017 | 29.2% | 25-35% | Within range |
| Gold (SGB + gold ETF/MF) | 22,64,155 | 10.2% | 5-10% | Over by 0-5pp |
| Real Estate (REITs) | 22,43,194 | 10.1% | - | N/A |
| Cash (bank balances) | 16,07,374 | 7.3% | 3-5% | Over by 2-4pp |
| TOTAL | 2,21,05,359 | 100% |
1. Equity is significantly underweight. At 43.2%, it is 12-22 percentage points below the 55-65% recommended for age 38. Even including REITs (which have equity-like characteristics), the combined equity+REIT allocation is 53.3% -- still at the low end.
2. Debt is within range at 29.2%, driven by large PPF (Rs 7.95L), EPF (Rs 14.86L), and SSY (Rs 15.20L) balances. These are locked-in retirement instruments.
3. Gold is slightly overweight at 10.2% (Rs 22.64L). Gold has appreciated 34.8% on aggregate cost, outperforming other asset classes. The overweight position is a result of price appreciation rather than over-investment.
4. Cash is elevated at 7.3% (Rs 16.07L). Rs 11.43L sits in the HUF HDFC account as an operational buffer for Deel payments and SIP debits. Given the March 2026 cash crunch, this cash level is arguably appropriate.
5. No small cap allocation exists anywhere in the portfolio. For age 38 with a 20+ year horizon, a 5-10% small cap allocation could improve long-term growth potential.
| Asset Class | Current % | Target % | Action |
|---|---|---|---|
| Equity | 43.2% | 55-60% | Increase by Rs 26-37L over next 12-18 months |
| Debt | 29.2% | 25-30% | Maintain; PPF/EPF/SSY grow organically |
| Gold | 10.2% | 7-8% | Trim Rs 5-7L over time |
| REITs | 10.1% | 5-7% | Hold; REIT income is useful |
| Cash | 7.3% | 3-5% | Maintain operational buffer; deploy surplus |
| Metric | Score |
|---|---|
| Overall (Nov-Apr, per-SIP average) | 67.8% |
| Stable period (Nov-Feb) | 81.1% |
| Rating (stable period) | Average |
| Total expected outflow (6 months) | Rs 17,08,900 |
| Total actual SIP outflow (6 months) | Rs 15,80,300 |
| Total actual incl. restructured | Rs 22,40,000 |
Starting around March 7-9, 2026, multiple SIPs were restructured from daily/weekly small-amount mandates into larger monthly installments:
| SIP | Before (Daily/Weekly) | After (Monthly) |
|---|---|---|
| HDFC MF | Rs 800/day (3 sub-SIPs: Rs 200+300+300) | Rs 65,000/month (4 txns) |
| Nippon India MF | Rs 500/day | Rs 10,000/month |
| ICICI Prudential MF | Rs 2,500/week | Rs 20,000+5,000/month |
| PPFAS MF | Rs 3,000/week | Rs 20,000/month |
| Zerodha/BSE ACH (HUF) | Rs 5,000-5,100/week | Rs 40-115K per batch |
This restructuring explains the apparent 0% execution rates in April for daily/weekly SIPs -- the mandates changed, not the discipline.
| SIP | Performance | Notes |
|---|---|---|
| Scripbox (Rs 1L/month) | 6/6 months, 100% | Perfect execution, 10th of each month |
| NPS Trust (Rs 10K/month) | 5/6 months, 83% | Missed Mar 2026 only |
| PPFAS MF (Rs 3K/week) | 4/4 months, then restructured | 100% discipline Nov-Feb |
| ICICI Pru Weekly | 4/4 months, then restructured | 100% discipline Nov-Feb |
| HDFC MF Daily | 4/4 months, then restructured | 100% discipline Nov-Feb |
| SIP | Month | Details | Amount Missed |
|---|---|---|---|
| UTI MF | Dec 2025 | No transaction found | Rs 10,000 |
| NPS Trust | Mar 2026 | No transaction found | Rs 10,000 |
| LIC | Apr 2026 | No transaction found | Rs 5,000 |
| Bandhan MF | Apr 2026 | No transaction found | Rs 10,000-20,000 |
| Zerodha ACH (HUF) | Nov 2025 | SIP mandates not yet active | Rs 20,400 |
| BSE Star MF (HUF) | Nov 2025 | SIP mandates not yet active | Rs 20,200 |
| Nippon India MF | Dec 2025 | 1 day missed (30/31 = 97%) | Rs 500 |
| Nippon India MF | Feb 2026 | 1 day missed (27/28 = 96%) | Rs 500 |
Total true misses (excluding restructuring and late-start SIPs): Rs 30,500-40,500 over 6 months.
This represents approximately 1.8-2.4% of total expected SIP outflow -- a strong discipline rate. The missed NPS in March is notable because NPS was otherwise consistently paid on the 5th of each month, and the March miss coincides with the zero-Deel-payment month when cash was critically low.
| SIP | 6-Mo Expected | 6-Mo Actual | Total Fund Amt | Avg Exec % |
|---|---|---|---|---|
| Scripbox (Monthly batch) | Rs 6,00,000 | Rs 6,00,000 | Rs 6,00,000 | 100% |
| BSE Star MF (HUF) | Rs 1,21,200 | Rs 2,35,300 | Rs 2,35,300 | 194% |
| Zerodha ACH (HUF) | Rs 1,22,400 | Rs 2,05,800 | Rs 2,05,800 | 168% |
| NPS Trust | Rs 60,000 | Rs 50,000 | Rs 50,000 | 83% |
| PPFAS MF | Rs 72,000 | Rs 54,000 | Rs 94,000 | 75% |
| ICICI Pru MF (Weekly) | Rs 60,000 | Rs 45,000 | Rs 1,35,000 | 75% |
| HDFC MF (Daily x3) | Rs 1,44,800 | Rs 1,00,700 | Rs 2,84,700 | 70% |
| HDFC MF (Weekly) | Rs 78,000 | Rs 54,000 | Rs 2,84,700 | 69% |
| Nippon India MF | Rs 90,500 | Rs 62,500 | Rs 82,500 | 69% |
| ICICI Pru MF (Monthly) | Rs 60,000 | Rs 40,000 | Rs 1,35,000 | 67% |
| Bandhan MF | Rs 1,20,000 | Rs 60,000 | Rs 60,000 | 50% |
| UTI MF | Rs 1,20,000 | Rs 50,000 | Rs 50,000 | 42% |
| LIC (Kuljeet Singh) | Rs 60,000 | Rs 23,000 | Rs 23,000 | 38% |
Note: HUF SIPs (BSE Star and Zerodha ACH) show >100% execution because they over-delivered -- the mandate amounts increased mid-period, and catch-up payments were made. The "Total Fund" column shows actual total investment into that fund house, which often exceeds the SIP-only amount due to lumpsum additions.
| SIP | Reference Expected | Actual Observed |
|---|---|---|
| UTI MF | Rs 20,000/month | Rs 10,000/month (consistent) |
| Bandhan MF | Rs 20,000/month | Rs 10,000/month (Nov-Feb), Rs 20,000 (Mar) |
| LIC | Rs 10,000/month | Rs 4,000 (Nov-Dec), Rs 5,000 (Jan-Mar) |
These discrepancies suggest the reference SIP amounts may be outdated or aspirational rather than the actual mandated amounts.
| Month | Total SIP | Rahul | HUF | Txn Count |
|---|---|---|---|---|
| Nov-25 | 2,24,515 | 2,24,515 | 0 | 172 |
| Dec-25 | 2,27,600 | 2,07,500 | 20,100 | 147 |
| Jan-26 | 3,08,200 | 2,27,800 | 80,400 | 165 |
| Feb-26 | 2,94,700 | 2,14,300 | 80,400 | 147 |
| Mar-26 | 4,17,800 | 2,72,600 | 1,45,200 | 61 |
| Apr-26 | 3,55,000 | 2,40,000 | 1,15,000 | 22 |
| Average | 3,04,636 |
HUF SIPs started late (December 2025) and ramped up over the period. Rahul's SIPs are stable and established.
| Entity | MF Holdings (folios) | Unique Schemes | Cost (Rs) | Market (Rs) |
|---|---|---|---|---|
| Rahul | 26 | 19 | 53,37,200 | 73,78,559 |
| Savita | 20 | 12 | 24,55,500 | 31,55,952 |
| HUF (Zerodha) | 10 | 10 | 11,31,000 | 11,37,757 |
| Total MF | 22 unique schemes | 89,23,700 | 1,16,72,268 |
| Category | Fund Count | Combined MV (Rs) | % of MF |
|---|---|---|---|
| Index - Nifty 50 | 1 (Bandhan) | 22,53,000 | 19.3% |
| Flexi Cap | 3 (HDFC, PPFAS, Nippon Value) | 21,03,000 | 18.0% |
| Index - Midcap 150 | 2 (Nippon, ABSL) | 15,04,000 | 12.9% |
| Gold (FoF) | 2 (HDFC Gold, Kotak Gold) | 11,25,000 | 9.6% |
| Large & Mid Cap | 1 (HDFC) | 9,77,000 | 8.4% |
| Index - Nifty Next 50 | 1 (UTI) | 7,31,000 | 6.3% |
| Debt (all sub-types) | 6 funds | 15,36,000 | 13.2% |
| Sectoral - IT | 1 (ICICI IT) | 5,24,000 | 4.5% |
| Large Cap (active) | 3 (SBI, Canara Robeco, ICICI Bluechip) | 5,07,000 | 4.3% |
| Mid Cap | 1 (HDFC) | 2,99,000 | 2.6% |
| Index - International | 1 (ICICI NASDAQ) | 1,20,000 | 1.0% |
#### Cross-Entity Overlap (Same fund held by 2-3 entities)
| Fund | Rahul | Savita | HUF | Total MV |
|---|---|---|---|---|
| Bandhan Nifty 50 Index (D) | 12.94L | 6.83L | 2.76L | 22.53L |
| HDFC Flexi Cap (D) | 1.29L | 2.45L | 1.46L | 5.20L |
| HDFC Gold ETF FoF | 1.51L(R) | 1.28L(D) | 1.20L(D) | 3.99L |
| HDFC Large & Mid Cap (D) | 1.54L | 1.42L | 1.73L | 4.69L |
| Kotak Gold Fund | 4.15L(R) | 2.45L(D) | 0.66L(D) | 7.26L |
| Parag Parikh Flexi Cap | 8.27L(R+D) | 2.66L(D) | 1.71L(D) | 12.64L |
| SBI Large Cap | 1.50L(R) | 1.18L(D) | -- | 2.68L |
| ICICI Pru Bluechip (D) | 1.39L | 0.19L | -- | 1.58L |
8 of 22 schemes are duplicated across entities. This is common in family portfolios for tax-entity separation but adds complexity.
#### Within-Category Overlap
| Category | Funds | Concern Level |
|---|---|---|
| Large Cap / Nifty Index | Bandhan Nifty 50 + UTI Nifty Next 50 + SBI Large Cap + Canara Robeco Large Cap + ICICI Bluechip | HIGH -- 5 funds targeting large-cap (Rs 34.91L). Nifty 50 + Next 50 = Nifty 100 exposure; the 3 active large-cap funds are redundant. |
| Debt | ABSL Savings + ABSL Money Manager + Axis Liquid + ICICI Savings + ICICI Short Term + Kotak Savings | HIGH -- 6 debt funds for Rs 15.36L. All ultra-short/liquid/low-duration. 2-3 funds would suffice. |
| Flexi Cap | HDFC Flexi Cap + PPFAS Flexi Cap + Nippon Value | MODERATE -- PPFAS has unique international allocation. HDFC Flexi is redundant. |
| Gold | HDFC Gold FoF + Kotak Gold Fund + Kotak Gold ETF | MODERATE -- 3 gold exposures, total 14.3% of portfolio. Consolidate to 1 vehicle. |
| Midcap Index | Nippon Midcap 150 (Rahul) + ABSL Midcap 150 (Savita) | LOW -- Same index, different entities. Acceptable. |
Rahul holds BOTH Regular and Direct plans of the same fund:
| Fund | Regular Plan MV | Direct Plan MV | Annual Expense Drag |
|---|---|---|---|
| HDFC Flexi Cap | 2.70L | 1.29L | ~Rs 2,700/yr |
| HDFC Large & Mid Cap | 5.08L | 1.54L | ~Rs 5,080/yr |
| Parag Parikh Flexi Cap | 6.75L | 1.52L | ~Rs 5,400/yr |
Total Regular-plan corpus in Rahul: Rs 24.53L paying unnecessary trail commissions.
Estimated annual expense drag: Rs 18,000-24,000/year.
Over 10 years with compounding: Rs 2.5-4L of additional wealth lost.
The following Regular plan holdings in Rahul's portfolio are paying trail commissions to a distributor:
| Fund | Regular Plan MV | Approx Regular Expense Ratio | Approx Direct Expense Ratio | Delta | Annual Drag (Rs) |
|---|---|---|---|---|---|
| HDFC Flexi Cap | 2,70,000 | 1.63% | 0.75% | 0.88% | 2,376 |
| HDFC Large & Mid Cap (2 folios) | 5,08,000 | 1.62% | 0.73% | 0.89% | 4,521 |
| Parag Parikh Flexi Cap (2 folios) | 6,75,000 | 0.63% | 0.28% | 0.35% | 2,363 |
| ABSL Money Manager (2 folios) | 6,70,000 | 0.44% | 0.16% | 0.28% | 1,876 |
| Kotak Gold Fund | 4,15,000 | 0.65% | 0.15% | 0.50% | 2,075 |
| HDFC Gold ETF FoF | 1,51,000 | 0.52% | 0.15% | 0.37% | 559 |
| SBI Large Cap (2 folios) | 1,50,000 | 1.59% | 0.65% | 0.94% | 1,410 |
| ICICI Pru Savings | 1,20,000 | 0.67% | 0.26% | 0.41% | 492 |
| Kotak Savings Fund | 1,24,000 | 0.47% | 0.15% | 0.32% | 397 |
| ABSL Savings (2 folios) | 59,000 | 0.55% | 0.15% | 0.40% | 236 |
| Axis Liquid Fund | 36,000 | 0.29% | 0.07% | 0.22% | 79 |
| TOTAL Regular Plan Corpus | 31,78,000 | 16,384 |
Conservative estimate: Rs 16,000-24,000/year depending on actual expense ratios (which vary by quarter).
10-year compounding impact:
Switching priority order (by annual drag):
1. HDFC Large & Mid Cap Regular (Rs 4,521/yr)
2. HDFC Flexi Cap Regular (Rs 2,376/yr)
3. Parag Parikh Regular (Rs 2,363/yr)
4. Kotak Gold Fund Regular (Rs 2,075/yr)
5. ABSL Money Manager Regular (Rs 1,876/yr)
6. SBI Large Cap Regular (Rs 1,410/yr)
7. Remaining (smaller amounts)
| Missing Category | Impact |
|---|---|
| Small Cap | Zero allocation. Historically highest long-term CAGR in India. 5-10% allocation recommended. |
| ELSS (Tax Saving) | No ELSS funds anywhere. ELSS offers shortest lock-in (3 years) among 80C instruments. |
| Hybrid / Balanced Advantage | No allocation. Could serve as conservative single-fund solution. |
| International (ex-US) | Only US exposure via NASDAQ 100. No Europe/China/EM. |
| Debt -- Long Duration / Gilt | All debt is ultra-short. If rates fall, a gilt fund would benefit. |
Current: 22 schemes, 40+ folios
Target: 11 schemes
| Category | Keep | Phase Out |
|---|---|---|
| Large Cap Index | Bandhan Nifty 50 Index (D) | SBI Large Cap (R+D), Canara Robeco (D), ICICI Bluechip (D) |
| Large Cap Index | UTI Nifty Next 50 Index (D) | -- |
| Large & Mid Cap | HDFC Large & Mid Cap (D) | -- |
| Mid Cap | Nippon/ABSL Midcap 150 (D) | -- |
| Flexi Cap | Parag Parikh Flexi Cap (D) | HDFC Flexi Cap (D) |
| Small Cap | ADD NEW | -- |
| International | ICICI NASDAQ 100 (D) | -- |
| Sectoral | ICICI Nifty IT (D) | -- |
| Gold | Kotak Gold ETF (Zerodha) | HDFC Gold FoF, Kotak Gold Fund (MF) |
| Debt | ICICI Short Term (D) + 1 liquid | 4 redundant debt funds |
| REITs | Embassy + Mindspace | -- |
| Entity | Gross Income (Ann.) | Taxable Income | Old Regime Tax | New Regime Tax | Recommended | Status |
|---|---|---|---|---|---|---|
| Parmar HUF | Rs 83,88,868 | Rs 42,19,445 | Rs 11,18,347 | Rs 8,79,667 | New | OVERDUE |
| Rahul Parmar | Rs 89,969 | Rs 0 / Rs 89,969 | Rs 0 | Rs 0 | Either | No obligation |
| Savita Thakur | Rs 33,47,808 | Rs 16,85,468 | Rs 3,28,795 | Rs 1,42,577 | New | OVERDUE |
| Household | Rs 14,47,142 | Rs 10,22,244 |
Household tax saving from New Regime: Rs 4,24,898
| Item | Amount (Rs) |
|---|---|
| Gross professional receipts (annualized) | 83,38,846 |
| 50% deemed profit under Sec 44ADA | 41,69,423 |
| Add: Bank interest | 13,772 |
| Add: FD interest (estimated) | 36,250 |
| Total income | 42,19,445 |
| Tax (New Regime) | 8,45,833 |
| Add: 4% Cess | 33,833 |
| Total tax payable | 8,79,667 |
44ADA CEILING WARNING: Annualized gross receipts (Rs 83.4L) exceed the Rs 75L threshold for Sec 44ADA eligibility. If actual full-year receipts exceed Rs 75L, presumptive taxation is disallowed and the HUF must maintain books of account under Sec 44AB (tax audit). Verify full-year receipts before filing.
Advance Tax Status: Under 44ADA, the entire tax was due as a single installment by March 15, 2026. Interest under Sec 234B/234C is now accruing at 1% per month on the unpaid amount.
| Item | Amount (Rs) |
|---|---|
| HDFC Savings interest | 3,418 |
| DLF HDFC interest | 654 |
| Jupiter savings/FD interest | 11,682 |
| REIT dividends | 74,095 |
| Stock dividends | 120 |
| Total income (annualized) | 89,969 |
Below the basic exemption limit under both regimes. No tax payable.
Deductions available (if Old Regime chosen):
| Item | Amount (Rs) |
|---|---|
| Deel professional receipts (annualized) | 33,24,680 |
| 50% deemed profit under 44ADA | 16,62,340 |
| Bank savings interest | 6,638 |
| SGB interest | 5,183 |
| FD interest (estimated) | 11,307 |
| Total income | 16,85,468 |
| Tax (New Regime) | 1,37,094 |
| Add: 4% Cess | 5,484 |
| Total tax payable | 1,42,577 |
44ADA eligibility confirmed: Annualized receipts (Rs 33.2L) well within Rs 75L ceiling.
Advance Tax Status: Rs 1,42,577 was due by March 15, 2026. Now overdue with interest accruing.
Since FY 2025-26 is over and advance tax was due by March 15, 2026:
#### HUF Interest Estimate
| Section | Basis | Rate | Months (Apr-Jul 2026) | Amount (Rs) |
|---|---|---|---|---|
| 234B (default in payment) | Rs 8,79,667 | 1%/month | 4 | 35,187 |
| 234C (deferment, one installment) | Rs 8,79,667 | 1%/month | 1 | 8,797 |
| Estimated interest through July 2026 | ~43,984 |
If tax is paid by July 2026 filing deadline, total interest is approximately Rs 44,000. Each additional month of delay adds Rs 8,800.
#### Savita Interest Estimate
| Section | Basis | Rate | Months (Apr-Jul 2026) | Amount (Rs) |
|---|---|---|---|---|
| 234B | Rs 1,42,577 | 1%/month | 4 | 5,703 |
| 234C | Rs 1,42,577 | 1%/month | 1 | 1,426 |
| Estimated interest through July 2026 | ~7,129 |
Combined household interest accruing: approximately Rs 51,100 through July 2026.
Action: Pay immediately. Every month of delay costs Rs 10,200 in combined interest.
1. No ELSS investments found across all three entities. No PPF contributions identified. No 5-year tax-saver FDs. The household is not optimizing Sec 80C.
2. No health insurance premium (80D) found in any bank statement. If Care Health Insurance is paid through other channels, it should be claimed.
3. HUF 44ADA ceiling risk is the most critical tax issue. If disallowed, actual profit becomes taxable and a tax audit is required.
4. REIT distributions are treated as fully taxable. A portion may be return of capital (non-taxable) -- verify against REIT distribution declarations.
5. Capital gains not computed. Tata MF redemption (Rs 1,20,991) is subject to separate LTCG/STCG computation with cost basis.
| Metric | Amount (Rs) |
|---|---|
| Gross Assets (data-backed, ex home) | 2,21,05,359 |
| Less: Liabilities (Home Loan) | (10,00,000) |
| Net Worth (ex home) | 2,11,05,359 |
| Add: Home estimate (~65L) | 65,00,000 |
| Net Worth (incl home) | ~2,76,05,359 |
| Less: Retirement lock-ins (PPF + EPF + SSY) | (38,01,831) |
| Liquid Net Worth | 1,73,03,528 |
#### Rahul Parmar -- Rs 1,17,35,349 (before Savita adjustment)
| Asset Class | Amount (Rs) | Notes |
|---|---|---|
| Bank Balances | 2,00,864 | HDFC Savings 1,25,066 + DLF 26,435 + Jupiter 49,362 |
| Mutual Funds (CAS) | 73,78,559 | 26 schemes via Scripbox/Jupiter/Zerodha |
| Stocks (Zerodha, ex-REITs) | 5,25,561 | 20 equities |
| REITs (Zerodha) | 13,48,875 | Embassy 6,39,720 + Mindspace 7,09,155 |
| PPF | 7,95,430 | Manual value |
| EPF | 14,86,061 | Manual value |
| Rahul Total | 1,17,35,349 | 53.1% of gross assets |
#### Parmar HUF -- Rs 44,77,506
| Asset Class | Amount (Rs) | Notes |
|---|---|---|
| Bank Balance | 11,43,050 | HDFC HUF a/c |
| Mutual Funds (deduped CAS + Zerodha) | 11,37,757 | 10 schemes (9 CAS + 1 Zerodha-only) |
| REITs (Zerodha) | 8,94,320 | Embassy 4,44,725 + Mindspace 4,49,595 |
| Gold ETF (Zerodha) | 8,02,380 | Kotak Gold ETF, 6,175 units |
| Fixed Deposit | 5,00,000 | HDFC FD, 7.25%, matures Sep 2026 |
| HUF Total | 44,77,506 | 20.3% of gross assets |
#### Savita Thakur -- Rs 58,92,504
| Asset Class | Amount (Rs) | Notes |
|---|---|---|
| Bank Balance | 2,63,460 | HDFC Savita a/c |
| Mutual Funds (CAS) | 31,55,952 | 20 schemes via Jupiter/Scripbox |
| Fixed Deposit | 6,16,752 | HDFC FD, 5.5%, matures Jun 2026 |
| SGB | 3,36,000 | 35 units, SGB 2023-24 Series II, matures Sep 2031 |
| SSY (Naavya) | 7,60,170 | Manual value |
| SSY (Shanvika) | 7,60,170 | Manual value |
| Savita Total | 58,92,504 | 26.7% of gross assets |
Entity cross-check: 1,17,35,349 + 44,77,506 + 58,92,504 = 2,21,05,359 (matches gross assets)
| Asset Class | Rahul | HUF | Savita | Total (Rs) | % of Gross |
|---|---|---|---|---|---|
| Bank Balances | 2,00,864 | 11,43,050 | 2,63,460 | 16,07,374 | 7.3% |
| Mutual Funds | 73,78,559 | 11,37,757 | 31,55,952 | 1,16,72,268 | 52.8% |
| Stocks (pure equity) | 5,25,561 | -- | -- | 5,25,561 | 2.4% |
| REITs | 13,48,875 | 8,94,320 | -- | 22,43,194 | 10.1% |
| Gold ETF | -- | 8,02,380 | -- | 8,02,380 | 3.6% |
| Fixed Deposits | -- | 5,00,000 | 6,16,752 | 11,16,752 | 5.1% |
| SGB | -- | -- | 3,36,000 | 3,36,000 | 1.5% |
| PPF | 7,95,430 | -- | -- | 7,95,430 | 3.6% |
| EPF | 14,86,061 | -- | -- | 14,86,061 | 6.7% |
| SSY | -- | -- | 15,20,340 | 15,20,340 | 6.9% |
| TOTAL | 1,17,35,349 | 44,77,506 | 58,92,504 | 2,21,05,359 | 100% |
| Category | Amount (Rs) | % |
|---|---|---|
| Liquid / Semi-Liquid | ||
| Bank Balances | 16,07,374 | 7.3% |
| Mutual Funds | 1,16,72,268 | 52.8% |
| Stocks | 5,25,561 | 2.4% |
| REITs (listed, tradeable) | 22,43,194 | 10.1% |
| Gold ETF (listed, tradeable) | 8,02,380 | 3.6% |
| Fixed Deposits (maturing <6 months) | 11,16,752 | 5.1% |
| SGB (listed, tradeable before maturity) | 3,36,000 | 1.5% |
| Subtotal Liquid | 1,83,03,528 | 82.8% |
| Illiquid / Locked-in | ||
| PPF | 7,95,430 | 3.6% |
| EPF | 14,86,061 | 6.7% |
| SSY (Naavya + Shanvika) | 15,20,340 | 6.9% |
| Subtotal Illiquid | 38,01,831 | 17.2% |
| TOTAL GROSS ASSETS | 2,21,05,359 | 100% |
| Liability | Outstanding (Rs) | Notes |
|---|---|---|
| Home Loan | 10,00,000 | Against Jains Alpine Meadows, Chennai |
| Credit Card Debt | Unknown | No CC statements available |
| Total Known Liabilities | 10,00,000 |
| Dimension | Amount (Rs) | % of Gross |
|---|---|---|
| By Liquidity | ||
| Instantly liquid (bank + liquid MF) | 31,43,000 | 14.2% |
| T+1 to T+3 liquid (equity MF + stocks + REITs + ETF) | 1,51,60,000 | 68.6% |
| Fixed term (FD, SGB) | 14,53,000 | 6.6% |
| Locked until retirement (PPF + EPF + SSY) | 38,02,000 | 17.2% |
| By Risk | ||
| Low risk (bank + FD + debt MF + PPF + EPF + SSY) | 80,52,000 | 36.4% |
| Medium risk (gold + REITs + SGB) | 33,43,000 | 15.1% |
| High risk (equity MF + stocks) | 1,00,71,000 | 45.6% |
| Cash (bank) | 16,07,000 | 7.3% |
| By Tax Entity | ||
| Rahul PAN | 1,17,35,000 | 53.1% |
| HUF PAN | 44,78,000 | 20.3% |
| Savita PAN | 58,93,000 | 26.7% |
| By Geography | ||
| India-only exposure | 2,19,85,000 | 99.5% |
| International (ICICI NASDAQ 100) | 1,20,000 | 0.5% |
Key observations:
1. 82.8% of assets are liquid or semi-liquid. This is healthy -- the household can access Rs 1.83 Cr in assets within a few business days if needed.
2. 17.2% is locked in retirement instruments (PPF + EPF + SSY = Rs 38L). These provide tax-efficient compounding but cannot be accessed until maturity/retirement.
3. Only 0.5% international exposure via ICICI NASDAQ 100. The portfolio is almost entirely domestic, creating India single-country risk.
4. Rahul holds 53% of household assets but earns zero direct income -- all income is via HUF and Savita entities. This is a deliberate tax-optimization structure.
Based on the 6-month data:
| Metric | 6-Month | Annualized |
|---|---|---|
| Net new investments | Rs 33,84,000 | Rs 67,68,000 |
| Market appreciation (est. 10% CAGR on Rs 2.05 Cr) | Rs 10,25,000 | Rs 20,50,000 |
| Interest/dividends reinvested | Rs 3,00,000 | Rs 6,00,000 |
| Less: Home loan repayment (principal) | Unknown | Unknown |
| Estimated annual net worth growth | Rs 88-94L |
At this trajectory, the household could reach:
These projections assume continued Deel income at current levels, maintained savings rate, and ~10% market returns. Any disruption to income would significantly impact this trajectory.
| # | Entity | Holding | Market Value (Rs) | % of Gross |
|---|---|---|---|---|
| 1 | Rahul | EPF | 14,86,061 | 6.7% |
| 2 | Rahul | Bandhan Nifty 50 Index Fund | 12,94,034 | 5.9% |
| 3 | HUF | HDFC HUF Bank Balance | 11,43,050 | 5.2% |
| 4 | Rahul | Nippon India Midcap 150 Index Fund | 8,50,405 | 3.8% |
| 5 | HUF | Kotak Gold ETF | 8,02,380 | 3.6% |
| 6 | Rahul | PPF | 7,95,430 | 3.6% |
| 7 | Rahul | SSY Naavya | 7,60,170 | 3.4% |
| 8 | Rahul | SSY Shanvika | 7,60,170 | 3.4% |
| 9 | Rahul | UTI Nifty Next 50 Index Fund | 7,30,899 | 3.3% |
| 10 | Rahul | Mindspace REIT (1,530 units) | 7,09,155 | 3.2% |
| 11 | Savita | Bandhan Nifty 50 Index Fund | 6,83,005 | 3.1% |
| 12 | Savita | ABSL Nifty Midcap 150 Index Fund | 6,50,267 | 2.9% |
| 13 | Rahul | Embassy REIT (1,496 units) | 6,39,720 | 2.9% |
| 14 | Rahul | ABSL Money Manager Fund | 6,18,426 | 2.8% |
| 15 | Savita | ICICI Pru Nifty IT Index Fund | 5,24,434 | 2.4% |
Top 15 holdings = Rs 1,34,47,606 (60.8% of gross assets).
| Parameter | Value | Basis |
|---|---|---|
| Monthly Deel income (HUF) | Rs 6,95,000 | 6-month average |
| Monthly Deel income (Savita) | Rs 2,77,000 | 6-month average |
| Monthly expenses | Rs 2,15,000 | 6-month average |
| Monthly investments (SIPs + recurring) | Rs 3,05,000 | Post-restructuring run rate |
| Monthly fixed obligations | Rs 5,20,000 | Expenses + investments |
| Starting cash (all accounts) | Rs 16,07,374 | Apr 30, 2026 balances |
| Horizon | Expected Income | Expected Outflow | Net Position | Ending Cash |
|---|---|---|---|---|
| May 2026 (30 days) | Rs 9,72,000 | Rs 5,20,000 | +Rs 4,52,000 | Rs 20,59,000 |
| Jun 2026 (60 days) | Rs 19,44,000 | Rs 10,40,000 | +Rs 9,04,000 | Rs 25,11,000 |
| Jul 2026 (90 days) | Rs 29,16,000 | Rs 15,60,000 | +Rs 13,56,000 | Rs 29,63,000 |
Stress scenario (1-month Deel gap like March 2026):
| Scenario | May Income | May Outflow | Ending Cash |
|---|---|---|---|
| Normal | Rs 9,72,000 | Rs 5,20,000 | Rs 20,59,000 |
| Zero Deel in May | Rs 0 | Rs 5,20,000 | Rs 10,87,000 |
| Zero Deel in May + Jun | Rs 0 | Rs 10,40,000 | Rs 5,67,000 |
The household can survive 2 months without Deel payments before cash reserves are critically depleted. However, this assumes no lumpsum investments -- with April's Rs 4.5L FD pattern, reserves deplete faster.
| Date | Event | Amount | Direction |
|---|---|---|---|
| ~Jun 10 | Scripbox SIP batch | Rs 1,00,000 | Out |
| Jun 18 | Savita HDFC FD maturity | Rs 6,33,878 | In (reinvest decision) |
| ~Jun 2026 | REIT Q4 distributions | Rs 28,000 | In |
| ~Jun 15 | FY25-26 tax filing deadline | Variable | Out |
| Ongoing | SIPs (restructured monthly) | Rs 2,05,000/mo | Out |
High risk identified. The structural issue:
1. Deel payments are irregular -- 0 to 5 payments per month, no guaranteed date.
2. SIPs debit on fixed weekly/monthly schedules regardless of income arrival.
3. March 2026 demonstrated the worst case: zero income, Rs 5.9L in investments debited, Rs 3.7L in expenses, HUF balance dropped to Rs 6,215.
Minimum balance history:
| Account | Nov | Dec | Jan | Feb | Mar | Apr |
|---|---|---|---|---|---|---|
| HDFC HUF | 36,740 | 3,67,827 | 3,70,161 | 6,33,527 | 6,215 | 8,351 |
| Rahul Savings | 92,619 | 10,990 | 31,537 | 90,308 | 2,24,128 | 1,23,771 |
HDFC HUF dropped below Rs 10,000 twice (March and April). Rahul Savings dropped to Rs 10,990 in December. These are dangerously close to zero.
Deel pays on an irregular schedule, typically 2-3 times per month for HUF and 1-2 times per month for Savita:
| Date | Payee | Amount (Rs) |
|---|---|---|
| 2025-11-01 | HUF | 2,92,927 |
| 2025-11-01 | Savita | 2,98,760 |
| 2025-11-18 | HUF | 3,40,330 |
| 2025-11-29 | HUF | 3,25,806 |
| 2025-11-29 | Savita | 2,58,488 |
| 2025-12-17 | HUF | 2,95,872 |
| 2026-01-02 | HUF | 2,96,966 |
| 2026-01-02 | Savita | 2,69,080 |
| 2026-01-17 | HUF | 2,99,562 |
| 2026-02-04 | HUF | 3,02,147 |
| 2026-02-04 | Savita | 2,64,893 |
| 2026-02-20 | HUF | 2,85,994 |
| 2026-04-04 | HUF | 4,54,366 |
| 2026-04-04 | Savita | 5,71,119 |
| 2026-04-13 | HUF | 3,64,927 |
| 2026-04-13 | HUF | 3,70,497 |
| 2026-04-17 | HUF | 2,66,591 |
| 2026-04-17 | HUF | 2,73,435 |
Patterns observed:
With monthly SIP commitments of Rs 3-5L and expenses of Rs 1.5-2.5L, the household needs at least Rs 5-7L in the HDFC HUF at all times to survive a single month without Deel payments. The current pattern of running the balance down to Rs 6-8K creates risk of:
1. Bounced ACH debits -- SIP mandates fail, breaking investment discipline and potentially attracting bank penalties.
2. Insufficient funds for critical expenses -- School fees (Rs 1.2L), medical (Rs 6.7K/month), and household services cannot be deferred.
3. Forced MF redemption -- Selling investments at potentially unfavorable NAVs to meet cash shortfalls.
4. Credit score impact -- Bounced mandates can affect CIBIL score.
Recommendation: Maintain a minimum Rs 12L buffer in HDFC HUF (2 months of combined outflow). This can be implemented by:
| Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | **6-Month Total** | |
|---|---|---|---|---|---|---|---|
| Income | 15,43,585 | 4,17,217 | 8,79,959 | 11,07,666 | 2,823 | 23,10,185 | 62,61,436 |
| Expenses | (1,89,419) | (2,70,664) | (1,04,826) | (1,95,906) | (3,69,485) | (1,58,821) | (12,89,121) |
| Gross Savings | 13,54,166 | 1,46,553 | 7,75,133 | 9,11,760 | (3,66,662) | 21,51,364 | 49,72,315 |
| Savings Rate | 88% | 35% | 88% | 82% | N/A | 93% | 79% |
| Investments | (8,35,401) | (5,07,600) | (3,08,200) | (3,39,906) | (5,87,885) | (8,05,000) | (33,83,991) |
| Net Cash Surplus | +5,18,765 | (3,61,047) | +4,66,934 | +5,71,854 | (9,54,547) | +13,46,364 | +15,88,324 |
| Cumulative Cash Position | +5,18,765 | +1,57,718 | +6,24,652 | +11,96,506 | +2,41,960 | +15,88,324 |
Notes on the P&L:
| Account | Opening (Nov 1) | Closing (Apr 30) | Change |
|---|---|---|---|
| HDFC HUF | 3,85,513 | 11,43,050 | +7,57,537 |
| Rahul Savings | 44,719 | 1,25,066 | +80,347 |
| Rahul Jupiter | 6,077 | 49,362 | +43,285 |
| Rahul DLF | 26,108 | 26,435 | +327 |
| Savita HDFC | 2,57,550 | 2,63,460 | +5,910 |
| TOTAL | 7,19,967 | 16,07,374 | +8,87,407 |
Total cash position grew by Rs 8.87L over 6 months, representing the portion of savings not deployed into investments.
#### RED FLAGS
| # | Risk | Impact | Severity |
|---|---|---|---|
| 1 | Single income source (Deel = 97%) | Any disruption to the Deel contract is existential. No backup income stream exists. | Critical |
| 2 | March 2026 income gap -- HUF balance Rs 6,215 | A full month with zero payments demonstrated the household has no structural buffer. SIP ACH debits could have bounced. | Critical |
| 3 | HUF 44ADA ceiling breach risk | Annualized receipts (Rs 83.4L) exceed Rs 75L. If full-year exceeds Rs 75L, presumptive taxation is disallowed, triggering tax audit. | High |
| 4 | Advance tax overdue (HUF Rs 8.8L + Savita Rs 1.4L) | Interest accruing at 1%/month since April 2026 under Sec 234B/234C. | High |
| 5 | Rs 24.5L in Regular MF plans | Paying distributor trail commissions unnecessarily. Annual drag of Rs 18-24K; Rs 2.5-4L over 10 years. | Medium |
| 6 | Equity underweight (43% vs 55-65% target) | Long-term wealth accumulation impacted. Missing small cap allocation entirely. | Medium |
| 7 | Portfolio complexity (22 schemes, 40+ folios) | Tax filing burden, tracking difficulty, rebalancing complexity. | Medium |
| 8 | Credit card spending opaque | Rs 1.52L paid to Jupiter Bill Pay but underlying CC spending is unknown. | Medium |
| 9 | No health insurance premium visible | If not insured, the family is exposed to catastrophic medical costs. | Medium |
#### AMBER FLAGS
| # | Flag | Notes |
|---|---|---|
| 10 | Cash withdrawals accelerating | Rs 0 in Nov-Dec to Rs 85K in Mar-Apr. Monitor for undocumented spending. |
| 11 | 6 debt funds for Rs 15.4L | Extreme fragmentation. 2-3 funds would do the same job. |
| 12 | Gold overweight at 10.2% | Above the 5-10% benchmark. Price appreciation driven, not over-investment. |
| 13 | Bandhan Nifty 50 CAS discrepancy | Units=0 in CAS but MV=Rs 12.94L. Needs verification against broker. |
| 14 | No ELSS/PPF contributions | Missing Sec 80C optimization across all entities. |
| 15 | Daily SIP transaction volume | 551 daily MF transactions create enormous LTCG/STCG tracking burden at redemption. |
#### GREEN FLAGS
| # | Positive Signal | Notes |
|---|---|---|
| 16 | 79% savings rate | Among the highest achievable for any household income level. |
| 17 | 54% investment rate | More than half of every rupee earned is invested. |
| 18 | Scripbox SIP -- 100% discipline | Rs 1L/month invested like clockwork for 6 consecutive months. |
| 19 | Zero credit card debt visible | Bills paid regularly via Jupiter Bill Pay; no debt accumulation signals. |
| 20 | Diversified investment vehicles | MF + stocks + REITs + gold ETF + FD + NPS + LIC + PPF + EPF + SSY. |
| 21 | Three tax entities | HUF + Rahul + Savita maximize basic exemption limits and LTCG thresholds. |
| 22 | SIP restructuring completed | Transition from daily to monthly reduces complexity without losing investment volume. |
| 23 | Home loan minimal | Rs 10L outstanding on a ~Rs 65L property (15% LTV) is conservative. |
| 24 | REIT income diversification | Rs 1.5L/year in quarterly REIT distributions, growing with unit accumulation. |
#### Priority 1: Build a Cash Buffer (Immediate)
Target: Rs 12-15L liquid reserve in HDFC HUF or a liquid fund.
This equals 2 months of combined outflow (expenses + SIP obligations) and would prevent a repeat of the March 2026 near-crisis.
Action steps:
1. Ring-fence Rs 12L in HDFC HUF as a minimum balance floor.
2. Set bank alerts at Rs 50,000 for HDFC HUF and Rs 25,000 for Rahul Savings.
3. Negotiate with Deel for fixed bi-monthly payment dates rather than ad-hoc payouts.
4. Stagger SIP debit dates to the 15th-25th of each month to allow Deel payments to land first.
#### Priority 2: Pay Overdue Advance Tax (Immediate)
**HUF: Rs 8,79,667 + interest | Savita: Rs 1,42,577 + interest**File returns for FY 2025-26 and pay outstanding tax to stop interest accrual. Verify whether HUF gross receipts breached Rs 75L (44ADA ceiling) and prepare for potential tax audit.
#### Priority 3: Switch Regular Plans to Direct (Within 30 days)
Stop all Regular plan SIPs immediately. Restart as Direct plan SIPs.
| Fund | Regular Plan MV | Annual Savings |
|---|---|---|
| HDFC Flexi Cap | 2.70L | ~2,700 |
| HDFC Large & Mid Cap | 5.08L | ~5,100 |
| Parag Parikh Flexi Cap | 6.75L | ~5,400 |
| ABSL Money Manager | 6.70L | ~2,000 |
| Kotak Gold Fund | 4.15L | ~2,100 |
| HDFC Gold FoF | 1.51L | ~750 |
| SBI Large Cap | 1.50L | ~1,200 |
| ICICI Pru Savings | 1.20L | ~600 |
| Kotak Savings | 1.24L | ~500 |
| ABSL Savings + Axis Liquid | 0.95L | ~300 |
| Total | 31.78L | ~20,650/year |
Tax note: Switching triggers redemption. For equity funds held over 1 year, LTCG above Rs 1.25L is taxed at 12.5%. Prioritize switching SIP-based Regular plans first (stop Regular SIP, start Direct SIP) to avoid lump-sum tax.
#### Priority 4: Consolidate Portfolio (Within 60 days)
1. Consolidate 6 debt funds to 2. Keep ICICI Short Term + ABSL Money Manager (Direct). Redeem the rest.
2. Phase out 3 active large-cap funds. Stop SIPs in SBI Large Cap, Canara Robeco Large Cap, ICICI Bluechip. Redirect to Bandhan Nifty 50 Index.
3. Consolidate gold to 1 vehicle. Keep Kotak Gold ETF (Zerodha HUF). Gradually trim HDFC Gold FoF and Kotak Gold Fund MF positions.
4. Merge duplicate folios. 8 pairs of duplicate folios across entities -- merge via MFU.
#### Priority 5: Fill Allocation Gaps (Within 90 days)
1. Add small cap fund. Target 5-8% allocation (~Rs 5-8L). Options: Nippon India Small Cap, HDFC Small Cap, or Quant Small Cap (Direct).
2. Increase equity allocation. Current 43% to target 55%. Deploy Rs 26L from trimmed gold + cash + debt consolidation proceeds + new SIP flows into equity.
3. Consider ELSS. If Sec 80C deductions are still needed (check against HUF/Savita filing), add ELSS SIPs.
#### Priority 6: Verify & Protect (Within 30 days)
1. Verify health insurance. No premium payments found in statements. If no coverage exists, purchase immediately. Family floater of Rs 10-15L recommended.
2. Verify Bandhan Nifty 50 holding. CAS shows units=0 but MV=Rs 12.94L. Cross-check with Zerodha demat statement.
3. Obtain NPS balance. Request PRAN statement to include in net worth.
4. Review LIC policy. Determine surrender value. If term plan, no value to track. If endowment, evaluate whether to continue or surrender.
The following items were not available for this analysis and should be obtained for a complete financial picture:
| # | Data Gap | Impact on Report | Priority |
|---|---|---|---|
| 1 | Savita Jupiter bank statement | Savita's expenses and investments via Jupiter are not captured. Household expense figures are understated. | High |
| 2 | NPS balance (PRAN statement) | NPS is not included in net worth. Rahul contributes Rs 10,000/month (Rs 50,000 observed). Accumulated balance is unknown. | High |
| 3 | LIC policy details & surrender value | Only premium payments visible (Rs 4-5K/month). Policy type (term vs endowment vs ULIP) and surrender value unknown. | Medium |
| 4 | Jupiter FD details | Rs 1,61,076 transferred to Jupiter FD/Pot from HUF. FD interest rate, maturity date, and current value are unknown. | Medium |
| 5 | Care Health Insurance details | No health insurance premium found in any statement. Coverage amount, premium, and renewal date are unknown. If no coverage exists, this is a critical gap. | High |
| 6 | Credit card statements | Rs 1,52,444 paid in credit card bills but underlying spending categories are opaque. | Medium |
| 7 | Home loan EMI schedule | Rs 10L outstanding but no EMI payments visible in these statements. Likely paid from a different account. EMI amount, remaining tenure, and interest rate unknown. | Medium |
| 8 | Savita SBI account statement | Rs 1,50,000 transferred from HUF to Savita SBI during the period. Account balance and activity unknown. | Low |
| 9 | Apr-Oct 2025 income data | Tax estimates use annualization (6-month x 2). Actual first-half income is needed for accurate tax filing, especially to determine HUF 44ADA eligibility. | High |
| 10 | Real estate valuation | Home value estimated at Rs 65L. Independent valuation would improve net worth accuracy. | Low |
| 11 | PPF/EPF/SSY latest statements | Values used are "manual" entries. Current statements would confirm balances and interest credits. | Low |
| 12 | Rohit Parmar CBI account | Rs 55,000 transferred to a CBI account tagged as Rohit. Relationship and purpose unclear -- is this a family obligation or inter-account transfer? | Low |
These transactions are excluded from both income and expense calculations.
| Transfer Route | Count | Amount (Rs) |
|---|---|---|
| HDFC HUF to Rahul Jupiter | 32 | 22,95,000 |
| HDFC HUF to Rahul Savings | 3 | 8,00,000 |
| Rahul Jupiter to Savita Jupiter | 10 | 6,70,000 |
| Rahul Jupiter to HDFC HUF | 7 | 5,60,000 |
| HDFC HUF to Rohit Parmar | 2 | 5,00,001 |
| HDFC HUF to Savita SBI | 6 | 1,50,000 |
| Rahul Jupiter to CBI (Rohit) | 7 | 55,000 |
| Rahul Savings to Rahul Jupiter | 1 | 50,000 |
| TOTAL | 68 | 50,80,001 |
The total inter-account transfer volume (Rs 50.8L) exceeds actual income (Rs 62.6L) and is 1.5x total investments (Rs 33.8L). This reflects the hub-and-spoke cashflow model where Deel payments arrive in the HUF account and are distributed to other accounts for SIPs, expenses, and family obligations.
| Account | Entity | Bank | Opening Balance | Closing Balance | Credits | Debits | Txns |
|---|---|---|---|---|---|---|---|
| 50100800924179 | HUF | HDFC | 3,85,513 | 11,43,050 | 64,32,170 | 56,74,633 | 269 |
| 50100072289435 | Rahul | HDFC | 44,719 | 1,25,066 | 11,86,275 | 11,05,927 | 57 |
| 77770114899814 | Rahul | Federal/Jupiter | 6,077 | 49,362 | 30,05,838 | 29,62,553 | 982 |
| 50100548554143 | Rahul | HDFC (DLF) | 26,108 | 26,435 | 327 | 0 | 2 |
| 50100643746451 | Savita | HDFC | 2,57,550 | 2,63,460 | 5,910 | 0 | 3 |
Total transactions analysed: 1,313
| Stock | Sector | P&L % | Unrealized P&L (Rs) |
|---|---|---|---|
| GRWRHITECH | Chemicals | +186.2% | +91,550 |
| RADICO | FMCG | +77.9% | +7,710 |
| SYRMA | Engg & Capital Goods | +74.5% | +23,233 |
| FEDERALBNK | Financial Services | +59.9% | +12,015 |
| SHRIPISTON | Engg & Capital Goods | +54.9% | +1,203 |
| Stock | Sector | P&L % | Unrealized P&L (Rs) |
|---|---|---|---|
| SENCO | Retail | -43.4% | (5,317) |
| PITTIENG | Engg & Capital Goods | -34.3% | (9,750) |
| JIOFIN | Financial Services | -26.4% | (17,170) |
| MMTC | Trading | -25.1% | (1,087) |
| BIKAJI | FMCG | -21.8% | (1,814) |
Direct equity (ex-REITs): Invested Rs 4,07,485, Present Rs 5,25,561, Net gain +29.0%.
10 of 20 stocks are in profit; 10 are in loss.
| Stock | Sector | Qty | Avg Price | CMP | Invested (Rs) | Present (Rs) | P&L (Rs) | P&L % |
|---|---|---|---|---|---|---|---|---|
| GRWRHITECH | Chemicals | 23 | 2,137 | 6,118 | 49,161 | 1,40,712 | +91,550 | +186.2% |
| RADICO | FMCG | 5 | 1,980 | 3,522 | 9,898 | 17,608 | +7,710 | +77.9% |
| SYRMA | Engg & Cap Goods | 50 | 624 | 1,089 | 31,195 | 54,428 | +23,233 | +74.5% |
| FEDERALBNK | Financial Svc | 111 | 181 | 289 | 20,058 | 32,073 | +12,015 | +59.9% |
| SHRIPISTON | Engg & Cap Goods | 1 | 2,189 | 3,391 | 2,189 | 3,391 | +1,203 | +54.9% |
| TI | FMCG | 30 | 301 | 456 | 9,030 | 13,670 | +4,640 | +51.4% |
| TIMETECHNO | Chemicals | 160 | 118 | 175 | 18,826 | 27,960 | +9,134 | +48.5% |
| ETERNAL | IT | 207 | 180 | 251 | 37,354 | 51,936 | +14,582 | +39.0% |
| SHYAMMETL | Metals | 10 | 811 | 975 | 8,108 | 9,753 | +1,645 | +20.3% |
| PRICOLLTD | Auto Ancillary | 20 | 554 | 563 | 11,077 | 11,258 | +181 | +1.6% |
| ASKAUTOLTD | Auto Ancillary | 40 | 497 | 456 | 19,888 | 18,238 | (1,650) | -8.3% |
| BERGEPAINT | Building Mat | 10 | 561 | 501 | 5,605 | 5,006 | (599) | -10.7% |
| RAINBOW | Healthcare | 20 | 1,586 | 1,385 | 31,727 | 27,693 | (4,034) | -12.7% |
| GRAUWEIL | Chemicals | 200 | 83 | 70 | 16,675 | 14,010 | (2,665) | -16.0% |
| AFFLE | Software Svc | 10 | 1,841 | 1,468 | 18,411 | 14,680 | (3,731) | -20.3% |
| BIKAJI | FMCG | 10 | 831 | 650 | 8,314 | 6,500 | (1,814) | -21.8% |
| MMTC | Trading | 50 | 87 | 65 | 4,334 | 3,247 | (1,087) | -25.1% |
| JIOFIN | Financial Svc | 200 | 325 | 239 | 64,960 | 47,790 | (17,170) | -26.4% |
| PITTIENG | Engg & Cap Goods | 20 | 1,422 | 934 | 28,435 | 18,685 | (9,750) | -34.3% |
| SENCO | Retail | 20 | 612 | 346 | 12,240 | 6,924 | (5,317) | -43.4% |
| TOTAL | 4,07,485 | 5,25,561 | +1,18,076 | +29.0% |
| Sector | Stocks | Invested (Rs) | Present (Rs) | P&L % |
|---|---|---|---|---|
| Chemicals | 3 | 84,662 | 1,82,682 | +115.8% |
| FMCG | 3 | 27,242 | 37,778 | +38.7% |
| Engg & Capital Goods | 3 | 61,819 | 76,504 | +23.7% |
| Financial Services | 2 | 85,018 | 79,863 | -6.1% |
| IT / Software | 2 | 55,765 | 66,616 | +19.4% |
| Auto Ancillary | 2 | 30,965 | 29,496 | -4.7% |
| Metals | 1 | 8,108 | 9,753 | +20.3% |
| Healthcare | 1 | 31,727 | 27,693 | -12.7% |
| Building Materials | 1 | 5,605 | 5,006 | -10.7% |
| Retail | 1 | 12,240 | 6,924 | -43.4% |
| Trading | 1 | 4,334 | 3,247 | -25.1% |
The Chemicals sector is the top performer driven entirely by GRWRHITECH (+186%). Financial Services is the largest sector allocation (Rs 85K invested in FEDERALBNK + JIOFIN) but is in the red due to JIOFIN's -26.4% loss.
| Metric | Value |
|---|---|
| Largest single position (JIOFIN by invested) | Rs 64,960 (15.9% of stock portfolio) |
| Largest single position (GRWRHITECH by present value) | Rs 1,40,712 (26.8% of stock portfolio) |
| Top 3 by invested value (JIOFIN + ETERNAL + SYRMA) | Rs 1,33,509 (32.8%) |
| Top 3 by present value (GRWRHITECH + SYRMA + ETERNAL) | Rs 2,47,076 (47.0%) |
GRWRHITECH has grown from a Rs 49K investment to Rs 1.41L (26.8% of the stock portfolio). At +186%, it dominates portfolio returns. Consider partial profit-booking to reduce single-stock concentration.
Total gold allocation: Rs 22,64,155 (10.2% of gross assets)
| Component | Entity | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|---|
| Kotak Gold ETF (GOLD1-E) | HUF | 6,49,347 | 8,02,380 | +23.6% |
| Kotak Gold Fund - Regular | Rahul | 2,69,800 | 4,15,474 | +54.0% |
| Kotak Gold Fund - Direct | Savita | 1,86,000 | 2,45,010 | +32.4% |
| SGB (35 units) | Savita | 2,05,555 | 3,36,000 | +63.5% |
| HDFC Gold ETF FOF - Regular | Rahul | 1,03,800 | 1,51,129 | +45.6% |
| HDFC Gold ETF FOF - Direct | Savita | 1,05,500 | 1,27,848 | +22.1% |
| HDFC Gold ETF FOF - Direct | HUF | 1,05,000 | 1,20,007 | +14.3% |
| Kotak Gold Fund - Direct | HUF | 55,000 | 66,308 | +20.6% |
| Total Gold | 16,80,002 | 22,64,155 | +34.8% |
Gold has been the best-performing asset class during this period, appreciating 34.8% on aggregate cost.
Total REIT exposure: Rs 22,43,194 (10.1% of gross assets)
| REIT | Entity | Units | Invested (Rs) | Present (Rs) | P&L % |
|---|---|---|---|---|---|
| Embassy Office Parks | Rahul | 1,496 | 5,67,819 | 6,39,720 | +12.7% |
| Embassy Office Parks | HUF | 1,040 | 4,36,549 | 4,44,725 | +1.9% |
| Mindspace Business Parks | Rahul | 1,530 | 5,85,607 | 7,09,155 | +21.1% |
| Mindspace Business Parks | HUF | 970 | 4,45,309 | 4,49,595 | +1.0% |
| Total REITs | 20,35,284 | 22,43,194 | +10.2% |
Combined: 2,536 Embassy units + 2,500 Mindspace units.
Quarterly distributions: approximately Rs 28,000 (Rahul) + Rs 10,000 (HUF) = Rs 38,000/quarter.
| FD | Entity | Principal (Rs) | Maturity (Rs) | Rate | Maturity Date |
|---|---|---|---|---|---|
| HDFC FD 50301127702610 | HUF | 5,00,000 | 5,57,174 | 7.25% | 14 Sep 2026 |
| HDFC FD 50301175075741 | Savita | 6,16,752 | 6,33,878 | 5.50% | 18 Jun 2026 |
| HDFC FDs (3 x Rs 1.5L) | Rahul | 4,50,000 | TBD | TBD | TBD |
| Total FD Principal | 15,66,752 |
Note: Rahul's 3 FDs were created on April 4, 2026. Rate and maturity details not available.
| Instrument | Entity | Value (Rs) | Notes |
|---|---|---|---|
| EPF | Rahul | 14,86,061 | Employer contribution + self, locked until retirement |
| PPF | Rahul | 7,95,430 | 15-year maturity cycle, partial withdrawal eligible |
| SSY (Naavya) | Savita | 7,60,170 | Matures when daughter turns 21 |
| SSY (Shanvika) | Savita | 7,60,170 | Matures when daughter turns 21 |
| NPS | Rahul | Unknown | Rs 10K/month contributions observed; PRAN statement needed |
| LIC | Rahul | Unknown | Rs 4-5K/month premium; surrender value unknown |
| Total (data-backed) | 38,01,831 | Excludes NPS and LIC |
Caution: 4 holdings have cost recorded as Rs 0 (transferred-in positions) contributing Rs 15,73,451 in market value with zero cost basis. Cost-tracked holdings gain is approximately +8.8%.
#### Equity MF (19 holdings across folios)
| Fund | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|
| Bandhan Nifty 50 Index Fund - Direct | 0* | 12,94,034 | -- |
| Nippon India Nifty Midcap 150 Index Fund - Direct | 7,82,000 | 8,50,405 | +8.7% |
| UTI Nifty Next 50 Index Fund - Direct | 6,98,000 | 7,30,899 | +4.7% |
| Parag Parikh Flexi Cap Fund - Regular (folio 14205336) | 4,64,600 | 4,67,809 | +0.7% |
| HDFC Large and Mid Cap Fund - Regular (folio 26102544) | 3,54,100 | 3,59,028 | +1.4% |
| HDFC Mid Cap Fund - Direct | 2,91,400 | 2,98,931 | +2.6% |
| HDFC Flexi Cap Fund - Regular | 2,78,600 | 2,69,723 | -3.2% |
| Parag Parikh Flexi Cap Fund - Regular (folio 12688028) | 1,58,500 | 2,07,482 | +30.9% |
| HDFC Large and Mid Cap Fund - Direct | 1,56,000 | 1,54,286 | -1.1% |
| Parag Parikh Flexi Cap Fund - Direct | 1,56,000 | 1,52,473 | -2.3% |
| ICICI Pru NASDAQ 100 Index Fund - Direct | 0* | 1,19,846 | -- |
| HDFC Large and Mid Cap Fund - Regular (folio 23327492) | 1,28,900 | 1,48,597 | +15.3% |
| ICICI Pru Equity & Debt Fund - Direct | 1,45,000 | 1,39,317 | -3.9% |
| HDFC Flexi Cap Fund - Direct | 1,30,000 | 1,28,601 | -1.1% |
| SBI Large Cap Fund - Regular (folio 38241376) | 98,300 | 1,07,573 | +9.4% |
| SBI Large Cap Fund - Regular (folio 38241357) | 40,600 | 42,394 | +4.4% |
| Equity MF Subtotal | 38,82,000 | 54,71,398 | +40.9%* |
*Excluding zero-cost positions (Bandhan Nifty 50 Rs 12.94L, ICICI NASDAQ Rs 1.20L), cost-tracked equity gain is +7.9%.
#### Debt MF (7 holdings)
| Fund | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|
| ABSL Money Manager Fund - Regular (folio 1045289399) | 5,88,000 | 6,18,426 | +5.2% |
| ICICI Pru Short Term Fund - Direct | 3,05,000 | 3,31,864 | +8.8% |
| Kotak Savings Fund - Regular | 0* | 1,23,655 | -- |
| ICICI Pru Savings Fund - Regular | 89,600 | 1,19,862 | +33.7% |
| ABSL Money Manager Fund - Regular (folio 1046608648) | 46,700 | 52,099 | +11.6% |
| ABSL Savings Fund - Regular (folio 1046608628) | 46,700 | 52,194 | +11.8% |
| Axis Liquid Fund - Regular | 0* | 35,916 | -- |
| ABSL Savings Fund - Regular (folio 1045289334) | 5,600 | 6,542 | +16.8% |
| Debt MF Subtotal | 10,81,600 | 13,40,558 | +23.9% |
Note: Kotak Savings and Axis Liquid have zero cost basis. On cost-tracked debt holdings (Rs 10.82L cost, Rs 11.80L market), the gain is approximately +9.1%.
#### Gold MF (2 holdings)
| Fund | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|
| Kotak Gold Fund - Regular | 2,69,800 | 4,15,474 | +54.0% |
| HDFC Gold ETF FOF - Regular | 1,03,800 | 1,51,129 | +45.6% |
| Gold MF Subtotal | 3,73,600 | 5,66,603 | +51.6% |
Both gold MF positions are in Regular plans (paying distributor commission) and should be switched to Direct.
| Category | Holdings | Cost (Rs) | Market (Rs) | % of Rahul MF |
|---|---|---|---|---|
| Large Cap Index (Nifty 50) | 1 | 0* | 12,94,034 | 17.5% |
| Midcap Index (Nifty Midcap 150) | 1 | 7,82,000 | 8,50,405 | 11.5% |
| Large Cap Index (Nifty Next 50) | 1 | 6,98,000 | 7,30,899 | 9.9% |
| Flexi Cap (PPFAS) | 3 | 7,79,100 | 8,27,764 | 11.2% |
| Large & Mid Cap (HDFC) | 3 | 6,39,000 | 6,61,911 | 9.0% |
| Debt (mixed) | 8 | 10,81,600 | 13,40,558 | 18.2% |
| Gold (Kotak + HDFC FoF) | 2 | 3,73,600 | 5,66,603 | 7.7% |
| Flexi Cap (HDFC) | 2 | 4,08,600 | 3,98,324 | 5.4% |
| Mid Cap (HDFC) | 1 | 2,91,400 | 2,98,931 | 4.1% |
| Large Cap (SBI) | 2 | 1,38,900 | 1,49,967 | 2.0% |
| International (ICICI NASDAQ) | 1 | 0* | 1,19,846 | 1.6% |
| Hybrid (ICICI Equity & Debt) | 1 | 1,45,000 | 1,39,317 | 1.9% |
Caution: 3 holdings have cost recorded as Rs 0 (transferred-in positions) contributing Rs 6,05,446 in market value with zero cost basis. Cost-tracked holdings gain is approximately +3.9%.
#### Equity MF (16 holdings)
| Fund | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|
| Bandhan Nifty 50 Index Fund - Direct | 6,90,000 | 6,83,005 | -1.0% |
| ABSL Nifty Midcap 150 Index Fund - Direct (2 folios) | 6,10,000 | 6,54,249 | +7.3% |
| ICICI Pru Nifty IT Index Fund - Direct | 0* | 5,24,434 | -- |
| Parag Parikh Flexi Cap Fund - Direct (2 folios) | 2,74,000 | 2,66,369 | -2.8% |
| HDFC Flexi Cap Fund - Direct (2 folios) | 2,54,500 | 2,45,011 | -3.7% |
| HDFC Large and Mid Cap Fund - Direct (2 folios) | 1,45,500 | 1,42,397 | -2.1% |
| SBI Large Cap Fund - Direct | 1,20,000 | 1,18,254 | -1.5% |
| Canara Robeco Large Cap Fund - Direct (2 folios) | 0* | 81,012 | -- |
| Nippon India Value Fund - Direct (2 folios) | 50,000 | 49,164 | -1.7% |
| ICICI Pru Equity & Debt Fund - Direct | 20,000 | 19,199 | -4.0% |
| Equity MF Subtotal | 21,64,000 | 27,83,094 | +28.6%* |
*Gain inflated by zero-cost positions. Cost-tracked equity gain: approximately +0.8%.
#### Gold MF (4 holdings)
| Fund | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|
| Kotak Gold Fund - Direct (2 folios) | 1,86,000 | 2,45,010 | +31.7% |
| HDFC Gold ETF FOF - Direct (2 folios) | 1,05,500 | 1,27,848 | +21.2% |
| Gold MF Subtotal | 2,91,500 | 3,72,858 | +27.9% |
Note: Savita holds no debt mutual funds. Her fixed-income allocation is entirely through FD (Rs 6.17L) and SSY (Rs 15.20L).
9 ISINs overlap between CAS HUF and Zerodha HUF. CAS values used for overlapping ISINs (more recent NAV). 1 Zerodha-only holding added.
#### Equity MF (4 holdings)
| Fund | ISIN | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|---|
| Bandhan Nifty 50 Index Fund - Direct | INF194K012A8 | 2,90,000 | 2,75,595 | -5.0% |
| HDFC Large and Mid Cap Fund - Direct | INF179KA1RQ7 | 1,75,000 | 1,73,146 | -1.1% |
| Parag Parikh Flexi Cap Fund - Direct | INF879O01027 | 1,75,000 | 1,70,838 | -2.4% |
| HDFC Flexi Cap Fund - Direct | INF179K01UT0 | 1,51,100 | 1,45,986 | -3.4% |
| Equity MF Subtotal | 7,91,100 | 7,65,565 | -3.2% |
All HUF equity MF positions are in the red, reflecting recent purchases (late 2025 onward) during a flat-to-declining market. The largest loss is Bandhan Nifty 50 at -5.0% (Rs 14,405 unrealized loss on Rs 2.90L invested).
#### Debt MF (4 holdings)
| Fund | ISIN | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|---|
| ICICI Pru Savings Fund - Direct (Zerodha-only) | INF109K01O82 | 74,997 | 77,127 | +2.8% |
| ABSL Money Manager Fund - Direct | INF209K01UU3 | 60,000 | 62,074 | +3.5% |
| Kotak Savings Fund - Direct | INF174K01JP2 | 0* | 36,285 | -- |
| ABSL Savings Fund - Direct | INF209K01UR9 | 10,000 | 10,391 | +3.9% |
| Debt MF Subtotal | 1,44,997 | 1,85,877 | +28.2% |
#### Gold MF (2 holdings)
| Fund | ISIN | Cost (Rs) | Market (Rs) | Gain % |
|---|---|---|---|---|
| HDFC Gold ETF FOF - Direct | INF179K01VX0 | 1,05,000 | 1,20,007 | +14.3% |
| Kotak Gold Fund - Direct | INF174K01MP6 | 55,000 | 66,308 | +20.6% |
| Gold MF Subtotal | 1,60,000 | 1,86,315 | +16.4% |
| Holding | Type | Qty | Invested (Rs) | Present (Rs) | P&L % |
|---|---|---|---|---|---|
| Kotak Gold ETF (GOLD1-E) | Gold ETF | 6,175 | 6,49,347 | 8,02,380 | +23.6% |
| Mindspace REIT | REIT | 970 | 4,45,309 | 4,49,595 | +1.0% |
| Embassy REIT | REIT | 1,040 | 4,36,549 | 4,44,725 | +1.9% |
| Subtotal | 15,31,205 | 16,96,699 | +10.8% |
| FD | Principal (Rs) | Maturity (Rs) | Rate | Maturity Date |
|---|---|---|---|---|
| HDFC FD (50301127702610) | 5,00,000 | 5,57,174 | 7.25% | 14 Sep 2026 |
| Metric | Amount (Rs) |
|---|---|
| Total debits (all accounts) | 97,53,113 |
| Classified as Investments | 33,83,991 |
| Classified as Transfers | 50,80,001 |
| Classified as Expenses | 12,89,121 |
| Sum (Inv + Xfer + Exp) | 97,53,113 |
| Difference | 0.00 |
| Investment reconciled with investments.json | Yes |
| Matched merchant refunds | 10,329 |
| Unmatched UPI reversals (not netted) | 2,32,945 |
| Net expenses (after merchant refunds) | 12,78,792 |
The debit reconciliation is exact -- every debit transaction across all 5 accounts is classified into one of three buckets (Investment, Transfer, Expense) with zero residual. This provides confidence that no transactions are missing or double-counted.
The household runs SIPs through multiple channels and frequencies:
| SIP | Frequency | Amount | Sub-transactions | Total/Mo |
|---|---|---|---|---|
| Scripbox Batch | Monthly (10th) | Rs 1,00,000 | 5 sub-SIPs (Rs 32,200 + Rs 21,600 x2 + Rs 12,300 x2) | Rs 1,00,000 |
| SIP | Frequency | Pre-Mar Amount | Post-Mar Amount |
|---|---|---|---|
| HDFC MF (3 sub-SIPs) | Daily | Rs 800/day (Rs 200+300+300) | Stopped; Rs 65,000/mo batch |
| Nippon India MF | Daily | Rs 500/day | Stopped; Rs 10,000/mo |
| ICICI Pru MF | Weekly | Rs 2,500/week | Stopped; Rs 25,000/mo batch |
| PPFAS MF | Weekly | Rs 3,000/week | Stopped; Rs 20,000/mo |
| HDFC MF (Weekly) | Weekly | Rs 3,000/week | Merged into monthly |
| UTI MF | Monthly | Rs 10,000/mo | Rs 10,000/mo (unchanged) |
| Bandhan MF | Monthly | Rs 10,000/mo | Rs 20,000/mo (doubled) |
| ICICI Pru MF (Monthly) | Monthly | Rs 10,000/mo | Merged into weekly batch |
| Digital Gold | Daily | Rs 501/day (Rs 101+400) | Not tracked after restructure |
| SIP | Frequency | Amount |
|---|---|---|
| NPS Trust | Monthly (5th) | Rs 10,000 |
| LIC (Kuljeet Singh) | Monthly (5th) | Rs 4,000-5,000 |
| SIP | Frequency | Pre-Jan Amount | Post-Jan Amount |
|---|---|---|---|
| Zerodha ACH MF | Weekly | Rs 5,000-5,100/week | Rs 20,000-75,000/batch |
| BSE Star MF | Weekly | Rs 5,000-5,100/week | Rs 20,000-40,000/batch |
| Type | Frequency | Amount |
|---|---|---|
| Zerodha Lumpsum | Ad-hoc | Rs 30,000-200,000 per transaction |
| Channel | Monthly Amount | Entity |
|---|---|---|
| Scripbox (5 sub-SIPs) | Rs 1,00,000 | Rahul |
| Jupiter Monthly MF batch (HDFC/ICICI/PPFAS) | Rs 1,30,000 | Rahul |
| UTI MF | Rs 10,000 | Rahul |
| Nippon India MF | Rs 10,000 | Rahul |
| NPS | Rs 10,000 | Rahul |
| Zerodha/BSE ACH (HUF) | Rs 1,15,000 | HUF |
| Total Monthly SIPs | Rs 3,75,000 |
The restructuring from daily/weekly to monthly reduced transaction count from ~170/month (Nov) to ~22/month (Apr) while maintaining comparable investment volumes. This simplifies tracking and reduces LTCG/STCG complexity at redemption.
This traces how Deel income flows through the household account structure:
DEEL PAYMENTS
|
+---> HUF HDFC (50100800924179) -- Primary Hub
| |
| +---> Zerodha (Lumpsum + ACH SIPs) -- Rs 11.51L
| +---> BSE Star MF (ACH SIPs) -- Rs 2.35L
| +---> Rahul Jupiter (transfers) -- Rs 22.95L
| | |
| | +---> Jupiter Daily/Weekly/Monthly MF SIPs -- Rs 5.42L
| | +---> NPS/LIC -- Rs 0.73L
| | +---> Expenses (Food, Medical, Tech, etc.) -- Rs 8.97L
| | +---> Savita Jupiter (transfers) -- Rs 6.70L
| | +---> HDFC HUF (return flows) -- Rs 5.60L
| | +---> CBI Rohit (transfers) -- Rs 0.55L
| |
| +---> Rahul Savings (transfers) -- Rs 8.00L
| | |
| | +---> Scripbox SIPs -- Rs 6.00L
| | +---> HDFC FDs -- Rs 4.50L
| | +---> Rahul Jupiter (transfer) -- Rs 0.50L
| |
| +---> Rohit Parmar -- Rs 5.00L
| +---> Savita SBI -- Rs 1.50L
| +---> Jupiter FD/Pot -- Rs 1.61L
| +---> Expenses (Education, Bills) -- Rs 3.92L
|
+---> Savita HDFC (50100643746451) -- Dormant (interest only)
The HUF HDFC account is the central hub. All Deel income (both HUF and Savita payouts via NEFT to HUF) flows through this account before being distributed to other accounts for investments, expenses, and family obligations. Savita's Deel payments that arrive directly into HUF are then transferred out to Savita's other accounts.
| Component | Nov | Dec | Jan | Feb | Mar | Apr | Avg/Mo |
|---|---|---|---|---|---|---|---|
| Tech - AI | 44,882 | 26,484 | 36,426 | 25,691 | 19,109 | 50,793 | 33,898 |
| Bills - Credit Card | 15,543 | 85,613 | 3,397 | 3,397 | 44,494 | 0 | 25,407 |
| Household - Services | 54,950 | 62,584 | 2,326 | 1,835 | 7,586 | 0 | 21,547 |
| Tech - Cloud/Hosting/Prof | 1,021 | 5,305 | 4,870 | 1,217 | 4,800 | 2,009 | 3,204 |
| Bills - Telecom | 0 | 475 | 1,355 | 1,704 | 1,655 | 1,355 | 1,091 |
| Subscriptions (Tech+Ent) | 818 | 967 | 1,052 | 2,145 | 1,162 | 1,117 | 1,210 |
| Household - Help | 6,420 | 1,450 | 230 | 1,070 | 0 | 0 | 1,528 |
| Tech - Freelancing | 0 | 3,947 | 7,369 | 1,722 | 0 | 0 | 2,173 |
| Insurance | 0 | 0 | 0 | 22,774 | 0 | 0 | 3,796 |
| Loans | 0 | 0 | 15,000 | 0 | 0 | 0 | 2,500 |
| Bank Charges | 0 | 2 | 0 | 1,180 | 599 | 3 | 297 |
| Housing | 0 | 0 | 278 | 0 | 0 | 0 | 46 |
| Fixed Total | 1,23,634 | 1,86,824 | 72,303 | 62,033 | 78,805 | 55,273 | 96,479 |
| Component | Nov | Dec | Jan | Feb | Mar | Apr | Avg/Mo |
|---|---|---|---|---|---|---|---|
| Education - Kids | 41,303 | 0 | 0 | 0 | 1,21,700 | 0 | 27,167 |
| Cash Withdrawal | 0 | 0 | 6,000 | 10,000 | 45,000 | 40,000 | 16,833 |
| Family - Gifts | 5,001 | 4,001 | 0 | 15,000 | 45,125 | 29,310 | 16,406 |
| PayPal - Services | 0 | 0 | 5,410 | 91,903 | 0 | 0 | 16,219 |
| Medical | 7,524 | 3,686 | 2,624 | 2,564 | 8,327 | 15,694 | 6,737 |
| Food (all) | 6,898 | 3,372 | 5,251 | 410 | 4,600 | 1,100 | 3,605 |
| Groceries | 2,745 | 3,065 | 4,232 | 4,293 | 795 | 0 | 2,522 |
| Shopping (all) | 929 | 0 | 6,219 | 6,846 | 30 | 7,035 | 3,510 |
| Transport | 0 | 1,137 | 623 | 755 | 0 | 7,343 | 1,643 |
| Entertainment | 0 | 0 | 0 | 0 | 0 | 1,378 | 230 |
| Personal | 0 | 0 | 0 | 100 | 10,000 | 0 | 1,683 |
| PayPal - Other | 0 | 748 | 573 | 586 | 1,722 | 1,276 | 818 |
| Household - Local | 1,385 | 1,078 | 2,591 | 235 | 50 | 409 | 958 |
| International/Other | 0 | 780 | 0 | 0 | 0 | 0 | 130 |
| Discretionary Total | 65,786 | 17,869 | 32,523 | 1,33,872 | 2,37,948 | 1,03,548 | 98,591 |
| Category | Avg/Mo | Std Dev | CV (Volatility) | Nature |
|---|---|---|---|---|
| Tech - AI | 33,898 | 11,800 | 35% | Semi-variable |
| Bills - Credit Card | 25,407 | 33,000 | 130% | Highly variable |
| Household - Services | 21,547 | 27,000 | 125% | One-off driven |
| Education | 27,167 | 48,000 | 177% | Lumpy (term-based) |
| Cash Withdrawals | 16,833 | 20,000 | 119% | Accelerating trend |
| Family Gifts | 16,406 | 17,000 | 104% | Seasonal (Holi) |
| Medical | 6,737 | 5,000 | 74% | Semi-variable |
| Food/Groceries | 6,127 | 2,200 | 36% | Stable |
Credit card bills, education fees, and household services have the highest volatility (CV > 100%), making monthly budgeting difficult. Food and AI tools are the most predictable recurring costs.
| Asset Class | Total Cost | Market Value | Gain (Rs) | Gain % | Notes |
|---|---|---|---|---|---|
| Gold (all) | 16,80,002 | 22,64,155 | +5,84,153 | +34.8% | Best performer |
| Direct Equity | 4,07,485 | 5,25,561 | +1,18,076 | +29.0% | 10/20 stocks in profit |
| Equity MF (Rahul, cost-tracked) | 38,82,000 | 41,17,364 | +2,35,364 | +7.9% | Excludes zero-cost |
| REITs | 20,35,284 | 22,43,194 | +2,07,910 | +10.2% | Plus quarterly income |
| Debt MF (all) | 12,26,597 | 15,26,435 | +2,99,838 | +24.4% | Includes old positions |
| HUF Equity MF | 7,91,100 | 7,65,565 | (25,535) | -3.2% | Recent purchases |
| Savita Equity MF (cost-tracked) | 15,58,000 | 15,69,089 | +11,089 | +0.8% | Excludes zero-cost |
1. Gold is the standout performer at +34.8% since inception, driven by global gold price rally. SGB (Savita) has appreciated +63.5%.
2. Direct equity shows a +29.0% overall gain, but highly concentrated: GRWRHITECH alone contributes Rs 91,550 of the Rs 1,18,076 total gain (+186.2%). Without GRWRHITECH, direct equity gain drops to +6.5%.
3. REITs provide modest capital appreciation (+10.2%) plus quarterly income of ~Rs 38,000/quarter (~Rs 1.5L/year). Combined total return (price + income) is approximately 14-15%.
4. HUF equity MF is underwater at -3.2%, reflecting recent purchases (most invested in late 2025 and 2026) during a flat-to-declining market.
5. Savita's cost-tracked equity MF shows only +0.8% gain -- essentially flat. Her Bandhan Nifty 50 position (Rs 6.83L, -1.0%) is the largest holding and is slightly in the red.
6. Zero-cost basis positions inflate reported returns for Rahul (CAS shows +38.2%, actual ~+8.8%) and Savita (CAS shows +28.5%, actual ~+3.9%). These are likely old transferred holdings where cost basis was not carried over in the CAS statement.
| Ratio | Formula | Value | Benchmark | Assessment |
|---|---|---|---|---|
| Savings Rate | (Income - Expenses) / Income | 79% | >30% (excellent) | Well above benchmark |
| Investment Rate | Investments / Income | 54% | >25% (excellent) | Outstanding |
| Expense Coverage | Liquid Assets / Monthly Expenses | 85 months | >6 months | Extremely healthy |
| Emergency Fund | Cash / Monthly Expenses | 7.5 months | 3-6 months | Adequate |
| Debt-to-Asset | Liabilities / Gross Assets | 4.5% | <30% | Very conservative |
| Debt-to-Income | Annual Debt Service / Annual Income | <2% | <35% | Negligible |
| Liquid Net Worth Ratio | Liquid NW / Gross NW | 78% | >50% | Healthy liquidity |
| Equity Allocation | Equity / Gross Assets | 43.2% | 55-65% (age 38) | Below target |
| Gold Allocation | Gold / Gross Assets | 10.2% | 5-10% | Slightly over |
| Single Source Income % | Deel / Total Income | 97% | <70% | Critical risk |
| SIP Commitment Ratio | Monthly SIPs / Monthly Income | 39% | 20-40% | At upper bound |
| Dimension | Parmar Household | Typical HNI | Notes |
|---|---|---|---|
| Savings rate | 79% | 30-40% | Exceptionally high |
| Equity allocation | 43% | 50-60% | Below peer average |
| Gold allocation | 10% | 5-8% | Above peer average |
| Real estate (% of NW) | 24% (incl home) | 40-60% | Below peer average (positive) |
| Number of MF schemes | 22 | 8-15 | Over-diversified |
| Regular plan usage | Rs 24.5L | Rs 0 (direct only) | Needs correction |
| Emergency fund | 7.5 months | 3-6 months | Above average |
| Insurance coverage | Unknown | 10-15x annual income | Verify immediately |
| International exposure | 0.5% | 5-10% | Significantly under |
| Small cap allocation | 0% | 5-10% | Missing entirely |
| Milestone | Estimated Timeline | Requirements |
|---|---|---|
| Rs 3 Cr (ex home) | Q4 2026 (~6 months) | Maintain current savings + 10% market return |
| Rs 5 Cr (ex home) | Mid 2028 (~24 months) | Maintain current savings + 12% market return |
| Rs 10 Cr (ex home) | 2031-2032 (~5-6 years) | Maintain savings + increase equity allocation |
| Financial Independence (Rs 15 Cr) | 2034-2035 (~8-9 years) | 4% SWR on Rs 15Cr = Rs 60L/year expenses |
At the current Rs 88-94L/year net worth growth rate, the household is on track for financial independence (ability to cover all expenses from investment returns alone) within 8-9 years, assuming continued income stability and disciplined investing.
*End of Report*
*Data sources: CAMS/KFintech CAS (Apr-May 2026), Zerodha Holdings (May 31, 2026), HDFC Bank Statements (Nov 2025 - Apr 2026), Federal Bank/Jupiter Statement (Nov 2025 - Apr 2026), HDFC FD Statements, Manual entries for PPF/SSY/EPF/SGB/Home Loan.*
*Generated: May 31, 2026*