Question

In: Finance

Period End Date 31-Dec-19 31-Dec-18 31-Dec-17 31-Dec-16 31-Dec-15 Total Inventories 17516000000 16450000000 15296000000 14760000000 14001000000 Cost...

Period End Date 31-Dec-19 31-Dec-18 31-Dec-17 31-Dec-16 31-Dec-15
Total Inventories 17516000000 16450000000 15296000000 14760000000 14001000000
Cost of Goods Sold incl. Depreciation 211248000000.00 163041000000.00 156258000000.00 148623000000.00 126762000000.00
Net Sales or Revenue 256577000000.00 194578000000.00 184786000000.00 177526000000.00 153290000000.00
Accounts Receivable Gross 17555000000 17303000000 13342000000 12450000000 12049000000
Accounts Payable 30972000000 26437000000 19223000000 17397000000 15143000000

Find the Operating cycle and Cash cycle (show work).

Solutions

Expert Solution

Days in inventory formula= Average Inventory/Cost of goods sold × 365

= (17516000000 + 16450000000/2)/ 211248000000 ×365

= (33966000000/2) / 211248000000 × 365

= 16983000000 / 211248000000 × 365

= 0.080 × 365

= 29.34 days

Days of sales outstanding= Average Account receivable / Sales × 365

= (1755500000+17303000000/2) / 256577000000 × 365

= ( 34858000000 / 2 ) / 256577000000

= 17429000000/ 256577000000 × 365

= 0.0679 × 365

= 24.79 days

Days of payable outstanding= Average Payable / cost of goods sold × 365

= (30972000000+26437000000/2) / 211248000000 × 365

= ( 57409000000/2 ) / 211248000000 × 365

= 28704500000 / 211248000000 × 365

= 0.135881 × 365

= 49.60 days

A) Operating cycle of 2019 = Days of inventory outstanding + Days of sales outstanding

= 29.34 days + 24.79 days

=  54.13 days

B) Cash conversion cycle of 2019= Operating cycle - Days of payable outstanding

= 54.13 - 49.60 days

= 4.53 days


Related Solutions

