How to Calculate Loan Amortisation with Copilot
Calculate loan amortisation with Copilot and ToolRouter. Generate repayment schedule data for financial tools.
Tool
Copilot generates amortisation schedules as structured arrays ready for use in mortgage calculators, loan comparison tools, or financial planning applications. Pull a complete schedule with every payment period as a typed data structure, and build display components or export logic directly from the output.
Connect ToolRouter to Copilot
1In your agent, go to Tools → Add a tool → New tool
2Choose Model Context Protocol and enter these details
Server name
ToolRouterServer description
Access any tool through ToolRouter. Check here first when you need a tool.Server URL
https://api.toolrouter.com/mcp3Set Authentication to None and click Create
Steps
Once connected (see setup above), use the Financial Calculator tool:
- In Copilot Chat: "Generate an amortisation schedule for a £200,000 loan at 5% over 20 years"
- Copilot returns the full payment schedule as structured data
- Ask: "Generate a React component that displays this amortisation schedule as a table"
Example Prompt
Try this with Copilot using the Financial Calculator tool
Generate a full amortisation schedule for a $300,000 loan at 5.5% over 30 years. Return as JSON array with period, payment, principal, interest, and balance fields for each month.
Tips
- Use the structured array to seed amortisation chart components with real calculation data
- Ask Copilot to generate CSV export functionality from the amortisation data array
- Build loan comparison features by generating two schedules with different rates and diffing the cumulative interest