skills.rest
lizhihuajob
lizhihuajobCOMMUNITY
Explore all skills by this author →
GitHub

officecli-financial-model

Automate Excel financial modeling workflows with scenario analysis and valuation calculations.

1|Updated May 10, 2026
Search Tags:#financial modeling#valuation#DCF#excel automation#scenario analysis#LBO
One-click install
npx skills add https://github.com/lizhihuajob/OceanOfficeCLI --skill officecli-financial-model-lizhihuajob
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-financial-model
Source: https://github.com/lizhihuajob/OceanOfficeCLI/tree/main/OfficeCLI-main/skills/officecli-financial-model
Command: npx skills add https://github.com/lizhihuajob/OceanOfficeCLI --skill officecli-financial-model-lizhihuajob

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, numpy, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation and management of complex financial models in Excel, enabling precise, formula-based analysis and valuation.

Core Features & Use Cases

  • End-to-End Financial Modeling: Builds integrated 3-statement models, DCF valuations, and LBOs with automated sheet setup and formula linking.
  • Scenario & Sensitivity Analysis: Creates grids for WACC and growth rate variations to evaluate valuation ranges.
  • Use Case: Finance professionals can quickly generate a detailed 5-year forecast, perform scenario analysis, and derive equity value, all within a structured Excel workbook.

Quick Start

Use the script to create a multi-sheet Excel model with assumptions, calculations, and valuation outputs, then customize your financial inputs directly in the sheets.

Frequently Asked Questions about officecli-financial-model

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

FAQPage Schema
How do I automate financial modeling and build a DCF valuation in Excel?▼

Automate financial modeling by using this Skill to generate multi-sheet Excel workbooks with linked formulas for DCF valuations and 3-statement models. It systematically sets up calculation zones and valuation outputs using openpyxl and pandas.

Can I perform scenario and sensitivity analysis for WACC and growth rates in Excel?▼

Scenario and sensitivity analysis for WACC and growth rate variations is supported through automated grid generation in Excel. The Skill creates structured sensitivity tables to evaluate valuation ranges without manual formula entry.

What's the best way to build an LBO model with formula-driven Excel sheets?▼

Building an LBO model with formula-driven Excel sheets is streamlined through automated sheet setup and formula linking. The Skill ensures zone segregation and caching integrity to produce audit-ready LBO calculations.

Do I need pandas and openpyxl to create integrated 3-statement financial models?▼

Pandas and openpyxl are required dependencies to manipulate Excel files systematically for 3-statement financial modeling. These libraries enable the automated generation of linked assumptions, calculations, and valuation outputs within the workbook.

How does this approach ensure formula accuracy for audit-ready financial models?▼

Formula accuracy for audit-ready financial models is ensured through zone segregation and caching integrity checks during automated Excel generation. This prevents broken links and maintains calculation consistency across multiple sheets.

What are the limitations of using openpyxl for corporate finance forecasting tasks?▼

Using openpyxl for corporate finance forecasting limits you to static Excel formula generation without real-time market data integration or live financial API connections. The Skill focuses on structured workbook creation rather than dynamic data streaming.

Related Skills

Explore More Finance & Accounting Skills→
AngelP17AngelP17
1

analyzing-financial-statements

Calculate financial ratios from CSV, JSON, text, or Excel data.

Community
Intermediate
nvmohinaninvmohinani

dcf-model

Build DCF valuation models with WACC, terminal value, and sensitivity analysis.

Community
Advanced
blueskies1818blueskies1818
1

comps-analysis

Generate comparable company analyses in Excel with operating metrics and valuation multiples.

Community
Advanced
BaranziniLabBaranziniLab
1

officecli-financial-model

Automate Excel financial model creation with DCF and LBO calculations.

Official
Advanced