I NEED HELP FIGURING OUT THE RATIOS FOR YEAR 2019 & 2020. PLEASE

KEY TRONIC CORPORATION AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In thousands) June 29, 2019 June 30, 2018 $ S 343 70,262 601 58,429 22,161 100,431 16,477 198,099 29,413 110,315 13,600 194,520 27,548 7,840 657 2.301 10,798 238,310 7.882 9,957 3,726 2,895 24,460 246,528 $ $ $ ASSETS Current assets: Cash and cash equivalents Trade receivables, net of allowance for doubtful accounts of $58 and $0 $0 Contract assets Inventories, net Other Total current assets Property, plant and equipment, net Other assets: Deferred income tax asset Goodwill Other intangible assets, net Other Total other assets Total assets LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Accounts payable Accrued compensation and vacation Current portion of debt, net Other Total current liabilities Long-term liabilities: Term loans Revolving loan Other long-term obligations Total long-term liabilities Total liabilities Commitments and contingencies (Note 4 and 9) Shareholders' equity: Common stock, no par valueshares authorized 25,000, issued and outstanding 10,760 and 10,760 shares, respectively Retained earnings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity See accompanying notes to consolidated financial statements. 73,571 6,759 5,841 7.233 93,404 76,198 8,105 5,841 8,769 98,913 7,091 23,356 12,932 16,222 380 30,447 123.851 29.534 128,447 46,680 65,353 2,426 114,459 238,310 46,244 72.806 (969) 118,081 246,528 $ 32 32 of 72 1/23/2021, 2:04 PM Document https://www.sec.gov/Archives/edgar/data/719733/000071973319000063/... KEY TRONIC CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (LOSS) (In thousands, except per share amounts) S June 29, 2019 464,044 429,443 S S Fiscal Year Ended June 30, 2018 446,322 412,153 34.169 6,186 34,601 July 1, 2017 467,797 429,497 38,300 6,393 22,363 6,555 21,556 22,334 12,448 Net sales Cost of sales Gross profit Research, development and engineering expenses Selling, general and administrative expenses Impairment of goodwill and intangibles Loss on settlement of arbitration Total operating expenses Operating income (loss) Interest expense, net Income (loss) before income taxes Income tax provision (benefit) Net income (less) Net income (loss) per share - Basic Weighted average shares outstanding - Basic Net income (loss) per share - Diluted Weighted average shares outstanding-Diluted 4.535 33,055 1.114 2,556 (1,442) (117) (1,325) 40.559 (5,958) 2,782 (8,740) (758) (7,982) (0.74) 10,760 (0.74) 10,760 28.756 9,544 2.288 7,256 1.639 $ $ $ 5,617 $ $ S (0.12) 10,760 (0.12) 10,760 0.52 10,756 0.51 10,917 $ S S See accompanying notes to consolidated financial statements, 33 Document https://www.sec.gov/Archives/edgar/data/719733/000071973319000063/... KEY TRONIC CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (LOSS) (In thousands) Fiscal Year Ended June 30, 2018 June 29, 2019 July 1, 2017 $ (7,982) s (1,325) S 5,617 Comprehensive income: Net income (loss) Other comprehensive income (loss): Unrealized gain on hedging instruments, net of tax Comprehensive income (loss) 2.392 3,395 (4,587) 4.798 10,415 1,067 Other comprehensive income (loss) for fiscal years 2019,2018, and 2017 is reflected net of tax provision of approximately $1.0 million, $0.7 million and $2.5 million, respectively. See accompanying notes to consolidated financial statements 34 Fiscal Year Ended June 10, 2018 June 29, 2019 July 1, 2017 S (7,982) S (1,325) $ 5,617 12,448 7,298 30 91 83 58 3 436 (1,116) 7,774 30 31 74 (84) 20 447 (1.562) (4,535) 7,232 17 496 68 (10) 101 692 (471) (12,559) (5,102) Operating activities: Net income (loss) Adjustments to reconcile net income (loss) to cash provided by operating activities: Goodwill and intangible assets impairment Depreciation and amortization Amortization of deferred loan costs Provision for obsolete inventory Provision for warranty D. Provision for (recovery of) doubtful accounts Loss on disposal of assets Share-based compensation expense Deferred income taxes Loss on settlement of arbitration Changes in operating assets and liabilities Trade receivables Contract assets Cash received from arbitration settlement Inventories Other assets Accounts payable Accrued compensation and vacation Other liabilities Cash provided by operating activities Investing activities: Purchases of property and equipment Proceeds from sale of fixed assets Cash receipts from deferred purchase price of factored receivables Cash provided by (used in) investing activities Financing activities: Payment of financing costs Proceeds from issuance of long term debt Repayments of long term debt Borrowings under revolving credit agreement Repayments of revolving credit agreement Tax withholding from exercise of share-based compensation Cash provided by used in) financing activities Net increase (decrease) in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period S Supplemental cash flow information: Interest payments $ Income tax payments, net of refunds S Se companying notes to consolidated financial statements 3,344 (10,255) 6,684 (1,417) (4,490) (2,627) (1,346) (323) 919 589 (9,249) 23,320 (1.900 2,051 3,122 4,920 (4,908) (5,889) 434 (913) 2,284 (8,386) 22 6,455 (1.909) (4,523) 1.041 8,335 4,853 (9,307) 834 7,141 (1,332) (15) (21) (5,871) 181.688 (174,554) (5.871) 187.419 (189,532) (221) 3,919 (5,435) 161,240 (160,978) (122) (1,597) (645) 1,018 373 1,248 258 143 (8,005) (30) 373 343 601 $ S 2.773 (511) $ $ 2.529 304 $ $ 2,238 1,799 Document https://www.sec.gov/Archives/edgar/data/719733/000071973319000063/... KEY TRONIC CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENT OF SHAREHOLDERS' EQUITY (In thousands) Common Stock Accumulated Other Comprehensive Income (Less) (7,573) Retained Earnings Shares 10,725 $ 45,227 $ $ $ 67,928 5,617 Total Shareholders Equity 105,582 5,617 4,798 4,798 49 (14) (122) 692 45,797 (122) 692 116,567 (1,325) 10,760 $ $ $ (2,775) $ Balances, July 2, 2016 Net income Unrealized gain on hedging instruments, net Exercise of stock appreciation rights Shares withheld for taxes Share-based compensation Balances, July 1, 2017 Net loss Tax rate effect reclassification Unrealized gain on hedging instruments, net Share-based compensation Balances, June 30, 2018 Net loss ASC 606 opening balance sheet adjustment Unrealized gain on hedging instruments, net Share-based compensation Balances, June 29, 2019 73.545 (1,325) 586 (586) 2,392 447 10,760 $ 46,244 $ $ (969) $ 72,806 (7,982) 529 2.392 447 118,081 (7,982) 529 3,395 436 114,459 3,395 436 10,760 $ 46,680 65.353 $ 2,426 $ See accompanying notes to consolidated financial statements, 36 On the balance sheet - Accounts Receivable is called "Trade-Receivables". The income statement is called the "consolidated statement of Income (loss)". "Cost of sales" is what we refer to as cost of goods sold. Earnings per share is called "Net Income Per Share". You can use the "Basic" version instead of the "Diluted Net Income per Share. (There is only 1 cent difference in the income statement for the year ending July 1, 2017. The other years are the same for basic and diluted) When computing the 2019 financial ratios that require an average value for the denominator, you will need the 2019 balance sheet amount and the 2018 balance sheet amounts. Only the 2020 and 2019 balance sheet amounts are shown on the balance sheet, so I appended the 2018 balance sheet to the assignment on page 3. The assignment has been uploaded to Moodle., It is in the assignments section and is called "Financial Analysis Project Spring 2021". Key Tronic Corporation Financial Ratios for Year Ended June 30, 2020 1.06 2019 2.12 0.63 7.21 Current Ratio Quick Ratio Accounts Receivables Turnover Average Collection Period Inventory Turnover Days' Sales in Inventory Debt to Equity Ratio Times Interest-Earned ratio Return on Sales Asset Turnover Return on Assets Return on Equity Earnings Per Share on Common Stock (Basic) Price Earnings Ratio Dividend Per Share of Common Stock Dividend Yield Market Price of Stock last day of fiscal year 1.29 2017 2.29 0.84 7.37 49.50 4.12 88.64 1.00 4.17 1.20% 2.00 2.4% 5.1% 2018 1.97 0.71 6.59 55.39 3.89 93.83 1.09 0.44 -0.30% 1.86 -0.6% -1.1% -0.12 -62.67 0 0.0% 7.52 Industry Average 2016 2015 2014 2.16 2.06 2.36 1.60 0.75 0.85 1.00 7.21 7.09 12.30 6.30 50.63 51.52 29.68 58.00 4.49 5.44 5.55 7.00 81.24 67.06 65.72 52.00 1.23 0.51 0.45 4.60 4.92 114.86 8.40 1.35% 0.99% 2.49% 6.00% 2.08 2.24 3.90 1.20 2.8% 2.2% 9.7% 7.20% 6.3% 4.2% 14.7% 11.60% 0.41 0.41 0.72 18.02 26.00 14.90 0 0 0.0% 0.0% 0.0% 7.39 10.66 10.73 0.52 13.42 0 0.0% 6.98 5.05 4.98