Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter: a....
60.1K
Verified Solution
Link Copied!
Question
Accounting
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? e. Now, use a Timeline to filter the pivot table so that it only shows 2015 to 2016. Now show only 2012 to 2013. Is there a difference in the trend of the current ratio in the two time periods?
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
