Question

In: Accounting

Hillside, Inc. BALANCE SHEET INCOME STATEMENT ($ in millions) ($ in millions) ASSETS LIABILITIES Revenue      ...

Hillside, Inc.
BALANCE SHEET INCOME STATEMENT
($ in millions) ($ in millions)
ASSETS LIABILITIES Revenue       28,681.10
Cash & Marketable Securities          449.90 Accounts Payable       1,611.20 Cost Of Goods Sold       20,768.80
Accounts Receivable          954.80 Salaries Payable          225.20 Gross Profit         7,912.30
Inventories       3,645.20 Other Current Liabilities       1,118.80
Other Current Assets          116.60 Total Current Liabilities       2,955.20 Operating Expenses:
Total Current Assets       5,166.50 Selling, General & Admin.         5,980.80
Other Liabilities          693.40 Depreciation            307.30
Machinery & Equipment       1,688.90 Operating income         1,624.20
Land       1,129.70 Total Liabilities       3,648.60
Buildings       2,348.40 Interest                    -  
Depreciation        (575.60) SHAREHOLDER'S EQUITY Other Expense (Income)            (13.10)
Property, Plant & Equip. - Net       4,591.40 Common Stock          828.50 Income Before Taxes         1,637.30
Other Long Term Assets          120.90 Retained Earnings       5,401.70 Income Taxes            618.10
Total Long-Term Assets       4,712.30 Total Shareholder's Equity       6,230.20 Net Income       1,019.20
Total Assets     9,878.80 Total Liabilities & Equity     9,878.80
Number of Common Stock
   Shares Outstanding       1,032,271
Input Answers Below Financial Performance Summary
LIQUIDITY RATIOS
Current Ratio (times)
Quick Ratio (times)
Average Payment Period (days)
ASSET MANAGEMENT RATIOS
Total Asset Turnover (times)
Average Collection Period (days)
Inventory Turnover (times)
FINANCIAL LEVERAGE RATIOS
Total Debt to Total Assets
Equity Multiplier (times)
PROFITABILITY RATIOS
Operating Profit Margin
Net Profit Margin
Return on Total Assets
Return on Equity
Earnings per Share

Solutions

Expert Solution

LIQUIDITY RATIOS Formula Answer
Current Ratio (times) =Current Assets/Current Liability 1.75 =5166.5/2955.2
Quick Ratio (times) =(Current assets-Stock)/Current Liability 0.51 =(5166.5-3645.2)/2955.2
Average Payment Period (days) =Accounts Payable/(Total credit purchaseor COGS/days in period) 28.32 =1611.2/(20768.8/365)
ASSET MANAGEMENT RATIOS
Total Asset Turnover (times) =Net Sales/Total assets 2.90 =28681.1/9878.8
Average Collection Period (days) =Accounts Receivable/(Net Sales/days in period) 12.15 =954.8/(28681.1/365)
Inventory Turnover (times) =COGS/Inventory 5.70 =20768.8/3645.2
FINANCIAL LEVERAGE RATIOS
Total Debt to Total Assets =Total Liabilities/Total assets 0.37 =3648.6/9878.8
Equity Multiplier (times) =Total assets/Total equity 1.59 =9878.80/6230.200
PROFITABILITY RATIOS
Operating Profit Margin =Operating profit/Net sales 5.66% =1624.2/28681.1
Net Profit Margin =Net profit/Net sales 3.55% =1019.2/28681.1
Return on Total Assets =Profitbefore interest and tax /total assets 16.57% =1637.3/9878.8
Return on Equity =Net profit/Equity 16.36% =(1019.2/6230.2)
Earnings per Share =Net profit/number of shares 987.34 =(1019.2*10^6)/1032271

