Midterm 1 Practice Problems

Precision Tools 2021 Income Statement Net sales Less: Cost of goods sold Less: Depreciation Earnings before interest and taxes Less: Interest paid $36,408 28,225 1,760 6,423 510 5,913 Taxable Income Less: Taxes 2.070 $3.843 Net Income Precision Tools 2020 and 2021 Balance Sheets 2020 2021 2020 2021 $ Cash 2,060 1,003 Accounts 7,250 8,384 payable Accounts 3,411 4,218 receivable 21.908 27,129 Inventory 18,776 24,247 17,500 3.825 Common stock Retained earnings Total liability & 15,000 Net fixed assets 14,160 14.080 6.357 Total assets 38.407 41,209 38,407 41,209 equity What is the times interest earned ratio for 2021?

Sales Revenues Cost of goods sold Fixed costs 48 16 Selling, general, and administrative expenses 22 Depreciation EBIT |laxes| 19 pastor Profit illa ESINOPATI 7 *** Tax rate Dividends paid ASSETS Current Assets Lish Accounts receivable Inventories Total current assets Cross Fixed assets Accumulated depreciation Net Fixed assets Intangible assets TOTAL ASSETS 40% $10 Partial Balance Sheet 12 31 2019 $4 6 LIABILITIES Current Liabilities Accruals Accounts payable 5 Total current liabilities Long-term debt Total Liabilities 70 OWNERS EQUITY 10 Retained earnings Common stock 0 total owner's equity |IOTAL LIABILITES & OWNERS SQUITY These are surtulative reliános szarnings haut textsenck strapl, calkat nainsi sum ASSETS LIABILITIES Total current assets Gros Fned assets Accumulated depreciation Intangbleaxeets Meninis prade Toral current liabilities 105 Toral liabilities OWNERS EQ L

cash flow for 2021

Partial Income Statement Excel Exercise Compute the Following ՀԱՐ Sales COGS SG&A Depreciation Debt Int. Rate Tax Rate* 2019 100 40 EBITDA EBIT 25 Interest 10 EBT 0.08 Tax 0.25 Net Income ? ? ? ? ? ? Partial Balance Sheet Debt and Loans 150 Total Equity 150 Total Assets 300 Inv. Change 10 A/R Change A/P Change 35 20 Net Profit Margin Equity Multiplier Verify Dupont ROE ? סיי ? ? ? ? ? * Assume all taxes paid in current period (no accrued taxes) for rest of course CF from Operations ROE Asset Turnover CED Tt O 24

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

Given the following information: $8 million $10 million $7 million $3 million Average Inventory: $6 million Average A/R: Average Fixed Assets: Accounts Payables:$4 million Revenues: $2 million Liabilities: Total Expenses: Cost of Goods Sold: $10 million Assume no other assets or liabilities exist beyond what is articulated above. a. Compute Net Profit Margin b. Compute Total Asset Turnover c. Compute Return on Equity (ROE) d. Compute Inventory Turnover e. How much equity would have to be swapped out for debt to increase ROE by 1% assuming that nothing else changes? f. What is the firm's sustainable growth rate if dividends are equal to $0.5 million?

Net sales Windswept, Incorporated 2021 Income Statement Cost of goods sold Depreciation ($ in millions) Earnings before interest and taxes Interest paid Taxable income Taxes Net income $ 10,800 7,950 420 $ 2,430 100 $ 2,330 489 $ 1,841 Windswept, Incorporated 2020 and 2021 Balance Sheets ($ in millions) 2020 2021 2020 Cash $ 280 $ 310 Accounts payable $ 1,790 2021 $ 1,842 Accounts received 1,110 1,010 Long-term debt Inventory 2,000 1,745 Common stock 1,070 3,360 1,353 3,030 Total $ 3,390 $ 3,065 Retained earnings 650 900 Net fixed assets 3,480 4,060 Total assets $ 6,870 $ 7,125 Total liabilities & equity $ 6,870 $ 7,125 What is the equity multiplier for 2021?

2

