Input cells marked in green
                                      Select Duration
                             From                       To
                   Year    Month    Day     Year     Month   Day
                       2005       1        1    2014       12      31
                           1-Jan-2005               31-Dec-2014
                   Monthly SIP           ₹1,000
                   Amount invested                            ₹120,000
                   Final Value      Nifty 100        Nifty 500
                   Daily SIP                 ₹238,262         ₹231,725
                   Weekly SIP                ₹238,336         ₹231,849
                   Monthly SIP               ₹239,060         ₹232,531
                   IRR              Nifty 100        Nifty 500
                   Daily SIP                  13.23%           12.70%
                   Weekly SIP                 13.25%           12.73%
                   Monthly SIP                13.21%           12.70%
                   Days in observation          2483
                   Weeks in observation          522
                   Months in observation         120
                   Daily SIP                    48.33
                   Weekly SIP                  229.89
                   Monthly SIP                1000.00
                           Advanced
                    Estimated Returns   10%
                              How to use this Workbook
           Change the cells in Green
           Acceptable dates in range are 1-Jun-2004 to 1-May-2021
           Advanced
           The Estimated Returns filed shouldn't be altered in most cases. In case the tool fails to show Internal Rate of 
           Return for special cases (example: very short period or a period having very high market movements) change the 
           value from the list
           Disclaimer: This analysis is for understanding performance of selected indices under various periodic investments. 
           This is for informational purposes only and should not be construed as recommendation or advice. Returns 
           provided are not an indicator of future performance.
How to use this Workbook
Change the cells in Green
Acceptable dates in range are 1-Jun-2004 to 1-May-2021
Advanced
The Estimated Returns filed shouldn't be altered in most cases. In case the tool fails to show Internal Rate of 
Return for special cases (example: very short period or a period having very high market movements) change the 
Disclaimer: This analysis is for understanding performance of selected indices under various periodic investments. 
This is for informational purposes only and should not be construed as recommendation or advice. Returns