Tapieau Dashboard Activity 3-1 You are new to the accounting team at Frank O. Pinion Consulting and are trying to gain insight into the company's cash flow history. At first glance you notice an apparent erratic relationship between net income and cash flows from operating activities. To better visualize the relationship, you have created a Tableau Dashboard depicting an overview of cash inflows and outflows for the most recent six years. Note: The "Years" filters for CFFO and NI are scrollable. Cash Flows from Operations 2016 Cash from Customers Rent Prepaid 3 Yrs Salaries Paid Utilities Paid 2017 CFFO Years (All) | 2016 2017 2018 Net Income vs Cash Flows from Operations 200K $200K 2019 2020 $150K 2021 150K $100K $50K 100K SOK Account Names Cash from Rent Salaries Utilities Cash from Rent Salaries Utilities Cru Rent Prepaid 3 Yrs Utilities Paid 2017 2016 (All) 2016 2017 2018 200K 2019 2020 2021 150K 100K Cash from Rent Customers Prepaid .. Salaries Paid Utilities Paid Cash from Rent Customers Prepaid... Salaries Paid Utilities Paid Account Names CFFO Net Income 50K ncome Revenues Rent Exp Salary Exp Utiities Exp 2016 2017 2016 2017 2018 2019 2020 2021 2018 Net Income (All) 2016 Cumulative Difference S Amount Net Income Revenues Rent Exp Salary Exp Utiities Exp 2017 2016 2018 2016 2017 2018 2019 2020 2021 200K ) Cumulative Difference $ Amount Net Income to (All) 2016 2017 2018 2019 2020 150K SOK $80K S86K S70K S60K 100K S50K S40K S30K 50K S20K $10K SOK OK Reven.. Rent E..Salary.. Utiitie. Reven.. Rent E.. Salary.. Utiitie. Reven.. Rent E.. Salary.. Utiitie.. 2016 2017 2018 2019 2020 2021 tableau t K T Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 In which years has the company prepaid its rent for three years? 2016 and 2019 O 2017 and 2020 2018 and 2021 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 What is the highest expense in 2019? Rent Salary Utilities Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 By how much do revenues exceed expenses in 2016? OIOIOIO 86,171 50,469 150,049 63,878 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 In which year is it most likely the company provided a high-priced service on account without cash being collected? 2016 O 2017 O2019 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 What is the most likely agreement between the consulting company and the customer who was provided the high-dollar service on account. O Payment was to be made equally over the following two years. Payment was to be made the following year. O Payment was to be made evenly over the following five years. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 What is the cumulative difference between net income and cash flows from operations over the six years reported? O Cash flows from operations over the six years significantly exceeded net income. O Cash flows from net income over the six years significantly exceeded cash flows from operations. Cash flows from operations over the six years was essentially the same as net income