swer questions Income Statement Items 2019 2016 (000'Rands) (000'Rands) Sales Depreciation and ammortisation Interest expense Operating expense Gross Profit Margin 000 480 40% %0% Tax rate 30% 30% 2019 2016 Balance Sheet (000'Rands) (000'Rands) Accounts Payable 1,500 Accounts Receivable Accumulated /Retained Profits to 00 to 00 Cash to 00 0o 00 to 00 to 00 0o 00 Inventory Long term loans Ordinary Shares Property, Plant and Equipment Short term loans to 00 0o 00 00 00

Net Income Interest (Loss) $ 185, 000 179, 600 157, 250 188, 100 Expense $ 59,200 80, 820 Income Taxes a. $ 46, 250 b. 64, 656 66,045 90, 288 C. 44, 030 11, 286 d. Compute times interest earned. Which company indicates the strongest ability to pay interest expense as it comes due? Complete this question by entering your answers In the tabs below. Times Interest Interest Earned Ratio Coverage Compute times interest earned. Times Interest Earned Ratio Company Choose Numerator: Choose Denominator: Ratio %3D %3D times times times !! times !! Interest Coverage >

Profit and Loss Account for the year ended 31st December 2021 (Figures are in £000) Particulars XYZ ABC Sales 3,690 4,586 Less: Cost of Goods Sold (Including purchases) (2,146) (2,690) Gross Profit 1,544 1,896 Less: Selling & Distribution Expenses     Less: Depreciation (1,103) (1,253) Earnings before Interest & Tax or Operating Profit 441 643 Less: Interest (225) (192) Earnings before Tax 216 451 Less: Taxes (86) (180) Earnings after Tax or Net Profit 130 271 Balance Sheet as at31st December 2021 (Figures are in £000) Assets XYZ ABC Fixed Assets 4,542 4,790 Current Assets     Account Receivables 274 313 Inventory 654 702 Cash 140 163 Total Current Assets 1,068 1,178 Total Assets 5,610 5,968 Liabilities   Capital 3,824 4,310 Long Term Debt 883 760 Current Liabilities     Account Payables…

LOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020   2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances   1,000   100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold   12,000   9,000 Gross profit $ 6,000 $ 5,900 Operating expenses:         Depreciation $ 700 $ 600 Selling and administrative   2,200   2,000 Research   550   500 Miscellaneous   360   300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense   560   500 Income before taxes $ 1,630 $ 2,000 Provision for taxes   640   800 Net income $ 990 $ 1,200     LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020   2020 2019 Assets         Current assets:         Cash $ 12,000 $ 9,000 Accounts receivable   16,500   12,500 Merchandise inventory   8,500   14,000 Prepaid expenses   24,000   10,000 Total current assets $ 61,000 $ 45,500 Plant and…

LOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020   2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances   1,000   100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold   12,000   9,000 Gross profit $ 6,000 $ 5,900 Operating expenses:         Depreciation $ 700 $ 600 Selling and administrative   2,200   2,000 Research   550   500 Miscellaneous   360   300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense   560   500 Income before taxes $ 1,630 $ 2,000 Provision for taxes   640   800 Net income $ 990 $ 1,200     LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020   2020 2019 Assets         Current assets:         Cash $ 12,000 $ 9,000 Accounts receivable   16,500   12,500 Merchandise inventory   8,500   14,000 Prepaid expenses   24,000   10,000 Total current assets $ 61,000 $ 45,500 Plant and…

Extract from Income Statement for the year ended 30 June 2020: R Sales 5 220 000 Cost of sales 3 600 000 Operating profit 1 295 000 Income tax 190 500 Net profit after tax 444 500 Extract from Balance Sheet on 30 June : 2020 2019 R Fixed assets (carrying value) 17 420 950 14 683 300 Fixed deposit: Ken Bank 250 000 380 000 Current assets 1 015 000 456 000 Inventories (only trading stock) 564 000 281 500 Trade and other receivables (debtors) 246 000 167 000 Cash and cash equivalents 205 000 7 500 Shareholders' equity 10 050 750 9 540 000 Ordinary share capital 10 000 000 9 180 000 Retained income 50 750 360 000 Loan: Barbie Bank 8 000 000 4 500 000 Current liabilities 635 200 1479 300 Trade and other payables 420 000 683 400 Shareholders for dividends 209 000 162 000 SARS: Income tax 6 200 23 400 Bank overdraft 610 500 Use the above information and calculate the following financial indicators were on 30 June: (Rounded off to 1 decimal) 2020 2019 Current ratio (A) (B) Acid-test ratio (C)…

