Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

please answer the required 1,2,3,4 from this question. the questions are the last 4 pictures, the ones in the beginning are only the prompts. The

please answer the required 1,2,3,4 from this question. the questions are the last 4 pictures, the ones in the beginning are only the prompts. The cut off in the third picture is intentional. Thank you so so much!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
IBS is a global provider of point-of-sale systems and related services that enable businesses to accept electronic payments. As a new hire in the company's international headquarters' accounting department, one of your first assignments is to assist a team tasked with analyzing the company's accounts receivable collections. As a starting point, the team is provided with the following Tableau Dashboard AR by Country Receivables Turnover Ra.. 0.00 16.30 2020 Mapbox OpenStreetMap AR by Company 0-30 Days 31-60 Days Company Invoice Past Due Past Due Company 1186 IN-1235005 45,009 0 IN-1237863 0 6,004 Company 1187 IN-1236006 278,003 0 IN-1237864 19.002 0 Company 1208 IN-1234995 44,118 0 Company 1256 IN-1236009 2.096,650 0 IN-1237776 120,000 0 IN-1237836 0 15,000 IN-1237845 92.805 0 IN-1237867 5,000 0 Company 1633 IN-1235004 300.987 IN-1237862 0 3.1.000 Company 1799 IN-1236016 3.008.009 IN-1237783 3.500 IN-1237843 O IN-1237852 0 13.000 Company 1800 IN-1236017 308.000 IN-1237784 100.400 7.000 IN-1237844 IN 1237853 Company 1801 IN-1236018 IN-1237785 20.00 61-90 Days 91-120 Days Past Due Past Due 0 0 0 15,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35.000 0 0 0 0 0 0 32.000 -24,000 104.009 >120 Days Grand Past Due Total 0 45,009 0 21,004 0 278,003 0 19,002 0 44,118 0 2,096,650 0 120,000 0 15,000 0 92.805 0 5,000 0 300.987 34,000 0 3,008,009 0 3,500 0 35,000 0 43,000 0 308,000 107,400 32.000 -24,000 104,009 120,000 To see companies within a particular country, either click on that country or use the search field in the upper left corner. To return to the map's global view, click on the Home icon in the upper left corner Drawing from the data available, assess the following: 1. Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. 2. Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? 3. Which company in Peru is most responsible for that country's low turnover ratio? 4. IBS has established estimates for percentages of outstanding accounts receivable that are past due for the following periods of time that will be uncollectible: 2x 53 10% 15% 20% 0-30 days 31-60 days 61-90 days 91-120 days >120 days Using these estimates calculate the Allowance for Uncollectible Accounts for South Korea Complete this question by entering your answers in the tabs below. Required Required a Required Required 4 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Identify the three countries with the most favorable collection experience as measured by their receivables turno (Round your answers to 2 decimal places.) Country Receivables Turnover Ratio Required 2 > Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? (Round your answer to 2 decimal places.) Country Receivables Turnover Ratio Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 which company in Peru is most responsible for that country's low turnover ratio? es Company 1186 O Company 3417 Company 11644 O Company 19949 Company 9913 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Requlyed 4 Calculate the Allowance for Uncollectible accounts for South Korea. Allowance for Uncollectible Accounts 120 Days Grand Past Due Total 0 45,009 0 21,004 0 278,003 0 19,002 0 44,118 0 2,096,650 0 120,000 0 15,000 0 92.805 0 5,000 0 300.987 34,000 0 3,008,009 0 3,500 0 35,000 0 43,000 0 308,000 107,400 32.000 -24,000 104,009 120,000 To see companies within a particular country, either click on that country or use the search field in the upper left corner. To return to the map's global view, click on the Home icon in the upper left corner Drawing from the data available, assess the following: 1. Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. 2. Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? 3. Which company in Peru is most responsible for that country's low turnover ratio? 4. IBS has established estimates for percentages of outstanding accounts receivable that are past due for the following periods of time that will be uncollectible: 2x 53 10% 15% 20% 0-30 days 31-60 days 61-90 days 91-120 days >120 days Using these estimates calculate the Allowance for Uncollectible Accounts for South Korea Complete this question by entering your answers in the tabs below. Required Required a Required Required 4 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Identify the three countries with the most favorable collection experience as measured by their receivables turno (Round your answers to 2 decimal places.) Country Receivables Turnover Ratio Required 2 > Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? (Round your answer to 2 decimal places.) Country Receivables Turnover Ratio Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 which company in Peru is most responsible for that country's low turnover ratio? es Company 1186 O Company 3417 Company 11644 O Company 19949 Company 9913 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Requlyed 4 Calculate the Allowance for Uncollectible accounts for South Korea. Allowance for Uncollectible Accounts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Information For Decisions

Authors: John J. Wild

10th Edition

9781260705584

Students also viewed these Accounting questions