(Answered) Using the data in the goog financialsxlsx workbook that was

Accounting

Using the data in the GOOG 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. Don't forget to enter the word "date" above the dates.

b. Build a pivot table from the data and group the dates by months, quarters, and years.

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 Google's short-term liquidity position deteriorated or improved over this five-year period?

e. Now, use the Timeline to filter the pivot table so that it only shows 2009 to 2010. Now show only 2012 to 2013. Is there a difference in the trend of the current ratio in the two time periods?

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M92591468
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - assume andersons general store bought on credit

Question - Assume Andersons general store bought on credit, a truckload of merchandise from American wholesaling costing $24,500. If Anderson paid National Trucking $800 cash for transportation, immediately returned good ...

Question - at december 31 2014 the available for sale

Question - At December 31, 2014, the available for sale equity portfolio for xyz corp. is as follows. Security Cost Fair Value Stock A 33,600 31,000 Stock B 175,000 174,000 Stock C 59,400 68,500 Total 268,000 273,500 Dec ...

Question - blue co reported 150000 of net income for 2017

Question - Blue Co. reported $150,000 of net income for 2017. The accountant, in preparing the statement of cash flows, noted the following items occurring during 2017 that might affect cash flows from operating activiti ...

Question - explain legislation and statutory requirements

Question - Explain legislation and statutory requirements and industry codes of practice including(Australia): Consumer credit code Privacy act Credit act Financial transaction reports act Corporations act (including acc ...

Question - on december 31 2016 wildhorse co had 1375000

Question - On December 31, 2016, Wildhorse Co. had 1,375,000 shares of $7 par common stock issued and outstanding. At December 31, 2016, stockholders' equity had the amounts listed here. Common Stock$9,625,000Additional ...

Question as a small business owner in todays

Question: As a small business owner in today's economy: • What three financial reports would you use on a regular basis? • What information would you find on each statement? • What decisions might each statement help you ...

Question - the financial records of ivanhoe inc were

Question - The financial records of Ivanhoe Inc. were destroyed by fire at the end of 2017. Fortunately, the controller had kept certain statistical data related to the income statement as follows. 1. The beginning merch ...

Question - during 2017 crimson inc purchased 2775000 of

Question - During 2017, Crimson Inc. purchased $2,775,000 of inventory. The cost of goods sold for 2017 was $2,635,938 and the ending inventory at December 31, 2017 was $544,688. What was the inventory turnover for 2017?

Question - on 24th may 2018 the board of abx authorised the

Question - On 24th May 2018, the board of ABX authorised the incorporation of ALCORE, a wholly owned subsidiary to develop a production plant capable of producing 50,000 tonnes of aluminium fluoride per annum? How will t ...

Question what discoveries have you made in your research

Question: What discoveries have you made in your research and how does this information inform your ability to evaluate effective coaching and its impact on organizations? Consider these guiding questions: 1. What core c ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert