# The Film Finance Handbook: companion files

Julian R. Sterling. Companion page: julianrsterling.com/film-finance

1. **Film_Finance_Workbook.xlsx**: the model behind every figure of The Lantern Keeper, the fictional independent feature followed through the book (USD, quarters counted from financing close). Tabs: README, Inputs, Budget, Plan, WF_Downside, WF_Base, WF_Upside, Returns, Sensitivity, Overrun_CostPlus and Checks. The all-in budget reads $12,765,473 and equity $5,117,153; the base case returns a 0.98x multiple, the upside 1.40x. The Checks tab must read 0.
2. **Film_Recoupment_Waterfall_Model.xlsx**: a standalone quarterly collection account waterfall for one film (sheets README, Inputs, Waterfall, Results), prefilled with the base case: the gap loan is repaid in full and equity receives $4,990,915. Replace the blue cells with your own film.

Blue cells are inputs, black cells are formulas; no macros, no circular references. The film, the companies, the distributors, the lenders and every figure are fictional teaching assumptions, not market data. Education only, not legal, tax, securities or investment advice.
