Excel Finance MCP

excel_create_loan_analysis

Generate a loan amortization worksheet with payment schedules and accounting entries for financial analysis and reporting.

Instructions

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

Input Schema

Name	Required	Description	Default
`annualRate`	Yes	Annual interest rate (e.g., 0.05 for 5%)
`loanAmount`	Yes	Principal loan amount
`worksheetName`	No		Loan Analysis
`years`	Yes	Loan term in years

Input Schema (JSON Schema)

{
  "properties": {
    "annualRate": {
      "description": "Annual interest rate (e.g., 0.05 for 5%)",
      "type": "number"
    },
    "loanAmount": {
      "description": "Principal loan amount",
      "type": "number"
    },
    "worksheetName": {
      "default": "Loan Analysis",
      "type": "string"
    },
    "years": {
      "description": "Loan term in years",
      "type": "number"
    }
  },
  "required": [
    "loanAmount",
    "annualRate",
    "years"
  ],
  "type": "object"
}

This server cannot be installed

Other Tools from Excel Finance MCP

Related Tools

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