THE WORKING LIBRARY

Go inside the numbers.

28 Excel workbooks connect the articles to editable assumptions, calculations, and scenarios. Included in the planned research membership.

Start with a free calculator →
EXCEL WORKBOOK / AMBC-01

Credit Readiness and Cash Cycle Workbook

Follow the money from regional infrastructure to the business next door.

Companion article: Capital and the business opportunity. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / AMBC-02

Credit Readiness and Cash Cycle Workbook

Follow the money from regional infrastructure to the business next door.

Companion article: Credit that fits the business. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KTHF-01

PAYE and Cash Flow

Build a working plan for your payslip, pension, healthcare, and home.

Companion article: What the payslip can fund. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KTHF-02

Pensions and Retirement

Build a working plan for your payslip, pension, healthcare, and home.

Companion article: Pension contributions over time. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KTHF-03

Medical and Emergency Funds

Build a working plan for your payslip, pension, healthcare, and home.

Companion article: Healthcare and accessible cash. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KTHF-04

Mortgages and Housing

Build a working plan for your payslip, pension, healthcare, and home.

Companion article: Housing the household can keep. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KECA-01

Screening and Income

Read the business, test its value, and build a portfolio with a purpose.

Companion article: Income and the research universe. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KECA-02

Statements and Valuation

Read the business, test its value, and build a portfolio with a purpose.

Companion article: Statements and valuation. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KECA-03

Portfolio Construction

Read the business, test its value, and build a portfolio with a purpose.

Companion article: Portfolio construction. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / KECA-04

Compounding and Simulation

Read the business, test its value, and build a portfolio with a purpose.

Companion article: Compounding and uncertain markets. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / NSE-DG-01

NSE Dividend Growth Formula Workbook

Build a dividend-growth core, stage the capital, and keep the next opportunity in view.

Companion article: Core portfolio and three-month DCA. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / USMPC-09

US Markets and Portfolio Construction Final Workbook

Build a US-market portfolio policy from benchmark and wrapper to implementation, risk budget and long-term review.

Companion article: Implementation over time. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-MSME-01

Project 1 - MSME Owner Earnings and Operations.xlsx

Measure the cash a business earns, protect its operating capacity and make practical decisions about owner pay, borrowing, growth and succession.

Companion article: The cash an owner can actually claim. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-MSME-02

Project 1 - MSME Owner Earnings and Operations.xlsx

Measure the cash a business earns, protect its operating capacity and make practical decisions about owner pay, borrowing, growth and succession.

Companion article: Maintenance capital and working capital. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-MSME-03

Project 1 - MSME Owner Earnings and Operations.xlsx

Measure the cash a business earns, protect its operating capacity and make practical decisions about owner pay, borrowing, growth and succession.

Companion article: The daily MSME operating toolkit. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-MSME-04

Project 1 - MSME Owner Earnings and Operations.xlsx

Measure the cash a business earns, protect its operating capacity and make practical decisions about owner pay, borrowing, growth and succession.

Companion article: Owner pay, reserves, growth and debt. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-MSME-05

Project 1 - MSME Owner Earnings and Operations.xlsx

Measure the cash a business earns, protect its operating capacity and make practical decisions about owner pay, borrowing, growth and succession.

Companion article: Buying, selling and succession. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-VALUATION-06

Project 2 - Listed Companies Owner Earnings and Valuation.xlsx

Reconstruct earning power from public filings and compare US and NSE companies through their distinct capital, asset and sector economics.

Companion article: Reconstructing owner earnings from public filings. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-VALUATION-07

Project 2 - Listed Companies Owner Earnings and Valuation.xlsx

Reconstruct earning power from public filings and compare US and NSE companies through their distinct capital, asset and sector economics.

Companion article: US technology and asset-light economics: NVIDIA. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-VALUATION-08

Project 2 - Listed Companies Owner Earnings and Valuation.xlsx

Reconstruct earning power from public filings and compare US and NSE companies through their distinct capital, asset and sector economics.

Companion article: Asset-heavy issuers and data-centre infrastructure. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-VALUATION-09

Project 2 - Listed Companies Owner Earnings and Valuation.xlsx

Reconstruct earning power from public filings and compare US and NSE companies through their distinct capital, asset and sector economics.

Companion article: Banks and insurers: distributable capital. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-VALUATION-10

Project 2 - Listed Companies Owner Earnings and Valuation.xlsx

Reconstruct earning power from public filings and compare US and NSE companies through their distinct capital, asset and sector economics.

Companion article: NSE cross-sector casebook: seven businesses, seven cash questions. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-FAILURE-11

Project 3 - Failure Retrospectives and Warning Systems.xlsx

Test which cash, funding, governance and counterparty warnings were knowable before distress, while keeping legal records and illustrative models distinct.

Companion article: The retrospective method. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-FAILURE-12

Project 3 - Failure Retrospectives and Warning Systems.xlsx

Test which cash, funding, governance and counterparty warnings were knowable before distress, while keeping legal records and illustrative models distinct.

Companion article: Nakumatt and Tuskys: two retail distress records. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / OE-FAILURE-13

Project 3 - Failure Retrospectives and Warning Systems.xlsx

Test which cash, funding, governance and counterparty warnings were knowable before distress, while keeping legal records and illustrative models distinct.

Companion article: Twiga and Copia: funding, legal entities and what the record can show. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / STARTUP-FUNDING-01

Startup Funding Market and Outcomes Workbook.xlsx

Read Kenya's startup funding totals through comparable denominators, financing instruments and dated company outcomes.

Companion article: Kenya’s startup funding headline needs three denominators. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / STARTUP-FUNDING-02

Startup Funding Market and Outcomes Workbook.xlsx

Read Kenya's startup funding totals through comparable denominators, financing instruments and dated company outcomes.

Companion article: What kind of money was raised?. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →
EXCEL WORKBOOK / STARTUP-FUNDING-03

Startup Funding Market and Outcomes Workbook.xlsx

Read Kenya's startup funding totals through comparable denominators, financing instruments and dated company outcomes.

Companion article: What happened after the raise?. The collection includes the model’s formula dictionary and mathematical explanations.

Explore the collection →