Hi, could you please provide the steps and specific calculations for each of these requirements? thank you!

Orange Ald, is a leading worldwide Integrated brand owner, botter, and distributor of nonalcoholic beverages The following represents selected data from recent financial statements of Orange Aid (dollars in millions Pontos ONGEAED Consolidated Balance Sheets (partial) December 31. 2013 5 (in millions) December 31. 20x2 Current assets Cash and cash equivalent Accounts receivable (net of allowances of $10 and 517, respectively) $220 Box Consolidated Statements of Income (partial) For the Year Ended December 11 in millions) 200 20x1 Net saler 5 5,630 $ 506 5,504 Net Income 1.074 $ $ The company also reported bad debt expense of $6 milion in 20x3. $12 million in 20x2, and $8 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! Required 2 Required 3 art 1 of 5 Record the company's write-offs of uncollectible accounts for 20x3. (If no entry is required for a transaction/event, select "Rio journal entry required in the first account field. Enter your answers in millions (ie. 10,000,000 should be entered as 10).) 5 View transaction list Book Journal entry worksheet terences 1 Record the company's write offs of uncollectible accounts for 20x3. Note: Enter debits before credits Transaction General Journal Debit Credit 1 Accounts receivable Allowance for uncollectible accounts - Required information of 5 The company also reported bad debt expense of $6 million in 20x3. $12 million in 20x2, and $8 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 Ald 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 Orangold collect from customers in 20x37 (Enter your answer in millions Cash collections for 2013 million