Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 R. 0.00 16:30 2021 Mapbox OpenStreetMap AR by Company >120 Days 91-120 Days Past Due 0 15,000 0 0 0 0 0 0 0 Company Invoice Company 1186 IN-1235005 IN-1237863 Company 1187 IN-1236006 IN-1237864 Company 1208 IN-1234995 Company 1256 IN-1236009 IN-1237776 IN-1237836 IN-1237845 IN-1237867 Company 1633 IN-1235004 IN-1237862 Company 1799 IN-1236016 IN-1237783 IN-1237843 IN-1237852 Company 1800 IN-1236017 IN-1237784 IN-1237844 IN-1237853 Company 1801 IN-1236018 IN-1237785 COA . **+ableau 0-30 Days 31-60 Days 61-90 Days Past Due Past Due Past Due 45,009 0 0 0 6,004 0 278,003 0 0 19,002 0 0 14.118 0 0 2.096.650 0 0 120,000 0 0 0 15,000 0 92.805 0 0 5.000 0 0 300,987 0 0 0 34.000 0 3,008,009 0 0 3,500 0 0 0 0 35,000 0 43,000 0 308,000 0 0 100.400 7,000 0 0 0 0 0 -24,000 0 0 104.009 0 120.000 0 0 0 0 0 0 0 0 0 0 32,000 0 0 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 0 34,000 0 3,008,009 0 3,500 0 35,000 0 43,000 0 308,000 0 107.400 0 32.000 -24,000 0 104,009 0 120.000 SARI T To see companies within a particular country, either click on that country or use the search field in the upper left comer. 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 ratlo? 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: 24 56 101 158 0-30 days 31-60 days 61-90 days 91-120 days >120 days 200 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 Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. (Round your answers to 2 decimal places.) Country Receivables Turnover Ratio 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 Required 1 Required 2 Required 3 Required 4 Calculate the Allowance for Uncollectible accounts for South Korea Allowance for Uncollection Accounts 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 R. 0.00 16:30 2021 Mapbox OpenStreetMap AR by Company >120 Days 91-120 Days Past Due 0 15,000 0 0 0 0 0 0 0 Company Invoice Company 1186 IN-1235005 IN-1237863 Company 1187 IN-1236006 IN-1237864 Company 1208 IN-1234995 Company 1256 IN-1236009 IN-1237776 IN-1237836 IN-1237845 IN-1237867 Company 1633 IN-1235004 IN-1237862 Company 1799 IN-1236016 IN-1237783 IN-1237843 IN-1237852 Company 1800 IN-1236017 IN-1237784 IN-1237844 IN-1237853 Company 1801 IN-1236018 IN-1237785 COA . **+ableau 0-30 Days 31-60 Days 61-90 Days Past Due Past Due Past Due 45,009 0 0 0 6,004 0 278,003 0 0 19,002 0 0 14.118 0 0 2.096.650 0 0 120,000 0 0 0 15,000 0 92.805 0 0 5.000 0 0 300,987 0 0 0 34.000 0 3,008,009 0 0 3,500 0 0 0 0 35,000 0 43,000 0 308,000 0 0 100.400 7,000 0 0 0 0 0 -24,000 0 0 104.009 0 120.000 0 0 0 0 0 0 0 0 0 0 32,000 0 0 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 0 34,000 0 3,008,009 0 3,500 0 35,000 0 43,000 0 308,000 0 107.400 0 32.000 -24,000 0 104,009 0 120.000 SARI T To see companies within a particular country, either click on that country or use the search field in the upper left comer. 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 ratlo? 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: 24 56 101 158 0-30 days 31-60 days 61-90 days 91-120 days >120 days 200 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 Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. (Round your answers to 2 decimal places.) Country Receivables Turnover Ratio 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 Required 1 Required 2 Required 3 Required 4 Calculate the Allowance for Uncollectible accounts for South Korea Allowance for Uncollection Accounts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Asia Bond Monitor September 2017

Authors: Asian Development Bank

1st Edition

9292579452,9292579460

More Books

Students also viewed these Finance questions

Question

What is the difference between risk and uncertainty?

Answered: 1 week ago