1- K Statistics (OMIT ALL ZEROS 000): if none, leave blank Income Statement Prior Year 623 M UD!|!!W=W Increase(Decrease) + £WZ8 Current Year 2651M % 325.81%. Sales/Revenue 926 m Il5 m 705.22%. Cost of Goods Sold 1725M 507M n$1218 239.571. Gross Income Net Income End of End of Increase (Decrease) Balance Sheet Current Year Prior Year 4295 m 9 04m +$339I 375.|11%. Cash & Short-term investments Total Accounts Receivable 295M 120m +$175 145.837. Invehtories 1,OSI M 360s 343.01%. 126m rý122 96.83% Total Current Assets wa soh Net Property, Plant & Equipment 24 8m Intangible Assets 35 M NIA Total Assets 5,298m 129 0m t$4008 310.701. +f7 334 m r926 277.25'1. 456m nf 98I 215.13%. 834m $3027 362.951. Accounts Payable 3507. Total Current Liabilities 126 0m 1437m Total Liabilities Total Shareholders' Equity 3861m sset Composition: End of Current Year argest Assets: (from above) can t short rerm nresrment tutal accounts receivable et property, % of Total Assets 4,295 81.07. 295 S.577. 248 Plahr't equip ment 4.68 7.

Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash Marketable securities Accounts and notes receivable (net) Inventories Prepaid expenses Total current assets Current liabilities: Accounts and notes payable (short-term) Accrued liabilities Total current liabilities a. Determine for each year (1) the working Current Year 1. Working capital 2. Current ratio 3. Quick ratio b. The liquidity of Nilo has current assets relative to current liabilities. $690,500 799,500 327,000 1,042,800 537,200. $3,397,000 $458,200 $579,600 652,100 217,300 673,400 430,600 $2,553,000 $483,000 331,800 207,000 $790,000 $690,000 capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Previous Year from the preceding year to the current year. The working capital, current ratio, and quick ratio have all . Most of these changes are the result of an in

Vertical Analysis of Balance Sheet Balance sheet data for a company for the years ended December 31, 20Y2 and 20Y1, are shown below. 20Y2 20Υ1 Current assets $ 752,000 $ 602,000 Property, plant, and equipment 6,248,000 5,397,000 Intangible assets 1,000,000 1,001,000 Current liabilities 504,000 427,000 Long-term liabilities 1,504,000 1,197,000 Common stock 1,248,000 1,253,000 Retained earnings 4,744,000 4,123,000 | Prepare a comparative balance sheet for 20Y2 and 20Y1, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. Round your answers to one decimal place. Comparative Balance Sheet December 31, 20Y2 and 20Y1 20Y2 Amount 20Y2 Percent 20Y1 Amount 20Y1 Percent Assets Current assets $752,000 % $602,000 % Property, plant, and equipment 6,248,000 5,397,000 Intangible assets 1,000,000 1,001,000

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) Profitability Ratios                          Current Yr.  Prior Yr.   Fav/Unfav. Gross Margin (%) {Gross Income/Sales Revenue}   Profit Margin (%) {Net income/ Sales Revenue}   Return on Assets (%) {Net Income/ Average Total Assets}