Master Long-Term Growth Forecasting in Excel Using the Solow-Swan Model

Forecast the Future: A Simple, Transparent Excel Model for Long-Term Growth

Forecasting decades into the future can feel like peering through a fog. Yet with the Excel Model Creator, you can illuminate the path ahead using the time-tested Solow-Swan growth model. This guide unpacks every step to build an Excel-based tool that forecasts how savings, labour, productivity and more combine to shape GDP trajectories. You’ll learn not just theory but hands-on practice: from named ranges to dynamic charts.

Along the way we’ll explore specialised extensions for public capital, total factor productivity, natural resources and human capital. Plus if you need visa support alongside your business plan, Torly.ai — The Advanced AI Agent for Innovator Founder Visa Readiness will streamline your application process. Ready to begin? Excel Model Creator by Torly.ai offers you that starting point.

Understanding the Solow-Swan Growth Model

At its core the Solow-Swan framework explains how an economy converges towards a steady-state growth path. It rests on three pillars:

• Capital accumulation: savings funnel into investment, building the capital stock.
• Labour force growth: population changes that expand or shrink work hours.
• Total factor productivity (TFP): measures technological progress and efficiency.

Whenever you tweak one variable the model recalculates how output per worker evolves. In your Excel Model Creator you embed this logic in simple formulas. For instance, net investment equals the savings rate multiplied by output minus depreciation, which then grows capital. This dynamic drives the familiar “Golden Rule” result: an optimal savings rate that maximises steady-state consumption.

To implement it you’ll need only a few rows of assumptions and a projection grid. The transparency of the Excel Model Creator ensures no hidden macros or black boxes. You can trace every line of formula to its source, audit calculations, and share with non-experts. That clarity elevates confidence in your results when you present to boards or funders.

Setting Up Your Excel Model: Step-by-Step

Turning theory into practice takes five clear steps in your Excel Model Creator:

1. Create an assumptions sheet
   – Label rows for savings rate, depreciation, population growth, initial capital per worker.
   – Format with named ranges (eg, s_rate, delta, n_pop, k0).

2. Build the projection grid
   – In year 0 set capital per worker k0.
   – Next row calculate k1 = (1 - delta) * k0 + s_rate * f(k0).
   – Use a loop of simple formulas downward for 50+ years.

3. Define the production function
   – Insert a cell for the output elasticity of capital (alpha).
   – Compute output per worker as k^alpha.

4. Automate chart updates
   – Convert your table into a named table.
   – Set up a line chart referencing table columns.

5. Stress-test scenarios
   – Duplicate your base sheet for alternative savings or TFP growth rates.
   – Add data validation drop-downs to switch scenarios on the dashboard.

Once you have this framework, the Excel Model Creator automatically recalculates your growth path whenever any assumption changes. It’s simple, fast, and requires only basic Excel skills. For offline or desktop use, you can also Download BP Build Desktop APP to keep your model at hand when you travel.

Customising Public Capital and Infrastructure Quality

Most basic Solow-Swan tools ignore the split between private and public capital. Yet infrastructure often amplifies growth. Enter the public capital extension, inspired by the LTGM-PC module.

• Separate total capital into private and public components.
• Introduce an Infrastructure Efficiency Index (IEI) that scales public stock by quality.
• Model how boosting public investment in low-stock economies yields larger growth payoffs.

In your Excel Model Creator you can add two columns for private and public capital per worker. Then compute an adjusted k_public * IEI that enters the production function alongside private capital. This allows you to test questions like: “If we double public investment over ten years, how does that shift the steady state?” The transparent layout means stakeholders grasp the mechanics immediately.

By extending the capital block, your Excel Model Creator becomes a policy-analysis powerhouse. It’s perfect for ministries or consultants plotting infrastructure plans over the next half-century.

Incorporating Total Factor Productivity Scenarios

Technology and institutions matter. The LTGM-TFP extension delivers a data-driven path for TFP growth using a composite index. It combines metrics on innovation, education, market efficiency, infrastructure, and governance.

To fold TFP forecasts into your Excel Model Creator:

• Create a separate sheet for TFP determinants and their weights.
• Run a fixed-effects regression externally to produce a projected TFP growth rate series.
• Link the results back into your main workbook so that each period’s output reflects TFP_growth + α × capital_growth.

This method transforms your model from a static assumption to a scenario engine grounded in real-world indicators. You can now ask: “What if our institutional reforms accelerate productivity by 0.5% annually?” and immediately see GDP and consumption curves update.

For teams needing offline support you can also Build Your Endorsement Application with 6 AI Agents that guide you through document prep and business plan alignment with international standards.

Mid-Article CTA

At this point, if you’re keen to streamline the core build and get immediate hands-on guidance, why not Get started with the Excel Model Creator? It’s a practical launchpad for any long-term growth analysis.

Analysing Natural Resource Dependencies

Resource-rich economies face unique dynamics. The LTGM-NR extension adds a commodity sector that lets you forecast the impact of price shocks, discoveries, and fiscal rules like the Hartwick rule.

In the Excel Model Creator:

• Add a revenue line for resource exports at projected prices.
• Subtract resource fiscal flows based on your chosen rule (eg, reinvestment rate).
• Integrate real gross domestic income (GDI) changes into total output.

This lets you simulate commodity booms and busts over decades. For example, you can test how channeling 20% of resource revenue into public capital alters growth compared to a balanced budget approach. It’s a ready-made extension to your baseline, requiring only a few extra rows of data.

Adding Demographics and Human Capital Forecasts

Human capital drives productivity too. The LTGM-HC module uses cohort-based schooling and health metrics to forecast when education reforms pay off.

To bring this into your Excel Model Creator:

• Set up age cohorts with learning-adjusted years of schooling and health indices.
• Compute a workforce-level human capital series that changes as new cohorts enter.
• Feed that series as an additional multiplier in your production function.

This dynamic analysis reveals lags: you might boost pre-tertiary quality today yet only see output gains two decades later. By embedding it in your Excel Model Creator, you gain a full picture of how demography, health and schooling factor into growth.

Visualising Results and Building Interactive Dashboards

All the data in the world won’t persuade decision-makers unless it’s digestible. Transform your Excel Model Creator into a dashboard hub:

• Use slicers and timeline controls for scenario switching.
• Embed key metrics in info-boxes that update automatically (eg, peak GDP year, steady-state output).
• Create a summary page with sparklines and conditional formatting to flag critical thresholds.

Interactive dashboards make meetings lively. You can tweak a slider for savings rate and watch charts animate. That level of engagement ensures stakeholders grasp trade-offs quickly, without wading through raw tables.

Finally, if charting options feel overwhelming, consider Your AI-powered assistant for UK Innovator Founder Visa business plan preparation to keep your project documentation crisp and visa-ready in parallel.

Conclusion: From Theory to Boardroom Confidence

You’ve now built an Excel Model Creator that spans the classic Solow-Swan model through extensions for public capital, TFP, resources and human capital. Each module slots into the same transparent workbook, making it easy to trace assumptions and share insights.

Embrace the Excel Model Creator to guide investment, policy and risk decisions over decades. And remember, beyond modelling economics, you can rely on Torly.ai — The Advanced AI Agent for Innovator Founder Visa Readiness if you’re applying for UK endorsement. Now it’s over to you: craft scenarios, stress test extremes, and present with confidence. Unlock long-term insights with the Excel Model Creator