Balance Sheet
Brand Brew Inc.
Years 1 & 2 ($000's)
Year 1 . Year 2 .
Cash & Marketable
Securities 309,705 59,167
Accounts Receivable 108,732 705,426
Inventories 138,577 215,159
Other Current Assets 49,515 74,144
Total Current Assets 606,529 1,053,896
PP&E, Net 869,710 1,380,239
Intangibles 86,289 1,256,145
Other Assets 177,164 607,131
Total Assets 1,739,692 4,297,411
Accounts Payable 222,493 334,647
Other current liabilities 210,052 669,195
Short-term Debt 85,000 144,049
Total Current Liabilities 517,545 1,147,891
Long-term debt 20,000 1,383,392
Other long-term liabilities 250,835 784,277
Total liabilities 788,380 3,315,560
Capital Stock 8,922 28,334
Retained earnings 954,981 1,086,965
Adjustments -12,591 -133,448
Total shareholders' equity 951,312 981,851
Total Liabilities & Equity 1,739,692 4,297,411
Income Statement for Brand Brew Inc. Year 1 Year 2 Revenues 2,429,462 3,776,322 COGS 1,537,623 2,414,530 Depreciation 121,091 230,299 SG&A 619,143 833,208 EBIT 151,605 298,285 Interest Expense –14,403 49,732 Other income 32,005 8,047 Pre-Tax Income 198,013 256,600 Income Tax 75,049 94,947 Net Income 122,964 161,653
7. Refer to Brand Brew, Inc. financial statements,
Which of the following statements is correct?
(x) Both total asset turnover and ROA for the
firm decreased from Year 1 to Year 2.
(y) The amount of debt held by Brand Brew, Inc.
increased by more than 300 percent from
Year 1 to Year 2.
(z) The ROE for Brand Brew, Inc. rose from
12.9% in Year 1 to more than 17.4% in
Year 2.
A. (x), (y) and (z)
B. (x) and (y) only
C. (x) and (z) only
D. (y) and (z) only
E. (x) only
8. Refer to Brand Brew, Inc. financial statements.
What is the most important determinant of the
change in ROE?
A. ROA
B. Profit Margin
C. The change in leverage
D. Total Asset Turnover
E. Both A and B are important determinants
7. The correct answer is option B is only x and y are the correct statements.
working notes:
statement x
Total Asset Turnover = Net Sales / Average Total Assets
where Average total assets = total assets / 2
YEAR 1
Total Asset Turnover = 2429462 / 869846 = 2.792
Where, Average total Assets = 1739692 / 2 = 869846
Similarly in YEAR 2
Total Asset Turnover = 3776322 / 2148705 = 1.75
...
ROA = Net Income / Average total assets
YEAR 1
ROA = 122964 / 869846 = 0.141
YEAR 2
ROA = 161653 / 2148705 = 0.075
So clearly, X is true.
Statement y
Increase in total debt from year 1 to year 2 = 1527441 - 105000 = 1422441
percentage increase = 1422441 / 105000 = 13.547 * 100 = 1354.7%
Again, Y us true.
Statement z
ROE = Net income / Shareholders equity
YEAR 1, ROE = 122964 / 951312 = 0.12897 * 100 = 12.9 % (approx)
YEAR 2, ROE = 161653 / 981851 = 0.16464 * 100 = 16.4 %
Z is false because it says that roe in the year 2 is 17.4%.
.....
8. Option E ie both ROA And Profit margin.
Balance Sheet Brand Brew Inc. Years 1 & 2 ($000's) Year 1 . Year 2 . Cash & Marketable Securities 309,705 59...
Balance Sheet and Income Statement ASSETS 2015 2014 CASH AND MARKETABLE SECURITIES 29,000 25,000 ACCOUNTS RECEIVABLE 116,000 100,000 INVENTORIES 145,000 125,000 CURRENT ASSETS 290,000 250,000 GROSS PLANT AND EQUIPMENT 362,000 350,000 LESS: ACCUMULATED DEPRECIATION 130,000 100,000 NET FIXED ASSETS 232,000 250,000 TOTAL ASSETS 522,000 500,000 LIABILITIES AND EQUITY ACCOUNTS PAYABLE 90,480 78,000 ACCRURALS 34,800 30,000 NOTES PAYABLE 25,420 34,000 CURRENT LAIBILITIES 150,700 142,000 LONG TERM DEBT 145,000 140,000 TOTAL LIABILITIES 295,700 282,000 COMMON STOCK ($1.00 par) 150,000 150,000 RETAINED EARNINGS...
Marnus Inc Income Statement For the Financial Year ended Statement values in 000's Period Ending: 12/31/19 12/31/18 Total Revenue (Net Revenue) $150,000,000 $140,000,000 Cost of Revenue (CoGS) ($130,000,000) ($123,000,000) $20,000,000 $17,000,000 Gross Profit Operating Expenses Sales, General and Admin. $9,000,000 $10,000,000 $0 $0 Other Operating Items Total Operating Exp ($9,000,000) ($10,000,000) $11,000,000 $7,000,000 Operating Income (or loss) Interest Expense ($1,000,000) ($800,000) $10,000,000 $6,200,000 Earnings Before Tax ($4,000,000) ($5,000,000) Income Tax Net Income (or loss) $5,000,000 $2,200,000 12/31/19 12/31/18 Dividends declared...
The balance sheet and income statement for Covid19 Bhd is presented below. BALANCE SHEET (000) Cash $ 500 Accounts receivable 1,500 Inventories 500 Current assets 2,500 Net fixed assets 5,000 Total Assets $ 7,500 Accounts payable 1,200 Bank note 300 Total current liabilities 1,500 Long term debt 4,000 Common stock 300 Retained earnings 1,700 Total liabilities and owner's equity $ 7,500 INCOME STATEMENT (000) Net sales $ 8,500 Cost of goods sold (3,400) Gross profit 5,100 Operating expenses (2,900) Net...
The balance sheet and income statement for Cullumber Supply Company for the fiscal year ended June 30, 2017 is as follows Cullumber Supply Company Income Statement for the Fiscal Year Ended June 30, 2017($ thousands) Net sales Cost of goods sold Selling and administrative expenses Nonrecurring expenses Earnings before interest, taxes, depreciation, and amortization (EBITDA) Depreciation Earnings before interest and taxes (EBIT) Interest expense Earnings before taxes (EBT) Taxes (35%) Net income $2,133,900 1,459,400 313,000 27,600 $333,900 112,150 221,750 117,650...
Problem SFP4-2 FINANCIAL PLANNING AND GROWTH CONSIDERATIONS Clueless, Inc. Balance Sheet at 12/31/2019 (000's) Cash & Marketable Securities 60 Accounts Payable 50 Accounts Receivable Long-Term Debt 293 Inventories 150 Total Liabilities Total Current Assets 321 Common Stock 145 Net Fixed Assets 250 Retained Earnings 83 Total Assets 571 Total Liabilities and Capi 571 Additional considerations: Sales for 2019 were $1,000,000; Net Income after Tax = $60,000 Management's estimates for the next years: Sales growth @30% for 2020 Net Income after...
• Post the most recent two-year Balance Sheet and Income Statement in Excel) of your company extracted from the 10-k report on sec.gov. • Show the calculations of 6 ratios in your Excel file) of your company in the most recent three years including: o current ratio o total asset turnover ratio o total debt ratio o net profit margin O ROA . ROE PERIOD ENDING: 6/30/2019 6/30/2018 CURRENT ASSETS Cash and Cash Equivalents $392,324 $322,591 Short-Term Investments $0 $0...
P4-42. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below for Under Armour Inc. UNDER ARMOUR INC. Consolidated Statements of Income For 12 Months Ended ($ in 000s) Dec. 31, 2015 M Net revenues ................................ Cost of goods sold ......... Gross profit.. Selling, general and administrative expenses ....... Income from operations ........ Interest expense, net ....... Other expense, net..................................................... Income before income taxes........... Provision for income taxes............... Net income.... o n o polduOHS. ...............
Balance Sheet Assets Fiscal year is January-December. All values USD millions. 2017 Cash & Short Term Investments 18.3B Total Accounts Receivable 13.49B Inventories 8.77B Other Current Assets 2.54B Total Current Assets 43.09B 2017 Net Property, Plant & Equipment 17.01B Total Investments and Advances 751M Long-Term Note Receivable - Intangible Assets 85.13B Other Assets 4.22B Total Assets 157.3B Liabilities & Shareholders' Equity 2017 ST Debt & Current Portion LT Debt 3.91B Accounts Payable 7.31B Income Tax Payable 1.85B Other Current Liabilities...
Balance sheets and income statements for the home depot inc. and
lowe's companies inc .
1.Compute return on equity, return on assets, and return on
financial leverage for each company in 2014
2. Disaggregate the ROA's computed into profit margin (PM) and
asset turnover (AT) components. Which of these factors drives ROA
for each company?
3. Compute the gross profit margin (GPM) and operating
expense-to-sales ratios for each company. How do these companies'
profitability measures compare?
4. Compute the accounts...
Analysis and Interpretation of Return on Investment for Competitors Balance sheets and income statements for The Home Depot, Inc., and Lowe's Companies, Inc., follow. Refer to these financial statements to answer the requirements. P5-38. Analyzing and Interpreting Financial Statemen HOME DEPOT, INC. LOWE'S 2014 2013 2014 ..$ 1,723 $1,929 466s 11,079 11,0578,911 Balance Sheets S millions) 125 1,398911 9,127 Cash and cash equivalents Short-term investments.... Receivables, net 1.016 95578 15,302 15,27910,080 22,720 23,348 20,034 1,289 BO10.296 Other current assets Total...