Skip to main content
Glama

time_value_calc

Read-only

Perform time-value-of-money and depreciation calculations, including future value, present value, periods, rate, IRR, and depreciation schedules.

Instructions

Perform a variety of time-value-of-money calculations and depreciation methods.

Args: operation: One of "fv", "pv", "nper", "rate", "depreciation", "irr". rate, nper, pmt, pv, fv, when, guess: Parameters depending on operation. cost, salvage, life, method, period: Parameters for depreciation operations. cash_flows: For IRR, list of floats.

Returns: dict: Operation-specific outputs (e.g. numeric answer, schedule, irr value).

Raises: ValueError: If required args for the selected operation are missing.

Notes: - Pure calculations except for methods that may write results when integrated into workbook workflows.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
fvNo
pvNo
pmtNo
costNo
lifeNo
nperNo
rateNo
whenNoend
guessNo
methodNosln
periodNo
salvageNo
operationYes
cash_flowsNo
Behavior1/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The annotations declare readOnlyHint=true, indicating the tool should be read-only. However, the description states 'except for methods that may write results when integrated into workbook workflows,' which suggests possible write side effects. This directly contradicts the readOnlyHint annotation. The description provides no further details about permissions, side effects, or what 'integrated into workbook workflows' means.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections for Args, Returns, Raises, and Notes, and opens with a concise one-sentence summary. It is not overly verbose, though the Args list somewhat duplicates the schema. The structure aids readability.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (14 parameters, 6 operations, no output schema), the description is insufficient for correct invocation. It does not specify required arguments per operation, output formats, or provide examples. The ambiguous write behavior further undermines completeness. The Raises section indicates errors but does not detail what is required.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The Args section groups parameters by operation type (e.g., rate/nper/pmt/pv/fv for financial calculations, cost/salvage/life for depreciation, cash_flows for IRR), adding some meaning beyond the bare schema. However, it does not explain parameter defaults like when='end', guess=0.1, or method='sln', nor does it specify which parameters are required for each operation. Since schema description coverage is 0%, the description partially compensates but not fully.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it performs time-value-of-money calculations and depreciation methods, listing specific operations like fv, pv, nper, rate, depreciation, and irr. This provides a specific verb+resource combination. However, it does not explicitly distinguish itself from sibling financial tools like loan_amortization or dcf_analysis, so it lacks full sibling differentiation.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

There is no guidance on when to use this tool versus alternatives such as loan_amortization or dcf_analysis. The description only states what it does and lists operations, but does not provide context on selection criteria or exclusions. The note about write behavior is not usage guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

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/mbeps/excel-mcp'

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