DCF Valuation Work

A banker's DCF from first build to specialist cases: projection choices, WACC inputs, terminal value, sensitivities, football field pages and the routines that keep every version defensible.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for DCF Valuation Work, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

207

Starter tasks

🏦 Investment Banking & Advisory

DCF Valuation Work

Building a banker's DCF: projections from management or consensus, WACC, terminal value methods, sensitivity tables and a football field of outcomes.

  1. Unlevered free cash flow built from the three statements
  2. Learning the firm's DCF template
  3. Choosing the projection case for a DCF
  4. Valuation date, stub period and discounting convention
  5. Enterprise value to equity value bridge
  6. Fully diluted share count for the DCF
  7. Discount rate source file
  8. DCF assumptions page that seniors can read
  9. Monthly WACC market data refresh
  10. Live assumption log on every DCF
  11. Snapshot of DCF outputs at every send
  12. Implied output sanity checks before sending
  13. Consensus refresh for coverage shell DCFs
  14. Quarterly peer beta set review
  15. Weekly blank-sheet DCF drill
  16. Updating the DCF after quarterly results
  17. Sector benchmark sheet for DCF drivers
  18. WACC built from first principles
  19. Unlevering and relevering beta
  20. Terminal value by growth and by exit multiple
  21. Steady-state terminal year and reinvestment
  22. Working capital and capex projection drivers
  23. Cash taxes, tax losses and the tax shield
  24. Stock-based compensation in the DCF
  25. Lease accounting consistency in the DCF
  26. Reading broker models to build a consensus case
  27. Standard sensitivity tables for every DCF
  28. Choosing the explicit forecast horizon
  29. Long-term growth rate rationale
  30. Country risk premium for emerging market targets
  31. Scenario cases with a single selector
  32. DCF bar on the valuation football field
  33. Explaining the gap between DCF value and market price
  34. First live-deal DCF for your associate
  35. Pitch DCF on a 48-hour turnaround
  36. Walking the MD through the DCF
  37. DCF pages for a client board discussion
  38. DCF modelling test for recruiting
  39. Student DCF on a listed company
  40. DCF interview question bank
  41. Summer intern's first DCF on the desk
  42. New analyst DCF competence in 90 days
  43. Associate review routine for analyst DCFs
  44. Moving to banker DCF style from another finance role
  45. Sum-of-the-parts DCF for a multi-division group
  46. Dividend discount model for banks and insurers
  47. Adjusted present value for changing capital structures
  48. Normalised DCF for cyclical and commodity businesses
  49. High-growth DCF with a long fade period
  50. Cross-currency DCF and inflation consistency

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Unlevered free cash flow built from the three statements

Every banker's DCF rests on one line: EBIT less cash taxes, plus depreciation and amortisation, less capex and the increase in net working capital. Rebuilding that line by hand from a real company's income statement, balance sheet and cash flow statement shows you where each number comes from, so you can defend it when an associate asks why free cash flow jumps in year three.

First tasks

  • Download the latest annual report of a listed company you know well
  • Copy three years of income statement, balance sheet and cash flow lines into a blank sheet
  • Build EBIT to unlevered free cash flow with every cell linked
  • Reconcile your result to operating cash flow less capex and note the gaps
  • Write a one-page formula sheet listing the five traps you hit

Learning the firm's DCF template

Most banks and boutiques have a standard DCF template with fixed tabs, colour codes and output pages, and seniors expect yours to look like it. Learning its structure before your first staffing means deal nights go on assumptions, not on hunting for the cell that drives the discount factor.

First tasks

  • Ask your associate or the training team for the current DCF template
  • Map each tab and how it feeds the output pages
  • List every switch, such as the mid-year convention and the case selector
  • Run a dummy company through the template and print the outputs
  • Book 20 minutes with an associate to clear your open questions

Choosing the projection case for a DCF

Whose numbers sit in the forecast changes the answer more than any discount rate. Management plans tend to be optimistic, broker consensus often covers only two or three years, and a banker's own case has to be justified line by line, so the choice and its source should be written down before the model is built.

First tasks

  • List every projection source available for the company
  • Compare each source's horizon and line-item detail in a short table
  • Flag where management numbers sit above consensus and by how much
  • Agree the base case with your associate and record the reason

Make it yours.

Install DCF Valuation Work, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.