Week 3 - AK

Module pute Net Operating Profit after Tax Refer to the balance sheet information below for Home Depot. Feb. 3, 2019 Jan. 28, 2018 $35,891 $34,794 1,511 3,056 $37,402 $37,850 $14,177 $13,640 24,822 22,974 $38,999 $36,614 Operating assets Nonoperating assets Total assets $ millions Operating liabilities Nonoperating liabilities Total liabilities Net sales Operating expense before tax Net operating profit before tax (NOPBT) Other expense Income before tax Tax expense Net income Assume a statutory tax rate of 22%. a. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = Net income + NNE Net income NNE NOPAT $ 9,453 $ $ $91,973 78,772 13,201 828 12,373 2,920 $9,453 7,361 * $ 16814 b. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = NOPBT - Tax on operating profit NOPBT Tax on operating profit 7,361 * $ 10,296.78 x $ NOPAT -2936

2019: Profit Margin – Profit $1435 / Net Sales $38,464 = 0.037:1 OR 3.7% Working Capital – Current Assets $3406 - Current Liabilities $4291 = -885 Current Ratio –  Current Assets $3406 / Current Liabilities $4291 = 0.79:1 OR $0.79 Current Cash Debt Coverage – Net Cash Provided by Operation Activities $2275 / Average Current Liabilities $8781.50 = 0.26:1 OR 0.26 Average Current Liabilities Calculation: 4291 + 8981 / 2 = 8781.50 Debt to Total Assets Ratio – Total Liabilities 4291 + 2129 = 6420 / Total Assets 3406 + 6371 = 9777 = 0.66:1 OR 0.66 Cash Debt Coverage – Net Cash Provided by Operation Activities $2275 / Average Total Liabilities 11,067.25 = 0.21:1 OR 0.21 Average Total Liabilities Calculation: 6420 + 9295 / 2 = 11,067.25 Return on Assets – Profit 1435 / Average Total Assets 11,160.50 = 0.128:1 OR 12.8% Average Total Assets Calculation: 9777 + 12544 / 2 = 11,160.50 2020: Profit Margin – Profit $978 / Net Sales $37,784 = 0.025:1 OR 2.5% Working Capital – Current Assets $3779 -…

BHP Group Ltd.- 2019 and 2020 Partial Balance Sheet Assets Liabilities & Owner’s Equity 2019 2020 2019 2020 Current assets $4665 $7279 Current liabilities $2076 $4256 Net Fixed assets $7033 $11378 Long-term debt $3712 $1980 Total Equity (Total assets – total liabilities) (Total assets – total liabilities) BHP Group Ltd.- 2020 Income Statement Sales $10073 Cost of goods sold $5815 Depreciation $2227 Interest paid $1284 Taxes $1202 Calculate the Profit margin ratio of BHP Group Ltd. for the financial year 2020

Global Corp. initially projected the 2019 income statement shown in the table E. Suppose that in 2019, Global launched an aggressive marketing campaign that boosted 2019 sales further by 14.1%. However, their operating margin fell from 5.56% to 4.49% Suppose that they had no other income, interest expenses were unchanged, and taxes were the same percentage of pretax income (26%) as in 2018. a. What was Global's EBIT in 2019? b. What was Global's income in 2019? c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019? a. What was Global's EBIT in 2019? Global's EBIT was $ million. (Round to two decimal places.) b. What was Global's income in 2019? Net income was $ million. (Round to two decimal places.) c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019? Global's share price in 2019 was $. (Round to the nearest cent.)

Income Statement (Extract) for the year ended 31 March   2018 2019   £ £ Sales 3,000,000 5,400,000 Less: Cost of Sales 2,400,000 4,320,000 Gross Profit 600,000 1,080,000 Less: Expenses 360,000 500,000 Operating Profit 240,000 580,000   Statement of Financial Position (Extract) as at 31 March   2018 2019   £ £ Non- Current Assets 364,000 512,000 Current Assets     Inventory 480,000 1,440,000 Trade Receivables 396,000 812,000 Total Assets £1,240,000 £2,764,000 Capital & Reserves     Ordinary Share Capital 140,000 240,000 Reserves 260,000 560,000 Non-Current Liabilities 440,000 500,000 Trade Payables 320,000 724,000 Bank Overdraft 80,000 740,000 Total Equity and Liabilities £1,240,000 £2,764,000   Calculate :  Trade Receivable Days  Trade Payable Days Non-current assets turnover

