The following table shows the revenue reported by Amazon for 12 consecutive quarters:
Quarter End Date | Revenue (Billion $) |
3/31/2016 | 29.13 |
6/30/2016 | 30.40 |
9/30/2016 | 32.71 |
12/31/2016 | 43.74 |
3/31/2017 | 35.71 |
6/30/2017 | 37.96 |
9/30/2017 | 43.74 |
12/31/2017 | 60.45 |
3/31/2018 | 51.04 |
6/30/2018 | 52.89 |
9/30/2018 | 56.58 |
12/31/2018 | 72.38 |
What is the value for the 6th observation in the 4 quarter moving average? Round your answer to 2 decimal places.
Answer:
The value for the 6th observation in 4 quarter moving average is The sum of previous 4 observations divided by 4
=(30.40+32.71+43.74+35.71)/4
= 35.64
The following table shows the revenue reported by Amazon for 12 consecutive quarters: Quarter End Date...
The following table reports the sale of umbrellas for 12 quarters. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 1 4 5 3 3 5 8 4 5 7 9 Develop a model using Quarter 4 as the reference year and compute the Second Quarterly sales forecast for Year 5. Round your answers to three decimal places.
Question 9 (5 points) The following table reports the sale of umbrellas for 12 quarters. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 1 4 5 3 3 5 8 4 9 5 7 Develop a model using Year 4 as the reference year and compute the Second Quarterly sales forecast for Year 5. Round your answers to three decimal places.
Microsoft Corporation reported the following information in its financial statements for three successive quarters during the 2014 fiscal year ($ in millions): Three Months Ended 3/31/2014 (Q3) 12/31/2013 (Q2) 9/30/2013 (Q1) Balance sheets: Accounts receivable, net $ 13,497 $ 15,986 $ 11,007 Income statements: Sales revenue $ 20,403 $ 24,519 $ 18,529 Required: Compute the receivables turnover ratio and the average collection period for the second and third quarters. Assume that each quarter consists of 91 days. (Round average cost...
Microsoft Corporation reported the following information in its financial statements for three successive quarters ($ in millions): Three Months Ended 9/30/2017 6/30/2017 3/31/2017 (21) (24) (23) $14,561 $19,792 $12,882 Balance sheets: Accounts receivable, net Income statements: Sales revenue $24,538 $23,317 $22,090 Required: Compute the receivables turnover ratio and the average collection period for Q1 and Q4. Assume that each quarter consists of 91 days. (Enter your answers in millions. Round average accounts receivable answers to nearest whole dollar and "Turnover...
Real World FinancialsABC Corporation reported the following information in its financial statements for three successive quarters ($ in millions): Three Months Ended9/30/2017 (Q1)6/30/2017 (Q4)3/31/2017 (Q3)Balance sheets:Accounts receivable, net$17,361$19,830$12,920Income statements:Sales revenue$24,570$23,350$22,160 Required:Compute the receivables turnover ratio and the average collection period for Q1 and Q4. Assume that each quarter consists of 91 days. (Round average accounts receivable answers to nearest whole dollar. Enter your answers in millions. Round "Turnover ratio" answers to 3 decimal places.)
Gates Electronics Corporattion reported the following information in s financial statements for three successive quarters(S in mons Three Months Ended 12/31/2015 (02) 9/30/2015 6/38/2815 (Q1) (04) Salance sheets: Accounts receivable, set Income statesents: Sales revenoe $14,600 $17,200 $12,400 $ 23,055 $27,898 s21,129 Required: Compute the recevables turnover ratio and the average collection period for Q1 and Q2 Assume that each quarter consists of 91 days. (Enter your answers In millons. Round "Turnover ratio" answers to 3 decimal pleces.)
Gulf Corporation manufactures and sells a seasonal product that has peak sales in the third quarter of the fiscal year. The following information concerns operations for Year 2017 and for the first two quarters of Year 2018 2018 Quarter 2017 Quarter ed Unit Sales40 60,000 100,000 50,000 70,00080,000 a) The company's single product sells for AED 8 per unit (all sales are on credit). b) Credit sales are collected in the following pattern: 75% in the quarter the sales are...
General Journal Debit Credit No 1 Date Jan 01, 2018 4,400 Cash Sales revenue 4,400 TOL 2 | Jan 01, 2018 2,900 Cost of goods sold Inventory 2,900 3 Jan 02, 2018 6,400 Equipment Accounts payable 6,400 1 4 | Jan 04, 2018 150 Advertising expense Accounts payable 150 T L 5 | Jan 08, 2018 5,900 Accounts receivable Sales revenue 5,900 Jan 08, 2018 3,700 Cost of goods sold Inventory 3,700 7 Jan 10, 2018 9,950 Inventory Accounts payable...
How would I Calculate the Average Quarterly Revenue for (AQR)
for the Label indicated car class for each of the four car classes.
Using the average function and name range (AE, AH, AP or AS) ONLY
NOT a range of cells. Ensure each of four averages is Currency
format with two decimal places preceded by a $ with no spaces
between the $ and the first number. I keep getting an error column
K. Please help
AutoSave o B Copy...
E3-5 Devin Wolf Company has the following balances in selected accounts on December should adopt the achtily each statement as true or false. If false, indicate how to correct the statement. E3-2 On numerous occasions, proposals have surfaced to put the federal government on the accrual basis of accounting. This is no small issue. If this basis were used, it would mean that billions in unrecorded liabilities would have to be booked, and the federal deficit (a) What is the...