please answer all parts and 1

Search DYMO Label QuickBooks AutoSave OD R 2 ExcelTemplateAssignment CM 14 (1) Excel File Home Insert Page Layout Formulas Data Review View Help P18 1 X for 4 A 1 E14.1 Prepare horizontal analysis 2 Financial information for Kurzen Inc. is presented below. ESEF G Current assets Plant assets (net) Current liabilities Long-term liabilities Common Stock, $1 par Retained earnings December 31, 2017 December 31, 2016 $125,000 $100,000 396,000 330,000 191,000 70,000 133,000 95,000 161,000 115,000 150,000 11 12 Instructions 13 Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year. 14 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". KURZEN INC. Condensed Balance Sheets December 31 2017 2016 Increase or (Decrease) Amount Percentage NANN Assets Current assets Plant assets (net) Total assets Value Value Value Value Liabilities Current liabilities Long-term liabilities Total liabilities Value Value Value Value 2 32 Stockholders' Equity E14-1 E14-2 2143 P14-9 Ready Type here to search CoSave OD R O Excel TemplateAssignment Ch14 (1) Excel S earch Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks XV for Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". KURZEN INC. Condensed Balance Sheets December 31 2017 2016 Increase or (Decrease) Amount Percentage Value Assets Current assets Plant assets (net) Total assets Value Value Value 1 Liabilities Current liabilities Long-term liabilities Total liabilities Value Value Value Value 7 Value Stockholders' Equity Common stock, $1 par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity ? 11. Assume that Plant assets and long-term liabilities changed in 2017 to $415,000 and $152,000 respectively Show impact on the horizontal analysis for 2017 E14-1 E14-2 | P14-3 P14-9