Cash Flow Projection Models

How to Build a Financial Model from Scratch (Step-by-Step) Most aspiring analysts get stuck not because financial modeling is hard… …but because no one ever shows them the actual process to start from zero. Here’s the exact step-by-step approach I teach and use 1. Understand the Business First Before Excel even opens. → What does the company do? → How does it make money? → What are its key drivers (pricing, volume, cost structure)? Without this clarity, your model is just numbers without meaning. 2. Gather the Right Data → Historical financials (3-5 years) → KPIs and segment data → Assumptions from management or research → Industry benchmarks → You’re building a story. Data is your raw material. 3. Lay Down the Skeleton → Start with a clean workbook. → Structure it like this: - Assumptions - Income Statement - Balance Sheet - Cash Flow Statement - Supporting Schedules (debt, depreciation, working capital) - Outputs & Valuation - Clarity of layout = clarity of thought. 4. Input Historicals Smartly → No hardcoding all over the place. → Use clean linking, color codes, and consistent formatting. → This sets the foundation for trust in your model. 5. Build the Projections Now the fun begins: → Project revenue and costs using drivers → Forecast balance sheet items based on logic (e.g., Days Receivables) → Ensure everything flows to cash → Watch for circular references in interest and revolvers 6. Add Schedules and Connect Everything → Depreciation & CapEx → Debt & Interest → Working Capital These links bring life to your model. They tell the real financial story. 7. Plug in Valuation → Now that you have free cash flows, layer in DCF or Comps. → Optional: Scenario and sensitivity analysis. That’s how top analysts stress test. 8. Review, Audit, and Polish → Check signs (Balance Sheet should Tall if this is rightly done) → Print preview → Add sanity checks → Color coding and formatting → If you wouldn’t present it to a client or MD, don’t call it done. Building a financial model gets you thinking like a business owner, being detail-obsessed, and crafting a tool that drives real decisions. And that’s a skill recruiters, investors, and bankers respect. Follow Pratik for investment banking careers and education

Capex models that don’t show payment timings aren’t forecasts. Here’s a model structure I use with clients that fixes this. In this example you see 3 capital investments for a food company: • Commercial kitchen buildout • Tempering machine • Automatic filler Each one is modeled separately, but they all feed the same integrated forecast. Here’s what makes it work so well: 1) Cash flow timing is everything A $800K kitchen buildout doesn’t hit cash on day one. There’s a deposit ($80K in February), a first phase ($360K in April), and a second phase ($360K in June). Miss that staging and your cash flow forecast is just wrong — even if the total is right. Drop-down selectors for each payment date let you update timing without rebuilding the model from scratch. 2) Depreciation runs on autopilot Each asset has a useful life assumption (15, 5, and 7 years respectively). From that single input, the model auto-calculates monthly depreciation. I use a mid-month convention in the first partial month. There are manual schedules and no formula overrides. Change the capex assumption and the whole schedule updates. 3) Scenario toggles At the top: three checkboxes (In Excel, you’ll find these on the Insert Ribbon). Check or uncheck to include or exclude any investment from the forecast. Why does this matter? Because zeroing out cells is permanent and can’t easily be brought back. Toggles let you run “what if we defer the kitchen?” without losing a single assumption. 4) Tie to operations It’s always wise to add tags that identify what the operational implications are. For the introduction of the commercial kitchen, that’s likely to reduce direct costs. So if the capex it toggled on, it should hit the P&L. If the capex is toggled off, it should do the opposite. The goal isn’t just to model capex — it’s to model decisions. The more integrated the forecast with the P&L and cash flows, the better. ⚡️ If you’d like to see how good cash flow modeling can be done with dynamics and automation, I’ll be doing a session to show you.

