We have offered a downloadable Excel sheet for mutual fund SIP calculation. This is a free XLSX file to do your investment-related work. In this blog post you know about How to calculate mutual fund returns in excel!
To calculate SIP returns in an Excel sheet, you can use the following steps:
- Create a new Excel spreadsheet.
- In the first row, list the following headings:
- Investment Amount
- Units Purchased
- Total Units
- Current Value
- In the second row, enter the following information:
- Month: The month in which you invested.
- Investment Amount: The amount of money you invested in that month.
- NAV: The net asset value of the mutual fund on the day of investment.
- Units Purchased: The number of units you purchased with your investment amount.
- To calculate the number of units purchased, use the following formula:
Units Purchased = Investment Amount / NAV
- To calculate the total units, use the following formula:
Total Units = Sum of Units Purchased in each month
- To calculate the current value, use the following formula:
Current Value = Total Units * Current NAV
- To calculate the returns, use the following formula:
Returns = (Current Value – Total Investment) / Total Investment
- Repeat steps 2-7 for each month that you have invested in.
- To calculate the overall returns on your SIP investment, use the following formula:
Overall Returns = (Current Value – Total Investment) / Total Investment
Let’s say that you have invested ₹10,000 per month in a mutual fund for a period of 10 years. The NAV of the mutual fund on the day of your first investment was ₹100.
To calculate your SIP returns in an Excel sheet, you would enter the following information:
|Month||Investment Amount||NAV||Units Purchased||Total Units||Current Value||Returns|
The overall returns on your SIP investment would be 1500%. This means that you have tripled your investment amount over a period of 10 years.
Use this financial tool mutual funds calculator