Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Nursery Used Rolling Cash Flow Forecasts to Fund Expansion
Transcript
- Lucas: So Luna, you know that plant nursery on the edge of town, the one with the big greenhouse and the pumpkin patch in October? Luna: Sure, Greenleaf Nursery. I drive by it all the time. They just opened a second location, right? Lucas: They did. And the interesting part isn't the new store. It's how they paid for it. The owner, Maria Chen, told me she funded the whole expansion without a single new loan. No bank debt, no equipment financing. Just cash flow. Luna: That's impressive. A nursery is about as seasonal as it gets. How do you build up that kind of cash without borrowing? Lucas: She credits something called a rolling cash flow forecast. Not a static annual budget, but a twelve-week rolling forecast she updates every single week. And it's surprisingly simple. A spreadsheet with weekly cash coming in and going out, projected out twelve weeks, and rolled forward each week. Luna: So instead of a budget you set in January and forget about, you're constantly updating your view of the next three months. Lucas: Exactly. And for a seasonal business like hers, that's huge. The whole year is a series of peaks and valleys. Spring is the big rush, then it dies in summer, then a small bump in fall with the pumpkins and mums. A static budget doesn't capture that rhythm. Luna: And the rolling forecast lets you see a cash crunch coming months before it hits. Lucas: Right. Maria told me that in late winter, the forecast showed a dip in early March, right before the spring rush. She knew she'd have about forty thousand dollars less in the bank than she needed for payroll and supplies. Because she saw it coming, she was able to push out a big supply order by two weeks and shift some marketing spend to late spring. No emergency loan, no panic. Luna: You know, that's the kind of thing that keeps small business owners up at night. The fear of the unexpected. A rolling forecast kind of takes the surprise out of it. Lucas: It does. And Maria's approach wasn't complicated. She used a simple spreadsheet. But she set it up with a few key features. First, every week, she updates actual cash in and out for the past week, then extends the forecast another week out. So there's always a twelve-week window ahead. Luna: So it's always rolling. You never have a blank spot. Lucas: Exactly. Second, she built in a 'best case' and 'worst case' scenario for each week. So not just one number, but a range. That forced her to think about what could go wrong and what could go right. Luna: And that's how she knew she could handle a slow spring or a supplier delay. Lucas: Right. She told me that in one forecast, the worst case showed she'd be down to a thousand dollars in the bank in May. That was a wake-up call. So she opened a line of credit with her bank then, even though she didn't need it. Just had it available. She never drew on it, but just having it changed her mindset. Luna: It's like having a spare tire. You hope you never need it, but you're glad it's there. Lucas: Exactly. And the forecast didn't just help her dodge problems. It also gave her confidence to make bigger moves. When she saw a consistent surplus building in her forecast, she started negotiating with suppliers for early payment discounts. She'd offer to pay in ten days instead of thirty, and in exchange, she'd get a two percent discount. That's a twenty-four percent annualized return, essentially. Luna: And that's the kind of thing that adds up to real money over a year. Lucas: It does. And it's also how she funded the expansion. She didn't just wake up one day and decide to open a second location. She had been tracking her cash flow for two years. She knew exactly what her peak season surplus looked like, and she knew what her baseline operating costs were. So when a property came up for lease near a new housing development, she was able to quickly model what the new location would do to her cash flow. Luna: And the rolling forecast let her stress-test the whole thing before signing anything. Lucas: Exactly. She ran a twelve-week forecast that included the build-out costs, the extra staff, the initial inventory, and she saw the worst-case scenario was a dip to about five thousand dollars in the bank. That was tight, but she had the line of credit as a backstop. And she had enough confidence in her spring sales to know she'd recover. Luna: So she made the leap, and it paid off. Lucas: It did. The new location opened in April, and by June, her forecast showed a twenty percent increase in cash on hand compared to the year before. She's already talking about paying off the line of credit early. Luna: You know, I love this story because it's so practical. No fancy software, no MBA. Just a spreadsheet and discipline. Lucas: And that's exactly why we wanted to share it. Look, if this conversation has given you a useful idea for your own business, honestly, if it was worth a coffee to you, that's the link. Buy me a coffee dot com slash fexingo. It's a small gesture, but it's what lets us keep the show ad-free and focused on stories like Maria's. Luna: Yeah, it really does. And we appreciate every bit of support. Lucas: So back to Maria. What I found most interesting was that she didn't just use the forecast for her own planning. She also used it to negotiate with her bank. When she went in to set up that line of credit, she brought her twelve-week forecast. The loan officer told her that most small business owners come in with an annual budget and no idea what their cash looks like week to week. Seeing a rolling forecast actually made the approval process easier. Luna: That's a great point. It shows you're on top of your numbers, which is exactly what a lender wants to see. Lucas: And that's a lesson that applies beyond nurseries. Any business with seasonal swings, or even just irregular sales cycles, can benefit from this approach. If you're a landscaper, a wedding photographer, a ski shop, a tax preparer, you have peak seasons and slow seasons. A rolling forecast helps you see the troughs ahead of time and plan for them. Luna: And the best part is, you can start today. Open up a spreadsheet, list your expected cash inflows and outflows for the next twelve weeks, and then update it every week. It doesn't have to be perfect. Lucas: Right. Maria's forecast started out pretty rough. She'd miss entries, double-count things. But the discipline of updating it every week forced her to get better. Within a few months, she had a tool that gave her a real competitive edge. Luna: And now she's opening a second location. I mean, that's the dream for a lot of small business owners, right? Lucas: It is. And it's a reminder that cash flow isn't just about survival. It's about opportunity. When you know your numbers, you can make moves that other businesses can't. Luna: So what's the one thing you'd want listeners to take away from Maria's story? Lucas: I think it's this: your cash flow forecast isn't a prediction, it's a planning tool. It's not about being right, it's about being prepared. And in a world where small business owners are constantly reacting to the unexpected, having a rolling forecast gives you the ability to act instead of react. Luna: Well said. And if you want to hear more stories like this, you know where to find us.