Use the information from the Income Statement and Balance Sheet to construct the ratios and answer the questions below. Downloadable Financial statements HW 4 SXP 19.docxPreview the document hw3 ratios.jpg
Barry Computers Income statement DEC 31, 2016 |
|||
Sales |
1,607,500 |
||
GOGS |
1,392,500 |
||
Gross Profit |
215,000 |
||
SG&A |
145,000 |
||
EBIT |
70,000 |
||
Interest Expenses |
24,500 |
||
EBT |
45,500 |
||
TX (40%) |
18,200 |
||
NI |
27,300 |
||
Barry Computers Balance Sheet DEC 31, 2016 |
|||
Cash |
77,500 |
Accounts Payable |
129,000 |
Accounts receivables |
336,000 |
Accruals |
117,000 |
Inventory |
241,500 |
Notes Payable |
84,000 |
Total current Assets |
655,000 |
Total Current Liabilities |
330,000 |
Long-term Debt |
256,500 |
||
Net Fixed Assets |
292,500 |
Common Equity |
361,000 |
Total assets |
947,500 |
Total Liabilities & Equity |
947,500 |
Group of answer choices
Current ratio
quick Ratio
Days of sales Outstanding
Inventory Turnover ratio
Days of sales in inventory
Total Asset Turnover
Fixed Asset Turnover
Return on Assets
Return on Equity
Return on Invested Capital
Times Earned Interest
Debt to Capital
Debt Ratio
Equity Ratio
Profit Margin
Current ratio = Current assets/Current liabilities = 655000/330000 = | 1.98 |
Quick Ratio = (Cash+Receivables)/Current liabilities = (77500+336000)/330000 = | 1.25 |
Days of sales Outstanding = Receivables*365/Sales = 336000*365/1607500 = | 76.29 |
Inventory Turnover ratio = Cost of goods sold/Inventory = 1392500/241500 = | 5.77 |
Days of sales in inventory = 365/Inventory turnover = 365/5.77 = | 63.30 |
Total Asset Turnover = Sales/Total assets = 1607500/947500 = | 1.70 |
Fixed Asset Turnover = Sales/Net fixed assets = 1607500/292500 = | 5.50 |
Return on Assets = NI/Total assets = 27300/947500 = | 2.88% |
Return on Equity = NI/Common equity = 27300/361000 = | 7.56% |
Return on Invested Capital = NOPAT/Total net operating assets = 70000*(1-40%)/(947500-246000) = | 5.99% |
Times Earned Interest = EBIT/Interest expense = 70000/24500 = | 2.86 |
Debt to Capital = Debt(Interest bearing)/(Debt-interest bearing+Equity) = (84000+256500)/(340500+361000) = | 48.54% |
Debt Ratio = Debt/Total assets = (330000+256500)/947500 = | 61.90% |
Equity Ratio = EquityTotal assets = 361000/947500 = | 38.10% |
Profit Margin = NI/Sales = 27300/1607500 = | 1.70% |
Use the information from the Income Statement and Balance Sheet to construct the ratios and answer...
4-22 1 year from now? BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.5% Days sales outstanding: 36.5 days Inventory turnover ratio: 5x Fixed assets turnover: 3.0% Current ratio: 2.0x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Calculation is based on a 365-day year. 60.000 Cash Accounts receivable Inventories Fixed assets Total assets Balance Sheet Current liabilities Long-term debt Common stock Retained earnings $300,000...
Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2019 (in Thousands) Sales Cost of goods sold $1,607,500 Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit $ 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) 70,000 Interest expense 21,000 Earnings before taxes (EBT) 49,000 Federal and state income taxes (25%) 12,250 Net income $ 36,750 Earnings...
Prepare a performance report
on Barry Computer Company. (Problem 4-23 on pages 140-141 of the
course text provides a balance sheet and an income statement for
the company.)
Prepare your performance report
to show calculations for the 14 ratios listed on page 141, as well
as a comparison of your computed ratios with the listed industry
averages.
Write a short memo to your
supervisor explaining your findings and your recommendations for
improvement.
Suggest some ways in which the
company can...
(Computing ratios) Use the information from the balance sheet and income statement in the popup window, to calculate the following ratios: a. Current ratio b. Acid-test ratio c. Times interest earned d. Inventory turnover e. Total asset turnover f. Operating profit margin g. Days in receivables h. Operating return on assets i. Debt ratio j. Return on equity k. Fixed asset turnover a. The current ratio is X. (Round to two decimal places.) Cash Accounts receivable Inventory 99,000 31,000 50,000...
Problem 4-23 Ratio Analysis Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as of December 31, 2015 (In Thousands) Cash $77,500 Accounts payable $129,000 Receivables 336,000 Other current liabilities 117,000 Inventories 241,500 Notes payable 84,000 Total current assets $655,000 Total current liabilities $330,000 Long-term debt $256,500 Net fixed assets 292,500 Common equity 361,000 Total assets $947,500 Total liabilities and equity $648,000 Barry Computer Company: Income Statement for Year Ended December 31, 2015(In Thousands)...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...
Use the attached Income Statement and Balance Sheet to compute
the required financial ratios for Seward Inc. and compare to the
industry averages. After that, write a brief summary as to what
each ratio is measuring and how Seward compares to the industry.
For example, you may find that Seward's Inventory Turnover is not
as high as the industry average, so they are either not managing
their inventories or may be experiencing a decrease in sales.
Seward Industries a. Compute...
Plankton Company Balance Sheet as of Dec 31, 2017 (in $) Cash 112,500 Accounts Payable 150,000 Receivables 336,000 Notes payable 84,000 Inventories 241,500 Other Current Liabilities 117,000 Total CA 690,000 Total CL 351,000 L-T debt 256,500 Net Fixed Assets 292,500 Common Equity 375,000 Total Assets 982,500 Total L+E 982,500 Plankton Company Income Statement (year ended Dec 31, 2017—in $) Sales 1,607,000 Cost of Goods Sold Materials 717,000 Labor 453,000 Heat, Light, and Power 68,000...
Problem # 1 (50 points) Given the Income Statement and Balance Sheet Compute: Current Ratio Acid-Test Ratio Days in Receivable Days in Inventory Operating Profit Margin Total Asset Tumover Fixed-asset turnover Debt Ratio Times Interest Earned Return on Equity Income Statement Balance Sheet Assets Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets Gross Plant and Equipment Accumulated Depreciation Net Fixed Assets Total Assets $200,000 $60,000 $100,000 $20,000 $380,000 $802,000 -$132,000 $670,000 $1,050,000 Sales (all credit) Cost of Goods Sold...
The balance sheet and income statement for the A. Thiel Mfg.
Company are as follows. Calculate the ratios at the
bottom.
Cash $ 500 Accounts receivable 2,000 Inventories 1,000 Current assets $3,500 Net fixed assets 4,500 Total assets $8,000 Accounts payable $1,100 Accrued expenses 600 Short-term notes payable 300 Current liabilities $2,000 Long-term debt 2,000 Owners' equity 4,000 Total liabilities and owners' equity $8,000 Income Statement ($000) Sales (all credit) $8,000 Cost of goods sold (3,300) Gross profit $4,700 Operating...