Computron's Income Statement                                   2019 2020 INCOME STATEMENT             Net sales          $           2,059,200  $               3,500,640 Cost of Goods Sold (Except depr. and amort.)        $           1,718,400  $               2,988,000 Other Expenses          $              204,000  $                   432,000 Depreciation and amortization        $                 11,340  $                     70,176 Total Operating Costs        $           1,933,740  $               3,490,176 Earnings before interest and taxes (EBIT)        $              125,460  $                     10,464 Less interest           $                 37,500  $                   105,600 Pre-tax earnings          $                 87,960  $                  (95,136) Taxes (40%)          $                 35,184  $                  (38,054) Net Income           $                 52,776  $                  (57,082)…

What are the firm’s net profit margins for 2018 and 2019? Income Statements ($ in millions) Balance Sheets ($ in millions)   2018 2019 Assets 2018 2019 Sales Revenue $2,580 $2,865 Cash $70 $50 Less: Cost of goods sold $1,060 $1,500 Short-Term investments $35 $9 Less: Operating Expenses $105 $162 Accounts rec. 400 460 Less: Depreciation $85 $80 Inventory 490 556 Earnings before interest and taxes $1,330 $1,123 Total Current Assets $995 $1,075 Less: Interest paid $350 $380 Net fixed assets 1890 1,910 Taxable Income $980 $743       Less: Taxes (40%) $392 $297 Total assets $2,885 2,985 Net income $588 $446 Liabilities and Owner's Equity     Dividends (45%) $265 $201   2018 2019 Additions to Retained Earnings $323 $245 Accounts payable $240 $210   Accruals $20 $20   Notes payable 65 74   Total Current…

PARROTHEAD ENTERPRISES 2020 and 2021 Partial Balance Sheets Assets 2020 2021 Liabilities and Owners’ Equity 2020 2021 Current assets  $ 1,278  $ 1,403 Current liabilities  $ 566  $ 613 Net fixed assets 5,057 6,120 Long-term debt 2,760 2,939     PARROTHEAD ENTERPRISE 2021 Income Statement Sales $ 15,874 Costs 7,243 Depreciation 1,435 Interest paid 436     a. What is owners' equity for 2020 and 2021?  b. What is the change in net working capital for 2021?  c-1. In 2021, Parrothead Enterprises purchased $2,640 in new fixed assets. How much in fixed assets did the company sell?  c-2. In 2021, Parrothead Enterprises purchased $2,640 in new fixed assets. What is the cash flow from assets for the year? The tax rate is 24 percent.  d-1. During 2021, Parrothead Enterprises raised $564 in new long-term debt. How much long-term debt must Parrothead Enterprises have paid off during the year?  d-2. During 2021, Parrothead Enterprises raised $564 in new…

Condensed financial data of Cheng Inc. follow. Cheng Inc. Comparative Balance Sheets December 31 Assets                                                                    2020                     2019 Cash                                                                    $     80,800        $ 48,400 Accounts receivable                                           92,800                  33,000 Inventory                                                             117,500         102,850 Prepaid expenses                                              28,400                  26,000 Investments                                                         143,000         114,000 Equipment                                                           270,000         242,500 Accumulated depreciation---                               (50,000)        (52,000)    equipment           Total                                                  $ 682,500         $ 514,750          Liabilities and Stockholders’ Equity…

