Answered step by step
Verified Expert Solution
Link Copied!

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 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?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

7th Edition

0073368717, 978-0073368719

More Books

Students also viewed these Finance questions

Question

3 What are the stages of Kotter and Cohens model of change?

Answered: 1 week ago

Question

4 What is organisation development?

Answered: 1 week ago

Question

5 What activities are employed in OD processes?

Answered: 1 week ago