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
Indirect Labor 113,000
Depreciation 41,500 1,392,000
Gross Profit 214,500
Selling Expenses 115,000
G&A Expenses 30,000
EBIT 69,500
Interest Expense 24,500
EBT 45,000
Taxes (40%) 18,000
Net Income 27,000
Use the data above for the Plankton Company to calculate the following ratios:
The answers must be carried out to two decimal points.
Current ratio:
Quick ratio:
Inventory Turnover:
Total Assets Turnover:
Profit Margin:
ROA:
ROE:
ROIC:
Total Debt/Total Capital:
Using the DuPont Equation please calculate the ROE? Must show the calculation in order to get credit.
|
As per rules I am answering the first 4 subparts of the question
Current ratio= Current assets/ current liabilities
= 690000/351000
= 1.97
Quick ratio =(Cash + receivables)/current liabilities
= (112500+ 336000)/351000
=1.28
Inventory Turnover= COGS/ Inventory
= 1392000/241500
=5.76
Total Assets Turnover= Sales/ Total assets
= 1607000/982500
=1.64
Plankton Company Balance Sheet as of Dec 31, 2017 (in $) Cash 112,500  
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...
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...
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...
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...
Pronghorn Company’s condensed financial statements provide the following information. PRONGHORN COMPANY BALANCE SHEET Dec. 31, 2017 Dec. 31, 2016 Cash $ 52,400 $ 60,600 Accounts receivable (net) 197,600 79,200 Short-term investments 79,200 40,000 Inventory 437,500 361,900 Prepaid expenses 3,000 7,000 Total current assets $ 769,700 $ 548,700 Property, plant, and equipment (net) 854,600 858,900 Total assets $1,624,300 $1,407,600 Current liabilities 233,500 167,200 Bonds payable 404,000 404,000 Common stockholders’ equity 986,800 836,400 Total liabilities and stockholders’ equity $1,624,300 $1,407,600 INCOME STATEMENT...
Grouper Company's condensed financial statements provide the following information. GROUPER COMPANY BALANCE SHEET Dec. 31, 2017 Dec. 31, 2016 Cash $51,900 $59,800 Accounts receivable (net) 199,900 79,300 Short-term investments 79,300 39,600 Inventory 442,700 359,900 Prepaid expenses 3,000 7,000 Total current assets $776,800 $545,600 Property, plant, and equipment (net) 850,400 845,400 Total assets $1,627,200 $1,391,000 Current liabilities 237,700 156,300 Bonds payable 398,800 398,800 Common stockhol ders' equity 990,700 835,900 Total liabilities and stockholders' equity $1,627,200 $1,391,000 INCOME STATEMENT FOR THE YEAR...
D. Ford Motor Company CONSOLIDATED BALANCE SHEET- USD (SI S in Millions Dec. 31, 2017 Dec. 31, 2016 ASSETS Cash and cash equivalents Short term Marketable securities (Note 9) Accounts receivables, (less allowances of $392 for 2017 and $412 for $ 18,492 $ 15,905 Calculate Gross Recievables 20,435 22.922 171,201 153,558 2016) Inventories (Note 12) Other assets Total current assets olFinancial Services finance receivables, net (Note 10) Net investment in operating leases 2Net property (Note 14) BEquity in net assets...
FIN Company: Balance Sheet as of December 31 ($ million) $40 Cash Account receivables Inventories Total current assets $40 $20 $100 $40 Account Payables ? Notes payable $160 Other current liabilities $310 Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total stockholders' equity $450 Total liabilities and equity $140 $114 ? Net fixed assets Total assets FIN Company: Income Statement for Year Ended December 31 ($ million) $800.0 Net sales Cost of goods sold (80% of net...
Barry Computer Company: Balance Sheet as of December 31, 2018 (In Thousands) Cash $167,440 Accounts payable $191,360 Receivables 382,720 Other current liabilities 179,400 Inventories 299,000 Notes payable to bank 119,600 Total current assets $849,160 Total current liabilities $490,360 $251,160 Long-term debt Common equity (45,448 Net fixed assets 346,840 454,480 Total assets $1,196,000 Total liabilities and equity $1,196,000 Barry Computer Company: Income Statement for Year Ended December 31, 2018 (In Thousands) Sales $2,300,000 Cost of goods sold Materials Labor $1,035,000 483,000...
ORIOLE COMPANY Balance Sheets December 31 2017 2016 Current assets Cash and cash equivalents Accounts receivable (net) $330 660 600 $360 590 530 Inventory Prepaid expenses 120 160 Total current assets 1,710 1,640 Investments 200 200 Property, plant, and equipment (net) Intangibles and other assets Total assets 420 380 530 510 $2,860 $2,730 $1,090 $980 550 520 Current liabilities Long-term liabilities Stockholders' equity-common Total liabilities and stockholders' equity 1,220 1,230 $2,860 $2,730 ORIOLE COMPANY Income Statements For the Year Ended...