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.
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 I are scrollable. CFFO Years Cash Flows from Operations Cash from Customers Salaries Paid (All) Rent Prepaid 3 Yrs Net Income vs Cash Flows from Operations Utilities Paid 2016 2017 2018 2020 200K 2017 2018 2019 $200K 2019 2016021 2020 2021 150K $100K 100K SOK Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Account Names CFFO Net Income BOK Net Income 2016 Revenues Rent Exp 2017 2018 Salary Exp Utiities Exp 2019 2021 2020 Net Income 2016 2017 2018 2019 2020 2021 200K Cumulative Difference 5 Amount SOK S86K 150K 2016 2017 2018 2019 2020 2021 SSOK $70K $60K 100K SOK 50K $40K $30K $20K $IOK SOK OK tides Udine Utitie Unides Utatie 2016 2017 2018 2019 2020 2021 + ableau TO Drawing from the data available, assess the following: 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 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. 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. CFFO Years Cash Flows from Operations Cash from Customers Net Income vs Cash Flows from Operations Rent Prepaid 3 Yrs 2018 Salaries Paid Utilities Paid 2020 (All) 2016 2017 2019 2016021 200K 2017 2018 2019 2020 2021 $200K 150K $100K 100K SOK Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Account Names CFFO Net Income BOK Net Income 2016 Revenues Rent Exp 2017 2018 Salary Exp Utiities Exp 2019 2021 2020 Net Income 2016 2017 2018 2019 2020 2021 200K Cumulative Difference SAmount SOK S86% 150K 2016 2017 2018 2019 2020 2021 100K $SOK $70K $60K $50K $40K SJOK SZOK SIOK SOK 50K ....... OK Chines Critie Udities Uite Chile Utitie 2016 2017 2018 2019 2020 2021 tableau Drawing from the data available, assess the following: 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. 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. 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. CFFO Years Cash Flows from Operations Cash from Customers Salaries Paid (A1) Net Income vs Cash Flows from Operations Rent Prepaid 3 Yrs Utilities Paid 2017 2019 2020 200K 2017 2018 2019 $200K 2016 2016021 2018 2020 2021 150K $100K 100K SOK Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Account Names CFFO Net Income BOK Net Income 2016 Revenues Rent Exp 2017 Salary Exp Utiities Exp 2018 2019 2021 2017 2018 2019 2020 2021 2016 Cumulative Difference 200K $ Amount 2020 Net Income 2016 2017 2018 2019 2020 2021 SOK 86K 150K 100K SSOK S70K $60K $50K $40K SJOK $20K $10K SOK 50K OK Unides Utte. Utitie Crities Utste 2016 2017 2018 2019 2020 2021 tableau Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. 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 2017 2019 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 Nl are scrollable. Cash Flows from Operations Cash from Customers CFFO Years Salaries Paid Net Income vs Cash Flows from Operations Rent Prepaid 3 yrs Utilities Paid (All) 2016 2017 2018 2019 2020 2016021 200K 2017 2018 2019 2020 150K $200K 2021 $100K 100K SOK Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Account Names CFFO Net Income BOK Net Income 2016 Revenues Rent Exp 2017 2018 Salary Exp Utiities Exp 2019 2021 2020 Net Income 2017 2018 2019 2020 2021 2016 Cumulative Difference Amount 200K SOI S86K 2016 2017 2018 2019 2020 2021 150K 100K S80K $70K $60K $50K $40K $30K $20K $10K SOK 50K ... OK dides Utitie Udities Usitie. Uries Utite 2016 2017 2018 2019 2020 2021 #+ableau E Drawing from the data available, assess the following: 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 highest expense in 2019? Rent Salary Utilities 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 Nl are scrollable. Cash Flows from Operations Cash from Customers CFFO Years Salaries Paid Net Income vs Cash Flows from Operations Rent Prepaid 3 yrs Utilities Paid (All) 2016 2017 2018 2019 2020 2016021 200K 2017 2018 2019 2020 150K $200K 2021 $100K 100K SOK Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Utilities Paid Account Names CFFO Net Income BOK Net Income 2016 Revenues Rent Exp 2017 2018 Salary Exp Utiities Exp 2019 2021 2020 Net Income 2017 2018 2019 2020 2021 2016 Cumulative Difference Amount 200K SOI S86K 2016 2017 2018 2019 2020 2021 150K 100K S80K $70K $60K $50K $40K $30K $20K $10K SOK 50K ... OK dides Utitie Udities Usitie. Uries Utite 2016 2017 2018 2019 2020 2021 #+ableau Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. 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 2017 and 2020 2018 and 2021
