Landmark Solutions Worksheet 2021 T2 2021

TABLE 2.5 2009-2013 Financial Statement Data and Stock Price Data for Mydeco Corp. Mydeco Corp. 2009-2013 (All data as of fiscal year end; in S million) Income Statement Revenue 2013 604.1 2009 2010 2011 2012 404.3 363.8 424.6 510.7 Cost of Goods Sold Gross Profit Sales and Marketing Administration (1883) (173.8) (206.2) (293.4) (246.8) 263.9 (102.1) (66.4) 216.0 190.0 2184 310.7 (66.7) (60.6) (27.3) (66.4) (59.1) (82.8) (59.4) (34.3) (120.8) (78.5) (38.6) Depreciation & Amortization EBIT Interest Income (Expense) (27.0) 37.5 38.4) 57.0 61.4 41.9 72.8 (33.7) 27.7 (32.9) 4.6 32.2) 9.7 (37.4) 19.6 (39.4) 33.4 (11.7) Pretax Income Income Tax (9.7) 18.0 (1.6) 3.0 (3.4) 6.3 (6.9) 12.7 Net Income 21.7 Shares eatstanding (milliona) Earnings per share 55.0 $0.33 55.0 $0.05 55.0 $0.11 55.0 $0.23 55.0 $0.39 Balance Sheet 2009 2010 2011 2012 2013 Assets Cash 48.8 68.9 69.8 86.3 69.8 28.4 77.5 76.9 85.0 Accounts Receivable 88.6 86.1 Inventory Total Current Assets Net Property, Plant & Equip.…

Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales $ 442,035 $ 338,635 212,324 126, 311 $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 266, 105 150,400 175,930 62,769 39,783 102,552 73,378 13,648 $ 59,730 84,600 31,020 46,732 29,800 76,532 49,779 19,505 50,525 34,075 Income tax expense 10, 205 6,917 Net income $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets Current assets $ 55,578 $ 37, 199 $ 49,726 Long-term investments Plant assets, net 900 4,570 56,095 104,820 $ 160,398 95,143 Total assets $ 133, 242 $ 110,391 Liabilities and Equity Current liabilities $ 19,853 $ 23,418 68,000 8,500…

QUESTION 12 Annual data for ABC Corporation appear below, in millions of US dollars: 2016 2017 2018 2019 Sales Revenue 126.1 131.3 144.5 150.4 Cost of Goods Sold 45.3 50.8 54.6 55.3 Operating Income Ending Inventory 18.8 21.1 20.9 23.3 9.6 10.2 10.8 9.6 Ending Accounts Payable 10.2 8.8 9.5 10.2 Calculate ABC's inventory turnover ratio for 2017. Round your answer to 1 decimal place (xx.x).

Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales Cost of goods sold $ 402,346 $ 308,230 242,212 $ 213,900 194,493 136,896 Gross profit 160,134 113,737 77,004 Selling expenses 57,133 42,536 28,235 Administrative expenses 36,211 27,124 17,754 Total expenses 93,344 69,660 45,989 Income before taxes Income tax expense 66,790 44,077 31,015 12,423 9,036 6,296 Net income $ 54,367 $ 35,041 $ 24,719 KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Total assets Current liabilities Liabilities and Equity Common stock Other paid-in capital Retained earnings Total liabilities and equity $ 180,932 2021 $ 63,959 116,973 0 2020 $ 42,808 800 106,691 $ 180,932 $ 150,299 $…

Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements. For Years Ended December 31 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…

Problem 13-2A (Static) Ratios, common-size statements, and trend percents LO P1, P2, P3 Skip to question   [The following information applies to the questions displayed below.]Selected comparative financial statements of Korbin Company follow.  KORBIN COMPANY Comparative Income Statements For Years Ended December 31   2021 2020 2019 Sales $ 555,000 $ 340,000 $ 278,000 Cost of goods sold 283,500 212,500 153,900 Gross profit 271,500 127,500 124,100 Selling expenses 102,900 46,920 50,800 Administrative expenses 50,668 29,920 22,800 Total expenses 153,568 76,840 73,600 Income before taxes 117,932 50,660 50,500 Income tax expense 40,800 10,370 15,670 Net income $ 77,132 $ 40,290 $ 34,830   KORBIN COMPANY Comparative Balance Sheets December 31   2021 2020 2019 Assets       Current assets $ 52,390 $ 37,924 $ 51,748 Long-term investments 0 500 3,950 Plant assets, net 100,000 96,000 60,000 Total assets $ 152,390 $ 134,424 $ 115,698 Liabilities…

Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 Sales Cost of goods sold Accounts receivable. 2021 $ 706,675 363,004 34,274 2020 2019 $464,918 $ 371,9341 238,808 193, 136 27,058 25,477 2018 $ 260,094 133,898 15,268 2017 $ 194, 100 98,991 13,296 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.

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…

