please answer in a clear Excel sheet. thank you

Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute the company's net sales for the year. Net Sales Sales Not sales Required Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute the company's total cost of merchandise purchased for the year. Cost of Merchandise Purchased Invoice cost of merchandise purchased Purchases discounts received Purchases returns and allowances Costs of transportation in Total cost of merchandise purchased Required 1 Required 3 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Prepare a multiple-step income statement that includes separate categories for net sales, cost of goods sold, selling expenses, and general and administrative expenses. VALLEY COMPANY Income Statement For Year Ended August 31 Expenses Selling expenses Total selling expenses General and administrative expenses Total general and administrative expenses Total expenses Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Prepare a single-step income statement that includes these expense categories: cost of goods sold, selling expenses, and general and administrative expenses. VALLEY COMPANY Income Statement For Year Ended August 31 Expenses Total expenses