Also calculate the profit and loss each year if they only have e-commerce and why this year we should shut down the business?

What year should the business shut down the stores and become an on-line only business? Assume: Retail Store sales are declining (-$100,000 per year) If you close the store, 25% of the store sales will migrate to e-commerce E-commerce SG&A can be managed to 25% of sales Current Projections 2024 2023 2020 2022 2021 2020 Store sales 1,100,000 e-commerce sales $ $ $ 800,000 $ 900,000 $ 1,000,000 $ 180,000 $ 175,000 $ 170,000 $ 982,020 $ 1,077,022 $ 1,172,021 $ 165,000 Total Sales 1,267,020 42.0% 42.0% 42.0% 42.0% Gross Margin % Gross Margin $ 412,448 452,349 $ 492,249 $ 532,148 $ $ $ $ SG&A 463,050 441,000 $ 420,000 $ 400,000 EBIT $ (50,602) $ 11,349 $ 72,249 $ 132,148 SG&A/sales 58% 49% 42% 36%