No. You don't. However, you do have enough data to compute an adjusted 12/31/19 AR balance for sales transaction invoice record. Using the data you have, populate columns K and L in the "2019 data" worksheet with excel formulas of your choice to compute the 12/31/19 balance on each sales transaction record. You must use a formula in each of the sales transaction record cells in columns K and L, do not copy or paste any values. Hint: using either VLookup or Index/Match is an effective approach but you may need to add/combine another excel function(s) to your formula as well. Do your own research as needed to find the excel function that works best for you. (4 points) C. Format the amounts in column B of the "Open Invoices P202" worksheet in the Accounting format with two decimal places. d. Use a cell reference to pull your Grand Total of the Open Invoices into cell B13 on the "P103" workshoot. The grading function is looking for this value when it grades your work. (2 points) Next you perform the following analyses and visualizations relating to collectability risk, which is the risk the company won't collect money for its sales, on the adjusted December 31, 2019 accounts receivable balance. For each of these analyses you must use your adjusted December 31, 2019 AR balance. This Instruction will not be repeated in the instructions below so take good care to Incorporate it into the remainder of your work; it will impact your answers and therefore your grade. Analytics mindset case studies - TechWear 6 @ 2018 Ernst & Young Foundation (US). All Rights Reserved. SCORE No. 02315-161US