How to Run a DCF Valuation with Copilot
Run a DCF valuation with Copilot and ToolRouter. Generate valuation outputs and model code in your workspace.
Tool
Copilot runs DCF calculations and returns structured results that slot directly into financial model codebases or analysis tools. Generate valuation data structures, sensitivity tables as arrays, and WACC calculation breakdowns — building your financial modelling infrastructure with real computed outputs.
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: "Run a DCF valuation with these cash flows and capital structure inputs"
- Copilot returns enterprise value, per-share value, and WACC as structured data
- Ask: "Generate a TypeScript function that runs this DCF calculation"
Example Prompt
Try this with Copilot using the Financial Calculator tool
Run a DCF valuation with FCF of $2m, $3m, $4m, $5m, $6m, terminal growth 2%, WACC 10%. Return the enterprise value, sensitivity matrix, and WACC components as JSON I can use in my valuation model.
Tips
- Ask for the sensitivity matrix as a 2D array — it slots into charting libraries directly
- Use the WACC breakdown to generate a capital structure display component
- Copilot can generate a DCF class or function from the returned calculation logic