This issue is purely because of over leverage on the customer front and currently this is in microfinance business only. MFIs lacked discipline, went on crazy to lend. They created this mess themselves.

Rate cut or raise will have small impact in margin here and there, this will not have relation to asset quality. My personal view, Interest rate cut doesn’t mean these companies will do well

Just a feedback: I wish I could see pricing without having to sign up.

Hi ValuePickr community,

I’ve been developing a web-based stock trading simulator and wanted to reach out to this knowledgeable community for feedback. The goal of the platform is to allow traders to test strategies and practice without financial risk.

Here’s what it offers:

• $500,000 virtual trading bankroll to simulate real-world trading scenarios.
• Up to 5 years of historical data, so you can backtest strategies across different market conditions.
• Anonymous leaderboards to track your performance without sharing personal details.
• Detailed trading metrics to help refine your strategies.
• Completely free and web-based, no downloads needed.

I would greatly appreciate any feedback or suggestions for improvement. Whether you’re an experienced trader or just testing strategies, your insights would be invaluable in refining the platform.

Here’s the link: simul8or.com

Thanks in advance for your time!

Banks/ NBFCs also do micro finance lending and the vice versa Microfinance institutions also do MSME and other loans. In my view the classification of the lending business should be secured vs a vs unsecured lending. The present problem is shown as the problem segregated to the MFIs only and the other lending businesses are fine. Is it that the problem will not percolate to the other lending businesses and the MFIs will only face the headwinds resulting to the value compression from its peaks of P/BV multiple of 3 to 0.2 ( in an extreme passimism) or MFIs are just ahead of the downward curve in the whole financial sector? As the rate cuts are just round the corner this situation would have been avoidable. Fusion Finance had a picture perfect situation up to FY 24 with ROE of 20%, ROA of 5% along with doubling AUM every alternative years and everything got melted in 4-5 months that too when the rate cut cycle is about to start! Please help me as I am unable to connect the dots. I had a perception that MFIs would do well in the rate cut cycles that doesn’t seem so far.

Hey, I have been investing in the stock market for the last three years and, like many of you, I’ve encountered the challenge of calculating accurate returns from my portfolio. With irregular investments across two different Demat accounts, calculating my returns manually became a tedious task. To streamline this process, I created a Google Sheets XIRR Calculator for my stock portfolio, which helps me track my returns effectively and perform multiple analyses like CAGR, stock performance, and much more.

In this post, I’ll walk you through how I set up the Google Sheet and how you can use it to analyze your own portfolio.

Google sheet Link : XIRR Calculator , Make a copy of this sheet for personal use.

( I referred to a helpful YouTube video uploaded by Vaibhav Jain while creating this Google Sheet, which explains how to calculate XIRR for stock portfolios and mutual funds. You can follow that video to set up a similar calculator for mutual funds as well.)

Why I Needed This XIRR Calculator

As I mentioned, my investments have been irregular. Given the different dates and amounts of my stock purchases, a simple CAGR calculation wouldn’t be accurate for assessing my performance. XIRR (Extended Internal Rate of Return) solves this problem by taking into account the exact timing of each cash flow (investment or sale). However, most Demat platforms don’t provide a detailed XIRR report. That’s why I built this Google Sheet to automate the process.

Key Features of My XIRR Calculator:

1. XIRR Calculation: Automatically calculates the XIRR of my portfolio based on trades.
2. CAGR and Profit & Loss Analysis: Provides additional insights into the performance of each stock.
3. GoogleFinance Function Integration: Automates some key data like current stock prices and overall portfolio value.
4. Manual Trade Data Entry: You need to upload your trade data manually from your Demat account broker statement into the sheet.

Step-by-Step Guide to Using the Sheet

1. Export and Upload Your Trade Data

To get started, export your trade data from your broker’s statement into an Excel file. Typically, your broker will provide this statement in a CSV or Excel format.

Next, copy and paste the necessary columns (like stock name, trade date, buy/sell, and trade amount) into the Trades Table in the Google Sheet. Ensure that the date format is correct; this is critical for the XIRR calculation to work properly.

2. Sort Your Data

After pasting the trade data, make sure to sort the table A-Z on two important columns:

• First, sort by stock name (Column 1).
• Then, sort by the date column A-Z, so your trades are listed in chronological order.

This sorting is essential for accurate calculations and a clean display of your trades.

3. Automating Stock Data with GoogleFinance

I added a feature that calculates the profit and loss (P&L) for all unique stocks in my portfolio. The stock names are automatically derived from the Trades Table, but here’s where things get tricky: the GOOGLEFINANCE function doesn’t recognize stock names unless you input the ticker symbol.

To resolve this, I manually enter the ticker symbols (e.g., NSE:RELIANCE for Reliance Industries) into another table. Once I input the ticker, the GOOGLEFINANCE function retrieves the current stock price and other relevant data like market value, which makes the overall calculation dynamic and insightful.

While manually entering the ticker symbols might seem like extra work, it’s exciting to see your portfolio’s real-time value and XIRR as the stock prices update automatically. I also added conditional formatting for fun—so you’ll see your stock’s performance in color-coded form!

4. How to Maintain and Update the Sheet

Once you’ve set up the Google Sheet, it’s pretty easy to maintain. I update my sheet once or twice a week by copying and pasting new trades from my Demat account’s broker statement. Since the formulas and functions are already set up, all I need to do is paste the new data and the sheet takes care of the rest, giving me updated XIRR, CAGR, and P&L for each stock.

Challenges I Encountered

One of the minor challenges I faced was ensuring that the stock names were correctly mapped to the ticker symbols. The GOOGLEFINANCE function only works with valid ticker symbols, so manually entering them became necessary. However, once done, the sheet runs smoothly, and the effort is well worth the insights I get.

Conclusion

I encourage you to try creating a similar Google Sheet for your portfolio. It’s a powerful way to calculate your returns, analyze stock performance, and get detailed insights into your investments. If anyone’s interested in further details or needs help setting up their own version, feel free to reach out! Happy investing!

I am not a SEBI-registered advisor, and the information shared here is purely for educational purposes based on my personal experience. The trade data included in the sheet is a sample for illustrative purposes and should not be taken as actual trading recommendations.

Looking forward to your feedback and thoughts!