Excel Waterfall Table

A waterfall table allows you to take an amount (like sales), and AMORTIZE that amount over a set of periods (like revenue).
 
Use this Excel worksheet to To get to gross sales (additions), this can come from anywhere