Do you even realize just how powerful a well-built Three-Statement Model can be? When you truly understand how the Income Statement, Balance Sheet, and Cash-Flow Statement flow into one another, and how the supporting schedules knit everything together, you unlock a toolkit that scales far beyond “textbook” budgeting. Here’s why those connections matter: ⨠Cause & effect comes to life. Change revenue recognition and you instantly feel the ripple in working capital, taxes, and cash. ⨠Checks & balances are built-in. The model’s dynamic logic forces every schedule (revenue, cost, capex, debt, equity, taxes, working capital) to reconcile, highlighting errors before they can hide in the numbers. ⨠Storytelling becomes sharper. A single assumption tweak tells a cohesive story across all three statements, exactly what boards, investors, and lenders want to see. 🔍 Master the foundations first, then level-up to tackle bigger questions like: ⁕ Full DCF valuations & sensitivity trees (equity or project finance) ⁕ Scenario-based cash runway planning for startups or high-growth SaaS ⁕ Debt-capacity & covenant headroom analysis in leveraged deals ⁕ LBO and recap structures with complex waterfall returns ⁕ Working-capital optimization and financing strategies (DSO/DIO/DPO) ⁕ Integrated stress testing & reverse stress cases for risk management ⁕ M&A accretion/dilution and synergy tracking ⁕ Tax-efficient structuring & NOL utilization ⁕ Capital allocation frameworks (dividends vs. buybacks vs. reinvestment) ⁕ Operational driver dashboards that tie KPIs directly to cash flow Whether you’re an analyst building your first model or a CFO steering strategic decisions, the Three-Statement backbone is the launchpad. Nail the linkages and those basic schedules will scale with every “what-if” the real world throws at you. I’m curious how you are leveraging your models for next-level insights! Drop a comment. Let’s compare notes! 👇 #Finance #FinancialModeling #ThreeStatementModel #FPandA #CorporateFinance #LinkedInLearning

I've reviewed cash flow forecasts for businesses from $1M to $500M. The same mistake appears every time. They forecast revenue instead of cash. Here's the difference: You close a $100,000 sale in Week 5. Your forecast shows $100,000 cash in Week 5. You plan accordingly. You hire. You invest. Week 5 arrives. Zero dollars hit your account. Because sales Week 5 means invoice Week 6 means payment Week 12. Seven weeks between sale and cash. Your forecast just killed your cash flow. Fix: Forecast when cash actually moves, not when sales happen. This one change improves forecast accuracy by an average of 34% in 90 days. Your 13-week forecast should show exactly when money hits your account. Not when customers commit. Not when you invoice. When the dollars arrive. The businesses that master this see problems six weeks before they hit. The ones that don't see problems when it's too late to fix them.

Essential Techniques: Effective Cash Flow Forecasting Effective cash flow forecasting is crucial for financial stability and planning future growth in banking. Accurate forecasting ensures banks can meet obligations, manage unexpected expenses, and seize opportunities. Forecasting starts with analysing historical data to identify patterns and trends, aiding in accurate predictions. Scenario planning involves developing best-case, worst-case, and most-likely scenarios to prepare for various financial situations. Rolling forecasts, which involve continuously updating projections with the latest data, allow banks to adjust forecasts based on changing market conditions and business activities. Detailed categorisation of cash flow into operational, investing, and financing activities helps identify areas needing attention or improvement. Technology integration enhances forecasting accuracy and efficiency. Advanced financial software, including artificial intelligence and machine learning, analyses vast amounts of data to identify patterns and provide precise forecasts. This streamlines forecasting processes and enables data-driven decisions. Collaboration across departments is crucial. Input from sales, operations, and finance ensures all relevant data is considered, fostering shared responsibility and informed decision-making. Monitoring economic indicators like interest rates, inflation, and market trends is essential for anticipating changes that could impact cash flow. Stress tests evaluate the bank’s cash flow under extreme conditions, simulating adverse scenarios to assess resilience and identify vulnerabilities. This allows treasurers to develop contingency plans to ensure financial stability. Regular review and adjustment of cash flow forecasts maintain accuracy and relevance. Forecasts should be updated to reflect actual performance and changes in the business environment, ensuring alignment with financial goals and market conditions. Engaging stakeholders, including senior management and board members, ensures alignment with strategic objectives. Transparent reporting builds confidence and facilitates informed decision-making, supporting the bank's overall strategy and long-term success. In summary, effective cash flow forecasting combines historical analysis, scenario planning, continuous updates, and technological integration. By employing these techniques, banks can achieve accurate predictions, better financial management, and preparedness for future challenges and opportunities. These practices are essential for maintaining financial stability and achieving long-term success in the dynamic banking environment.

