Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is part of the question to the first picture AutoSave & hc385 4ks financial performance worksheet (2) - Excel P age Layout Formulas Data

this is part of the question to the first picture image text in transcribed
image text in transcribed
AutoSave & hc385 4ks financial performance worksheet (2) - Excel P age Layout Formulas Data Review View Help File Home insert Draw Font POF Power Prot Times New Roman - 10 - AA BIU- - - A = General Paste Wrap Test Merge & Center $ -% % -? Conditional Formatas Cell Formatting Table Styles Insert Delete Form Clipboard Font G28 - X 4 A Hillside, Inc. BALANCE SHEET (Sin millions) INCOME STATEMENT (S in millions) ASSETS Cash & Marketable Securities Accounts Receivable Inventones 449.90 95430 3,615.20 LABILITIES Accounts Payable Salanes Payable Other Current Liabilities Total Current Listes Revenue Cost Of Goods Sold Gross Profit 28,681.10 20.758.80 7912 30 Other Current Assets Total Current Assets 3,100.3 Other Liabilities Operating penses Selling General & Adnan Depreciation Operating income 5,980.89 307.30 1.60420 Machinery & Equpment 1.6589 Total Liabilities 1. 1291 2.3454 Buildings Deprecation Property, Plant & Equip-Net Other Long Term Assets Total Long Term Assets 4.391. SHAREHOLDER'S EQUITY Con Stock Retained Emings Total Shareholder's Equity $26.50 3.401.10 Other Expense (come) Incone Before Taxes Income Tas Net Income (1310) 1,537.30 613.10 1.019.20 4712) Total Assets Total Liabilities & Equity Number of Common Stock Shares Outstanding Problem for Students acer C D F G nyut An Le Pinancial Performances 28 LIQUIDITY RATIOS 29 Current Ratio (times) 30 Quick Ratio (times) 31 Average Payment Period (days) 33 ASSET MANAGEMENT RATIOS 34 Total Asset Tamover times) 35 Average Collection Period (days) 36 Inventory Tumover times) 38 EINANCIAL LEVERAGE RATIOS 39 Total Debt to Total Assets 40 Equity Multiplier times) 42 PROFITABILITY RATIOS 43 Operating Profit Margin 44 Net Profit Mar 45 Retum on Total Assets 46 Retum on Equity 47 Earnings per Share Problem for Students e Sa DP NOW CET

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

Governmental and Nonprofit Accounting

Authors: Robert Freeman, Craig Shoulders, Gregory Allison, Robert Smi

10th edition

132751267, 978-0132751261

Students also viewed these Accounting questions