Required Information Problem 12-6B Use ratios to analyze risk and profitability (LO12-3, 12-4) (The following information applies to the questions displayed below.] Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC Incone Statements For the years ended December 31 2022 $12, see, eee 8, 150,eee 4,350,000 2021 Net sales Cost of goods sold Gross profit Expenses: Operating expenses bepreciation expense Interest expense Income tax expense Total expenses $11,0se,000 6,900,000 4,150,000 1,750,eee 200,000 55,000 58e,e00 2,585,000 $ 1,765,000 1,700,000 200, e00 55,000 500,000 2,455,e00 $ 1,695,000 Net incone THE ATHLETIC ATTIC Balance Sheets December 31 2022 2021 2020 Assets Current assets: Cash Accounts receivable Inventory Supplics Long term assets: Equipnent Less: Accumulated depreciation $ 240,000 1,005,000 1,740,000 145,800 170,000 755,000 1,370,000 115,000 234,000 775,00e 1,048,eee 90,000 1,700,000 (75e,00e) 1,700,000 (S5e,000)…

! Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2019 $ 279,900 179, 136 Sales Cost of goods sold $ 526,492 316,948 2020 $ 403,336 252,892 Gross profit 209,544 150,444 100,764 Selling expenses 74,762 55,660 36,947 Administrative expenses 47,384 35,494 23,232 Total expenses 122,146 91,154 60,179 Income before taxes 87,398 59,290 40,585 Income tax expense 16,256 12,155 8,239 Net income $ 71,142 $ 47,135 $ 32,346 KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Current liabilities Total assets Liabilities and Equity Common stock Other paid-in capital Retained earnings 8,750 66,994 2021 2020 $ 60,926 0 109,735 $ 40,778 1,000 99,989 $ 170,661 $ 141,767 $…

Required Information Problem 12-6B Use ratios to analyze risk and profitablity (LO12-3, 12-4) (The following information applies to the questions displayed below.] Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC Incore Statements For the years ended December 31 2022 $12,500,800 8,150,eee 4,350,000 2021 Not sales Cost of goods sold Gross profit Expenses: Operating cxpenses Depreciation expense Interest expense Income tax expense Total expenses $11,e5e,000 6,900,000 4,150,000 1,750,000 200,e00 55,000 588, 000 2,585,000 1,700,000 200,800 55,000 500,000 2,455,000 $ 1,695,00e Net income $ 1,765,000 THE ATHLETIC ATTIC Balance Sheets December 31 2022 2021 20z0 Assets Current assets: 0 Cash Accounts receivable Inventory Supplics Long term assets: Equipment Less: Accumulated depreciation 178,000 755,000 1,370,00e 115,000 234,000 775,000 1,040,eee 90,000 240,000 1,005,eee 1,740,000 145,000 1,700,000 (750,000) $4,080,000 1,700,e00 (550,000)…

Total Net Fixed Assets Total Assets O 14.97 siven, O 16.05 O 9.63 Cash Accounts Receivable Inventory Click to open: O 12.59 Net Sales Less: Cost of Goods Sold Less: Depriciation Earnings before Interest and Taxes O 10.12 Less: Interest Paid Taxable income Less: Taxes Net Income Precision Tools 2012 Income Statement ($ in Millions) What is the times interest earned ratio for 2012? 2011 2060 3411 18776 24247 14160 38407 LE 36408 28225 1760 6423 510 5913 2070 3843 Precision Tools 2011 and 2012 Balance Sheets ($ in Millions) 2012 1003 Accounts Payable 4218 Long Term Debt 21908 Common Stock 27129 Retained Earnings 14080 41209 Total Liabilities and Equity 2011 7250 9800 15000 6357 38407 2012 8384 11500 17500 3825 41209 97

sa

Description  FY10  FY11  FY12  FY13  FY14 Financial Statements  GBP m  GBP m  GBP m  GBP m  GBP m Income Statements           Revenue          4,390          3,624          3,717          8,167          11,366 Profit before interest & taxes (EBIT)             844             700             704             933            1,579 Net Interest Payable             (80)             (54)             (98)           (163)             (188) Taxation           (186)           (195)           (208)           (349)             (579) Miniorities             (94)             (99)           (105)           (125)             (167) Profit for the year             484             352             293             296                645 Balance Sheet           Fixed Assets          3,510          3,667          4,758       10,431          11,483…

20

ccounting Assume the following sales data for a company: 2026 $734000 2025 655500 2024 570000 If 2024 is the base year, what is the percentage increase in sales from 2024 to 2025? 129% 29% 115% 15%

Bhupatbhai

A. Devine and Vicky are partners dealing in cosmetics and other assorted goods. They share profit and losses in ratio 3:2. The trial balance below was extracted from the books of the partners as at 31“ December, 2020. DR CR Rent Expenses 400,000 Bank overdraft 100,000 Discount 50,000 100,000 Turnover 2,100,000 Cost of Sales 700,000 Receivable 400,000 Patent 400,000 Stocks (31/12/2019) 150,000 Loan from Devine at 15% per annum 200,000 Land 900,000 Motor vehicle 600,000 Equipment 400,000 Provision for depreciation:

What advice would you give to Juirgen PROBLEM 17-19 Incomplete Statements; Analysis of Ratios [LO2, LO3, L04] Incomplete financial statements for Tanner Company are given below: Tanner Company Income Statement For the Year Ended December 31 Revenue. $2,700,000 Cost of goods sold.. Gross margin. Selling and administrative expenses . . ? Net operating income Interest expense 45,000 Net income before taxes ? Income taxes, 40%. ? Net income 2$ ? Scanned by CamScanı Financial Staterment Analysis 923 Tanner Company Balance Sheet. December 31 Non-current Assets: Plant and equipment, net Current assets: Accounts receivable, net . . Inventory.. Cash and cash equivalents. Total current assets $ ? Total assets $ ? Equity: Common stock, $2.50 par value Retained earnings Total equity . . .. Bonds payable, 10% Current liabilities ? $250,000 Total liabilities. ? Total equity and liabilities $ ? The following additional information is available about the company: Selected financial ratios computed…

numbers 7, 8, 9 only

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:       20Y8     20Y7     20Y6     20Y5     20Y4 Net income $273,406   $367,976   $631,176   $884,000   $800,000   Interest expense 616,047   572,003   528,165   495,000   440,000   Income tax expense 31,749   53,560   106,720   160,000   200,000   Total assets (ending balance) 4,417,178   4,124,350   3,732,443   3,338,500   2,750,000   Total stockholders’ equity (ending balance) 3,706,557   3,433,152   3,065,176   2,434,000   1,550,000   Average total assets 4,270,764   3,928,396   3,535,472   3,044,250   2,475,000   Average total stockholders' equity 3,569,855   3,249,164   2,749,588   1,992,000   1,150,000   You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:     20Y4–20Y8 Return on total assets 28%…

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:       20Y8     20Y7     20Y6     20Y5     20Y4 Net income $273,406   $367,976   $631,176   $884,000   $800,000   Interest expense 616,047   572,003   528,165   495,000   440,000   Income tax expense 31,749   53,560   106,720   160,000   200,000   Total assets (ending balance) 4,417,178   4,124,350   3,732,443   3,338,500   2,750,000   Total stockholders’ equity (ending balance) 3,706,557   3,433,152   3,065,176   2,434,000   1,550,000   Average total assets 4,270,764   3,928,396   3,535,472   3,044,250   2,475,000   Average total stockholders' equity 3,569,855   3,249,164   2,749,588   1,992,000   1,150,000   You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:     20Y4–20Y8 Return on total assets 28%…

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:       20Y8     20Y7     20Y6     20Y5     20Y4 Net income $273,406   $367,976   $631,176   $884,000   $800,000   Interest expense 616,047   572,003   528,165   495,000   440,000   Income tax expense 31,749   53,560   106,720   160,000   200,000   Total assets (ending balance) 4,417,178   4,124,350   3,732,443   3,338,500   2,750,000   Total stockholders’ equity (ending balance) 3,706,557   3,433,152   3,065,176   2,434,000   1,550,000   Average total assets 4,270,764   3,928,396   3,535,472   3,044,250   2,475,000   Average total stockholders' equity 3,569,855   3,249,164   2,749,588   1,992,000   1,150,000   You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:     20Y4–20Y8 Return on total assets 28%…

A4

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Υ7 20Y6 20Υ5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders' equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Υ4-20Υ8 Return on total assets 28% Return on stockholders' equity 18% Times interest earned 2.7 Ratio of liabilities to stockholders' equity 0.4 Required: 1.…

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:                              20Y8           20Y7     20Y6     20Y5 20Y4 Net income $1,078,700   $929,900   $781,400   $667,900   $566,000 Interest expense 366,800   334,800   289,100     220,400      175,500 Income tax expense 345,184   260,372   218,792   173,654    135,840 Total assets (ending balance) 8,226,651   8,779,231   6,276,721   6,620,869   5,020,826 Total stockholders' equity (ending balance) 2,543,681   3,148,667   2,003,133   2,553,135   1,531,881 Average total assets 8,502,941   7,527,976   6,448,795   5,517,391   4,722,930   Average stockholders' equity 2,846,174   2,575,900   2,278,134   2,042,508   1,808,307 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:…

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:                              20Y8           20Y7     20Y6     20Y5 20Y4 Net income $1,078,700   $929,900   $781,400   $667,900   $566,000 Interest expense 366,800   334,800   289,100     220,400      175,500 Income tax expense 345,184   260,372   218,792   173,654    135,840 Total assets (ending balance) 8,226,651   8,779,231   6,276,721   6,620,869   5,020,826 Total stockholders' equity (ending balance) 2,543,681   3,148,667   2,003,133   2,553,135   1,531,881 Average total assets 8,502,941   7,527,976   6,448,795   5,517,391   4,722,930   Average stockholders' equity 2,846,174   2,575,900   2,278,134   2,042,508   1,808,307 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:…

Value Plus, Inc. was organized several years ago to develop and market computer software programs. The company is small but growing and you are considering the purchase of some of its ordinary shares as an investment. The following data on the company is available for the past two years:(Click the file for easy answering) Assignment 6.1.xlsx I Prepare the following financial statement analysis tool: 1. Horizontal Analysis 2. Vertical Analysis 3. Financial Ratio

what does the percentages mean in vertical analysis?       Year 4 % of Sales Year 3 % of Sales               Assets             Current Assets           Cash      $          40,000 6.67  $          36,000 6.67 Marketable Securities   20000 3.33 6000 1.11 Accounts Receivable   54000 9.00 46000 8.52 Inventories   135000 22.50 143000 26.48 Prepaid Items   25000 4.17 10000 1.85 Total Assets current   274000 45.67 241000 44.63 Investments   27000 4.50 20000 3.70 plant net     270000 45.00 255000 47.22 Land     29000 4.83 24000 4.44 Total Assets    $        600,000 100.00  $        540,000 100.00                             Liabilities and Stock equity         Liabilities            Current Liabilities           Notes payable    $          17,000 2.83  $            6,000 1.11 Accounts payable   113800 18.97 100000 18.52 salaries payable   21000 3.50 15000 2.78 Total current liabilities   151800 25.30 121000 22.41 Noncurrent liabilities…

ACC610

QUESTION 8 P18-5A P14.5A (LO 3) are presented here (in millions). Compute selected ratios, and compare liquidity, profitability, and solvency for two сотрanies. Suppose selected financial data of Target and Wal-Mart for 2020 Wal-Mart Target Corporation Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 L Wal-Mart Target Corporation Stores, Inc. Interest expense 707 2,065 Other income (expense) (94) (411) Income tax eхрense 1,384 7,139 $ 2,488 Balance Sheet Data (End of Year) Net income $ 14,335 Current assets $18,424 $ 48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current liabilities $11,327 $ 55,561 Long-term debt Total stockholders' equity 17,859 44,089 15,347 71,056 Total liabilities and stockholders' equity $44,533 $170,706 Beginning-of-Year Balances Total assets $44,106 $163,429 Total stockholders' equity 13,712 65,682 Current liabilities 10,512 55,390…

Sh22