Uses npm for package management and dependency installation for the MCP server
Leverages Python for complex financial calculations including NPV, IRR, depreciation methods, and tax computations
Implemented as a TypeScript server providing the core MCP server functionality and Excel integration capabilities
Excel Finance MCP
A comprehensive Model Context Protocol (MCP) server for Excel operations focused on finance, accounting, rental property management, and expense tracking.
Features
Core Excel Operations
- Create, open, save Excel workbooks
- Read/write worksheet data
- Named ranges and formulas
- Data validation and conditional formatting
- File merging and protection
Financial Calculations
- Investment Analysis: NPV, IRR, MIRR, Payback Period, Profitability Index
- Loan Analysis: Amortization schedules, payment calculations
- Depreciation: Straight-line, declining balance, MACRS, Section 179
- Bond Pricing: Price, duration, yield calculations
- Cost of Capital: WACC, CAPM calculations
- Financial Ratios: Liquidity, leverage, profitability ratios
Rental Property Management
- Rent Roll Generation: Current tenant listings with lease details
- Vacancy Analysis: Physical and economic vacancy rates
- Lease Management: Expiration tracking, renewal analysis
- NOI Calculations: Net Operating Income analysis
- Cash Flow Projections: Multi-year property cash flows
- Market Analysis: Comparable rent analysis
- Cap Rate Calculations: Investment return metrics
Expense Tracking
- Expense Management: Categorized expense tracking
- Vendor Management: Vendor database with payment terms
- Budget Analysis: Budget vs actual comparisons
- Cost Savings: Identify optimization opportunities
- 1099 Reporting: Vendor payment reporting
- Cash Flow Impact: Pending payment analysis
Cash Flow Analysis
- Cash Flow Statements: Operating, investing, financing activities
- Forecasting: Multi-scenario cash flow projections
- Burn Rate Analysis: Cash runway calculations
- Working Capital: Efficiency analysis
- Cash Flow at Risk: Risk metrics (CFaR)
- Liquidity Analysis: Cash position assessment
Financial Reporting
- Income Statements: P&L with comparative periods
- Balance Sheets: Assets, liabilities, equity statements
- Trial Balance: Account balance verification
- Financial Ratios: Comprehensive ratio analysis
- Custom Templates: Pre-built Excel templates
Tax Calculations
- Income Tax: Federal and state calculations
- Self-Employment Tax: Social Security and Medicare
- Payroll Taxes: Employer and employee portions
- Quarterly Estimates: Estimated tax payments
- Business Deductions: Allowable deduction analysis
- Tax Planning: Strategy recommendations
Data Validation
- Field Validation: Required, numeric, date, currency formats
- Financial Statement Validation: Cross-field validations
- Excel Data Validation: Worksheet data verification
- Data Cleaning: Automated data cleaning and formatting
Installation
Usage
Start the MCP server:
Or for development:
Available Tools
Excel Operations
excel_create_workbook
- Create new workbooksexcel_open_file
- Open existing filesexcel_save_file
- Save workbooksexcel_read_worksheet
- Read worksheet dataexcel_write_worksheet
- Write data to worksheetsexcel_add_worksheet
- Add new worksheetsexcel_find_replace
- Find and replace textexcel_conditional_formatting
- Apply formatting rules
Financial Calculations
calculate_npv
- Net Present Valuecalculate_irr
- Internal Rate of Returnloan_amortization
- Loan payment schedulescalculate_bond_price
- Bond valuationdepreciation_*
- Various depreciation methodscalculate_financial_ratios
- Financial ratio analysis
Rental Management
rental_generate_rent_roll
- Rent roll reportsrental_calculate_vacancy_rate
- Vacancy analysisrental_calculate_noi
- Net Operating Incomerental_project_cash_flow
- Cash flow projectionsrental_rent_comparables_analysis
- Market analysis
Expense Management
expense_add
- Add expense entriesexpense_summary_report
- Expense summariesexpense_budget_vs_actual
- Budget comparisonsexpense_forecast
- Expense forecastingexpense_1099_report
- 1099 vendor reporting
Cash Flow
cash_flow_statement
- Cash flow statementscash_flow_forecast
- Future cash flow projectionscash_burn_analysis
- Burn rate analysisliquidity_analysis
- Liquidity position
Reporting
generate_income_statement
- P&L statementsgenerate_balance_sheet
- Balance sheetsgenerate_trial_balance
- Trial balance reportsfinancial_ratios_analysis
- Ratio analysis
Tax Calculations
calculate_federal_income_tax
- Federal tax calculationscalculate_self_employment_tax
- SE tax calculationsestimated_quarterly_taxes
- Quarterly paymentsbusiness_tax_summary
- Business tax overview
Architecture
- TypeScript Server: MCP server implementation
- Python Calculations: Complex financial calculations
- Excel Integration: ExcelJS for file operations
- Data Validation: Comprehensive input validation
- Modular Design: Separate modules for different domains
Example Usage
local-only server
The server can only run on the client's local machine because it depends on local resources.
Tools
Enables comprehensive Excel operations and financial calculations including investment analysis, rental property management, expense tracking, and automated financial reporting. Supports creating Excel workbooks with advanced financial formulas, cash flow projections, and tax calculations for accounting and finance workflows.