Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
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
Expert Solution
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.
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





