InvestorQ : How is SIP calculated ? Which SIP investment is best in India looking at the current market scenario?
Ankita Patil made post

How is SIP calculated ? Which SIP investment is best in India looking at the current market scenario?

Answer
user profile image
Sadaf Khan answered.
1 year ago


The simplest way one can calculate SIP is as follows : What you need is: ♦ SIP amount ♦ Dates of SIP investments ♦ Date of redemption, and ♦ Maturity (redemption) amount Example: SIP of Rs 5,000 a month with redemption amount of Rs 31,000 Starting date of SIP: 01/01/2016, Last SIP date: 01/06/2016 Redemption date of SIP: 01/07/2016 (For better understanding, only six months considered) . Open an excel sheet. ♦ Step1: In column A, enter the transaction dates on the left side ♦ Step 2: In column B, enter SIP figure of 5000 as a negative figure as it’s an outflow Step 3: Against the redemption date (Column A), enter redemption amount (Column B) (31000) Step 4: In the box below 31000, type in: =XIRR (B1:B7, A1:A7)*100 and hit enter XIRR, Best Sip fund investment according to 2019's scenario : Reliance Small Cap Fund, SBI Small Cap Fund, UTI Transportation & Logistics Fund, L&T Emerging Businesses Fund, Aditya Birla SL Banking & Financial Services Fund , Mirae Asset Emerging Bluechip.