You are given the following information. Please use it for the following 31-Dec-16 31-Dec-16 31-dec-17 31-Dec-17...
You are given the following information. Please use it for the following 31-Dec-16 31-Dec-16 31-dec-17 31-Dec-17 stock Price Shares Price Shares w 50$ 10000 25$ 20000 x 40$ 5000 25$ 10000 y 20$ 20000 30$ 20000 z 30$ 15000 40$ 15000 Stocks W and X had 2 for 1 splits on December 31, 2016. The information in the table for 2016 is pre-split. 3.4 Calculate the price weighted series for Dec 31, 2016, prior to the splits. 3.5 Calculate the...
JOHNSTON ENTERPRISES           BALANCE SHEET              31-Dec-17       31-Dec-16 Current Assets:        &nb
JOHNSTON ENTERPRISES           BALANCE SHEET              31-Dec-17       31-Dec-16 Current Assets:           Cash   $140,000        $120,000 Accounts Receivable   200,000       300,000 Inventory   400,000       300,000 Total Current Assets   740,000       720,000 Property, Plant, and Equipment   1,241,000       1,122,000 Less: Accumulated Depreciation   -476,000       -442,000 Total Assets   1,505,000       1,400,000            Current Liabilities:             Accounts Payable   $201,000        $130,000 Notes Payable   40,000       60,000 Income Taxes Payable   90,000       70,000 Total...
Given the following numbers:   25 16 61 18 15 20 15 20 24 17 19 28,...
Given the following numbers:   25 16 61 18 15 20 15 20 24 17 19 28, derive the mean, median, mode, variance, standard deviation, skewness, kurtosis, range, minimum, maximum, sum, and count. Interpret your results. What is the empirical rule for two standard deviations of the data?
Given the following numbers: 25 16 61 18 15 20 15 20 24 17 19 28,...
Given the following numbers: 25 16 61 18 15 20 15 20 24 17 19 28, derive the mean, median, mode, variance, standard deviation, skewness, kurtosis, range, minimum, maximum, sum, and count. Interpret your results. What is the empirical rule for two standard deviations of the data?
18. Marigold Corp.'s accounting records reflect the following inventories: Dec. 31, 2019 Dec. 31, 2020 Raw...
18. Marigold Corp.'s accounting records reflect the following inventories: Dec. 31, 2019 Dec. 31, 2020 Raw materials inventory $30000    $ 87000    Work in process inventory 66000    84000    Finished goods inventory 60000    48000    During 2020, Marigold purchased $890000 of raw materials, incurred direct labor costs of $175000, and incurred manufacturing overhead totaling $224000. How much is total manufacturing costs incurred during 2020 for Marigold? $1289000 $1244000 $1232000 $1295000 17. Gulick Company developed the following data for the current year: Beginning work...
Abreviated Income Statement $thousands, except EPS 31-Dec-20 31-Dec-19 Total Revenue 1,743,641      781,963 Cost of Goods...
Abreviated Income Statement $thousands, except EPS 31-Dec-20 31-Dec-19 Total Revenue 1,743,641      781,963 Cost of Goods Sold      431,725      278,433 Gross Profit 1,311,916      503,530 Operating Expenses        68,470        52,402 Operating Income 1,243,446      451,128 Interest & Taxes      453,190      293,537 Net Income      790,256      157,591 EPS, 50,000,000 shares outstanding         15.81           3.15 (Round all answers to two decimals, i.e. 12.00) a) Calculate the degree of operating leverage (DOL). Blank 1 b) Calculate the degree...
January 15, 2017 January 16, 2017 January 17, 2017 January 18, 2017 January 19, 2017 January...
January 15, 2017 January 16, 2017 January 17, 2017 January 18, 2017 January 19, 2017 January 20, 2017 January 21, 2017 Person 1 32 56 92 76 72 32 72 Person 2 40 0 20 4 20 0 0 Person 3 30 5 10 15 15 20 25 Person 4 47 35 71 13 17 29 42 Person 5 10 15 15 15 15 15 25 Person 6 0 0 0 10 5 5 0 Person 7 0 12 2...
79, 19, 16, 64, 28, 28, 31,90, 60, 56, 31, 56, 22, 18, 45, 48, 17,...
79, 19, 16, 64, 28, 28, 31,90, 60, 56, 31, 56, 22, 18, 45, 48, 17, 63, 69, 17 with these number find a) Frequency distribution b)Frequency polygon c) less than cumulative frequency polgon.
A B C 8 24 19 12 16 28 22 22 24 15 14 31 18...
A B C 8 24 19 12 16 28 22 22 24 15 14 31 18 20 19 9 32 Test at the 5% level of significance to see if the means are all the same. 1. What is the null and alternate hypotheses? 2. What is the p-value? 3. Decide if you reject or accept (fail to reject) your null hypothesis. 4. Decide if you reject or accept (fail to reject) your claim.
31-Dec-17 31-Dec-16 Accounts receivable (net) 275,000 196,500 Accumulated Depreciation 300,000 200,000 Additional Paid in Capital-Common 600,000...
31-Dec-17 31-Dec-16 Accounts receivable (net) 275,000 196,500 Accumulated Depreciation 300,000 200,000 Additional Paid in Capital-Common 600,000 400,000 Administrative expenses 371,000 475,000 Bond payable, 10% due 2025 500,000 500,000 Cash 162,000 120,000 Common stock, $2 par 200,000 100,000 Cost of goods sold 1,550,000 1,420,500 Current liabilities 267,000 268,000 Depreciation Expense 100,000 100,000 Dividends on common stock 40,000 40,000 Dividends on preferred stock 12,500 12,500 Gain on Sale of Land 125,000 0 Income tax expense 168,000 118,750 Inventories 417,000 132,500 Long-term investments...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT