Bill Hanna uses Google's Gemini to build an INDEX/MATCH formula that finds when a startup turns profitable. He prompts Gemini to search for the first positive net income value and return the matching month, then changes revenue growth from baseline to 30% to show the result shift from June 2026 to December 2025.
C16
Row 3
Gemini (integrated assistant)
June 2026
December 2025
This AI trick with Gemini made my life super easy. If I'm reviewing a financial model with my CEO and I have various assumptions that drive the profitability cogs and opex. And I want to add a cell that says when are we profitable? And in here I just want to return the month which our net income goes from net loss to a positive net profit. So I'm going to go to Gemini, which is the icon here on top. Click on that and then write my prompt, write a formula that brings an cell. And my Cell here is C16 that searches in row for the first positive value and bring back the corresponding month from row three and we hit enter. It's going to create this index match formula for me. So I'm going to go ahead and copy my index match formula, go to C16, say equal and paste my formula, hit enter and it's going to say that my first month that we become profitable is June of 2026. I'm going to go ahead and validate. So net income as we see here is trending still negative. And yes, in June, it's the first month that we turn positive. If the model changes and my revenue is growing at 30%, you can see that now my first profitable month is dynamically changing to December of 2025. If you want to sharpen your AI skills in finance, go ahead and follow the channel.
