Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Using the financial statements in the "fsa_assignment

Using the financial statements in the "fsa_assignment

Finance

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

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

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.