Question

In: Finance

Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in...

Canadian Bacon Inc. financial statements are presented in the table below.

Based on the information in the table, and using a 365-day year, calculate cash conversion cycle

Round the answers to two decimal places


Balance Sheet December 31, 2013

Cash and marketable securities $112,000 Accounts payable $211,000
Accounts receivable $325,000 Notes payable $51,500
Inventories $426,000 Accrued expenses $50,100
Prepaid expenses $10,700 Total current liabilities $312,600
Total current assets $873,700 Long-term debt $225,000
Gross fixed assets $1,514,000 Par value and paid-in-capital $117,000
Less: accumulated depreciation $315,000 Retained Earnings $1,418,100
Net fixed assets $1,199,000 Common Equity 1,535,100
Total assets $2,072,700 Total liabilities and owner’s equity $2,072,700
Income Statement, Year of 2013

Net sales (all credit) $3,256,600.00
Less: Cost of goods sold $2,572,714.00
Selling and administrative expenses $323,000.00
Depreciation expense $115,000.00
EBIT $245,886.00
Interest expense $29,600.00
Earnings before taxes $216,286.00
Income taxes $86,514.40
Net income $129,771.60

Solutions

Expert Solution

Cash Conversion Cycle = Days Inventory Outstanding + Days Sales Outstanding - Days Payables Outstanding

= [(Inventory/COGS) * No. of Days in Period] + [(Accounts Receivable/Sales) * No. of Days in Period] -
[(Accounts Payable/COGS) * No. of Days in Period]

= [($426,000/$2,572,714) * 365] + [($325,000/$3,256,600) * 365] - [($211,000/$2,572,714) * 365]

= 60.44 + 36.43 - 29.94 = 66.93 days


Related Solutions

Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in...
Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate Days payables outstanding (Payables conversion period). Round the answers to two decimal places Balance Sheet December 31, 2011 Cash and marketable securities $143,000 Accounts payable $278,000 Accounts receivable $354,000 Notes payable $87,000 Inventories $672,000 Accrued expenses $65,000 Prepaid expenses $12,500 Total current liabilities $430,000 Total current assets $1,181,500 Long-term debt $284,000 Gross fixed assets $1,675,000 Par...
Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in...
Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate cash conversion cycle Round the answers to two decimal places Balance Sheet December 31, 2011 Cash and marketable securities $143,000 Accounts payable $278,000 Accounts receivable $354,000 Notes payable $87,000 Inventories $672,000 Accrued expenses $65,000 Prepaid expenses $12,500 Total current liabilities $430,000 Total current assets $1,181,500 Long-term debt $284,000 Gross fixed assets $1,675,000 Par value and paid-in-capital...
Canadian Bacon Inc. financial statements are presented in the table below.             Based on the information in...
Canadian Bacon Inc. financial statements are presented in the table below.             Based on the information in the table, and using a 365-day year, calculate operating cycle. Round the answers to two decimal places Balance Sheet December 31, 2013 Cash and marketable securities $112,000 Accounts payable $211,000 Accounts receivable $325,000 Notes payable $51,500 Inventories $426,000 Accrued expenses $50,100 Prepaid expenses $10,700 Total current liabilities $312,600 Total current assets $873,700 Long-term debt $225,000 Gross fixed assets $1,514,000 Par value and paid-in-capital $117,000...
Canadian Bacon Inc. financial statements are presented in the table below.
a)      Canadian Bacon Inc. financial statements are presented in the table below.            Based on the information in the table, and using a 365-day year, calculate operating cycle.Round the answers to two decimal placesBalance Sheet December 31, 2014Cash and marketable securities$132,000Accounts payable$399,000Accounts receivable$311,000Notes payable$98,500Inventories$512,000Accrued expenses$89,300Prepaid expenses$11,300Total current liabilities$586,800Total current assets$966,300Long-term debt$799,400Gross fixed assets$2,104,000Par value and paid-in-capital$298,000Less: accumulated depreciation$398,000Retained Earnings$988,100Net fixed assets$1,706,000Common Equity1,286,100Total assets$2,672,300Total liabilities and owner’s equity$2,672,300Income Statement, Year of 2014Net sales (all credit)$4,276,600.00Less: Cost of goods sold$3,292,982.00Selling and administrative expenses$349,000.00Depreciation expense$148,000.00EBIT$486,618.00Interest expense$49,600.00Earnings...
Canadian Bacon Inc. financial statements are presented in the table below.
Canadian Bacon Inc. financial statements are presented in the table below.Based on the information in the table, calculate the firm’s accounts receivable turnover ratio.Round the answers to two decimal placesBalance Sheet December 31, 2010Cash and marketable securities          $102,000 Accounts payable $287,000Accounts receivable                           $299,000 Notes payable $61,200Inventories                                          $628,000 Accrued expenses                               $51,900Prepaid expenses                                $10,300 Total current liabilities $400,100Total current assets                             $1,039,300 Long-term debt                                   $415,000Gross fixed assets                               $1,502,000 Par value and paid-in-capital $376,000Less:...
Canadian Bacon Inc. financial statements are presented in the table below.
Canadian Bacon Inc. financial statements are presented in the table below.Based on the information in the table, and using a 365-day year, calculate Average Credit Sales per Day.Round the answers to two decimal placesBalance Sheet December 31, 2011Cash and marketable securities         $187,000 Accounts payable $217,000Accounts receivable                           $498,000 Notes payable $51,500Inventories                                          $799,000 Accrued expenses                               $58,300Prepaid expenses                               $19,300 Total current liabilities $326,800Total current assets                             $1,503,300   Long-term debt $215,400Gross fixed assets                               $1,978,000 Par value and paid-in-capital $128,000Less:...
Financial information for Kurzen Inc. is presented below.
Question Description   Financial information for Kurzen Inc. is presented below.   Instructions Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year.
Based on in the table presented below. How would you best balance Apple’s Inc. financial leverage...
Based on in the table presented below. How would you best balance Apple’s Inc. financial leverage to optimize shareholder wealth going forward taking into consideration the Apple’s Inc. current market position, credit rating, dividend policy, etc. Financial Leverage 2015 2016 2017 2018 2019 Debt to Assets 0.59 0.60 0.64 0.71 0.73 Debt to Equity 0.45 0.59 0.73 0.87 1.01 Interest Coverage 99.93 43.15 28.59 23.50 19.38
Find the inflation rate based in the information presented in the table below. For you calculations...
Find the inflation rate based in the information presented in the table below. For you calculations assume a fix consumption basket consisting of 3 footballs and 4 basketballs, and year 1 as the base year. Year Price of Footballs Price of Basketballs Year 1 $10 $12 Year 2 12 15 Year 3 14 18
Financial? ratios: Financial leverage.??The financial statements for Tyler? Toys, Inc. are shown in the table below....
Financial? ratios: Financial leverage.??The financial statements for Tyler? Toys, Inc. are shown in the table below. Calculate the debt? ratio, times interest earned? ratio, and cash coverage ratio for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the? shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,146,827 $13,567,406 Cost of goods sold $-8,447,289...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT