Investing regularly in stocks or mutual funds every month is called SIP (Systematic Investment Plan). But how does SIP actually work? How does it generate returns? In this article, we’ll walk through these questions using an Excel sheet to show you the real power of SIP.
Understanding SIP
I’ve often talked about disciplined investing, and the best example of this is SIP. You may have heard about SIPs from mutual funds, Smallcase, or even me. So, how does SIP work? How does monthly investing lead to compounding returns? This is a fundamental question many people ask. My answer is simple: you choose a fixed date every month and invest consistently in a stock, mutual fund, or Smallcase, regardless of its price on that day. Now, many people wonder: if I bought a share or mutual fund unit for ₹100 last month, and this month it’s ₹110, why am I buying it at a higher price? Why not wait for the price to go back down to ₹100 to get better returns? This confusion often derails the whole investment process. To explain how SIP generates returns, I’ll show you an Excel sheet comparison. I’ll also explain how SIPs are different from lump-sum investments and a critical factor to consider when signing up for a SIP.How SIPs Work
To analyze how SIPs work, I referred to the Association of Mutual Funds in India (AMFI), which provides historic data of mutual funds. You can also check it out;:https://www.amfiindia.com/ I picked one mutual fund—PPFAS Flexi Cap Direct Growth Plan (Note: This is not a recommendation). I chose this randomly. Please make investment decisions using your own judgment. On AMFI’s site, you can download the NAV (Net Asset Value) data. NAV is like the share price of a mutual fund unit. As NAV rises, the value of your investment increases. You can access NAV data of any mutual fund, even if it’s old—freely available. I downloaded the NAV data from August 2011 to July 2016 (maximum 5 years allowed at once). The fund was launched around May 2013, and the NAV on 28th May 2013 was 9.9992, usually a NAV starts at about 10. By 27th July 2016, the NAV had risen to around ₹18—almost doubling in 3 years. Continuing from August 2016 to July 2021, the NAV reached around ₹45—meaning it increased 4.5 times in 8 years.Types of SIP
Understand these type of Sip and pic the right one as for your goal Top Up Sip Flexible Perpetual SIPWhat is a Top-up SIP?
A Top-up SIP allows you to increase your monthly SIP amount at regular periods — say, every year.. For example, ₹5,000 per month today. After one year, you might increase it to ₹6,000, then ₹7,000 next year, and so on. This flexibility helps you scale your investments as your income grows. Why is this powerful? Because as your income increases, your cost of living goes up — but ideally, your investments should also grow proportionately. If you want to increase your investment when you have a higher income then A Top-up SIP help you do that Also, by gradually increasing your SIP amount, you:-
- Take better advantage of compounding returns.
-
- Invest more in high-performing funds over time.
-
- Avoid the temptation to spend surplus income.
-
- Total Investment: ₹4,90,000
-
- Total Value: ₹11,60,000
-
- Growth: More than doubled in 8 years
- Growth: More than doubled in 8 years
-
- Total Investment: ₹9,80,000
-
- Total Value: ₹23,00,000
-
- Investment of ₹5000 in May 2013 is now worth ₹22,000.
-
- Total SIP: ₹4,90,000
-
- Current Value: ₹11,60,000
-
- Absolute Return: 137%
-
- Annual Return (CAGR): ~11% over 8 years
-
- 6 years → 12% return
-
- 5 years → 13% return
-
- 4 years → 14% return
-
- 3 years → 17% return
-
- 2 years → 22% return
-
- 1 year → 25% return
The Real Advantage of SIP
Systematic Investment Plan (SIP) offers many different benefits. Here, we will talk about a few of them. SIP is like a risk-free FD. You invest ₹5000 each month in a fund or Smallcase, without fail. Over time, your money grows substantially:-
- Doubled in 7 years (109%)
-
- 50% increase in 2 years (49%)
-
- Direct Plan
-
- Regular Plan
-
- It’s the percentage of your money that is not invested but used to cover management costs.
-
- For example, if the expense ratio is 1% and you invest ₹100, only ₹99 is actually invested.
-
- In regular plans, agent commissions are included—making them more expensive than direct plans.
How to Convert to a Direct Plan
It’s not simple, but it’s essential. Here’s why it’s tricky:-
- Exit Load – If you exit a fund early, a fee may be charged.
-
- Short-Term Capital Gain Tax (STCG) – If sold before 1 year, tax is 15%; after 1 year, it’s 10% (LTCG).
-
- Put the lump-sum in a Debt Mutual Fund (safer, offers fixed returns).
-
- Start an SIP from this amount.
-
- Lump-sum = ₹1,00,000
-
- Monthly SIP = ₹10,000 from the debt fund
-
- The money will last 10 months. After that, continue SIP from your regular income.





