Question
Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter: Create a pivot chart that shows the current ratio over time.
-
Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter:
-
Create a pivot chart that shows the current ratio over time. Has Alphabets liquidity deteriorated or improved over this period? Insert a trend line into the chart to verify your results.
-
Now, use a Timeline to filter the pivot table so that it only shows 2018 to 2019. Now show only 2013 to 2014. Is there a difference in the trend of the current ratio in the two time periods?
-
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
Creative Accounting, Fraud And International Accounting Scandals
Authors: Michael J. Jones
1st Edition
0470057653, 9780470057650