Most startup financial models are beautiful lies. I’ve reviewed hundreds of early-stage models. And the pattern is clear: → CAC magically drops over time → Churn is “estimated” but never tracked → LTV isn’t calculated or worse, inflated → Headcount costs are wildly optimistic → There’s a “Misc” tab with $1.2M in it Why does this happen? Because founders treat models like investor theatre. Built to impress. Not to operate. The cost? → You raise capital with zero visibility on runway → You overhire and miss your margin targets → You make roadmap bets you can't actually afford → And worst of all? You realize too late that the business model doesn’t work Your model isn’t a pitch prop. It’s your decision engine. A good one should answer: → What happens if CAC jumps 25% next quarter? → Can we delay the next hire and still hit targets? → What’s real runway after expansion churn? If you can’t get those answers, you don’t have a model. You have a spreadsheet in a blazer. Here’s how to build one that actually works: 1/ Start with a clear purpose → What decisions should this model help you make? Hiring plan, pricing strategy, runway clarity? Be specific from day one. 2/ Ground it in real systems → Pull actuals from your CRM, accounting, and payroll. Your model is only as useful as the data it’s built on. 3/ Link your core financials → P&L, Balance Sheet, and Cash Flow should speak to each other. If they don’t, your forecast can’t be trusted. 4/ Segment revenue realistically → Break revenue down by product, customer type, or geography. Model retention, expansion, and churn by cohort — not hope. 5/ Reflect costs with accuracy → Include real team ramp times, founder comp, tech debt, and overlooked ops costs. This is where most risk hides. 6/ Run scenarios, add sensitivity → Best case, worst case, base case. Play with CAC, churn, and pricing levers. Your model should answer “what if?” 7/ Use and update it regularly → If your model isn’t revisited monthly, it’s already outdated. It should evolve with your business — not collect dust post-fundraise. Bottom line? If your model looks polished but doesn’t drive decisions.. Rebuild it. Your business depends on it. PS: Curious, what’s the one metric you check first when you open your model? ——— Need help making the numbers make sense? I’m Mariya. Fractional CFO for SaaS startups. I help founders get clear on what the numbers are really saying. 📩 DM me if your model doesn’t match your reality.

🚀 How to Build a Financial Model for Finance based Case Competitions like FinShiksha Learning Championship Building a solid financial model is often the game-changer in such competitions. Here's a simplified framework I follow, 🔸 Step 1: Income Statement – Forecasting Revenue & Costs Start by identifying revenue drivers — volume x price. 📌 Read earnings call transcripts 📌 Look for Capex announcements → Capex ↑ = Capacity ↑ = Revenue ↑ 📌 Watch for cost optimization signals: • Moving to lean teams → Lower employee costs • Shifting to renewable energy → Lower power bills 🧠 Pro tip: A switch from grid electricity to in-house solar can drastically reduce ₹/kWh costs in the long term, look for historical trend to validate your hypothesis 🔸 Step 2: Balance Sheet – Build Working Capital, Debt & Fixed Asset Schedule To forecast balance sheet items, focus on: 📊 Working Capital Schedule • Use historical ratios for Inventory Days, Payable Days, Receivable Days • Apply them to future projections to get WC changes 📉 Debt Schedule • Review historical Capex funding: Debt vs Equity • If new Capex is planned, model fresh debt/equity infusion accordingly 💡 Fixed Asset Forecasting Tip: Always link the net block (not gross block) to the balance sheet. 🔹 Net Block = Gross Block - Accumulated Depreciation Mixing them up leads to balancing errors. For items like "Other Non-Current Assets" or "Misc. Provisions," keep them constant unless specific info is available. 🔸 Step 3: Cash Flow Statement – Let the Balance Sheet Drive It Cash flow is derived, not assumed. ✔️ Changes in WC, depreciation, Capex from BS go here ✔️ Always check if your final Cash Balance tallies with the Balance Sheet If not — double-check depreciation or missed items in fixed asset schedules. 🔸 Step 4: WACC Calculation – Know Your Discount Rate 📌 Components: • Risk-Free Rate (10Y G-Sec) • Beta (Sector avg or listed peer) • Equity Risk Premium (Sensex/Nifty 500 CAGR) • Cost of Debt (Check company's credit rating and refer the corresponding bond yields for this rating) 📈 Post-tax Cost of Debt = Pre-tax Cost × (1 - Tax Rate) 📉 WACC = Weighted Avg of Cost of Equity & Cost of Debt 🔸 Step 5: DCF Valuation – Find Intrinsic Value 📍 Use forecasted Free Cash Flows to the Firm (FCFF) 📍 Discount them using WACC 📍 Add Terminal Value using Gordon Growth Model 📍 Subtract net debt → Get Equity Value 🧮 Divide by shares → Get Target Price per Share 🔸 Step 6: Relative Valuation – Use Market Multiples 📊 Key multiples: • EV/EBITDA • EV/Sales • P/E • P/B 🎯 Sector-specific multiples are powerful: → E.g., EV/ton for cement, EV/subscriber for telecom, EV/bed for hospitals 📌 Final Tip: Always triangulate your valuation — DCF + Relative This framework has helped me structure and approach finance-based case competitions effectively. One should think like an investment analyst while preparing for such cases, ensuring that every assumption made is backed by clear rationale.

