Please kindly attached the excel file solution, not the image

Today is Dec 31, 2020.THP is a clothing retailer that started its business 20 years ago.It currently has two locations within Scarborough Town Centre shopping mall, one near Entrance A (Location #1) on the upper floor and one near Entrance F (Location #2) on the lower floor. The 2020 income statement for each location and other selected information are shown below (For the purpose of this assignment, consider 2020 as Year 0, 2021 as Year 1 etc.).

THP 2020 Income Statement (by location) Location #1 Location #2 Entrance A Sales 800,000 COGS 550, 000 Gross Margin 250,000 Rent 80,000 Salaries 64,000 G&A 35,000 EBIT 71,000 Other information Store Size (Sq. ft.) 19,000 Inventory level (as at Dec 31, 2020) 200,000 Entrance F 1, 000, 000 700, 000 300, 000 200, 000 90, 000 60, 000 (50, 000) 25,000 250,000 Total 1,800,000 1, 250, 000 550,000 280,000 154,000 95,000 21,000