Dates and Timing 15
FIGURE 1.4 Time will progress vertically in
this model.
FIGURE 1.5 The beginning of the
dates and timing section on the Cash
Flow sheet.
Model Builder 1.2: Cash Flow Sheet — Dates and Timing
1.The Cash Flow sheet is the third sheet in the model. Rename the third sheet
from Sheet3 toCash Flow.
2.In the Cash Flow sheet, Row 4 will be dedicated to headers. InputPeriodin cell
A4,Datein cell B4, andDay Factorin cell C4.
3.The first column to work on is where the periods are tracked. In cell A6
input 0, followed by inputting 1 in the cell directly below, A7. Highlight both
