Orange Aid, is a leading worldwide integrated brand owner, bottler, and distributor of nonalcoholic beverages. The following represents selected data from recent financial statements of Orange Aid (dollars in millions): December 31, 20x2 ORANGEAID Consolidated Balance Sheets (partial) December (in millions) 31, 20x3 Assets Current assets: Cash and cash equivalents $223 Accounts receivable (net of allowances of $19 and $26, respectively) 529 $ 65 543 Consolidated Statements of Income (partial) For the Year Ended December 31 (in millions) 20x3 20x2 20x1 Net sales $ 5,640 $ 5,516 $ 5,514 Net income $ 1,052 $ 845 $ 735 The company also reported bad debt expense of $8 million in 20x3, $14 million in 20x2, and $10 million in 20x1. Required: 1. Record the company's write-offs of uncollectible accounts for 20x3. 2. Assuming all sales were on credit, what amount of cash did Orange Aid collect from customers in 20x3? 3. Compute the company's net profit margin for the three years presented. Complete this question by entering your answers in the tabs below. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Record the company's write-offs of uncollectible accounts for 20x3. (If no entry is required for a transaction/event, select "No journal entry required in the first account field. Enter your answers in millions (i.e., 10,000,000 should be entered as 10).) View transaction list Journal entry worksheet Record the company's write-offs of uncollectible accounts for 20x3. Note: Enter debits before credits. Transaction General Journal Debit Credit 1 Assets Current assets: Cash and cash equivalents Accounts receivable (net of allowances of $19 and $26, respectively) $223 $ 65 529 543 Consolidated Statements of Income (partial) For the Year Ended December 31 (in millions) 20x3 20x2 20x1 Net sales $ 5,640 $ 5,516 $ 5,514 Net income $ 1,052 $ 845 $ 735 The company also reported bad debt expense of $8 million in 20x3, $14 million in 20x2, and $10 million in 20x1. Required: 1. Record the company's write-offs of uncollectible accounts for 20x3. 2. Assuming all sales were on credit, what amount of cash did Orange Aid collect from customers in 20x3? 3. Compute the company's net profit margin for the three years presented. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Assuming all sales were on credit, what amount of cash did Orange Aid collect from customers in 20x37 (Enter your answer in millions.) Cash collections for 20x3 million Consolidated Statements of Income (partial) For the Year Ended December 31 (in millions) 20x3 20x2 20x1 Net sales $ 5,640 $ 5,516 $ 5,514 Net income $ 1,052 $ 845 $ 735 The company also reported bad debt expense of $8 million in 20x3. $14 million in 20x2. and $10 million in 20x1. Required: 1. Record the company's write offs of uncollectible accounts for 20x3. 2. Assuming all sales were on credit, what amount of cash did Orange Aid collect from customers in 20x3? 3. Compute the company's net profit margin for the three years presented. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the company's net profit margin for the three years presented. (Round your percentage answers to 2 decimal places (i.e. 0.1234 should be entered as 12.34).) Net Profit Margin % 20x3 20x2 % 20x1 %