CRUZ, INCORPORATED Comparative Balance Sheets 2021 At December 31 Assets 2020 Cash Accounts receivable, net Inventory Prepaid expenses Total current assets $ 75,900 32,600 68, 300 4,200 181,000 $ 18,900 40,100 75,300 3,500 137,800 Furniture Accumulated depreciation-Purniture ৪4, 600 (13,100) $ 252,500 99, 200 (7,500) $ 229,500 Total asseta Liabilities and Equity Accounts payable Wages payable Incone taxes payable Total current liabilities Notes payable (long-term) Total liabilities Equity Comnon stock, $5 par value Retained earnings $ 11,900 7,100 1,200 20,200 24,800 45,000 $ 16,900 4,000 2,200 23,100 58,400 81,500 177,300 30,200 $ 252,500 141,500 6,500 $ 229,500 Total liabilities and equity CRUZ, INCORPORATED Incone Statement For Year Ended Decenber 31, 2021 Sales $ 392,900 252,900 140,000 Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Incone before taxes Incone taxes expense 71,600 30, 200 36, 200 13,900 $ 24,300 Net income

General Accounting Question Solution Please

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…

Avery Corporation Balance Sheet For year ending December 31 2019 2020 2021 ssets Cash & securities 17,643.813 132,468.629 22,281.616 115,121.68 27,594.924 ccounts receivable 112,479.309 100,955.129 10,947.986 251,977.349 ventories 78,867.845 90,512.493 10,222.209 239,202.497 repaid expenses 10,426.653 otal current assets 238,342.442 Flant property and equipment Lcumulated depreciation let property plant and equipment 531,554.881 510,906.018 536,451.319 87,197.29 128,069.772 170,985.877 444,357.591 382,836.246 365,465.442 Other assets 10,222.209 15,639.98 16,421.979 otal Assets 693,782.297 636,818.669 633,864.769 iabilities & Shareholders'Equity ccounts payable ank Loan axes Payable ccrued expenses 54,080.808 31,297.644 27,599.965 45,191.687 112,482.797 26,066.634 15,639.98 37,773.252 150,798.301 27,369.965 26,577.744 139,556.161 32,843.958 248,785.476 otal current liabilities 199,381.098 ong term debt 95,000 55,000 30,000 Common stock 300,000 200,000 150,000 Eetained earnings Total…

What are the firm’s days’ sales outstanding for 2018 and 2019? Income Statements ($ in millions) Balance Sheets ($ in millions)   2018 2019 Assets 2018 2019 Sales Revenue $2,580 $2,865 Cash $70 $50 Less: Cost of goods sold $1,060 $1,500 Short-Term investments $35 $9 Less: Operating Expenses $105 $162 Accounts rec. 400 460 Less: Depreciation $85 $80 Inventory 490 556 Earnings before interest and taxes $1,330 $1,123 Total Current Assets $995 $1,075 Less: Interest paid $350 $380 Net fixed assets 1890 1,910 Taxable Income $980 $743       Less: Taxes (40%) $392 $297 Total assets $2,885 2,985 Net income $588 $446 Liabilities and Owner's Equity     Dividends (45%) $265 $201   2018 2019 Additions to Retained Earnings $323 $245 Accounts payable $240 $210   Accruals $20 $20   Notes payable 65 74   Total…

IKIBAN INC.Comparative Balance SheetsJune 30, 2019 and 2018   2019     2018     Assets                 Cash $ 105,700     $ 47,000     Accounts receivable, net   69,500       54,000     Inventory   66,800       91,000     Prepaid expenses   4,700       6,000     Total current assets   246,700       198,000     Equipment   127,000       118,000     Accum. depreciation—Equipment   (28,500 )     (10,500 )   Total assets $ 345,200     $ 305,500     Liabilities and Equity                 Accounts payable $ 28,000     $ 34,500     Wages payable   6,300       15,600     Income taxes payable   3,700       4,400     Total current liabilities   38,000       54,500     Notes payable (long term)   33,000       63,000     Total liabilities   71,000       117,500     Equity                 Common stock, $5 par value   226,000       163,000     Retained earnings   48,200       25,000     Total liabilities and equity $ 345,200     $ 305,500…

HIC GROUP OF Companies COMPARATIVE INCOME STATEMENT For years  ended 3rd December                                                                                                                               2019                                     2020       Revenue and gains Sales revenue                    495,500                                 496,738.75 Interest revenue                 278,500                                 279,196.25 Investment Income            71,700                                   71,879.25 Other revenue                   101,500                                 101,753.75 Total revenue and gains     947,200                                 949,968 Expenses and losses                                                            Cost of good sold              450,000                                 447,750 Selling&administrative      185,000                                 184,075 Computer (operating)        42,500                                   42,288…

