Trusted by Students Everywhere
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

Finance Feb 27, 2021

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
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment