This calculation gives a volume, not a schedule. Leads generated in the final weeks of a quarter cannot close inside it if your cycle is longer than the time remaining, so the leads that hit a Q4 revenue target largely have to be generated in Q3. Work backwards from your average cycle length and set the generation deadline accordingly, otherwise you hit the lead target and miss the revenue.
The model also assumes each stage feeds the next independently. In practice, pushing lead volume up through a channel usually pushes lead quality down, because you exhaust the best-matched audience first and buy further out. A campaign that doubles volume at the same cost per lead often converts at a materially lower rate, so the second half of the leads is worth less than the first.
Finally, the output is new business only. It counts nothing from renewals, upsells, or existing-customer expansion. If part of your revenue target is meant to come from the existing base, subtract that portion before entering the goal, or the tool will size a pipeline for revenue your account team is already covering.