How MProfit computes Total Gain value and % in XIRR reports?

Modified on Fri, 29 Mar 2024 at 10:30 AM


In this tutorial, we will explain how you can compute Total Gain value and % in XIRR reports MProfit.


Step 1:  Login to your MProfit account and select your desired AIF fund.


Here, we have taken Artelia Capital Fund I- Scheme II as an example. 


Image


Step 2: In the next window, keep the Period as All To Date from the drop-down list. 


Image


Step 3: 

  1. Initial investment made on March 6, 2020, was ₹1,00,000.

  2. On March 16, 2022, there was a withdrawal of ₹40,000.

  3. On January 17, 2024, an interest payout of ₹10,000 was received.

  4. The closing value is ₹60,000, and the manually kept current value is ₹75,000.

  5. Calculate the total gain using the formula: Total investment - Current value. Total investment = ₹1,00,000, Current value = ₹75,000. Total gain = ₹1,00,000 - ₹75,000 = ₹25,000.

  6. Calculate the total gain percentage using the formula: (Total gain / Total investment)  100. Total gain = ₹25,000, Total investment = ₹1,00,000. Total gain percentage = (₹25,000 / ₹1,00,000)  100 = 25%.

  7. Verification: Check the Reports tab for accuracy.

Image


Step 4: Click Performance and select Annualised Return (XIRR)


Image


Step 6: Click All Assets


Image


Step 7: Finally, click Generate Report


Image


As evident from the data, the overall increase amounts to twenty-five percent.


This is how you can seamlessly compute Total Gain value and % in XIRR reports in MProfit!

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article