Question: Answer the questions based on the information on the graphs. This is all the information that was given. There isnt anymore information to share with

 Answer the questions based on the information on the graphs. This
is all the information that was given. There isnt anymore information to
share with you. You are new to the accounting team at Franko.
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 GFFOY Cash Flows from Operations
Cash Com Salaries Net Income vs Cash Flows from Operations Restrepid 2016
2003 2017 AD 2017 Hook S200K 2013 rences SISON ISOK S100K SOK
TOK SOR Salaries R Casteen paid Rest Ces Prepaid Paid Account Names
CFFO Net Salary Exp Net Income Revenues Reat Esp 2016 201N 2010
200 CAN M2016 Cumulative Difference Amor Net Income Revenues Rent Exp Salary
Exp Utiities Exp 2017 2016 2018 200K Net Income (All) 2016 150K
2017 C wwar * + 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 year is it most likely the company provided a
high-priced service on account without cash being collected? 2016 O 2017 2019
Analytics i Saved LURU ** + 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 By how much do revenues exceed expenses in 2016? $
Answer the questions based on the information on the graphs. This is all the information that was given. There isnt anymore information to share with you.

You are new to the accounting team at Franko. 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 GFFOY Cash Flows from Operations Cash Com Salaries Net Income vs Cash Flows from Operations Restrepid 2016 2003 2017 AD 2017 Hook S200K 2013 rences SISON ISOK S100K SOK TOK SOR Salaries R Casteen paid Rest Ces Prepaid Paid Account Names CFFO Net Salary Exp Net Income Revenues Reat Esp 2016 201N 2010 200 CAN M2016 Cumulative Difference Amor Net Income Revenues Rent Exp Salary Exp Utiities Exp 2017 2016 2018 200K Net Income (All) 2016 150K 2017 C wwar * + 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 year is it most likely the company provided a high-priced service on account without cash being collected? 2016 O 2017 2019 Analytics i Saved LURU ** + 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 By how much do revenues exceed expenses in 2016? $ $ 86,171 50,469 150,049 63,878 Analytics Saved * + 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 What is the highest expense in 2019? Rent Salary Utilities LULU 4 + 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? O 2016 and 2019 O2017 and 2020 O2018 and 2021 Required 1 Required 2 > Check my work V 100K Account Names CFFO Net Income 50K 2016 2017 2018 2019 2020 2021 Cumulative Difference SAmount SOK S86K $80K $70K S60K S50K $40K $30K $20K $10K SOK 2016 le.. 2017 2018 2019 2020 2021 K TO 2 Check my work Net Income vs Cash Flows from Operations 200K 150K 100K Account Names CFFO Net Income 50K 2016 2017 2018 2019 2020 2021 Cumulative Difference S Amount SOK $86K $80K Net Income Revenues Rent Exp Salary Exp Utiities Exp 2017 2016 2018 Net Income 200K C (A1I) 2016 2017 2018 150K S $ $ 2019 100K 2020 $ S $ $ 50K $ OK Reven.. Rent E.Salary.. Utiitie. Reven.. Rent E..Salary.. Utiitie. Reven.. Rent E..Salary.. Utiitie.. ** + ableau Cash Flows from Operations Salaries Paid Cash from Customers Rent Prepaid 3 Yrs CFFO Yello (All) 2016 2017 Utilities Paid 2017 2016 $200K 2018 2019 2020 $150K 2021 $100K $50K SOK Cash from Rent Customers Prepaid .. Salaries Paid Utilities Paid Cash from Rent Customers Prepaid .. Salaries Paid Utilities Paid 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 Cath from Customers Net Income vs Cash Flows from Operations 200K CHFO Yar Rent paid 3 Yrs Sales Uh Paid 2016 2017 2016 S200K OIR 2019 2020 2021 SISOK 1546 S1OOK SSOK LOK SOK Salaries Paid Cash from Real Customers Prepaid Paid Account Nam CFFO Net Income SON Net Income Revenues Rent Exp Salary Exp Utilities Exp 2017 2016 2018 2016 2017 2018 2020 200K Net Income CAID Cumulative Difference SA You are new to the accounting team at Franko. 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 GFFOY Cash Flows from Operations Cash Com Salaries Net Income vs Cash Flows from Operations Restrepid 2016 2003 2017 AD 2017 Hook S200K 2013 rences SISON ISOK S100K SOK TOK SOR Salaries R Casteen paid Rest Ces Prepaid Paid Account Names CFFO Net Salary Exp Net Income Revenues Reat Esp 2016 201N 2010 200 CAN M2016 Cumulative Difference Amor Net Income Revenues Rent Exp Salary Exp Utiities Exp 2017 2016 2018 200K Net Income (All) 2016 150K 2017 C wwar * + 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 year is it most likely the company provided a high-priced service on account without cash being collected? 2016 O 2017 2019 Analytics i Saved LURU ** + 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 By how much do revenues exceed expenses in 2016? $ $ 86,171 50,469 150,049 63,878 Analytics Saved * + 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 What is the highest expense in 2019? Rent Salary Utilities LULU 4 + 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? O 2016 and 2019 O2017 and 2020 O2018 and 2021 Required 1 Required 2 > Check my work V 100K Account Names CFFO Net Income 50K 2016 2017 2018 2019 2020 2021 Cumulative Difference SAmount SOK S86K $80K $70K S60K S50K $40K $30K $20K $10K SOK 2016 le.. 2017 2018 2019 2020 2021 K TO 2 Check my work Net Income vs Cash Flows from Operations 200K 150K 100K Account Names CFFO Net Income 50K 2016 2017 2018 2019 2020 2021 Cumulative Difference S Amount SOK $86K $80K Net Income Revenues Rent Exp Salary Exp Utiities Exp 2017 2016 2018 Net Income 200K C (A1I) 2016 2017 2018 150K S $ $ 2019 100K 2020 $ S $ $ 50K $ OK Reven.. Rent E.Salary.. Utiitie. Reven.. Rent E..Salary.. Utiitie. Reven.. Rent E..Salary.. Utiitie.. ** + ableau Cash Flows from Operations Salaries Paid Cash from Customers Rent Prepaid 3 Yrs CFFO Yello (All) 2016 2017 Utilities Paid 2017 2016 $200K 2018 2019 2020 $150K 2021 $100K $50K SOK Cash from Rent Customers Prepaid .. Salaries Paid Utilities Paid Cash from Rent Customers Prepaid .. Salaries Paid Utilities Paid 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 Cath from Customers Net Income vs Cash Flows from Operations 200K CHFO Yar Rent paid 3 Yrs Sales Uh Paid 2016 2017 2016 S200K OIR 2019 2020 2021 SISOK 1546 S1OOK SSOK LOK SOK Salaries Paid Cash from Real Customers Prepaid Paid Account Nam CFFO Net Income SON Net Income Revenues Rent Exp Salary Exp Utilities Exp 2017 2016 2018 2016 2017 2018 2020 200K Net Income CAID Cumulative Difference SA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!