Hi, I am trying to model my in- and outgoing cash flow and want to have them dynamically change when I change the payment terms. Any ideas? Thanks!
<colgroup><col width="184" style="width: 138pt;"><col width="128" style="width: 96pt;"><col width="87" span="9" style="width: 65pt;"></colgroup><tbody>
</tbody>
| Start date week | 12/1/18 | 12/8/18 | 12/15/18 | 12/22/18 | 12/29/18 | 1/5/19 | 1/12/19 | 1/19/19 | 1/26/19 | |
| Year | 2018 | 2018 | 2018 | 2018 | 2018 | 2019 | 2019 | 2019 | 2019 | |
| Quarter | 4 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | 1 | |
| Month | 12 | 12 | 12 | 12 | 12 | 1 | 1 | 1 | 1 | |
| Week# | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | |
| Week-consecutive | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |
| Units ordered | 0 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| Price per unit | 100 | |||||||||
| Payment terms (in weeks) | 4 | |||||||||
| Cash out |
<colgroup><col width="184" style="width: 138pt;"><col width="128" style="width: 96pt;"><col width="87" span="9" style="width: 65pt;"></colgroup><tbody>
</tbody>
