A research-driven valuation and investment analysis pack for GlobalFoundries Inc., covering the semiconductor foundry business model, operating drivers, valuation framework, source library, and model update process.
This repository contains an institutional-style investment case built around a maintained valuation model and supporting research library. The core asset is intended to be a DCF and comparable-company valuation framework supported by reported financials, investor materials, company research, end-market analysis, operating datasets, and final output materials.
The model is designed to be updated over time as new quarterly reports, Form 6-K filings, investor presentations, operating metrics, capacity data, comparable company data, and industry research become available. The repository is organized so that sources, assumptions, and outputs can be reviewed and refreshed without rebuilding the analysis from scratch.
The Excel workbook is intended to be structured around a control page, operating build, valuation tabs, comparable company analysis, and supporting assumptions.
| Tab | Purpose |
|---|---|
| Exec Summary | High-level model output, key valuation takeaways, and investment case summary. |
| Cover | Control panel, valuation summary, scenario selectors, and upside/downside summary. |
| Operating Build | Revenue, margin, capex, cash flow, and key operating driver forecast. |
| DCF | Consolidated discounted cash flow valuation. |
| WACC | Cost of capital assumptions. |
| Ratios | Financial and valuation ratio analysis. |
| Graphs | Visual outputs and supporting charts. |
| Foundry Comps | Comparable company analysis for semiconductor foundries and related peers. |
| Actuals | Reported financial data from quarterly financials and Form 6-K filings. |
| Historicals | Historical operating and financial assumptions. |
The model is intended to be usable as a working valuation file rather than a static output. Scenario selectors, operating assumptions, peer multiples, WACC inputs, and historical data can be refreshed as the research base evolves.
This repository is broader than a single Excel workbook. It is intended to function as a complete valuation pack containing:
00_Index.xlsx Central index of key sources and files.
01_Filings Primary filings, regulatory documents, government disclosures, and official source documents.
02_Investor_Materials Company presentations, investor materials, fundraising documents, factsheets, and management materials.
03_Financial_Reporting Financial reports, transcripts, earnings materials, conference transcripts, and management commentary.
04_Research Broker reports, industry reports, competitor research, TAM studies, and valuation research.
05_News News articles, funding rounds, M&A announcements, major contracts, and important developments.
06_Operating_Data Model input datasets such as revenue by end market, wafer metrics, capacity, utilisation, capex, and peer multiples.
07_Model Main Excel valuation model, archived versions, and model cover image.
08_Output Investment memos, valuation summaries, presentation decks, and final outputs.
The repository is designed for periodic maintenance as new information becomes available.
Quarterly updates may include:
- Add new operating data.
- Refresh comparable company trading multiples.
- Update WACC assumptions.
- Update wafer shipments, ASP, capacity utilisation, capex, gross margin, and free cash flow assumptions.
- Reconcile new actuals or management commentary.
Annual updates may include:
- Rebuild historical financials.
- Refresh long-term assumptions.
- Update TAM and industry research.
- Review DCF assumptions.
- Refresh scenario cases.
- Archive prior model versions.
This repository can be used for:
- Learning valuation modelling.
- Understanding GlobalFoundries' business model.
- Practicing investment research workflows.
- Tracking semiconductor foundry operating assumptions.
- Building repeatable investment case repositories.
This project is for educational and research purposes only. It is not financial advice, investment advice, or a recommendation to buy or sell any security.