Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter: a . Convert the balance sheet into a format that is
Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter:
a Convert the balance sheet into a format that is suitable for a pivot table by transposing the data using Get & Transform. Don't forget to enter the word "Date" above the dates.
b Build a pivot table from the data showing Total Assets by Quarter. Add a pivot chart showing how total assets have grown over time.
c Create a calculated field that shows the current ratio in the pivot table, and format the numbers with two decimal places.
d Create a pivot chart that shows the current ratio over time. Has Alphabet's liquidity deteriorated or improved over this period? Insert a trend line into the chart to verify your results.
E Now, use a Timeline to filter the pivot table so that it only shows to Now show only to 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