Assets Current assets Net fixed assets INCOME STATEMENT, 2022 (Figures in $ millions) Revenue Cost of goods sold Depreciation Interest expense 2021 $ 101 2022 $ 195 910 1,010 $ 2,005 1,085 405 251 Req A and B Req C and D BALANCE SHEET AT END OF YEAR (Figures in $ millions) Liabilities and Shareholders' Equity Current liabilities Long-term debt Req E Complete this question by entering your answers in the tabs below. a&b. What is shareholders' equity in 2021 and 2022? c&d. What is net working capital in 2021 and 2022? e. What are taxes paid in 2022? Assume the firm pays taxes equal to 21% of taxable income. f. What is cash provided by operations during 2022? g.Net fixed assets increased from $910 million to $1,010 million during 2022. What must have been South Sea's gross investment in fixed assets during 2022? Answer is complete but not entirely correct. h. If South Sea reduced its outstanding accounts payable by $46 million during the year, what must have happened to its other current…

Taser Corporation’s recent comparative balance sheet and income statement follow.   Balance Sheets, December 31 2019 2020 Assets     Cash and cash equivalents $35,100 $57,420 Accounts receivable (net) 61,200 61,200 Merchandise inventory 140,400 153,000 Investments, long-term   18,000 Plant assets 303,300 324,900 Accumulated depreciation (79,200) (61,200) Total assets $460,800 $553,320 Liabilities and Stockholders’ Equity     Accounts payable $37,800 $34,200 Salaries payable 2,700 900 Income taxes payable 3,600 6,300 Bonds payable 180,000 180,000 Premium on bonds payable 7,200 6,660 Common stock, no-par 216,000 279,900 Retained earnings 13,500 45,360 Total liabilities andstockholders’ equity $460,800 $553,320 Income Statement,For Year Ended December 31 2020 Sales revenue $216,000 Cost of goods sold (86,400) Depreciation expense (10,800) Salaries expense (39,600) Income tax expense (18,000) Interest expense (12,600) Other…

Rodriquez Corporation’s comparative balance sheets are presented below: RODRIQUEZ CORPORATIONComparative Balance SheetsDecember 31     2020   2019 Cash   $16,500     $17,400   Accounts receivable   25,300     22,100   Investments   20,150     15,850   Equipment   59,950     69,850   Accumulated depreciation—equipment   (13,850 )   (10,300 )    Total   $108,050     $114,900                 Accounts payable   $14,850     $11,150   Bonds payable   10,600     30,100   Common stock   49,500     45,500   Retained earnings   33,100     28,150      Total   $108,050     $114,900   Additional information: 1.   Net income was $18,550. Dividends declared and paid were $13,600. 2.   Equipment which cost $9,900 and had accumulated depreciation of $1,600 was sold for $3,300. 3.   No noncash investing and financing activities occurred during 2020. Prepare a statement of cash flows for 2020 using the…

Forecast income statement - ALL FIGURES IN $ MILLION Financial year ending 31 March 2023 2024 2025 Revenue 165.0 180.0 210.0 Less: Operating expenses 120.0 128.0 145.0 Operating earnings before depreciation 45.0 52.0 65.0 Less: Depreciation 30.0 32.0 25.0 Earnings before interest and tax (EBIT) 15.0 20.0 40.0 Less: Interest expense 5.0 5.0 5.0 Earnings before tax 10.0 15.0 35.0 Less: Tax expense 2.8 4.2 9.8 Net profit (earnings) 7.2 10.8 25.2   In addition, you have collected the following information: Operating working capital (OWC) in each year will be 10% of revenue in that year Capital expenditure (capex) will be $25 million in each year The corporate tax rate is 28%.   What is Electrix's free cash flow to the firm (FCF) in year 2025? Thanks!

c. Calculate the profitability ratio which includes gross profit margin, operating profit margin, net profit margin, and NOPAT margin