Selected ratios formulars Unilever 2021 BOPP 2021 ROCE PBIT / net assets * 100 (32,424/39,406 *100 = - 82% 102,154 / 192,758 *100 =53% Net Assets Turnover Revenue / Net Assets 526,912 / 39,406 = 13 times 214,174 / 192,758 = 1 time Gross Profit Margin Gross profit / revenue *100 97,046 / 526,912 *100 18.4% 115,462 / 214,174 * 100 54% Net Profit Before Tax PBT / revenue * 100 (35,005) / 526,912* 100 = -6.6% 104,778 / 214,174* 100 =48.9% Current Ratio Current assets / current liabilities 214,665/341,171 = 0.5 139,104 / 30,368 = 4.5 Quick Ratio Current assets – inventory / current liabilities 214,665-91,627 /341,171 = 0.4 139,104 -13,248/ 30,368 = 4.1 Inventory Days Inventory / cost of sales * 365 days  91,627/ 429,866 *365 = 77 days 13,248 / 101,397 *365 = 47 days Receivable Days Receivables / cost of sales * 365 days 24,515 / 429,866 *365 =20 days 92,860 / 101,397 *365 =334 days Payable Days…

Help

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

Provide this question solution general accounting

Calculate:  (i) Return on capital employed(ii) Net profit margin(iii) Total Payable days

an

Find the Net Sales

Sales Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income tax Income tax expense Net income (a) 2021 $1,595 900 695 524 171 80 Your answer is incorrect. 91 25 $66 2020 $1,387 $1,208 743 644 411 233 50 183 2019 46 596 612 402 210 40 170 43 $137 $127 Using horizontal analysis, calculate the horizontal percentage of a base-year amount, assuming 2019 is the base year. (Round answers to 1 decimal place, e.g. 5.2%. Enter negative amounts using either a negative sign preceding the number e.g. -45.1% or parentheses e.g. (45.1) %.)

need formula for cost of goods sold CURRENT ASSETS     Cash and cash equivalents  $ 607,987  $ 480,626 Accounts receivable, net 104,500 80,545 Inventory 26,445 26,096 Prepaid expenses and other current assets 54,906 57,076 Income tax receivable 282,783 27,705 Investments 343,616 400,156 Total current assets 1,420,237 1,072,204 Leasehold improvements, property and equipment, net 1,584,311 1,458,690 Long term investments 102,328 0 Restricted cash 27,849 27,855 Operating lease assets 2,767,185 2,505,466 Other assets 59,047 18,450 Goodwill 21,939 21,939 Total assets 5,982,896 5,104,604 Current liabilities:     Accounts payable 121,990 115,816 Accrued payroll and benefits 203,054 126,600 Accrued liabilities 164,649 155,843 Unearned revenue 127,750 95,195 Current operating lease liabilities 204,756 173,139 Total current liabilities 822,199 666,593 Commitments and contingencies (Note 12)     Long-term operating lease liabilities 2,952,296…

How can i figure the problem out

MOSS COMPANY Selected Balance Sheet Information December 31, 2019 and 2018 2019 2018 Current assets $84,650 25, 000 60,000 Cash $26,800 32, е00 54, 100 Accounts receivable Inventory Current liabilities Accounts payable Income taxes payable 30,400 2,050 25,700 2,200 MOSS COMPANY Income Statement For Year Ended December 31, 2019 Sales $ 515,000 331,600 183,400 Cost of goods sold Gross profit Operating expenses Depreciation expense Other expenses Income before taxes $ 36,000 121,500 157,500 25,900 7,700 Income taxes expense Net income $ 18,200

17. Cost of goods sold Interest Dividends Depreciation Addition to retained earnings Tax rate $6,409 315 520 811 267 30% What is the operating income (EBIT) given the above information?

None