Fill This Form To Receive Instant Help
Homework answers / question archive / Using the financial statements in the "fsa_assignment
Using the financial statements in the "fsa_assignment.xlsx" file on canvas, compute the firm's times interest earned. Round your final answer to two decimals. Question 8 1 pts Using the financial statements in the "fsa_assignment.xlsx" file on canvas, compute the firm's cash conversion cycle (CCC). Round your final answer to two decimals.
Assumptions Corporate tax rate 21% Income Statement Sales Cost of goods sold Gross margin Sales, general, and administraive expense Depreciation expense EBIT Interest Expense EBT Taxes Earnings $ 1,000.00 $ 500.00 $ 500.00 $ 100.00 $ 200.00 $ 200.00 $ 50.00 $ 150.00 $ 31.50 $ 118.50 Balance Sheet Cash Accounts receivable Inventory Total Current Assets $ 300.00 Accounts payable $ 500.00 Current portion of Long-term-debt $ 200.00 Short-term debt $ 1,000.00 Total current liabilities $ 500.00 $ 100.00 $ 100.00 $ 700.00 $ 500.00 $ 1,200.00 Property, plant, and equipment Accumulated depreciation Net property, plant and equipment Long-term debt $ 1,000.00 Total liabilities $ 400.00 $ 600.00 Common stock at par value Additional paid in capital Retained earnings Total shareholders' equity $ 50.00 $ 250.00 $ 100.00 $ 400.00 Total assets $ 1,600.00 Total liabilities and shareholders' equity $ 1,600.00 $ net income ROA ROE 118.50 $0.07 $0.30
Times interest earned = Earnings before interest and taxes / Interest expense
= 200 / 50 = 4 times
b)
Cash conversion cycle (CCC) = Inventory days + Receivable days - payable days
Inventory days = ( Inventory / Cost of goods sold ) * 365
= (200 / 500) * 365 = 146 days
Receivable days = ( Accounts receivables / Revenue ) * 365
= (500 /1000) * 365 = 182.5 days
Payable days = ( Accounts payable / Cost of goods sold ) * 365
= (500 / 500) * 365 = 500 days
Cash conversion cycle (CCC) = 146 + 182.5 - 365 = -36.5 days
A negative conversion cycle shows hogh liquidity of cash in the business, that is yor are receiving cash earlier than you are paying it.