We need to use the given data to fill in requirment 1, 2, and 3.
AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 ' 2 Wrap Text Paste BIU "A v Merge & Cente 026 x x B D H 1 Given Data P05-03: THE UNDERWOOD CORPORATION $ $ 3 4 5 6 7 8 9 10 11 12 13 14 15 16 June 12, 2021 September 17, 2021 December 31, 2021 March 4, 2022 May 20, 2022 July 2, 2022 October 19, 2022 December 31, 2022 Transactions for 2021 and 2022: Provide service to customers on account Receive cash from customers on account Estimated A/R that will not be received Provide service to customers on account Receive cash from customers for 2021 services Write off remaining 2021 accounts Receive cash from customers for 2022 services Estimated AR that will not be received $ $ 41,000 25.000 45% 56,000 10.000 2 45,000 45% $ 18 19 20 21 22 23 24 25 26 27 28 29 30 32 33 35 37 38 40 41 42 44 40 49 50 P05-03 P05-04 POS-08 Given P05-03 Given P05-04 Given POS-08 Problem 05-03 Requirement 1: THE UNDERWOOD CORPORATION 2021 and 2022 Transactions Date June 12, 2021 Debit Credit Account Accounts Receivable Service Revenue (Provide services on account) Cash Accounts Receivable (Receive cash on account) Bad Debt Expense Alowance for Uncollectible Accounts Estimate future bad debts) 4 September 17, 2021 5 .6 17 18 December 31, 2021 19 20 21 22 March 4, 2022 23 24 25 25 May 20, 2022 27 20 20 30 July 2, 2022 31 32 33 34 October 19, 2022 35 Accounts Receivable Service Revenue (Provide services on account) Cash Accounts Receivable Receive cash on account) Allowance for Uncolectible Account Account cevable Wit of actual bad debt 37 38 39 Cash Accounts Receivable Receive cash on account) Bad Debt Expense Allowance for Uncate Accounts Este future bad de December 31, 2022 Requirement 2: THE UNDERWOOD CORPORATION T.Ants 45 46 Allowance for Lincollectie A Cash Account Receivable P06-04 POS- POS-03 Given P05-03 Given P05-04 Given P05-0 MacBook Pro esc B % @ # 3 5 6 7 4 1 2 T E Y W R Y Data Review View Tell me Arial 10 Wrap Text Paste General B BE Merge & Center $ % 1 X & fx D E F H J October 19, 2022 Cash Accounts Receivable Receive cash on account B December 31, 2022 Bad Debt Expense Alowance for Uncollectible Accounts (Estimate future bad debts) 1 2 Requirement 2: 14 15 THE UNDERWOOD CORPORATION T-Accounts 47 18 Cash Accounts Receivable Allowance for Uncollectible Accts 50 51 55 12/31/21 12/31/21 12/31/21 55 56 57 58 59 60 12/31/22 12/31/22 12/3122 2021 2022 62 89 54 65 Requirements: Total accounts receivable Les Allowance for uncolle account Net accounts receivable TE 00 38 POS-00 Given P06-03 P06-04 Given P05-04 Pos os Given POS MacBook Pro esc B
