Skip to main content
Glama

Excel Finance MCP

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
excel_create_workbook

Create a new Excel workbook with specified worksheets and data

excel_open_file

Open an existing Excel file

excel_save_file

Save the current workbook to a file

excel_read_worksheet

Read data from a specific worksheet

excel_write_worksheet

Write data to a worksheet

excel_add_worksheet

Add a new worksheet to the current workbook

excel_delete_worksheet

Delete a worksheet from the current workbook

excel_create_named_range

Create a named range in the workbook

excel_find_replace

Find and replace text in a worksheet

excel_get_formulas

Extract all formulas from a worksheet

excel_protect_worksheet

Protect a worksheet with a password

excel_merge_files

Merge multiple Excel files into one workbook

excel_conditional_formatting

Apply conditional formatting to a range

excel_data_validation

Add data validation to a range

excel_close_workbook

Close the current workbook

excel_autofit_columns

Auto-fit column widths based on content with min/max constraints

excel_autofit_all_columns

Auto-fit column widths for all worksheets in the workbook

excel_create_formula_reference

Create a comprehensive formula reference sheet with accounting standards and links

excel_create_npv_analysis

Create a comprehensive NPV analysis worksheet with formulas and documentation

excel_create_loan_analysis

Create a loan amortization analysis worksheet with payment schedule and accounting entries

excel_create_rent_roll

Create a comprehensive rent roll analysis worksheet with occupancy and financial metrics

excel_create_financial_ratios

Create a financial ratios analysis worksheet with GAAP-compliant ratio calculations

excel_create_cash_flow_projection

Create a 12-month cash flow projection worksheet with operating, investing, and financing activities

excel_add_formula_with_documentation

Add a financial formula to a cell with complete documentation and validation

calculate_npv

Calculate Net Present Value of cash flows

calculate_irr

Calculate Internal Rate of Return

calculate_mirr

Calculate Modified Internal Rate of Return

loan_amortization

Generate loan amortization schedule

calculate_bond_price

Calculate bond price given yield and terms

calculate_wacc

Calculate Weighted Average Cost of Capital

depreciation_straight_line

Calculate straight-line depreciation schedule

depreciation_declining_balance

Calculate declining balance depreciation schedule

calculate_financial_ratios

Calculate comprehensive financial ratios

effective_annual_rate

Calculate effective annual rate from nominal rate

payback_period

Calculate payback period for investment

profitability_index

Calculate profitability index (PI)

capm_expected_return

Calculate expected return using CAPM model

bond_duration

Calculate Macaulay duration for bond

depreciation_sum_of_years

Calculate sum-of-years-digits depreciation schedule

depreciation_units_production

Calculate units of production depreciation

depreciation_macrs

Calculate MACRS depreciation schedule

future_value

Calculate future value of present amount

present_value

Calculate present value of future amount

rental_generate_rent_roll

Generate rent roll report for a property

rental_calculate_vacancy_rate

Calculate vacancy rate and rental loss for a property

rental_lease_expiration_report

Generate report of upcoming lease expirations

rental_calculate_noi

Calculate Net Operating Income for a property

rental_calculate_cap_rate

Calculate capitalization rate for a property

rental_project_cash_flow

Project property cash flows with financing analysis

rental_rent_comparables_analysis

Analyze comparable rents for market analysis

rental_add_property

Add a new rental property to the system

rental_add_unit

Add a rental unit to a property

rental_add_lease

Add a new lease agreement

rental_add_tenant

Add a new tenant to the system

expense_add

Add a new expense entry

expense_add_vendor

Add a new vendor to the system

expense_summary_report

Generate expense summary report

expense_budget_vs_actual

Compare actual expenses against budget

expense_forecast

Forecast future expenses based on historical data

expense_cost_savings_analysis

Identify potential cost savings opportunities

expense_1099_report

Generate 1099 reporting for vendors

expense_cash_flow_impact

Analyze cash flow impact of pending expenses

expense_vendor_analysis

Analyze vendor spending patterns and performance

expense_spending_trends

Analyze spending trends over time

expense_create_budget

Create a new budget for expense planning

generate_income_statement

Generate Income Statement (P&L) for specified period

generate_balance_sheet

Generate Balance Sheet as of specified date

generate_trial_balance

Generate Trial Balance as of specified date

comparative_income_statement

Generate comparative income statement for multiple periods

financial_ratios_analysis

Calculate comprehensive financial ratios

create_rental_property_analysis

Create rental property analysis Excel template

create_cash_flow_template

Create cash flow projection Excel template

create_budget_template

Create budget vs actual Excel template

cash_flow_statement

Generate cash flow statement for specified period

cash_flow_forecast

Forecast future cash flows with scenario analysis

cash_burn_analysis

Analyze cash burn rate and calculate runway

working_capital_analysis

Analyze working capital changes and efficiency

cash_flow_at_risk

Calculate Cash Flow at Risk (CFaR) metric

liquidity_analysis

Analyze current liquidity position and requirements

calculate_federal_income_tax

Calculate federal income tax based on taxable income and filing status

calculate_self_employment_tax

Calculate self-employment tax (Social Security and Medicare)

calculate_payroll_taxes

Calculate payroll taxes for employer and employee

calculate_state_taxes

Calculate state income tax for supported states

estimated_quarterly_taxes

Calculate estimated quarterly tax payments

calculate_depreciation_deduction

Calculate tax depreciation deduction for an asset

business_deductions_analysis

Analyze allowable business deductions

tax_planning_strategies

Get tax planning strategy recommendations

business_tax_summary

Generate comprehensive business tax summary

tax_projection_scenarios

Generate tax projections under different income scenarios

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/jeremycharlesgillespie/excel-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server