MOSS COMPANY Selected Balance Sheet Information 2020 At December 31 Current assets Cash Accounts receivable. Inventory Current liabilities. Accounts payable Income taxes payable $ 84,650 25,000 60,000 Sales Cost of goods sold Gross profit 30,400 2,050 2019 $26,800 32,000 54,100 MOSS COMPANY Income Statement For Year Ended December 31, 2020 25,700 2,200 Operating expenses (excluding depreciation) Depreciation expense Income before taxes Income taxes expense Net income $ 515,000 331,600 183,400 121,500 36,000 25,900 7,700 $ 18,200 Use the information above to calculate cash flows from operating activities using the indirect method. Note: Amounts to be deducted should be indicated by a minus sign. Cash flows from operating activities: Adjustments to reconcile net income to net cash provided by operating activities

A companies financial statement show the following. Balance Sheet Information December 31, 2020 2020 $236,600 33,000 61,500 2019 $146,500 47,000 49,000 26,000 365,000 (200,000) Difference $90,100 (14,000) 12,500 (26,000) 90,000 (90,000) Cash Accounts receivable Merchandise inventory Long-term investment Machinery Accumulated depreciation, machinery 455,000 (290,000) Total assets $496,100 $433,500 $62,600 $65,600 66,000 200,000 164,500 Accounts payable Bonds payable $51,200 $14,400 66,000 200,000 182,300 Common shares Retained earnings (17,800) Total liabilities and shareholders' equity $496,100 $415,700 $62,600 Income Statement For the Year Ended December 31, 2020 Sales $982,000 Cost of goods sold Other expenses Depreciation expenses Profit from operations Loss on sale of long-term investment $703,000 135,000 90,000 928,000 $54,000 10,000 Profit $44,000 The following occurred during 2020: a. Purchased machinery for $90,000 cash. b. Sold the long-term investment for $16,000. c. Issued…

Balance Sheet for Bearcat Hathaway, 2022 2021 2022 Cash Accounts Receivable Inventory Current Assets Accum.Depreciation Net Fixed Assets Gross Fixed Assets $16,251,665 $20,567,330 Less $7,460,897 $10,117,819 Total Assets O 11.58% O 44.90% O 8.37% $5,268,485 $10,268,485 O 4.35% $2,574,230 $2,314,672 O 6.02% $529,062 $696,685 $8,371,777 $13,279,842 Total Liabilities and Equity What is the common size value for 2022 Notes Payable? $8,790,768 $10,449,511 $17,162,545 $23,729,353 Current Liabilities 2021 Accounts Payable Notes Payable $1,033,110 $1,987,233 2022 $1,673,992 $2,438,271 $2,707,102 $4,425,504 Long Term Debt $9,242,830 $11,468,302 Total Liabilities $11,949,932 $15,893,806 Common Stock ($0.50 par) $1,300,000 $1,600,000 Capital Surplus $1,148,120 $1,800,969 Retained $2,764,493 $4,434,578 Earnings $17,162,545 $23,729,353

Assets Current assets Cash Accounts receivable Inventory Total Total assets Sales Cost of goods sold Depreciation Taxable income Taxes (23%) Earnings before interest and taxes Interest paid Net income SMOLIRA GOLF CORPORATION 2021 Income Statement Dividends Retained earnings Fixed assets Net plant and equipment $465,700 $ 521,583 Total Cash, beginning of the year Operating activities 2020 $35,685 $39,032 28.936 43,152 $58,136 $111,120 Net cash from operating activities Investment activities SMOLIRA GOLF CORPORATION 2020 and 2021 Balance Sheets 2021 18,451 4,000 Cash, end of year Net cash from investment activities Financing activities Net cash from financing activities SMOLIRA GOLF CORPORATION Statement of Cash Flows For 2021 $ 523,836 $ 632,703 Total liabilities and owners' equity Liabilities and Owners' Equity Current liabilities $ 24,000 39,144 Accounts payable Notes payable Other Long-term debt Owners' equity Common stock and paid-in surplus Accumulated retained earnings Prepare…