Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use the following excel screenshots to answer the following questions. Please show working, formulas and/or explanation. Calculate and analyze the financial leverage of Company

Please use the following excel screenshots to answer the following questions. Please show working, formulas and/or explanation.

  1. Calculate and analyze the financial leverage of Company ABC (debt-to-assets & debt-to equity ratios).
  2. Calculate and analyze the Cash Conversion Cycle of Company ABC.
  3. Calculate and analyze the Current and Quick Ratios of Company ABC.

image text in transcribedimage text in transcribed

A3 Description H 1 j L M N O B C DE E F 1 Company ABC Income Statements for Years Ending December 31 (in thousands) 2 3 Description Current Year Prior Year 4 Assets: 5 Current Assets: scach 6 Cash $ 600.00 $ 300.00 7 7 Marketable securities $ 250.00 $ 50.00 8 Accounts receivable $ 750.00 $ 775.00 9 Inventories $ S 2,000.00 $ 1,300.00 . 10 Total Current Assets S 3.600.00 can $ 2,425.00 11 Fixed Assets: FUNCU 12 Gross plant and equipment $ 10,000.00 $ 8,000.00 13 Accumulated depreciation $ 4,200.00 $ 3,500.00 14 Net plant and equipment $ 5,800.00 $ 4,500.00 15 Intangible assets $ 1,400.00 $ 1,400.00 16 Total Fixed Assets S 7,200.00 $ 5.900.00 17 Total Assets $ 10,800.00 $ 8,325.00 18 Liabilities and Shareholder Equity 19 Accounts payable $ 700.00 $ 550.00 20 Other current liabilities $ 620.00 $ 340.00 21 Long-term debt o loosterm $ 4,800.00 $ 5,200.00 22 Total liabilities $ 6,120.00 $ 6,090.00 23 Common stock, $1 par value; 24 Authorized 2,000,000 shares 25 Issued 1,750,000 and 1,000,000 shares $ 1,750.00 $ 1,000.00 26 Additional paid-in capital $ 1,750.00 $ 500.00 27 Retained earnings $ 1,180.00 $ 735.00 28 Total shareholders' equity $ 4,680.00 $ 2,235.00 29 Total liabilities and shareholder equity $ 10,800.00 $ 8,325.00 30 31 32 Balance Sheet Income Statement A8 for Administrative expense F G H J K L 9800 A B D E 1 Company ABC Income Statements for Years Ending December 31 (in thousands) 2 3 Description Current Year Prior Year 4. Sales 12550 5 Cost of goods sold 7500 6700 6 Gross profit 5050 3100 7 Lease expense 1300 500 8 Administrative expense 800 700 9 Earnings before interest and taxes (EBIT) 2950 1900 10 Interest 650 500 11 Earnings before taxes 2300 1400 12 Taxes 930 600 13 Net income 1370 800 14 Preferred dividends 175 150 15 Earnings available to common shareholders 1195 650 16 Common dividends 600 500 17 Retained earnings 595 150 18 19 20 21 22 23 24 25 Balance Sheet Income Statement @

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Biblical Finance Reflections On Money Wealth And Possessions

Authors: Mark Lloydbottom, Keith Tondeur

1st Edition

0956395023, 978-0956395023

More Books

Students also viewed these Finance questions