2- Ratios - Complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8X). FAVORABLE Current Year (G) Prior Year (C) (UNFAVORABLE) Profitability Ratios Gross Margin (%) {Gross Income / Sales Revenue} Profit Margin (%) {Net Income / Sales Revenue} Return on Assets (%) {Net income / Average Total Assets}

Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,091,242 158,522 428,867 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…

Compute common-size percents for the following comparative income statements (round percents to one decimal). Using the common-size percents, which item is most responsible for the decline in net income?

i. Use the information available in Income and Financial position statementin Part A and calculate the following ratios for DavidCompetitors Average• Net profit margin 28%• Gross profit margin 65%• Current ratio 2.10x• Acid test ratio 1.50x• Accounts receivable collection period 47 days• Accounts payable payment period 65 days   Net Profit Margin = Net Income/ Sales = 350/2300 = 15.22% Gross Profit = Sales Revenue + Ending Inventory - Purchases less purchase returns  = 2300 + 250 - 1100 = 1450 Gross Profit Margin = Gross Profit/ Sales = 1450/2300 = 63.04% Current Ratio = Current Assets/ Current Liabilities Current Assets = Cash + Bank + Accounts Receivable + Inventory  = 4050 + 17100 + 400 + 250 = 21800 Current Liabilities = Accounts Payable = 700 Current Ratio = 21800/700 = 31.14:1     please answer this QUESTION :ii. Assuming David’s competitor’s ratio averages are as stated above:Analyse his performance with reference to each of the ratios calculatedin comparison to those of her…

Your Task… Using your assigned financial statements calculate the required ratios below Indicate if the change from year to year is favorable or unfavorable. All values should be accurate to at least two decimal places. The expectation is to submit a professional report free of grammar and spelling errors and easy to read. Think of this as a menu you would be handing to a customer.  All calculations are to be represented. Analysis of Profitability Gross Profit Ratio Operating Profit Ratio Net Profit Ratio Sales to Total Assets Ratio Return on Total Assets Return on Equity Earnings Per Share

2) Ratios  Based on the information given in picture #1, complete the following ratios for the last TWO  years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Liq./Solv. Ratios                          Current Yr.  Prior Yr.   Fav/Unfav. Current Ratio (X)  {Total. Current Assets/ Total Current Liabilities}   Quick Ratio (X) {Cash + Short term Investments + Current Receivables/ Current Liabilities}   Day's Sales Uncollected (days) {Total Accounts Receivables / Sales x 365}

Required: Compute the following ratios for 2020: 1. Current Ratio 2. Quick Ratio 3. Receivable Turnover 4. Average Collection Period 5. Inventory Turnover 6. Average Sales Period 7. Working Capital 8. Debt Ratio 9. Equity Ratio 10. Debt to Equity Ratio 11. Time Interest Earned 12. Gross Profit Ratio 13. Operating Profit Margin 14. Net Profit Margin 15. Return on Assets

Required: 1. Complete the following columns for each item in the comparative financial statements (Negative answers shoul be indicated by a minus sign. Round percentage answers to 2 decimal places, i.e., 0.1243 should be entered as 12.43.): Increase (Decrease) Year 2 over Year 1 Amount Percentage Statement of earnings: Sales revenue Cost of sales Gross margin Operating expenses and interest expense Earnings before income taxes Income tax expense Net earnings $ 45,770 38,650 7,120 4,020 3,100 1,050 $ 2,050 Statement of financial position: Cash (4,720) Accounts receivable (net) (4,220) Inventory 6,200 Property, plant, and equipment (net) 6,380 $ 3,640 Current liabilities (3,840) Long-term debt 3,530 Common shares 0 Retained earnings 3,950 $ 3,640

8

Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Previous Year Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Current Year $447,000 272,670 71,520 71,520 13,410 $384,000 215,040 69,120 57,600 15,360