Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| 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 |