please help me nake a spreadsheet answering those questions

Use for Problems 14A and 14B Potato Company Bulunce Shee: Decamiber 31, 202x. Potato Company Income Statement For the year ended December 31, 202x Horizontal and Vertical Analysis P 14-A * Requirements: Using the financial statements given (on the next page), for the Potato Company, use an electronic spreadsheet to prepare the following: 1) A Balance Sheet using horizontal analysis (see page 661 in text). 2) An Income Statement using horizontal analysis (see page 662 in text). 3) A Balance Sheet using vertical analysls (see page 664 in text). 4) An Income Statement using vertical analysis (see page 665 in text). Note: Percentage should be displayed with one decimal place. Basic Financial Ratios P 14 - B Requirements: Calculate the following financial ratios, for the Potato Company, for both This Year and Last Year. 1) Debt-to-equity ratio. 2) Return on total assets (total assets at the beginning of Last Year were $88,000). 3) Eamings per share. 4) Dividend yield ratio (the market price per share of Common Stock was $90, at: the end of This Year, and $80, at the end of Last Year). 5) Price-earnings ratio. 6) Working capital. 7) Current ratio. 8) Acid-test ratio. 9) Turnover of recelvables with average collection period (accounts recelvable at the beginning of Last Year was $15,000 ). 10) Turnover of inventory with average sale period (inventory at the beginning of Last Year was $4,000 ). 11) Number of days in operating cycle