Quetion 14. In the range I6:I32, calculate the running total of gross profit for the year.

File Home Insert Page Layout Formulas Data Review View Help Share X Cut LL = 11 AA Century Gothic Wrap Text Accounting 20% - Acc... 20% - Acc... 20% - Acc... 47 0 TTTT LG Copy Paste 20% - Acc... Conditional Format as 40% - Acc... Formatting Table BIU 40% - Acc... Merge & Center 40% - Acc... $ % 48_98 40%- ACC... Ideas Insert Delete Format AutoSum Fill Sort & Find & Clear Filter Select Editing Format Painter Clipboard Font Alignment Number Styles Cells Ideas 16 fo B J L E F Income ($mil) Cost of Goods ($mil) Cumulative Profit ($mil) $12.30 32.0% $13.25 25 3.4% A 5 Startup Costs ($mil) 6 Operational Cost Percentage 7 Current Cleanup Costs ($mil) 8 Years of Operation 9 Inflation Rate 10 11 Projections 12 Final Cleanup Costs ($mil) 13 Total Income ($mil) 14 Total Expenses ($mil) 15 16 Guess 17 $30.57 $155.99 $148.06 Internal Rate of Return 18 D Year Startup Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25 Cleanup $0.75 $1.07 $1.52 $2.16 $3.08 $4.38 $6.24 $8.88 $12.64 $18.00 $15.49 $13.32 $11.46 $9.86 $8.49 $7.30 $6.28 $5.40 $4.65 $4.00 $3.40 $2.80 $2.20 $1.60 $1.00 G Fixed Costs ($mil) $12.30 $ $1.80 $1.87 $1.95 $2.02 $2.11 $2.19 $2.28 $2.37 $2.46 $2.56 $2.66 $2.77 $2.88 $3.00 $3.12 $3.24 $3.37 $3.51 $3.65 $3.79 $3.41 $3.07 $2.76 $2.49 $2.24 $30.57 $0.24 $0.34 $0.49 $0.69 $0.99 $1.40 $2.00 $2.84 $4.05 $5.76 $4.96 $4.26 $3.67 $3.16 $2.72 $2.34 $2.01 $1.73 $1.49 $1.28 $1.09 $0.90 $0.70 $0.51 $0.32 H Profit ($mil (12.30) ($1.29) ($1.15) ($0.91) ($0.55) ($0.01) $0.79 $1.97 $3.67 $6.14 $9.68 $7.87 $6.29 $4.91 $3.71 $2.65 $1.72 $0.90 $0.17 ($0.48) ($1.07) ($1.10) ($1.17) ($1.27) ($1.40) ($1.56) ($30.57) 19 20 Discount Rate 21 22 23 24 25 26 27 28 29 Net Present Value ($mil) 30 31 32 33