cathay-excel-template

Generate a 13-sheet Cathay PE financial model template with linked IS/BS/CF formulas.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/harryhuang0719/Skills-for-Cathay --skill cathay-excel-template
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: cathay-excel-template
Source: https://github.com/harryhuang0719/Skills-for-Cathay/tree/main/templates/cathay-excel
Command: npx skills add https://github.com/harryhuang0719/Skills-for-Cathay --skill cathay-excel-template

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes assets (resource) and references (resource) components.

What problem does it solve?

Cathay Excel financial model template addresses the pain of building and maintaining a credible, auditable PE model by providing a ready-to-use, branded workbook with cross-sheet linkage and built-in formatting.

Core Features & Use Cases

  • 13-sheet template covering Revenue Build-up, COGS & OpEx, IS, BS, CF, WC, Debt & CapEx, Returns, DCF, Comps, Dashboard
  • Built-in linking and formatting to ensure consistency across statements and quick scenario analysis
  • Real-world workflow: plug in historical data and assumptions to produce forecast outputs for deal evaluation and exit planning

Quick Start

Populate the provided assets/template.xlsx with your data to generate a fully linked 13-sheet financial model.

Frequently Asked Questions about cathay-excel-template

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a PE financial model with cross-sheet references for deal analysis?

You can generate a complete 13-sheet PE financial model template with linked Income Statement, Balance Sheet, and Cash Flow formulas. This template provides built-in cross-sheet references to ensure statement consistency for deal evaluation.

What is included in a complete PE financial model template for revenue modeling and valuation?

A complete PE financial model template includes 13 sheets covering Revenue Build-up, COGS, OpEx, IS, BS, CF, Working Capital, Debt, CapEx, Returns, DCF, Comps, and a Dashboard. These sheets provide linked formulas to support revenue modeling, valuation, and cash flow forecasting.

How do I set up scenario analysis across Base, Upside, and Downside cases in Excel?

To set up scenario analysis, populate the provided Excel template with your historical data and assumptions. The workbook applies built-in linking and formatting to quickly generate forecast outputs across Base, Upside, and Downside scenarios for exit planning.

Can I use this Excel template for cash flow forecasting and DCF valuation without starting from scratch?

Yes, you can use this template for cash flow forecasting and DCF valuation without starting from scratch. It functions as a ready-to-use, validation-ready workbook where you plug in structured data to produce formatted forecast outputs automatically.

What is the best way to ensure consistency across Income Statement, Balance Sheet, and Cash Flow statements in a PE deal model?

The best way to ensure consistency across financial statements is using a template with built-in cross-sheet linking. This model automatically connects IS, BS, and CF formulas from your structured data to maintain auditable consistency throughout the deal analysis.

Do I need structured historical data to generate a fully linked financial model for a PE deal?

Yes, you need structured historical data and assumptions to generate a fully linked financial model. You populate the provided Excel template with this data to produce complete forecast outputs for deal evaluation and returns analysis.