Horizontal and Vertical AnalysisP $14-$ A$*$

Please helppp!!!!

Requirements:Using the financial statements given $($on the next page$),$ for the Pepper Company, use an electronic spreadsheet to prepare the following:$1)$ A Balance Sheet using horizontal analysis $($see page $661$ in text$)\mathrm{.}2)$An Income Statement using horizontal analysis $($see page $662$ in text$).$A Balance Sheet using vertical analysis $($see page $664$ in text$)\mathrm{.}4)$ An Income Statement using vertical analysis $($see page $665$ in text$).$Note: Percentage should be displayed with one decimal place.Basic Financial RatiosP $14-$ BRequirements:Calculate the following financial ratios, for the Pepper Company, for both This Year and Last Year$\mathrm{.}1)$ Debt$-$to$-$equity ratio$\mathrm{.}2)$Return on total assets $($total assets at the beginning of Last Year were $$92,000)\mathrm{.}3)$Earnings per share$\mathrm{.}4)$Dividend yield ratio $($the market price per share of Common Stock was $$150$ at the end of This Year, and $$120,$ at the end of Last Year$)\mathrm{.}5)$ Price$-$earnings ratio$\mathrm{.}6)$ Working capital$\mathrm{.}7)$ Current ratio$\mathrm{.}8)$ Acid$-$test ratio$\mathrm{.}9)$Turnover of receivables with average collection period $($accounts receivable at the beginning of Last Year was $$8,000)\mathrm{.}10)$ Turnover of inventory with average sale period $($inventory at the beginning of Last Year was $$16,000)\mathrm{.}11)$ Number of days in operating cycle.