In cell C11, construct a formula to calculate the annual projected street maintenance costs for the...

 

Transcribed Image Text:

In cell C11, construct a formula to calculate the annual projected street maintenance costs for the year 2025 after the projected increase of 5% is applied. Use absolute cell references as necessary. Fill the formula through cell F11, and then use Format Painter to copy the formatting from cell B11 to the range C11:F11 toSave e Paste C11 1 23456 Home X Cut Copy Format Painter Clipboard 5 Percent Increase 4 Annual Street Costs 18 19 Insert 7 8 Projected Increase 9 10 Year Projected Costs 20 21 22 23 24 A 25 26 27 28 29 Page Layout Century Gothic BIU 30 31 ✓ 32 33 34 12 13 Projected Estimates 2024 to 2028. 14 Year 15 5% increase 16 3% Increase 17 Y Font $ Formulas Data ✔ 11-AA === *- A B G Review 2020 3.058.712 $ View 2024 3,586.110 City of Springbury Street Maintenance Costs 2020 to 2024 2021 2022 3,124,985 $ 217% Help Wrap Text Merge & Center - Alignment D 2025 Projected Street Maintenance Costs 5% 3.262.557 $ 440% 2026 General $-% 9898 E Number 2023 3.484.221 $ 679% 2027 Conditional Format Formatting Table 2024 3,586,110 292% 2028 G In cell C11, construct a formula to calculate the annual projected street maintenance costs for the year 2025 after the projected increase of 5% is applied. Use absolute cell references as necessary. Fill the formula through cell F11, and then use Format Painter to copy the formatting from cell B11 to the range C11:F11 toSave e Paste C11 1 23456 Home X Cut Copy Format Painter Clipboard 5 Percent Increase 4 Annual Street Costs 18 19 Insert 7 8 Projected Increase 9 10 Year Projected Costs 20 21 22 23 24 A 25 26 27 28 29 Page Layout Century Gothic BIU 30 31 ✓ 32 33 34 12 13 Projected Estimates 2024 to 2028. 14 Year 15 5% increase 16 3% Increase 17 Y Font $ Formulas Data ✔ 11-AA === *- A B G Review 2020 3.058.712 $ View 2024 3,586.110 City of Springbury Street Maintenance Costs 2020 to 2024 2021 2022 3,124,985 $ 217% Help Wrap Text Merge & Center - Alignment D 2025 Projected Street Maintenance Costs 5% 3.262.557 $ 440% 2026 General $-% 9898 E Number 2023 3.484.221 $ 679% 2027 Conditional Format Formatting Table 2024 3,586,110 292% 2028 G