Question

You have the following balance sheet and income statement information for Epic Corp.: Balance sheet $...

You have the following balance sheet and income statement information for Epic Corp.:

Balance sheet $
Accounts receivable (A/R) 2,200
Inventory 3,400
Accounts payable (A/P) 870
Income statement $
Sales 6,800
Cost of goods sold (COGS) 5,440

All sales and purchases were on credit.
1. How long is the days' sales in inventory (in days)?
2. How long is the average collection period (in days)?
3. How long is the average payment period (in days)?
4.How long is the cash cycle (in days)?

Homework Answers

Answer #1

1. Days Sales in inventory = Inventory/(COGS/365) = 3400/(5440/365) = 228.125 days

2. Average Collection Period = Amount Receivables/( Sales/365) = 2200/(6800/365) = 118.088 days

3. Average Payment Period = Amount Payable/( COGS/365) = 870/(5440/365) = 58.373 days

4. Cash Cycle =   Days Sales in inventory + Average Collection Period days - Average Payment Period  days =  228.125 + 118.088 -  58.373 = 287.84

Best of Luck. God Bless

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Garcia Industries balance sheet and income statement for the year ended Year 1 are as...
The Garcia Industries balance sheet and income statement for the year ended Year 1 are as follows: Balance Sheet (in Millions of Dollars) Assets Liabilities and Stockholders’ Equity Cash $5.0 Accounts payable $8.0 Accounts receivable 16.0 Salaries, benefits, and payroll taxes payable 2.0 Inventories* 13.0 Other current liabilities 13.0 Fixed assets, net 31.0 Long-term debt 16.0 $65.0 Stockholders’ equity 26.0 $65.0 *The average inventory over the past two years also equals $13.0 million. Income Statement (in Millions of Dollars) Net...
The following information is from a firm’s 2018 income statement and balance sheet. Use it to...
The following information is from a firm’s 2018 income statement and balance sheet. Use it to calculate the Cash Conversion Cycle (8 points) Sales 122,800 Cost of Goods Sold 104,380 Accounts Receivable 10,900 Inventory 1,420 Accounts Payable 22,640
The following information is from a firm’s 2018 income statement and balance sheet. Use it to...
The following information is from a firm’s 2018 income statement and balance sheet. Use it to calculate the Cash Conversion Cycle. (Please show your work) Sales 122,800 Cost of Goods Sold 104,380 Accounts Receivable 10,900 Inventory 1,420 Accounts Payable 22,640
Selected 2021 balance sheet and income statement information from Gia, Inc. and Bradley Company follows: ($...
Selected 2021 balance sheet and income statement information from Gia, Inc. and Bradley Company follows: ($ millions) Gia Bradley Sales $13,800 $7,500 Cost of goods sold 10,600 5,400 Average accounts receivable 345 150 Average inventory 2,525 900 Average total assets 6,200 2,500 A. Compute the accounts receivable turnover rate for Gia (to two decimals): B. Compute the accounts receivable turnover rate for Bradley (to two decimals): C. Compute the average collection period for Gia (to two decimals): days D. Compute...
The relevant detail is contained in the James Income Statement and Balance Sheet. Calculate the James...
The relevant detail is contained in the James Income Statement and Balance Sheet. Calculate the James Cash Conversion Cycle and interpret the result? Sales $104,500 Cost of Goods Sold $50,568 Accounts Receivable $16,788 Inventory $12,335 Accounts Payable $20,980
​(Working with an income statement and balance sheet​) Prepare a balance sheet and income statement for...
​(Working with an income statement and balance sheet​) Prepare a balance sheet and income statement for Kronlokken Company from the scrambled list of items shown in the popup​ window, Depreciation expense   66,000 Cash   225,000 Long-term debt   334,000 Sales   573,000 Accounts payable   102,000 General and administrative expenses   79,000 Buildings and equipment   895,000 Notes payable   75,000 Accounts receivable   153,000 Interest expense   4,750 Accrued operating expenses   7,900 Common stock   289,000 Cost of goods sold   297,000 Inventory   99,300 Taxes   50,500 Accumulated depreciation   -263,000 Prepaid...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 31,000 Accounts receivable 72,000 Notes payable 25,000 Inventory 53,000 Total current assets 135,000 Total current liabilities 56,000 Fixed assets 81,000 Long-term debt 30,000 Equity 130,000 Total assets $ 216,000 Total liabilities and equity $ 216,000 Income Statement Sales (all on credit) $ 290,000 Cost of goods sold 180,000 Gross margin 110,000 Selling and administrative expenses 43,000 Depreciation 7,000 EBIT...
Use the following balance sheet and income statement for Sullo Inc. to answer the next 5...
Use the following balance sheet and income statement for Sullo Inc. to answer the next 5 questions. Hint: Some questions may yield negative answers. Assets (Millions) Liabilities and owners equity (Millions) Cash 4000 Accounts Payable 900 Inventory 600 Accrued operating expense 400 Accounts Receivable 1500 Notes Payable 3500 Fixed assets 6000 Long Term Debt 2000 Shareholders Equity 5300 Total 12100 Total 12100 Income Statement (Millions) Revenues 7000 COGS 4500 Operating Expenses 900 Depreciation 600 Interest 400 Taxes 500 Net Profit...
complete a Trial Balance, Income Statement, Statement of Retained Earnings, Balance Sheet, and calculate all of...
complete a Trial Balance, Income Statement, Statement of Retained Earnings, Balance Sheet, and calculate all of the ratios. Accounts Receivable        16,250 Accumulated depreciation: Office equipment        25,000 Cash        25,300 Land        58,500 Merchandise inventory        25,250 Office equipment        41,000 Office supplies          4,410 Prepaid rent          1,800 Cost of Goods Sold      112,575 Depreciation expense: office equipment          2,750 Income tax expense          9,000 Insurance expense          1,900 Office supplies expense              520 Rent expense          5,700...
Projected Income statement for Year Ending Dec 31, 2004 Projected balance sheet at December 31, 2004...
Projected Income statement for Year Ending Dec 31, 2004 Projected balance sheet at December 31, 2004 Amount Assets Amount Projected sales $3,600 Cash (1.5% of sales) 54 COGS Accounts receivable (12% of sales) 432 Beginning inventory $418 Inventory (16% of sales) 576 Purchases $2,750    Current assets 0 $3,168 PP&E (grow with sales) 210 Ending inventory $576    Total assets 1,272     COGS (72% of sales) $2,592 Gross profit $1,008 Liabilities Less: Operating expenses (25% of sales) $900 Notes payable...