Ask Question
12 November, 10:13

Real World Financials ABC Corporation reported the following information in its financial statements for three successive quarters ($ in millions) : Three Months Ended 9/30/2017 (Q1) 6/30/2017 (Q4) 3/31/2017 (Q3) Balance sheets: Accounts receivable, net $ 21,361 $ 19,880 $ 12,970 Income statements: Sales revenue $ 24,620 $ 23,400 $ 22,260 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.)

+3
Answers (1)
  1. 12 November, 13:19
    0
    (Q4) Receivables turnover ratio = 1.135

    (Q1) Receivables turnover ratio = 1.153

    Average collection period for Q1=31 7 days

    Average collection period for Q4 = 317 days

    Explanation:

    The Receivables turnover ratio gives us the efficiency of collections and the Average collection period tells us the number of days in which the receivable is collected.

    Three Months Ended (Q1) (Q4) (Q3)

    9/30/2017 6/30/2017 3/31/2017

    Balance sheets:

    Accounts receivable, net $ 21,361 $ 19,880 $ 12,970

    Income statements:

    Sales revenue $ 24,620 $ 23,400 $ 22,260

    Receivables turnover ratio = Net Sales / Average Accounts Receivable

    Average Accounts Receivable = Net Receivables for one Quarter + Net Receivables for other Quarter/2

    (Q3) Receivables turnover ratio = $ 22,260 / $ 12,970 + $ 19,880/2

    (Q3) Receivables turnover ratio = $ 22,260 / 16425

    (Q3) Receivables turnover ratio = 1.355

    This indicates that average accounts receivable balance is converted into cash 1.355 times during the quarter.

    (Q4) Receivables turnover ratio = $ 23,400 / $ 19,880 + $ 21,361 / 2

    (Q4) Receivables turnover ratio = $ 23,400 / 20620.5

    (Q4) Receivables turnover ratio = 1.135

    This indicates that average accounts receivable balance is converted into cash 1. 135 times during the quarter.

    (Q1) Receivables turnover ratio = $ 24,620/$ 21,361 (assuming net is average)

    (Q1) Receivables turnover ratio = 1.153

    This indicates that net accounts receivable balance is converted into cash

    1. 153 times during the quarter.

    Average collection period for Q1 = 365 / Receivables turnover ratio

    Average collection period for Q1 = 365/1.153 = 316.6 = 317 days

    Average collection period for Q1=31 7 days

    Average collection period for Q4 = 365/Receivables turnover ratio

    Average collection period for Q4 = 365/1.15 = 317.4 = 317 days
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Real World Financials ABC Corporation reported the following information in its financial statements for three successive quarters ($ in ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers