Questions: Use the information on the Data worksheet and pivot tabies, formulas, and/or functions to answer the following questions. 01a. What is the percentage of Property, plant, and equipment (net) to total assets for Division 3 in 2023 ? (Round the percentage to two decimal places, such as 8.79% ) % Q1b. How much did the percentage increase (decrease) from 2022 ? (Round the percentage to two decimal places, such as 8.79%.) Q2a. Does total assets = total liabilities + total stockholders' equity for all divisions combined in 2023? Yes No Q2b. What is the percentage of total stockholders' equity to total liabilities + total stockhalders' equity for all divisions combined in 2023 ? (Round the percentage to two decimal places, such as 8.79%.) Q3a. Among the divisions, what is the highest percentage of gross profit to sales in 2023 ? (Round the percentage to two decimal places, such as 8.799.). % Q3b. Which division has the highest percentage? Division 1 Division 2 Division 3 04a. For all three divisions combined, what is the percentage of net income to sales in 2023 (Round the percentage to two decimal places, such as 8.79%.) % Q4b. How much did the percentage increase (decrease) from 2022 ? (Round the percentage to two decimal places, such as 8.79%.) % Q2a. Does total assets = total liabilities + total stockholders' equity for all divisions combined in 2023 ? Yes No Q2b. What is the percentage of total stockholders' equity to total liabilities + total stockholders' equity for all divisions combined in 2023 ? (Round the percentage to two decimal places, such as 8.79%.) Q3a. Among the divisions, what is the highest percentage of gross profit to sales in 2023 ? (Round the percentage to two decimal places, such as 8.79%.) Q3b. Which division has the highest percentage? Division 1 Division 2 Division 3 Q4a. For all three divisions combined, what is the percentage of net income to sales in 2023 ? (Round the percentage to two decimal places, such as 8.79%. Q4b. How much did the percentage increase (decrease) from 2022? (Round the percentage to two decimal places, such as 8.79% ) Q5. Which statement explains why the percentage of net income to sales will always be equal to or lower than the percentage of gross profit to sales? Cos of goods suld is ahong grewer than total eperating expenies. Teal eperaing espenses decrase the grou prefit artount. Teal eperving expense increase the grow profit ameunt. Vertical Analysis Completing this activity will help you leam to: - Evaluate a company's performance using vertical analysis. - Extract information from a dato set using Excel formulas, functions, and/or pivot tables. Scenario: Company A has three divisions: 1,2 , and 3. Each division prepares its own financial reports using the same financial statement templates. The Data worksheet contains a list of 2023 and 2022 account balances that relate to these divisions. Each row provides information about one account in one of the two years and in one of three divisions. Other information includes account type, financial statement where the account is reported, and the account balance. Open spreadsheet Steps to create a pivot table: 51. Select a cell in the data on the Data worksheet. 52. Select Insert / Pivot Table, The data range will automatically be inserted. A "Create Pivotrable" window should appeac. 53. In the window, under "Choose where you want the PivotTable report to be placed", select "New Worksheet". A new worksheet should appear with the PivotTable. 54. A PivorTable Field List should pop up, Drag fields into rows, columns, fitters, and values areas as needed, (tr this gray work box does not appear, right click in the pivot tabie and select "Show Field List".) Questions: Use the information on the Data worksheet and pivot tabies, formulas, and/or functions to answer the following questions. 01a. What is the percentage of Property, plant, and equipment (net) to total assets for Division 3 in 2023 ? (Round the percentage to two decimal places, such as 8.79% ) % Q1b. How much did the percentage increase (decrease) from 2022 ? (Round the percentage to two decimal places, such as 8.79%.) Q2a. Does total assets = total liabilities + total stockholders' equity for all divisions combined in 2023? Yes No Q2b. What is the percentage of total stockholders' equity to total liabilities + total stockhalders' equity for all divisions combined in 2023 ? (Round the percentage to two decimal places, such as 8.79%.) Q3a. Among the divisions, what is the highest percentage of gross profit to sales in 2023 ? (Round the percentage to two decimal places, such as 8.799.). % Q3b. Which division has the highest percentage? Division 1 Division 2 Division 3 04a. For all three divisions combined, what is the percentage of net income to sales in 2023 (Round the percentage to two decimal places, such as 8.79%.) % Q4b. How much did the percentage increase (decrease) from 2022 ? (Round the percentage to two decimal places, such as 8.79%.) % Q2a. Does total assets = total liabilities + total stockholders' equity for all divisions combined in 2023 ? Yes No Q2b. What is the percentage of total stockholders' equity to total liabilities + total stockholders' equity for all divisions combined in 2023 ? (Round the percentage to two decimal places, such as 8.79%.) Q3a. Among the divisions, what is the highest percentage of gross profit to sales in 2023 ? (Round the percentage to two decimal places, such as 8.79%.) Q3b. Which division has the highest percentage? Division 1 Division 2 Division 3 Q4a. For all three divisions combined, what is the percentage of net income to sales in 2023 ? (Round the percentage to two decimal places, such as 8.79%. Q4b. How much did the percentage increase (decrease) from 2022? (Round the percentage to two decimal places, such as 8.79% ) Q5. Which statement explains why the percentage of net income to sales will always be equal to or lower than the percentage of gross profit to sales? Cos of goods suld is ahong grewer than total eperating expenies. Teal eperaing espenses decrase the grou prefit artount. Teal eperving expense increase the grow profit ameunt. Vertical Analysis Completing this activity will help you leam to: - Evaluate a company's performance using vertical analysis. - Extract information from a dato set using Excel formulas, functions, and/or pivot tables. Scenario: Company A has three divisions: 1,2 , and 3. Each division prepares its own financial reports using the same financial statement templates. The Data worksheet contains a list of 2023 and 2022 account balances that relate to these divisions. Each row provides information about one account in one of the two years and in one of three divisions. Other information includes account type, financial statement where the account is reported, and the account balance. Open spreadsheet Steps to create a pivot table: 51. Select a cell in the data on the Data worksheet. 52. Select Insert / Pivot Table, The data range will automatically be inserted. A "Create Pivotrable" window should appeac. 53. In the window, under "Choose where you want the PivotTable report to be placed", select "New Worksheet". A new worksheet should appear with the PivotTable. 54. A PivorTable Field List should pop up, Drag fields into rows, columns, fitters, and values areas as needed, (tr this gray work box does not appear, right click in the pivot tabie and select "Show Field List".)