Projecting Farther
So far, you have managed to project The Body Shop’s financial statements through
2002. Now, extend your projection to years 2003 and 2004. See Table 3 for Excel
commands. A simple way to do this is to copy your model for the two additional
years. Before copying the formulas from column B to columns C and D. make sure
that any references to your Input Data (cells B3 through B12} are absolute references
as opposed to relative references. An absolute reference means that when you copy