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

“Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

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

Use the information below for Harding Company to answer the question that follow. Harding Company Accounts payable $36,767 Accounts receivable 74,993 Accrued liabilities 6,681 Cash 17,378 Intangible assets 41,965 Inventory 83,039 Long-term investments 90,147 Long-term liabilities 70,154 Marketable securities 39,256 Notes payable (short-term) 24,477 Property, plant, and equipment 689,894 Prepaid expenses 1,932 Based on the data for Harding Company, what is the amount of working capital?
Net sales Cost of goods sold Gross profit Expenses: Operating expenses Depreciation expense Loss on sale of land Interest expense Income tax expense Total expenses Net income Assets Current assets: Cash For the Years Ended December 31 2025 $ 3,560,000 2,490,000 1,070,000 Accounts receivable Inventory Prepaid rent Long-term assets: Investment in bonds Land Equipment Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Interest payable Income tax payable Long-term liabilities: Notes payable Problem 12-6A (Static) Part 1 Stockholders' equity: Common stock Retained earnings Total liabilities and stockholders' equity Receivables turnover ratio Inventory turnover ratio Current ratio Debt to equity ratio 965,000 40,000 0 23,000 9,000 1,037,000 $ 33,000 2024 38.3 times 15.1 times % 2024 $ 3,086,000 1,960,000 1,126,000 VIRTUAL GAMING SYSTEMS Balance Sheets December 31 2025 39.3 times 19.5 times 868,000 32,000 % 9,000 20,000…
BALANCE SHEET AT END OF YEAR (Figures in $ millions) Assets 2021 2022 Liabilities and Shareholders' Equity 2021 2022 Current assets $ 102 $ 200 Current liabilities $ 74 $ 96 Net fixed assets 920 1,020 Long-term debt 660 870 INCOME STATEMENT, 2022 (Figures in $ millions) Revenue $ 2,010 Cost of goods sold 1,090 Depreciation 410 Interest expense 252 g. Net fixed assets increased from $920 million to $1,020 million during 2022. What must have been South Sea’s gross investment in fixed assets during 2022?........... (M1)
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
Current assets Cash Accounts receivable Inventory Prepaid expenses Total current assets Current liabilities Accounts payable Salaries payable Income tax payable Total current liabilities (a1) a. $8,600 Current ratio 12,900 b. Quick ratio 145,000 5,200 $171,700 $53,300 3,600 1,000 $57,900 2024 $30,100 10,300 :1 105,000 $152,300 :1 6,900 $40,400 5,000 1,000 $46,400 $27,100 7,700 100,000 During 2024, credit sales and cost of goods sold were $138,040 and $82,500, respectively. The 2023 and 2022 credit sales were $151,200 and $151,840, respectively, and the cost of goods sold for the same periods were $79,950 and $82,325, respectively. The accounts receivable and inventory balances at the end of 2021 were $6,900 and $85,000, respectively. 5,600 $140,400 Using the above data, calculate the following ratios: (Round receivables turnover ratio and average collection period to 1 decimal place, e.g. 15.2, days to sell inventory to 0 decimal places, e.g. 152 and all other answers to 2 decimal…
Problem 3-3 (Algo) Balance sheet preparation [LO3-2, 3-3] The following is a December 31, 2021, post-closing trial balance for Almway Corporation. Account Title Cash Investment in equity securities Accounts receivable. Inventory Prepaid insurance (for the next 9 months) Land Buildings Accumulated depreciation-buildings Equipment Accumulated depreciation-equipment Patent (net) Accounts payable Notes payable Interest payable Bonds Payable Common stock Retained earnings Totals $ Debits 65,000 130,000 70,000 210,000 8,000 110,000 430,000 120,000 20,000 Credits $ 110,000 70,000 95,000 160,000 30,000 250,000 330,000 118,000 $1,163,000 $1,163,000 Additional information: 1. The investment in equity securities account includes an investment in common stock of another corporation of $40,000 which management intends to hold for at least three years. The balance of these investments is intended to be sold in the coming year. 2. The land account includes land which cost $35,000 that the company has…
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…
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 887.00 Cost of goods sold 747.00 Depreciation 37.00 Earnings before interest and taxes (EBIT) $ 103.00 Interest expense 18.00 Income before tax $ 85.00 Taxes 17.85 Net income $ 67.15 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 375 $ 324 Long-term assets 270 228 Total assets $ 645 $ 552 Liabilities and shareholders’ equity Current liabilities $ 200 $ 163 Long-term debt 114 127 Shareholders’ equity 331 262 Total liabilities and shareholders’ equity $ 645 $ 552 The company’s cost of capital is 8.5%. Required: Calculate Watervan’s economic value added (EVA). Note: Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places. What is the company’s return on capital? (Use start-of-year rather than average capital.) Note: Do not…
Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment Total assets SMOLIRA GOLF, INC. 2016 Income Statement Sales Cost of goods sold Depreciation EBIT Interest paid Taxable income Taxes Assets Net income Dividends Retained earnings $ 2,757 $ 2,881 4,712 12,698 5,671 13,672 $20,291 $ 22,100 1. Profit margin n. Return on equity SMOLIRA GOLF, INC. Balance Sheets as of December 31, 2015 and 2016 2015 2016 $57,432 $77,723 $12,015 24,206 Short-term solvency ratios a. Current ratio b. Quick ratio Asset utilization ratios d. Total asset turnover e. Inventory turnover Long-term solvency ratios g. Total debt ratio h. Debt-equity ratio i. Equity multiplier j. Times interest earned ratio Profitability ratios $ 83,529 $105,629 $189,570 127,303 5,223 $ 57,044 1,320 $ 55,724 19,503 $36,221 Liabilities and Owners' Equity Current liabilities Accounts payable Notes payable Other Total Long-term debt Owners' equity Common stock and paid-in surplus Accumulated…
Assets Cash Accounts receivable Inventory Total current assets Equipment Accumulated depreciation-Equipment Total assets Liabilities and Equity Accounts payable Income taxes payable Total current liabilities Equity Common stock, $2 par value Paid-in capital in excess of par value, common stock Retained earnings Total liabilities and equity GOLDEN CORPORATION Income Statement For Current Year Ended December 31 Sales Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Income before taxes Income taxes expense Net income GOLDEN CORPORATION Comparative Balance Sheets. December 31 Additional Information on Current Year Transactions a. Purchased equipment for $56,300 cash. b. Issued 13,200 shares of common stock for $5 cash per share. c. Declared and paid $101,000 in cash dividends. Cash flows from operating activities Adjustments to reconcile net income to net cash provided by operations: Income statement items not affecting cash Changes in…

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