9 In cell A13 , type Projected Costs and then in the range
6.000
B12 : F12 , use the fill handle to enter the years 2016 through 2020 . Apply Bold to the years . Copy cell F5 and paste to cell B13 . Type 6 % in cell B10 .
10 To the range A10 : B10 , apply Bold and Italic . 4.000
11 In cell C13 , construct a formula to calculate the annual
6.000 projected street maintenance costs for the year 2017 after the projected increase of 6 % ( stored in cell B10 ) is applied . Fill the formula through cell F13 , and then use Format Painter to copy the formatting from cell B13 to the range C13 : F13 .
12 In cell A15 , type Projected Estimates 2016 to 2020
6.000 and then use Format Painter to copy the format from cell A8 to cell A15 . In cells A17 : A19 , type the following row titles :
Year