The Problem

You have a comprehensive financial model open in Excel for an energy and infrastructure client. The deliverable is a full DCF valuation with WACC assumptions, terminal value calculations, and a discounted cash flow summary, structured for review and ready for the deal team.

Manually, that means building out discount rate assumptions, layering in terminal value methods, calculating present values across the forecast horizon, and sense-checking whether the valuation approach even fits the asset type. For a finite-life asset like a battery storage business, this last step is critical and easy to miss.

The Solution

You can use saved workflows in Tracelight's AI for financial modeling to accelerate this process by over 90%

Step 1: Trigger the DCF Workflow

To begin, select the saved DCF Workflow from Tracelight's prompt library. The Workflow contains all the instructions your team has standardised for valuation builds, including the base year, output structure, and assumptions framework. One click, and Tracelight begins executing against the live model.

Step 2: Build WACC and Terminal Value Assumptions

Tracelight generates a complete set of WACC assumptions and builds terminal value calculations using both the perpetuity growth rate and exit multiple methods. All assumptions are clearly laid out in the workbook, linked to the underlying model inputs, and ready for you to review and adjust. No manual formula construction, no copy-paste from a prior deal's template.

Step 3: Calculate Discounted Cash Flows

Tracelight calculates unlevered free cash flow from the financial statements, referencing separate NWC and net debt schedules already present in the model. It then discounts each period's cash flow back using the WACC assumptions, producing a full DCF output sheet. For this particular asset, the business is fully depreciated by 2033 and EBITDA turns negative by 2042, details that flow directly into how the valuation should be interpreted.

The Result

A full DCF valuation, from WACC assumptions through terminal value methods to discounted cash flows, built directly into the existing model in minutes rather than hours.