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:
- Month
- Investment Amount
- NAV
- Units Purchased
- Total Units
- Current Value
- Returns

- 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

**Example**

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 |

1 | ₹10,000 | ₹100 | 100 | 100 | ₹12,000 | 20% |

2 | ₹10,000 | ₹120 | 83.33 | 183.33 | ₹22,000 | 120% |

3 | ₹10,000 | ₹140 | 71.43 | 254.76 | ₹35,600 | 256% |

… | … | … | … | … | … | … |

120 | ₹10,000 | ₹200 | 50 | 750 | ₹150,000 | 1500% |

*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**