Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Presented in the line graphs below are trends in revenues and expenses for each of three companies over their first six years of operations. The
Presented in the line graphs below are trends in revenues and expenses for each of three companies over their first six years of operations. The balance of the Retained Earnings account at the end of each year is presented by the bars. Each company has the same amount of revenues in Year 1 and the same amount of expenses in Year 1. Assume no dividends were paid by any of the companies. Company A Revenues, Expenses, and Retained Earnings Company B Revenues, Expenses, and retained Earnings Company C Revenues, Expenses, and Retained Earnings $32,000,000 $ $32,000,000 $32,000,000 $20,000,000 $20,000,000 $20,000,000 $8,000,000 $8,000,000 $8,000,000 ($4,000,000) Year 1 2 3 5 6 $4,000,000) 3 4 5 6 ( ($4,000,000) Year 1 2 3 4 Year 1 2 Retained Earnings +Revenues Retained Earnings +Revenues -Expenses -Expenses Retained Earnings Revenues - Expenses Click here to open the graph(s) in a new tab. Required: 1. For Company A revenues over the six years are: 2. For Company C. expenses in Year 5 are: 3. For Company A the difference between revenues and expenses is the same in each of the six years. Therefore, the company's balance of Retained Earnings over the six years: 4. 4 Company B has the same amount of expenses as Company A in each year, but revenues are growing at a faster pace. Therefore, by the end of Year 6. Company B's balance of Retained Earnings will be: 5a. Company C has the same amount of revenues as Company A in each year, but expenses are growing at a faster pace. Therefore, by the end of Year 6. Company C's balance of Retained Earnings will be: 5b. In a year that Company C reports expenses greater than revenues, the balance of Retained Earnings: 5c. By the end of Year 6. Company C's balance of Retained Earnings is: 6. If any of these companies had paid dividends in any year, their balances of Retained Earnings by the end of year 6 would have been.... Presented in the bar charts are three columns for each of the first three years of a company's operations. The three columns represent amounts reported at the end of each year - net income (left), dividends (middle). and retained earnings (right). Examine the graphs and answer the following questions. Net Income, Dividends, and Retained Earnings $300 $250 110 $200 $150 90 90 $100 150 120 $50 100 80 80 80 40 20 30 $0 NI Div RE NI Div RE Year 1 NI Div RE Year 2 Year 3 Click here to open the graph(s) in a new tab. 20 30 40 $0 NI Div RE NI Div RE NI Div RE Year 3 Year 1 Year 2 Click here to open the graph(s) in a new tab. Required: 1. What is the amount of Retained Earnings at the end of Year 1? 2a. At the end of Year 2, the company reports Net Income of $120. This amount includes: 2b. What amount of dividends did the company declare in Year 2? 2c. What is the ending balance of Retained Earnings in Year 2? 2d. The ending balance of Retained Earnings in Year 2 includes: 3a. What amount of Net Income did the company report in Year 3? 3b. What amount of dividends did the company declare in Year 3? 3c. What is the ending balance of Retained Earnings in Year 3? 3d. The ending balance of Retained Earnings in Year 3 includes: 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. CFFO Years Cash Flows from Operations Cash from Customers Salaries Paid (ALI) Net Income vs Cash Flows from Operations Rent Prepaid 3 Yrs Utilities Paid 2016 200K 2017 2018 $200K 2019 2020 $150K 2021 150K 2017 2016 N $100K $50K 100K SOK Cash from Rent Customers Prepaid .. Salaries Paid Utilities Cash from Rent Paid Customers Prepaid Salaries Paid Utilities Paid Account Names CFFO Net Income 50K Revenues Net Income Rent Exp Salary Exp Utiities Exp 2017 2016 2018 2016 2017 2018 2019 2020 2021 Net Income 200K (All) Cumulative Difference S Amount Net Income 50K Net Income Revenues Rent Exp Salary Exp Utiities Exp 2017 2016 2018 2016 2017 2019 2020 2021 200K SAmount Cumulative Difference Net Income (All) 2016 2017 2018 2019 2020 150K $86K 100K SSOK $70K $60K S50K $40K S30K $20K SIOK SOK 50K OK Reven. Rent E..Salary.. Utilitie. Reven.. Rent E.. Salary.. Utiitie. Reven... Rent E.. Salary.. Utiitie.. .. 2016 2017 2018 2019 2020 2021 ** + ableau Drawing from the data available, assess the following: Complete this question by entering vour answers in the tabs below. 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? O2016 and 2019 2017 and 2020 2018 and 2021 Required 2 > 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 awing 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? S $ OI000 86,171 50,469 150,049 63,878 $ 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? O 2016 2017 2019 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. 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. Yearl and the same amount or expenses in Year 1. Assume no olvidends were pa dividends paid by same amount of revenues companies. Company A Revenues, Expenses, and Retained Earnings Company B Revenues, Expenses, and retained Earnings Company Revenues, Expenses, and Retained Earnings $32,000,000 $32,000,000 $32,000,000 $20,000,000 $20,000,000 $20,000,000 $8,000,000 $8,000,000 $8,000,000 3 4 5 ($4,000,000) 5 6 2 ($4,000,000) Year 1 2 Retained Earnings 5 Year 1 2 3 4 Retained Earnings Revenues ($4,000,000) Year 1 Retained Earnings +Revenues Revenues -Expenses -Expenses Expenses Click here to open the graph(s) in a new tab. Required: 1. 2. For Company A revenues over the six years are: For Company C. expenses in Year 5 are: For Company A the difference between revenues and expenses is the same in each of the six years. Therefore, the company's balance of Retained Earnings over the six years: 3. Presented in the line graphs below are trends in revenues and expenses for each of three companies over their first six years of operations. The balance of the Retained Earnings account at the end of each year is presented by the bars. Each company has the same amount of revenues in Year 1 and the same amount of expenses in Year 1. Assume no dividends were paid by any of the companies. Company A Revenues, Expenses, and Retained Earnings Company B Revenues, Expenses, and retained Earnings Company C Revenues, Expenses, and Retained Earnings $32,000,000 $ $32,000,000 $32,000,000 $20,000,000 $20,000,000 $20,000,000 $8,000,000 $8,000,000 $8,000,000 ($4,000,000) Year 1 2 3 5 6 $4,000,000) 3 4 5 6 ( ($4,000,000) Year 1 2 3 4 Year 1 2 Retained Earnings +Revenues Retained Earnings +Revenues -Expenses -Expenses Retained Earnings Revenues - Expenses Click here to open the graph(s) in a new tab. Required: 1. For Company A revenues over the six years are: 2. For Company C. expenses in Year 5 are: 3. For Company A the difference between revenues and expenses is the same in each of the six years. Therefore, the company's balance of Retained Earnings over the six years: 4. 4 Company B has the same amount of expenses as Company A in each year, but revenues are growing at a faster pace. Therefore, by the end of Year 6. Company B's balance of Retained Earnings will be: 5a. Company C has the same amount of revenues as Company A in each year, but expenses are growing at a faster pace. Therefore, by the end of Year 6. Company C's balance of Retained Earnings will be: 5b. In a year that Company C reports expenses greater than revenues, the balance of Retained Earnings: 5c. By the end of Year 6. Company C's balance of Retained Earnings is: 6. If any of these companies had paid dividends in any year, their balances of Retained Earnings by the end of year 6 would have been.... Presented in the bar charts are three columns for each of the first three years of a company's operations. The three columns represent amounts reported at the end of each year - net income (left), dividends (middle). and retained earnings (right). Examine the graphs and answer the following questions. Net Income, Dividends, and Retained Earnings $300 $250 110 $200 $150 90 90 $100 150 120 $50 100 80 80 80 40 20 30 $0 NI Div RE NI Div RE Year 1 NI Div RE Year 2 Year 3 Click here to open the graph(s) in a new tab. 20 30 40 $0 NI Div RE NI Div RE NI Div RE Year 3 Year 1 Year 2 Click here to open the graph(s) in a new tab. Required: 1. What is the amount of Retained Earnings at the end of Year 1? 2a. At the end of Year 2, the company reports Net Income of $120. This amount includes: 2b. What amount of dividends did the company declare in Year 2? 2c. What is the ending balance of Retained Earnings in Year 2? 2d. The ending balance of Retained Earnings in Year 2 includes: 3a. What amount of Net Income did the company report in Year 3? 3b. What amount of dividends did the company declare in Year 3? 3c. What is the ending balance of Retained Earnings in Year 3? 3d. The ending balance of Retained Earnings in Year 3 includes: 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. CFFO Years Cash Flows from Operations Cash from Customers Salaries Paid (ALI) Net Income vs Cash Flows from Operations Rent Prepaid 3 Yrs Utilities Paid 2016 200K 2017 2018 $200K 2019 2020 $150K 2021 150K 2017 2016 N $100K $50K 100K SOK Cash from Rent Customers Prepaid .. Salaries Paid Utilities Cash from Rent Paid Customers Prepaid Salaries Paid Utilities Paid Account Names CFFO Net Income 50K Revenues Net Income Rent Exp Salary Exp Utiities Exp 2017 2016 2018 2016 2017 2018 2019 2020 2021 Net Income 200K (All) Cumulative Difference S Amount Net Income 50K Net Income Revenues Rent Exp Salary Exp Utiities Exp 2017 2016 2018 2016 2017 2019 2020 2021 200K SAmount Cumulative Difference Net Income (All) 2016 2017 2018 2019 2020 150K $86K 100K SSOK $70K $60K S50K $40K S30K $20K SIOK SOK 50K OK Reven. Rent E..Salary.. Utilitie. Reven.. Rent E.. Salary.. Utiitie. Reven... Rent E.. Salary.. Utiitie.. .. 2016 2017 2018 2019 2020 2021 ** + ableau Drawing from the data available, assess the following: Complete this question by entering vour answers in the tabs below. 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? O2016 and 2019 2017 and 2020 2018 and 2021 Required 2 > 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 awing 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? S $ OI000 86,171 50,469 150,049 63,878 $ 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? O 2016 2017 2019 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. 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. Yearl and the same amount or expenses in Year 1. Assume no olvidends were pa dividends paid by same amount of revenues companies. Company A Revenues, Expenses, and Retained Earnings Company B Revenues, Expenses, and retained Earnings Company Revenues, Expenses, and Retained Earnings $32,000,000 $32,000,000 $32,000,000 $20,000,000 $20,000,000 $20,000,000 $8,000,000 $8,000,000 $8,000,000 3 4 5 ($4,000,000) 5 6 2 ($4,000,000) Year 1 2 Retained Earnings 5 Year 1 2 3 4 Retained Earnings Revenues ($4,000,000) Year 1 Retained Earnings +Revenues Revenues -Expenses -Expenses Expenses Click here to open the graph(s) in a new tab. Required: 1. 2. For Company A revenues over the six years are: For Company C. expenses in Year 5 are: For Company A the difference between revenues and expenses is the same in each of the six years. Therefore, the company's balance of Retained Earnings over the six years: 3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started