How do I forecacast sales, cost of pairs sold, gross margin? I need to forcast for years 21,22,23,24,25? in the other picture theres ratios for years 10 and 20 year 10 is

to be used as the base line.

Bookd Excel Signin -? Insert Page Layout Formules Data ReviewView ACROBATTell me what you want to do ? AutoSum g Copy Format Painter -A-|-? BIU ? ??Merge & Center , Conditional Format as Neutral Formatting Table Sort & Find & Filter Select S . % , Calculation Check Cell Insert Delete Format Clear 21 Historical Data 2016 20172018 2019 2021 Forecast 2021 2022 2023 2024 2025 769,216 811,821 819,171 947,420 1,066,002 402,731 418,605 437,655 449,6SS491,806 366,485 393,216 381,516 497,765 574,196 Cost of Pairs Sold 5 Gross Margin 8 Expenses 38,257 43,288 48,302 54,839 58,103 109,856 110,623 114,118 161,736 166,079 19,650 21.366 21,629 21.699 21,768 167,763 175,277 184,049 238,274 245,950 19B,722 217,939 167,467 259,801 328,246 2,556 14,319 10,187 3,7424,440 12 Marketing 13 14 Admin 16 Total Expenses 18 Operating Profit 20 Interest income 22 Other Income 23 24 Pre-tax Profit 196,166 203,620 157,280 256,059 323,8D6 97,142 226,664 25 income Tax 58,850 61,086 47,184 76,818 20 Net Profit 137,316 142,534 110,096 179,241 Sheet acer