You just finished a $2M project. Made 18% margin on paper. And you can't make payroll next week! This is the cash flow paradox that breaks contractors, and most don't see it coming until they're scrambling. Here's what happened: You bid the job tight to win it. Materials went on your credit line upfront. Labor got paid every two weeks. Subs invoiced on their schedule. Meanwhile, the owner is paying on net-30 (or net-45, or net-60 if it's a GC). Plus 10% retainage held until final completion. Plus change orders that won't get approved for another billing cycle. So you're $300K out of pocket before the first real payment hits your account. The project closes. Your accountant says you made great margin. The P&L looks clean. But your bank account is empty. Because profit and cash are not the same thing. The culprit? Nobody's forecasting cash flow at the project level. They're tracking job costs (what they spent). They're tracking billings (what they invoiced). But they're not tracking cash timing, when money actually moves. Here's what changes the game: Weekly cash flow modeling per project. Not complicated. Just: What are we spending this week? (labor, materials, subs) What are we billing this week? When will that payment actually hit the bank? (not when invoiced—when paid) What's our cash position 30, 60, 90 days out? The contractors who do this? They know exactly which projects are cash-positive and which are cash drags. They can see the crunch coming 6 weeks out and adjust (delay equipment purchases, negotiate sub payment terms, accelerate billing). They stop being surprised by cash flow problems because they're managing cash flow, not just hoping it works out. If you're sitting on a great backlog but constantly stressed about cash, you don't have a sales problem. You have a cash flow visibility problem. Fix that, and the stress drops by half. How many of you have been "profitable on paper" but scrambling to cover expenses? Let's talk about it. #Construction #ConstructionBusiness #ContractorLife #AIinConstruction #ConstructionTech #CashFlow

Burned through Series A in 8 months. Here's the cash management framework that saved us. Growing fast and running out of money isn't ironic - it's predictable. Revenue growth without cash flow discipline kills more promising startups than product failures. The 5-3-1 Cash Rule: • 5 months: Minimum runway before raising next round • 3 scenarios: Best case, likely case, worst case planning • 1 person: CEO owns cash flow, updates weekly Monthly cash flow tracking essentials: contracted ARR, pipeline probability, fixed vs variable costs, and customer payment terms. Real example: SaaS company with $200K MRR looked healthy until we mapped payment terms. 60% of revenue came with 60-day payment cycles. They needed bridge funding despite strong growth metrics. Build a 13-week rolling cash flow model this Friday. Update every week without exception to avoid cash crunches. #CashFlow #StartupFinance #Fundraising #StartupAdvice #BusinessMetrics #Entrepreneurship #StartupStrategy #FinancialPlanning

A construction and excavation company owner came to us doing ~$3M a year with 22 employees. His P&L said profitable. His bank account said otherwise. Every Wednesday night he was moving every dollar into checking just to make sure payroll would clear Thursday morning. Here’s what we built before anything else could change: 1. We went line by line through every expense category and recategorized costs that were hiding below the gross margin line. Equipment maintenance, depreciation, project manager salaries — all sitting in operating expenses instead of COGS. His “real” gross margin was significantly lower than what the books showed. But now it was a number he could actually use. 2. We mapped every dollar of debt into one document. SBA loan, line of credit, a six figure hard money loan at 34% interest he’d taken out just to make payroll. Found an early payoff clause buried in the contract that saved roughly $36,000 in interest. 3. We reorganized his P&L from a single “services” revenue line into four distinct streams (commercial excavating, residential excavating, commercial sewer/water/septic, and residential). For the first time he could see which work was actually making money and which wasn’t pulling its weight. 4. We built a real cash flow projection using a seven-month rolling average. He could finally model scenarios instead of guessing: “If I pay off these two loans and keep four crews running, what does cash look like in six months?” 5. We established a monthly close process with his bookkeeper. By the 15th of every month, the prior month was locked. No more making decisions off financials that were three months old and still in flux. By the time a major growth opportunity showed up (launching a fiber optic utility division) he had the financial framework to model it before committing a dollar. Most contractors try to scale their way out of financial fog. The ones who scale successfully clear the fog first. How confident are you that your P&L is telling you the real story?