Description 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. 1) In which years has the company prepaid its rent for three years? – 2016 and 2019 – 2017 and 2020 -2018 and 2021 2) What is the highest expense in 2019? – rent – salaries – uitilities 3) By how much do revenues exceed expenses in 2016? – 86,171 – 50,469 – 150,049 – 63,878 4) In which year is it most likely the company provided a high-priced service on account without cash being collected? – 2016 -2017 -2019 5) What is the most likely agreement between the consulting company and the customer who was provided the high-dollar service on account. – Payment was to be made equally over the following two years. – Payment was to be made the following year. – Payment was to be made evenly over the following five years. 6) What is the cumulative difference between net income and cash flows from operations over the six years reported? – Cash flows from operations over the six years significantly exceeded net income. – 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. Tags: net income accounting team Tableau Dashboard erratic relationship highest expense User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Description

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.

1) In which years has the company prepaid its rent for three years?

– 2016 and 2019

– 2017 and 2020

-2018 and 2021

2) What is the highest expense in 2019?

– rent

– salaries

– uitilities

3) By how much do revenues exceed expenses in 2016?

– 86,171

– 50,469

– 150,049

– 63,878

4) In which year is it most likely the company provided a high-priced service on account without cash being collected?

– 2016

-2017

-2019

5) What is the most likely agreement between the consulting company and the customer who was provided the high-dollar service on account.

– Payment was to be made equally over the following two years.

– Payment was to be made the following year.

– Payment was to be made evenly over the following five years.

6) What is the cumulative difference between net income and cash flows from operations over the six years reported?

– Cash flows from operations over the six years significantly exceeded net income.

– 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.

Tags: net income accounting team Tableau Dashboard erratic relationship highest expense
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.