Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Paste Merge& Center 00 ?0 Formatting . Table. Number Styles Font Alignment Clipboard 110 Aging of Accounts Receivable The Lake Lucerne Company uses the
Paste Merge& Center " 00 ?0 Formatting . Table. Number Styles Font Alignment Clipboard 110 Aging of Accounts Receivable The Lake Lucerne Company uses the allowance method of estimating bad debts expense. An aging schedule is prepared in order to calculate the balance The percentage uncollectible is calculated as follows 1% 2% 5% 50% After 365 days, the account is written off 1-30 Days 31-60 Days 61-90 91-365 Days l Requirements 1. Calculate the number of days each receivable is outstanding. 2. Complete the Schedule of Accounts Receivable. 3. Journalize the adjusting entry for bad debt expense. Excel Skills 1. Use the DAYS function to calculate the number of days between the invoice date and the date of the aging schedule. 2. Use the VLOOKUP function to provide the uncollectible accounts percentage based on the days outstanding 3. Use IF and AND functions to determine in which column of the Accounts Receivable Schedule to place the amount for each customer. 4. Format cells using number and percentage formats. 5. Use formulas to calculate totals. 6. Use the Increase Indent button to indent the credit account for the journal entry 7. Use Absolute references to refer to a table in the VLOOKUP formula. Formule returns Excel Tips of days between Formula End Date DAYS function VLOOKUP function Given a table with amounts and uncollectible percentages, you can use ViLOOKUP to determine the uncollectible rate for a specilic numbes
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/08/66d0220aaeace_23466d0220a30d95.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/08/66d0220b5ce27_23466d0220ad6fd4.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/08/66d0220c36ae4_23566d0220baeb45.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/08/66d0220d0627b_23666d0220c65070.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/08/66d0220d8d3de_23766d0220d2e634.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/08/66d0220e3d932_23766d0220db49b5.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/08/66d0220ee9e48_23866d0220e6d9c9.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started