Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Food Truck Used Rolling Forecasts to Keep the Engine Running
Transcript
- Lucas: So there's this food truck in Portland, Mateo's Kitchen, that nearly closed last summer. Not because the food wasn't good — it was. But because Mateo, the owner, couldn't see past the next weekend's festival bookings. And that's a cash flow problem, not a cooking problem. Luna: I love a food truck example. Everyone thinks they're cash machines, but the margins are brutal. What happened? Lucas: So Mateo was doing around twelve thousand dollars a month in revenue, but it was lumpy as hell. Some weeks he'd clear three grand, others he'd barely break five hundred. And he was paying for food, fuel, permits, and a commissary kitchen — all before he saw a dime. The bank account would swing from healthy to overdrawn in a week. Luna: Classic feast or famine. So what did he do — cut costs? Lucas: He tried that. He trimmed the menu, renegotiated his produce order, even skipped paying himself for two months. But the swings were too big. What actually turned it around was something you'd normally hear from a CFO of a fifty-million-dollar company: a rolling thirteen-week cash flow forecast. Luna: Okay, that sounds intimidating. But I'm guessing it's simpler than it sounds? Lucas: Much simpler. The basic idea is you project your cash coming in and going out every week for the next thirteen weeks. Then, each week, you drop the oldest week and add a new one. So it's always a rolling thirteen-week view. Mateo started with a spreadsheet — nothing fancy. Luna: And what did that show him that his gut wasn't? Lucas: It showed him that his cash crunches weren't random — they were seasonal. He'd book big events like the Rose Festival or the Saturday Market, then have dead weeks in between. The forecast made those dips visible months ahead. He could see exactly when the bank balance would hit zero if he didn't act. Luna: So he could plan instead of panic. That's huge. Did he change how he did business? Lucas: Yeah, in a couple of ways. He started pushing for prepaid contracts with event organizers — you know, a deposit to hold the slot. And he shifted some of his menu to higher-margin items that were easier to prep. But the real win was that he used the forecast to time a small equipment loan. Luna: Tell me about that. Equipment loans and food trucks — that seems like a trap if you're not careful. Lucas: It can be. But Mateo needed a new flat-top grill — his old one was dying, and repair costs were eating him alive. Instead of waiting for the emergency, he looked at his forecast and saw that the fall festival season would give him three solid weeks of cash. So he timed the loan to close right before that, used the uptick to cover the payments, and the grill paid for itself in two months. Luna: That's smart. He didn't just borrow money — he borrowed it at the right moment. The forecast gave him that confidence. Lucas: Exactly. And it changed his relationship with his bank too. Instead of walking in with a vague 'I need cash,' he had a spreadsheet showing his expected inflows and outflows. The loan officer told him it was the first time a food truck owner came in with a 13-week forecast. They actually gave him a better rate. Luna: Of course they did. That's what bankers want — visibility. This is a great story, Lucas, but I have to ask: is this something a small business owner can actually do without an accounting degree? Lucas: Absolutely. You don't need a finance background. You need a spreadsheet and a willingness to update it every week. I'd say it's more about discipline than skill. Mateo spent maybe fifteen minutes a week on it after the first setup. Luna: And what about the people who think, 'I'm too busy cooking to do spreadsheets'? I mean, that was Mateo's first reaction too, right? Lucas: Yeah, he told me he almost didn't try it. But he had a mentor, a retired accountant who volunteered with a small business development center, who walked him through the first version. After that it was just maintenance. And honestly, the time it saved him in stress — and in avoiding overdraft fees — was way more than the fifteen minutes a week. Luna: I bet. And it's not just food trucks. I was reading about a landscaping company that used the same approach to navigate winter — you know, when revenue dries up. They'd use the forecast to decide when to take on a snow removal contract or defer a truck purchase. Lucas: Right, that's the beauty of it. The tool is industry-agnostic. Whether you're a roofer, a bakery, or a freelancer, the cash flow patterns might differ, but the forecasting discipline is the same. You're just looking at your own numbers. Luna: So what's the one thing you'd tell a small business owner to start with? I mean, if they're listening right now and thinking, 'I should do this.' Lucas: Start by pulling your last three months of bank statements. List every cash inflow and outflow by week. You'll see patterns — when you get paid, when you pay suppliers, when the big dips hit. That's your baseline. Then project forward eleven more weeks using your upcoming contracts, known bills, and a reasonable estimate for walk-up sales. Update it every Friday. Luna: And you don't need fancy software either, right? Mateo used a spreadsheet. Lucas: Yeah, Google Sheets or Excel is fine. There are also templates online — the Small Business Administration has some good free ones. But the spreadsheet is the key. It forces you to think in terms of timing, not just totals. Luna: That's a good point. I think a lot of people confuse profit with cash flow. You can be profitable on paper and still run out of cash. Lucas: Exactly. Profit is a concept, cash is a fact. And the 13-week forecast keeps you honest about that fact. It's like a map for a road trip — you don't need to predict every pothole, but you need to know the general terrain so you don't drive off a cliff. Luna: I like that analogy. So what happened to Mateo's Kitchen? Did the forecast save the business? Lucas: It did. He's now profitable eight months out of the year, which for a food truck is solid. More importantly, he has a cash reserve that covers two months of expenses. That's a first for him. And he's already used the forecast to plan his winter strategy — he's partnering with a brewery to do indoor pop-ups, which keeps revenue coming in when the weather tanks. Luna: That's great. And it's a good reminder that cash flow management isn't just about survival — it's about having options. If you know your cash position, you can say yes to the right opportunities. Lucas: Exactly. And that's the kind of confidence that changes everything. You're not just reacting to the market; you're anticipating it. And for a small business owner, that's a superpower. Luna: And speaking of superpowers, I have to say, one of the things I love about this show is that we can have these conversations without any ads interrupting us. It's a rare thing these days. Lucas: It is. We deliberately keep this show ad-free. If you find these episodes useful, and you want to support that choice, the link is buy me a coffee dot com slash fexingo. It's a simple way to say you value what we're doing. Luna: Yeah, and every bit helps us keep doing these deep dives. Now, back to Mateo — you mentioned he partnered with a brewery. That's actually a clever way to use a rolling forecast to experiment with new revenue streams. Lucas: Absolutely. Because he knew his cash baseline, he could afford to try something new without risking his core operation. He built the brewery pop-up into his forecast, projected the costs, and set a target for what it needed to bring in. If it didn't hit the numbers, he'd pull the plug after one month. Luna: That's the thing — a forecast isn't a commitment. It's a tool to test scenarios. You can ask 'what if' without putting the business at risk. Lucas: Right. And that's the mindset shift. Instead of 'I hope this works,' it's 'I can see the numbers, and I'll make a decision based on them.' That's professional. Luna: So, for anyone listening, what's the first step to get started? Like, literally today? Lucas: Open a spreadsheet right now. Label twelve columns — one for each week — and start filling in the cash you expect to come in and go out. You don't need perfect data. You just need to start. The act of writing it down will already change how you think about your money. Luna: That's practical. And I'd add: don't be afraid to ask for help. Mateo's mentor came from a small business development center, and those services are usually free. There are also tons of resources online. Just don't let the fear of spreadsheets stop you. Lucas: Exactly. And if you're in a business that has seasonal swings, like a food truck or landscaping, this is even more critical. You need to know how deep the valley is before you enter it. Luna: Well said. So the takeaway from today is: build a rolling 13-week cash flow forecast, even if it's rough, and you'll buy yourself clarity and options. Lucas: And that's the kind of foresight that keeps a business alive. Thanks for joining us, and we'll catch you next time on Cash Flow Conversations.