Using the Project Two Financial Formulas Spreadsheet spreadsheet and the balance sheet, income statement, and cash flow statement from Mergent Online for your chosen company, calculate the financial ratios for the most recent fiscal quarter. Then, compare those ratios with the same ratios for the same fiscal quarter from one year prior in Mergent Online, and analyze your results. Specifically, you must address the following rubric criteria: Financial Calculations: Calculate accurate financial ratios to assess the business's current financial health. Specifically, calculate the following ratios: o Working capital o Current ratio o Debt ratio - Earnings per share o Price/earnings ratio o Total asset turnover ratio . Financial leverage o Net profit margin o Return on assets - Return on equity Fiscal Quarter Comparison: Using Mergent Online, summarize the differences between the results from your financial calculations of the most recent fiscal quarter and the results of the same financial calculations of the same fiscal quarter from a year before for your chosen business. . For example, if the most recent fiscal quarter available is the 3rd quarter in 2020, then you will compare those results to the same financial calculations from the 3rd quarter in 2019. Comparison Analysis: Explain what the results of your calculations and your comparison indicate about the business's current financial health, providing examples to support your explanation. You might consider the following questions: . Do the results indicate the business is financially healthy or financially unhealthy? Which results indicate this? o What might be the cause(s) of the business's financial success or failure? . Is more information needed to determine the business's financial health? If so, which pieces of information might still be needed? Short-Term Financing: Explain how potential short-term financing sources could help the business raise needed funds to improve its financial health. Base your response on the business's current financial information. Net Present Value (NPV) Calculator Building Initial Investment Year 1 2 3 4 4 5 6 7 8 9 10 Annual Cash Inflows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Cash Flows Year Discount Rate NPV = $O 11 12 13 14 15 16 17 18 19 20 Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Number of Years Salvage Value Equipment Initial Investment Year 1 2 3 4 5 6 7 8 9 10 $0 $0 $0 $0 $0 $0 $0 $0 $0 Annual Cash Inflows Discount Rate Cash Flows Year NPV = $0 11 12 13 14 $0 15 $0 16 17 18 19 20 Cash Flows $0) $0 $0) $0 $0 $0 $0 $0) $0 Number of Years Salvage Value Bonds Initial Investment Annual Cash Inflows Discount Rate Number of Years Principal Returned NPV = $0 Year 1 2 3 4 5 6 8 9 10 7 $0 Cash Flows $0 $ $0 2 $0 $0 $0 $0 $0 $0 $0 Standardized Quarterly Balance Sheet Report Date 10/02/2021 10/03/2020 4th Quarter 4th Quarter USD USD Not Qualified Not Qualified Yes Yes Thousands Thousands 15959000 17914000 15959000 17914000 13367000 12708000 1331000 1583000 3000000 33657000 70544000 37920000 32624000 3046000 35251000 67595000 35517000 32078000 Currency Audit Status Consolidated Scale Cash & Equivalents Cash & Equivs & ST Investments Receivables (ST) Inventories Assets Held for Sale (ST) Other Current Assets Total Current Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Assets Held for Sale (LT) Long Term Investments Intangible Assets Other Assets Total Assets Accounts Payable & Accrued Exps Accounts Payable Accrued Expenses Current Debt Other Current Liabilities Total Current Liabilities LT Debt & Leases Pensions & OPEB Deferred LT Liabilities Minority Interests Other Liabilities 3935000 95186000 38207000 203609000 20894000 17412000 3482000 5866000 4317000 31077000 48540000 4132000 7246000 13671000 10390000 3903000 96862000 33455000 201549000 16801000 13876000 2925000 5711000 4116000 26628000 52917000 6451000 7288000 13929000 10753000 Total Liabilities Common Share Capital Retained Earnings Accum Other Comprehensive Income Treasury Stock For Curr Trans (BS) Other Equity Total Equity Total Liabilities & Equity 115056000 55471000 40429000 -6440000 907000 -958000 958000 88553000 203609000 117966000 54497000 38315000 -8322000 907000 -949000 949000 83583000 201549000 Standardized Quarterly Income Statement Report Date Currency Audit Status Consolidated Scale Sales Revenue Total Revenue Direct Costs Gross Profit Selling General & Admin Depreciation & Amortization Restruct Remediation & Impair Other Operating Expense Total Indirect Operating Costs Operating Income Interest Income Other Non-Operating Income Total Non-Operating Income Earnings Before Tax Taxation Minority Interests 10/02/2021 10/03/2020 4th Quarter 4th Quarter USD USD Not Qualified Not Qualified Yes Yes Thousands Thousands 18534000 14707000 18534000 14707000 12341000 11013000 6193000 3694000 4319000 2812000 1275000 1335000 654000 5735000 0 0 6248000 9882000 -55000 -6188000 -317000 -496000 763000 5998000 446000 5502000 391000 -686000 34000 49000 96000 81000 Earnings Before Tax Taxation Minority Interests Equity Earnings Discontinued Operations Extraordinary Items Accounting Changes Net Income Preference Dividends & Similar Net Income to Common Average Shares Basic EPS Net Basic EPS Continuing Basic Average Shares Diluted EPS Net Diluted EPS Continuing Diluted Shares Outstanding 391000 34000 96000 -101000 -1000 0 0 159000 0 159000 1816000 0.09 0.08 1831000 0.09 0.09 1781000 -686000 49000 81000 106000 0 0 0 -710000 0 -710000 1811000 -0.39 -0.4 1811000 -0.39 -0.4 1781000 Standardized Quarterly Retained Earnings not available for this company at present. Standardized Quarterly Cumulative CF Report Date Yes 10/02/2021 10/03/2020 4th Quarter 4th Quarter USD USD Not Qualified Not Qualified Yes Thousands Thousands 2536000 -2442000 836000 10703000 2194000 -645000 5566000 7616000 -3578000 -4022000 Currency Audit Status Consolidated Scale Net Income (Cumu) Adjustments from Inc to Cash (Cumu) Change in Working Capital (Cumu) Cash Flow from Operations (Cumu) Purchase of Pty Plant & Equip (Cumu) # 5566000 -3578000 7616000 -4022000 407000 -3171000 -3699000 435000 -1121000 -4385000 30000 -1951000 17954000 16003000 5927000 -3578000 172000 -3850000 11233000 305000 -1587000 -1471000 8480000 38000 12499000 5455000 17954000 5345000 -4022000 103 Cash Flow from Operations (Cumu) 104 Purchase of Pty Plant & Equip (Cumu) 105 Change in Business Activities (Cumu) 106 Other Investing Cash Flows (Cumu) 107 Cash Flow from Investing (Cumu) 108 Change in LT Debt (Cumu) 109 Change in Equity (Cumu) 110 Payment of Dividends (Cumu) 111 Other Financing Cash Flows (Cumu) 112 Cash Flow from Financing (Cumu) 113 Effect of Exchange Rate (Cumu) 114 Change in Cash (Cumu) 115 Opening Cash (Cumu) 116 Closing Cash 117 Depn & Amorth (CF) (Cumu) 118 Net Purch of Pty Plant & Equip (Cumu) 119 120 Standardized Quarterly CS Balance Sheet 121 Report Date 122 123 Currency 124 Audit Status 125 Consolidated 126 Scale 127 Cash & Equivalents %TA 128 Cash & Equivs & ST Investments %TA 129 Receivables (ST) %TA 130 Inventories %TA 131 Assets Held for Sale (ST) %TA 132 Other Current Assets %TA 133 Total Current Assets %TA 134 Gross Property Plant & Equip %TA 135 Accumulated Depreciation %TA 10/02/2021 10/03/2020 4th Quarter 4th Quarter USD USD Not Qualified Not Qualified Yes Yes Thousands Thousands 7.838 8.888 7.838 8.888 6.565 6.305 0.654 0.785 1.473 16.530 34.647 18.624 1.511 17.490 33.538 17.622 16.023 15.916 136 Net Property Plant & Equip%TA 137 Assets Held for Sale (LT) %TA 138 LT Investments %TA 139 Intangible Assets %TA 140 Other Assets %TA 141 Total Assets as 100% 142 Accounts Payable & Accrued Exps %TA 143 Accounts Payable %TA 144 Accrued Expenses %TA 145 Current Debt %TA 146 Other Current Liabilities %TA 147 Total Current Liabilities %TA 148 LT Debt & Lease %TA 149 Pensions & OPEB %TA 150 Deferred LT Liabilities %TA 151 Minority Interests %TA 152 Other Liabilities %TA 153 Total Liabilities %TA 154 Common Share Capital %TA 155 Retained Earnings %TA 156 Accum Other Comprehens Income %TA 157 Other Equity %TA 158 Total Equity %TA 159 Total Liabilities & Equity %TA 160 161 Standardized Quarterly CS Income Statement 162 Report Date 163 164 Currency 165 Audit Status 166 Consolidated 167 Scale 168 Sales Revenue %TR 1.933 46.749 18.765 100 10.262 8.552 1.710 2.881 2.120 15.263 23.840 2.029 3.559 6.714 5.103 56.508 27.244 19.856 -3.163 0.471 43.492 100 1.937 48.059 16.599 100 8.336 6.885 1.451 2.834 2.042 13.212 26.255 3.201 3.616 6.911 5.335 58.530 27.039 19.010 -4.129 0.471 41.470 100 10/02/2021 10/03/2020 4th Quarter 4th Quarter USD USD Not Qualified Not Qualified Yes Yes Thousands Thousands 100 100 166 Consolidated 167 Scale 168 Sales Revenue %TR 169 Total Revenue (100% TR) 170 Direct Costs %TR 171 Gross Profit %TR 172 Selling General & Admin %TR 173 Depreciation & Amortization %TR 174 Restruct Remediation & Impair %TR 175 Other Operating Expense %TR 176 Total Indirect Operating costs %TR 177 Operating Income %TR 178 Interest Income %TR 179 Other Non-Operating Income %TR 180 Total Non-Operating Income %TR 181 Earnings Before Tax %TR 182 Taxation %TR 183 Minority Interests %TR 184 Equity Earnings %TR 185 Discontinued Operations %TR 186 Extraordinary Items %TR 187 Accounting Changes %TR 188 Net Income %TR 189 Preference Dividends & Similar %TR 190 Net Income to Common %TR 191 192 193 194 Yes Yes Thousands Thousands 100 100 100 100 66.586 74.883 33.414 25.117 23.303 19.120 6.879 9.077 3.529 38.995 0 0 33.711 67.192 -0.297 -42.075 -1.710 -3.373 4.117 40.783 2.406 37.411 2.110 -4.664 0.183 0.333 0.518 0.551 -0.545 0.721 -0.005 0 0 0 0 0 0.858 -4.828 0 0 0.858 -4.828