Use Table 1: Hillside, Inc. Balance Sheet($ in Millions) information in cells A3through D19 and Table 2: Hillside, Inc.Income Statement ($ in Millions)information in cells A21 through B38 tocomplete Table 3: Financial RatioCalculations in cells A40 through B57.This is the only tab in this file, and it isPart 2 of the Wk 4 SummativeAssessment: Financial AnalysisCalculations.Table 1: Hillside, Inc. Balance Sheet ($ inMillions)ASSETSCash & Marketable SecuritiesAccounts ReceivableInventoriesOther Current AssetsTotal Current AssetsMachinery & EquipmentLandBuildingsDepreciationProperty, Plant, and Equipment (Net)Other Long-Term AssetsTotal Long-Term AssetsTotal AssetsTable 2: Hillside, Inc. Income Statement ($in Millions)RevenueCost Of Goods SoldGross ProfitOperating Expenses:Selling, General & Admin.DepreciationOperating incomeInterestOther Expense (Income)Income Before TaxesIncome TaxesNet IncomeNumber of Common StockShares OutstandingTable 3: Financial Ratio CalculationsCalculate 3 Liquidity RatiosCurrent Ratio (times)Quick Ratio (times)Average Payment Period (days)Calculate 3 Asset-Management RatiosTotal Asset Turnover (times)Average Collection Period (days)Inventory Turnover (times)Calculate 2 Financial Leverage RatiosTotal Debt to Total AssetsEquity Multiplier (times)Calculate 5 Profitability RatiosOperating Profit MarginNet Profit MarginReturn on Total AssetsReturn on EquityEarnings per ShareAssetsInformationILITIES449.90 Accounts Payable954.80 Salaries Payable3,645.20 Other Current Liabilities116.60 Total Current Liabilities5,165.271,688.901,129.70 Total Liabilities2,348.40(575.60) SHAREHOLDER'S EQUITY4,591.40 Common Stock120.90 Retained Earnings4,712.30 Total Shareholder's Equity9,877.57 Total Liabilities & Equity28,681.1020,768.807,912.30OperatingExpensesInformation5,980.80307.301,624.200(13.10)1,637.30618.101,019.201,032,271Liquidity RatiosAnswers1.000.61365.00Asset-ManagementRatios AnswersOther Liabilities0.10342 days56973.00FinancialLeverage RatiosAnswers36.93%1.59ProfitabilityRatios Answers5.66%3.55%573.00%16.30%1019.19LiabilitiesInforma1,611.20225.201.118.802,955.20693.403,648.60Shareholder'sEquity Information828.505,401.706,230.209,878.80

ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets Machinery & Equipment Land Buildings Depreciation Property, Plant, and Equipment (Net) Other Long-Term Assets Total Long-Term Assets Total Assets Table 2: Hillside, Inc. Income Statement ($ in Millions) Revenue Cost Of Goods Sold Gross Profit Assets Information LIABILITIES 449.90 Accounts Payable 954.80 Salaries Payable 3,645.20 Other Current Liabilities 116.60 Total Current Liabilities 5,165.27 Other Liabilities 1,688.90 1,129.70 Total Liabilities 2,348.40 (575.60) SHAREHOLDER'S EQUITY 4,591.40 Common Stock 120.90 Retained Earnings 4,712.30 Total Shareholder's Equity 9,877.57 Total Liabilities & Equity 28,681.10 20,768.80 7,912.30 Liabilities Information 1,611.20 225.20 1,118.80 2,955.20 693.40 3,648.60 Shareholder's Equity Information 828.50 5,401.70 6,230.20 9,878.80

ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets Machinery & Equipment Land Buildings Depreciation Property, Plant, and Equipment (Net) Other Long-Term Assets Total Long-Term Assets Total Assets Table 2: Hillside, Inc. Income Statement ($ in Millions) Revenue Cost Of Goods Sold Gross Profit Assets Information LIABILITIES 449.90 Accounts Payable 954.80 Salaries Payable 3,645.20 Other Current Liabilities 116.60 Total Current Liabilities 5,165.27 Other Liabilities 1,688.90 1,129.70 Total Liabilities 2,348.40 (575.60) SHAREHOLDER'S EQUITY 4,591.40 Common Stock 120.90 Retained Earnings 4,712.30 Total Shareholder's Equity 9,877.57 Total Liabilities & Equity 28,681.10 20,768.80 7,912.30 Liabilities Information 1,611.20 225.20 1,118.80 2,955.20 693.40 3,648.60 Shareholder's Equity Information 828.50 5,401.70 6,230.20 9,878.80

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Question Content Area Use the information provided for Harding Company to answer the question that follow. Harding Company Accounts payable $33,234 Accounts receivable 67,995 Accrued liabilities 6,510 Cash 22,738 Intangible assets 35,347 Inventory 83,390 Long-term investments 101,069 Long-term liabilities 79,156 Notes payable (short-term) 27,161 Property, plant, and equipment 689,074 Prepaid expenses 2,037 Temporary investments 30,842 Based on the data for Harding Company, what is the quick ratio (rounded to one decimal place)? a.3.1 b.0.8 c.1.8 d.15.4
J-Mark Superstores provides the following selected financial data. Cash and cash equivalents Short-term investments Accounts receivable Inventory Property, plant and equipment Long-term investments Total asset 2024 $ 852,540 45,050 1,120,545 2023 $ 750,235 39,194 1,030,901 2,812,020 2,615,179 4,212,686 3,749,291 96,555 82,072 9,139,396 8,266,871 Total liabilities 4,204,122 3,968,098 Total stockholders' equity 4,935,274 4,298,773 Net sales 15,579,865 13,710,281 Operating income 5,452,953 4,661,496 Interest expense 157,655 148,804 Investment income 5,947 4,851 Calculate the return on investments ratio for 2024. Note: Round your answer to 1 decimal place. Answer is complete but not entirely correct. Return on investments ratio 4.2 × %
Accounts payable 919 Accounts receivable 631 Accumulated depreciation 1,813 Cash 729 Common stock 1,387 Cost of goods sold 7,578 Current portion of long-term debt 24 Depreciation expense 108 Dividends 13 Goodwill and other long-term assets 2,627 Income tax expense 24 Income taxes payable 12 Interest expense 54 Interest revenue 11 Inventories 930 Long-term liabilities 1,585 Prepaid expenses and other current assets 65 Property and equipment 2,389 Retained earnings 825 Sales 9,710 Selling, general, and administrative expenses 2,276 Unearned revenue 990 Wages payable 148 Prepare the balance sheet.
Prepare a blance sheet
Current assets: Cash and marketable securities Accounts receivable Inventory Total Assets Fixed assets: Gross plant and equipment Less: Accumulated depreciation Net plant and equipment Other long-term assets Total Total assets Net sales Less: Cost of goods sold Gross profits Less: Other operating expenses 2024 VALIUM'S MEDICAL SUPPLY CORPORATION Balance Sheet as of December 31, 2024 and 2023 (in millions of dollars) $ 72 187 312 $ 571 Earnings per share (EPS) Dividends per share (DPS) Book value per share (BVPS) Market value (price) per share (MVPS) 2023 $ 71 181 291 $ 543 $ 1,073 146 $ 927 134 $ 1,061 $ 1,632 $ 1,446 $ 882 113 $ 769 134 $ 903 Liabilities and Equity Current liabilities: Accrued wages and taxes Accounts payable Notes payable Total Long-term debt Stockholders' equity: Preferred stock (6 thousand shares) Common stock and paid-in surplus (100 thousand shares) Retained earnings Total VALIUM'S MEDICAL SUPPLY CORPORATION Income Statement for Years Ending December 31, 2024 and…
perience p....pptm ^ Type here to search w X # 3 E Coronado Company's condensed financial statements provide the following information. C Cash Accounts receivable (net) Short-term investments Inventory Prepaid expenses Total current assets Property, plant, and equipment (net) Total assets Current liabilities ACC341-2022-Ho....xlsx $ 4 Bonds payable R F % 5 O CORONADO COMPANY BALANCE SHEET T At O+ 6 V B ▶ music 2.jpeg n H & 7 Dec. 31, 2020 $52,100 197,700 80,800 442,700 3,000 $776,300 849,900 $1,626,200 237,700 401,800 U 20 8 J Dec. 31, 2019 $60,200 O 80,800 39,600 N M 360,200 $547,700 849,900 $1,397,600 6,900 155,700 ( 401,800 9 W K F11 ) O 0 888 P Home End C Rair Inse
Assets Current assets: Cash and marketable securities Accounts receivable Inventory Total Fixed assets: Gross plant and equipment Less: Depreciation Net plant and equipment Other long-term assets Total Total assets Net sales (all credit) Less: Cost of goods sold Gross profits Less: Other operating expenses Earnings per share (EPS) Dividends per share (DPS) Book value per share (BVPS) Market value (price) per share (MVPS) 2821 $ 75 115 200 $390 ROA ROE $580 110 $470 50 $520 $910 Less: Depreciation Earnings before interest and taxes (EBIT) Less: Interest Earnings before taxes (EBT) Less: Taxes Net income Less: Preferred stock dividends Net income available to common stockholders Less: Common stock dividends Addition to retained earnings Per (common) share data: 96 96 Earnings before interest, taxes, depreciation, and amortization (EBITDA) 2020 $ 65 110 198 $365 DuPont Analysis times times $471 100 $371 LAK OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2021 and 2020…
QUESTION : " The balance sheet of Lara Ltd are as follows: 31/12/2019 Non-Current Assets RM RM RM Equipment (Cost) Less: Accumulated depreciation 28,500 (11,450) 17,050 Current Assets 18,570 Inventory Account receivable 8,470 Less: Provision doubtful debts (420) 8,050 4,060 30,680 Cash and bank Total Assets Current Liabilities Account Payable 4,140 Non-Current Liabilities Loan 10,000 Total Liabilities (14,140) 16,540 Net Assets 33,590 Capital Opening Add: Net profit 35,760 10,240 Cash introduced Less: Drawing Total Capital (12,410) 33,590 31/12/2020 Non-Current Assets RM RM RM Equipment (Cost) Less: Accumulated depreciation 26,100 (13,010) 13,090 Current Assets 16,250 Inventory Account receivable 14,190 Less: Provision doubtful debts (800) 13,390 3,700 33,340 Cash and bank Total Assets Current Liabilities Account Payable 5,730 Non-Current Liabilities Loan 4,000 23,610 36,700 Total Liabilities (9,730) Net Assets
Assets Cash Receivables (net) Inventory PP & E (net) Patents&Licenses Goodwill Total assets Liabilities & Equity Accounts payable Short term debt Long term debt Preferred stock Common Equity Total Liabilities + Equity New Chip Corp Balance Sheet at 12/31/22 ($ in Millions) 31 45 64 215 28 19 402 53 19 179 23 128 402
mework i 0 ences Mc Graw Hill INCOME STATEMENT OF QUICK BURGER CORPORATION, 2022 (Figures in $ millions) Net sales Costs Depreciation Earnings before interest and taxes (EBIT) Interest expense Pretax income Federal taxes (@ 21%) Net income Assets Current assets Cash and marketable securities Receivables Inventories Other current assets Total current assets Fixed assets Property, plant, and equipment Intangible assets (goodwill) Other long-term assets Total assets a. Free cash flow b. Additional tax c. Free cash flow million million million $ 27,571 17,573 1,406 $ 8,592 521 2022 8,071 1,695 $ 6,376 BALANCE SHEET OF QUICK BURGER CORPORATION, 2022 (Figures in $ millions) 2021 $ 2,340 1,379 126 1,093 $ 4,938 $ 24,681 2,808 2,987 $ 35,414 $ 2,340 1,339 121 620 $ 4,420 Saved $ 22,839 2,657 3,103 Liabilities and Shareholders' Equity Current liabilities Debt due for repayment Long-term debt Other long-term liabilities Total liabilities Total shareholders' equity $ 33,019 Total liabilities and…
Assets Current assets: Cash Marketable securities Accounts receivable (net) Inventory Total current assets Investments Plant and equipment Less: Accumulated depreciation Net plant and equipment Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Notes payable Accrued taxes Total current liabilities Long-term liabilities: Bonds payable Total liabilities Stockholders' equity Preferred stock, $ 50 par value Common stock, $ 1 par value Capital paid in excess of par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 611,000 272,000 $ 52,500 22,500 178,000 290,000 $ 543,000 66,200 339,000 $948,200 $ 95,100 78,700 12,000 $ 185,800 159,400 $ 345,200 $ 100,000 80,000 190,000 233,000 $ 603,000 $948,200
Balance Sheet as at As at 30/9/16 As at 30/9/15 $ $ Assets Current assets- Cash 8,200 9,400 Accounts Receivable 107,000 103,500 Inventory 82,700 71,300 Non-current assets less accumulated depreciation 242,600 245,700 Total assets 440,500 429,900 Liabilities and Owners' equity Current liabilities 117,000 120,000 Loan (repayable in 2019) 152,000 150,000 Total liabilities 269,000 270,000 Owners' equity 171,500 159,900 Total Liabilities and Owners' equity 440,500 429,900 Summarised Income Statement of Bishan Enterprise for the year ended 30 September 2016 $ Sales 990,000 Cost of goods sold 580,000 Gross profit 410,000 Operating expenses 350,000 Net profit 60,000 · Note - The owner withdrew $48,400 during 2016. Required: Calculate…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS