I NEED HELP WITH QUESTION 10. Linda projects that fixed costs will initially grow at a rate if 4% per year.

Extrapolate the year 1 fixed cost value through year 20 in the range G8:G26.

I NEED STEP BY STEP EXPLANATION PLUS ANSWER THANKS.

G H $12.30 3209 Fixed Cox's (Smil) $12.39 $ $1.80 $13.25 25 3.4% 3057 Return D E F Year-by-Year Projections Yes Income Stil) Corld Good (Stil) Startup You 1 $0.75 $0.24 You 2 $1.07 $0.34 Yes 3 S1.52 90.49 Yer 4 $2.18 $0.69 Yes 5 $3.08 $0.99 Yes 6 $439 $1.40 Year? 5824 $2.00 Yeri sa 68 5284 Yorg 51284 $4.05 Yey 10 $18.00 55.78 Yoss 11 $15.49 $498 Yer 12 $13.32 54.28 Yes 13 $11.48 $3.67 Yer 14 59.88 53.16 Yes 15 $8.49 52.72 Yes 16 57:30 $234 Yey 17 58.28 S2.01 Yes 18 $5.40 51.73 You 19 $4.65 51.49 Yes 20 $4.00 51.28 Year 21 $3.40 $1.09 Year 22 S2.80 $0.90 Yar 23 S2 20 $0.70 Yes 24 51.60 90.51 Yes 25 $1.00 SO 32 Cleanup Profit (Smi) (12.30) $ ($1.50) $ $0.34 $ $0.49 $ 50.69 $ $0.99 $ $1.40 $ $200 $ $284 $ S4.05 $ $5.78 $ $4.98 $ S428 $ $3.67 $ 53.16 $ $2.72 $ $234 $ S201$ $1.73 $ $1.49 $ 51.285 $1.09 $ SO 90 $ 50.70 $ S0 51 90.32 $ ($30.57) $ Cumulative Prat (Smil). 5.25 17:55 19.11 15.76 15.25 17:59 16.60 15.20 13.20 10.35 631 0.55 (4.40) (8.67) (1234) (1519) (15.21) (20.54) (22.55) (24.25) (25.77) (27.05) (25.14) (29.03) (29.74) (30.25) (30.57) Bus (Smil) $ 30.57 + 8. In the range F7:F31, calculate the annual operational costs of the mine by multiplying the income value by the operational cost percentage in cell B6. 9. Linda estimates the copper mine will have $1.80 million in fixed costs in Year 1. Enter $1.80 in cell G7. 10. Linda projects that fixed costs will initially grow at a rate of 4% per year. Extrapolate the Year 1 fixed cost value through Year 20 in the range G8:G26. 11. From Year 21 to Year 25, Linda projects that fixed costs will decline by 10% per year (so that each year's fixed cost is 90% of the previous year). E> polate the Year 21 fixed-cost values through Year 25 in the range G27:G31 using a growth value of 0.9. 12. In cell G32, enter the cleanup cost using the value in cell B12. 13. In the range H6:H32, calculate the copper mine's gross profit by subtracting the sum of the annual cost of goods ar fixed costs from the mine's annual income. AutoFill the values without formatting. 14. In the range 16:132, calculate the running total of gross profit for each year. 15. Create a line chart of the range D5:032,15:132 to show the cumulative profit of the mine. Move and resize the chart cover the range K5:Q20. The payback period is indicated where the line chart crosses the horizontal axis. 16. In cell B13, calculate the total income from the copper mine by adding all the values in column E. In cell B14, calculate the total cost of the mine by adding all the values in columns F and G. Note that by the raw totals, the min