Skip to main content
Glama

Excel Finance MCP

calculate_bond_price

Calculate bond price using face value, coupon rate, yield rate, and maturity period to determine current market value for investment analysis.

Instructions

Calculate bond price given yield and terms

Input Schema

NameRequiredDescriptionDefault
couponRateYesAnnual coupon rate as decimal
faceValueYes
frequencyNoCoupon payments per year
yearsYes
yieldRateYesRequired yield as decimal

Input Schema (JSON Schema)

{ "properties": { "couponRate": { "description": "Annual coupon rate as decimal", "type": "number" }, "faceValue": { "type": "number" }, "frequency": { "default": 2, "description": "Coupon payments per year", "type": "number" }, "years": { "type": "number" }, "yieldRate": { "description": "Required yield as decimal", "type": "number" } }, "required": [ "faceValue", "couponRate", "yieldRate", "years" ], "type": "object" }

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