Related Solutions

Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets Liabilities...
Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets Liabilities and Equity Cash and due from banks $ 9,400 Demand deposits $ 23,000 Investment securities 27,000 NOW accounts 93,000 Repurchase agreements 46,000 Retail CDs 32,000 Loans 94,000 Debentures 23,000 Fixed assets 19,000 Total liabilities $ 171,000 Other assets 4,400 Common stock 12,000 Paid-in capital 4,000 Retained earnings 12,800 Total assets $ 199,800 Total liabilities and equity $ 199,800 Income Statement Interest on fees and...
3. Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets...
3. Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets | Liabilities and Equity Cash and due from banks $ 9,000 | Demand deposits $ 19,000 Investment securities 23,000 | NOW accounts 89,000 Repurchase agreements 42,000 | Retail CDs 28,000 Loans 90,000 | Debentures 19,000 Fixed assets 15,000 | Total liabilities $155,000 Other assets 4,000 | Common stock 12,000 Total assets $183,000 | Paid-in capital 4,000 | Retained earnings 12,000 | Total liabilities and...
Consider the following balance sheet for ABC Inc( in millions) Assets Liabilities and Equity Floating Rate...
Consider the following balance sheet for ABC Inc( in millions) Assets Liabilities and Equity Floating Rate loans ( currently 6% annually) = $80 Demand Deposits(currently at 1% annually) = $30 20 year fixed rate loans ( currently 5% annually) = $20 Time Deposits( currently at 6% annually) = $60 Total Assets = $100 Equity = $10 Total Liabilities and Equity = $100 a) What is ABC's expected net interest income at year end? b) What will be the net interest...
Consider the following balance sheet for Watchover Savings, Inc. (in millions): Assets Liabilities and Equity   Floating-rate...
Consider the following balance sheet for Watchover Savings, Inc. (in millions): Assets Liabilities and Equity   Floating-rate mortgages      (currently 12% p.a.) $ 86   Now deposits      (currently 8% p.a.) $ 118   30-year fixed-rate loans      (currently 9% p.a.) 103   5-year time deposits      (currently 8% p.a.) 26   Equity 45      Total $ 189   Total $ 189 a. What is Watchover’s expected net interest income at year-end? (Enter your answer in millions rounded to 2 decimal places. (e.g., 32.16))   Net interest income $  million b. What...
Consider the following balance sheet for Watchover Savings Inc. (in millions): Assets Liabilities and Equity Floating-rate...
Consider the following balance sheet for Watchover Savings Inc. (in millions): Assets Liabilities and Equity Floating-rate mortgages (currently 12% p.a.) $ 70 Now deposits (currently 8% p.a.) $ 110 30-year fixed-rate loans (currently 9% p.a.) 95 5-year time deposits (currently 8% p.a.) 21 Equity 34 Total $ 165 Total $ 165 a. What is Watchover’s expected net interest income at year-end? (Enter your answer in millions rounded to 2 decimal places. (e.g., 32.16)) b. What will be the net interest...
Consider the following balance sheet for WatchoverU Savings Inc. ($ in millions): Assets Liabilities Floating-rate mortgages...
Consider the following balance sheet for WatchoverU Savings Inc. ($ in millions): Assets Liabilities Floating-rate mortgages (currently 10% annually) $ 60 NOW accounts (currently 6% annually) $ 80 30-year fixed-rate loans (currently 7% annually) 60 Time deposits (currently 6% annually) 24 Equity 16 Total $ 120 $ 120 a. What is WatchoverU’s expected net interest income at year-end? b. What will be the net interest income at year-end if interest rates rise by 2 percent?
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 13 years...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 13 years $ 970 Duration = 5 years $ 900 Equity 70 a. What is the FI’s duration gap? (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16)) b. What is the FI’s interest rate risk exposure? c. How can the FI use futures and forward contracts to create a macrohedge? d. What is the impact on the FI’s equity value...
Ratio Analysis: Balance Sheet (Millions of $)       Assets   Liabilities and Equity   Cash and securities $  1,554.0...
Ratio Analysis: Balance Sheet (Millions of $)       Assets   Liabilities and Equity   Cash and securities $  1,554.0 Accounts payable $  7,980.0 Accounts receivable 9660.00 Notes payable 5880.00 Inventories   13,440.0 Accruals     4,620.0 Total current assets 24654.00 Total current liabilities 18480.00 Net plant and equipment   17,346.0 Long-term bonds   10,920.0 Total assets 42000.00 Total debt 29400.00     Common stock 3360.00     Retained earnings     9,240.0     Total common equity 12600.00     Total liabilities and equity 42000.00 Income Statement (Millions of $)   Other data:   Sales 58800.00 Shares outstanding (millions) 175.00...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 10 years...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 10 years $950 Duration = 2 years $860 Equity     90 a)What is the FI's duration gap? b)What is the FI's interest rate risk exposure? c)How can the FI use futures and forward contracts to put on a macrohedge? d) What is the impact on the FI's equity value if the relative change in interest rates is an increase of 1 percent? That is, DR/(1+R) =...
Consider the following income statement for WatchoverU Savings Inc. (in millions): Assets Liabilities Floating-rate mortgages (currently...
Consider the following income statement for WatchoverU Savings Inc. (in millions): Assets Liabilities Floating-rate mortgages (currently 12% annually) $ 63 NOW accounts (currently 8% annually) $ 83 30-year fixed-rate loans (currently 9% annually) 63 Time deposits (currently 8% annually) 26 Equity 17 Total $ 126 $ 126 a. What is WatchoverU’s expected net interest income at year-end? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places. (e.g., 32.16)) Net interest income $ 4.51 million...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT