Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Next, perform the following analyses relating to collectability risk [the risk the company 1won't collect money for its sales) on the December 31, 2015, accounts
Next, perform the following analyses relating to collectability risk [the risk the company 1won't collect money for its sales) on the December 31, 2015, accounts receivable balance. For each procedure, provide a brief statement regarding your ndings as a caption to the visualized data. Format the caption appropriately to allow for easy reading alongside the table or graph. Ham: Note that \"year-to-date\" means cumulative, from the beginning of the year. For example, at the end of January, \"year-todate\" sales are January sales, but at the end of February, \"year-to- date\" sales are January + February sales, and so on. There are many approaches you may take in responding to questions 2-4. It is acceptable to add columns to the source data for month, cumulative days in the period, aging category, etc. As you respond to the questions, think about how you expect the data to look and whetherthe results are consistent with your expectations. 2. {5 patina) Display the year-to-date trend in sales and cash receipts by month for 21315 (with dollars on the a-axis and months on the y-axis). Use a visualization to best highlight any concerns about potential collection issues. Caption the visualization with a brief statement of your ndings and ioferences,highlighting any concerns. 3. ['15 patios) Compute the year-todate days-sales-outstanding (BSD) ratio for each month. Show the results numerically and with a visualization. For the latter, use a column chart, also cailed a vertical bar chart {with DSCI as the z-axis and months as the y-azis), to best highlight any concerns about potential collection issues. Caption the visualization with a brief statement of your ndings and inferences, highlighting any concerns. DSD = ending AR balance for the period ! total sales for the period [year-todateD * number of days in the period (year-to-date) 4. (I5 patina) Develop an aging analysis by customer and invoice using 30-day increments (D 3D days, Illtil} days, lQ days and 1:: 9!] days). Display this at the customer level with the ability to drill down to the transaction (invoice) level. Provide a visualization of the percentage of accounts receivable in each aging category at the company level using a column chart [with percentage as the x-axis and aging category as the yazis]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started