Building a Same-Day DCF Model Solo Under Time Pressure
Scoped, built, and delivered a full DCF model in a single day without support, making all growth assumptions independently.

Ayush Gupta
Senior Analyst at Leading Financial Services Inc



From their time as
Senior Analyst
Leading Financial Services Inc • 2026
Overview
A client came in with a request to build a DCF model from scratch. The request arrived in the morning, and the junior analyst who typically supports Ayush on execution was on leave. Ayush picked up the task alone.
The Story
A client came in with a request to build a DCF model from scratch. The request arrived in the morning, and the junior analyst who typically supports Ayush on execution was on leave. Ayush picked up the task alone.
He started by scoping the work before touching the model. He read through the company's background, identified the industry, and mapped out a timeline for himself so he could commit to a same-day delivery.
With the scope clear, he used AI tools to handle the financial spreading, a step that previously consumed significant time. That freed him to focus on the growth assumptions, which required judgment rather than process. He worked through the company's own projections, which were aggressive, and landed on a middle-ground set of assumptions that neither accepted the company's optimistic case nor defaulted to an overly conservative one. Where the company projected an adjusted EBITDA range of 14.8 to 15.5, he landed at 15.1, a number that held up under both downside and upside scenarios.
Every assumption in the model was his own call. He did not escalate or ask for a second opinion. By end of day, the model was delivered to the client, who reviewed it, gave positive feedback on the quality, and specifically noted the turnaround speed.
