I need help with this spreadsheet

H G 1 Rainbird Car Wash Company had the following current assets and current liabilities at the end of two recent years: 2 Compute a horizontal analysis on the selected accounts: 3 4 5 6 Cash and cash equivalents 7 Short-term investments, at cost 8 Accounts and notes receivable, net 9 Inventories 10 Prepaid expenses and other current assets 11 Short-term obligations 12 Accounts payable 13 Current Year (in millions) % Change $3,931 2,792 8,877 1,755 585 Previous Year (in millions) $4,041 7,504 7,697 2,341 866 3,314 7,376 312 7,488 14 15 16 a. Determine the (1) current ratio and (2) quick ratio for both years. Round to one decimal place. 17 Current Year Previous Year 18 1. Current ratio 19 2. Quick ratio 20 21 22 23 Inventory Analysis Rainbird and Menards compete with each other in selling car care products. Selected financial information for both companies from recent financial statements follows (in millions): Rainbird Menards Sales $56,940 $120,357 Cost of goods sold 44,754 92,385 Inventory, beginning of period 1,382 6,317 Inventory, end of period 1,404 7,490 a. Determine for both companies (1) the inventory turnover and (2) the number of days' sales in inventory. Round your calculations and answers to one decimal place. Assume 365 days a year. Rainbird Menards 1. Inventory turnover 2. Number of days' sales in inventory days days Solvency/Profitability The balance sheet for Rainbird Car Wash Company at the end of the current fiscal year indicated the following: Bonds payable, 8% $5,000,000 Preferred $4 stock, $50 par 2,500,000 Common stock, $10 par 5,000,000 Income before income tax expense was $3,000,000, and income taxes were $1,200,000 for the current year. Cash dividends paid on common stock during the current year totaled $1,200,000. The common stock was selling for $32 per share at the end of th Determine each of the following. Round to one decimal place, except for dollar amounts which should be rounded to the nearest whole cent. Use the rounded answers for subsequent requirements, if required. a. Earnings per share on common stock b. Price-earnings ratio c. Dividends per share of common stock