How does MProfit compute the total gain value and percentage in XIRR reports?

Modified on Fri, 26 Apr at 1:12 PM


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


Follow the step-by-step guide below:


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. 



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



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)



Step 5: Click All Assets


Image


Step 6: 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 the total gain value and percentage 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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article