Question

In: Finance

Ho to calculate receivable collection period, payables deferral period, and cash conversation period for P&G 2016,...

Ho to calculate receivable collection period, payables deferral period, and cash conversation period for P&G 2016, 2017, 2018.

http://financials.morningstar.com/income-statement/is.html?t=PG&region=usa&culture=en-US

http://financials.morningstar.com/balance-sheet/bs.html?t=PG&region=usa&culture=en-US

http://financials.morningstar.com/cash-flow/cf.html?t=PG&region=usa&culture=en-US

Expert Solution

Cash Conversion Cycle = Inventory Conversion Period + Receivables Collection Period – Payables Deferral Period

Inventory Conversion Period = 365 / [Cost of Goods Sold / Average Inventory]

Inventory Conversion for 2018 = 365 / {34,268 / [(4,738 + 4,624)/2]}
=> 365 / [34,268 / 4,681] = 49.86

Inventory Conversion for 2017 = 365 / {32,535 / [(4,624 + 4,716)/2]}
=> 365 / [34,268 / 4,681] = 52.37

Inventory Conversion for 2016 = 32,909 / [(4,716 + 5,454)/2]
=> 365 / [34,268 / 4,681] = 56.41

Receivable Collection Period = 365 Days / [Net Sales / Average Account Receivables]

Receivable Collection Period for 2018 = 365 / {66,832 / [(4,686 + 4,594)/2]}
=> 365 / 14.40345 = 25.34 Days

Receivable Collection Period for 2017 = 365 / {65,058 / [(4,594 + 4,373)/2]}
=> 365 / 14.5105= 25.15 Days

Receivable Collection Period for 2016 = 365 / {65,299 / [(4,373 + 4,861)/2]}
=> 365 / 14.1432= 25.81 Days

Payables Deferral Period = 365 / [Net Sales/Average Accounts Payable]

Payables Deferral Period for 2018 = 365 / {66,832 / [(10,344 + 9,632)/2}
=> 365 / 6.6912 = 54.55

Payables Deferral Period for 2017 = 365 / {65,058 / [(9,632 + 9,325)/2}
=> 365 / 6.8637 = 53.18

Payables Deferral Period for 2016 = 365 / {65,299 / [(9,325 + 8,257)/2}
=> 365 / 7.4279 = 49.14

Cash Conversion Cycle for 2018 = 49.86 + 25.34 + 54.55 = 129.75

Cash Conversion Cycle for 2017 = 52.37 + 25.15 + 53.18 = 130.70

Cash Conversion Cycle for 2016 = 56.41 + 25.81 + 49.14 = 131.36

jeff jeffy answered 9 months ago

Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle,...

Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle, days Adidas 112 27 57 82 Puma 107 18 49 Nike 128 20 43 105 Under Armor 89 24 21 1)calculate CCC for Puma and UA. 2)pick any 1 company of the 4: how its operational liquidity stands versus competitors (other 3 firms)? how can this company improve its liquidity? What are possible risks/limitations to your proposed changes?

What is the average collection period, inventory turnover, and total asset turnover for P&G from 2016,...

What is the average collection period, inventory turnover, and total asset turnover for P&G from 2016, 2017, and 2018 using http://financials.morningstar.com/balance-sheet/bs.html?t=PG&region=usa&culture=en-US http://financials.morningstar.com/income-statement/is.html?t=PG&region=usa&culture=en-US http://financials.morningstar.com/cash-flow/cf.html?t=PG&region=usa&culture=en-US

Famous Farm's payables deferral period (PDP) is 40 days (on a 365-day basis), accounts payable are...

Famous Farm's payables deferral period (PDP) is 40 days (on a 365-day basis), accounts payable are $120 million, and its balance sheet shows inventory of $208 million. What is the inventory turnover ratio?

Based on the following accounting information, please calculate Inventory period Receivable period Operating Cycle Cash Cycle...

Based on the following accounting information, please calculate Inventory period Receivable period Operating Cycle Cash Cycle Inventory: Beginning = 200,000 Ending = 300,000 Accounts Receivable: Beginning = 150,000 Ending = 200,000 Accounts Payable: Beginning = 50,000 Ending = 100,000 Net sales = 1,500,000 Cost of Goods sold = 800,000

The average collection period ratio is defined as shown below: Accounts Receivable / (sales/ 365) It...

The average collection period ratio is defined as shown below: Accounts Receivable / (sales/ 365) It shows how many days, on average, it takes to collect your receivables. If your average collection period was 30 days last year and it is now 45 days, what does that imply? What is happening to your cash position? What are some things you might do to reduce your average collection period?

Mervyn’s Fine Fashions has an average collection period of 40 days. The accounts receivable balance is...

Mervyn’s Fine Fashions has an average collection period of 40 days. The accounts receivable balance is $46,000. What is the value of its annual credit sales? (Use a 360-day year.)

Given the following information, calculate the cash cycle. Use average inventory, receivables, and payables in your...

Given the following information, calculate the cash cycle. Use average inventory, receivables, and payables in your calculations. Credit sales = $1,000,000 Cost of goods sold = $750,000 Beginning balances: Inventory = $300,000 Accounts Receivable = $280,000 Accounts Payable = $260,000 Ending balances: Inventory = $280,000 Accounts Receivable = $250,000 Accounts Payable = $240,000 a)141 days b)261 days c)97 days d)116 days e)238 days

Based on the data below, with a collection period of 60 days what are cash collections...

Based on the data below, with a collection period of 60 days what are cash collections in Q2? (format $xxx as needed, no cents) Beginning A/R $335 a. Collection Period 45 b. Collection Period 60 c. Collection Period 30 Sales: Q1 $545 Q2 $598 Q3 $575 Q4 $795

If ending accounts receivable exceeds the beginning accounts receivable: A. cash collections during-the period exceed the...

If ending accounts receivable exceeds the beginning accounts receivable: A. cash collections during-the period exceed the amount of revenue earned. B. net Income for the period is less than the amount of cash basis income. C. no cash was collected during the period. D. cash collections during the year are less than the amount of revenue earned.

how to calculate sales budget/cash collection budget for a master budget case?