Acquisition Schedule Formula

Here's one way:

       --A-- -B- -C- ------------------------------------D-------------------------------------
   1   value 100 100                                                                           
   2   cycle   3   4                                                                           
   3                                                                                           
   4    FY                                                                                     
   5       1 100 100 B5 and across and down: =IF(OR(MOD($A5, 5) = 1, MOD($A5, B$2) =1), B$1, 0)
   6       2   0   0                                                                           
   7       3   0   0                                                                           
   8       4 100   0                                                                           
   9       5   0 100                                                                           
  10       6 100 100                                                                           
  11       7 100   0                                                                           
  12       8   0   0                                                                           
  13       9   0 100                                                                           
  14      10 100   0                                                                           
  15      11 100 100                                                                           
  16      12   0   0                                                                           
  17      13 100 100                                                                           
  18      14   0   0

My attempt.

Cheers,