A B C E F G Prepare horizontal analysis Financial information for KBC Inc. is presented below. December 31, 2017 December 31, 2016 Current assets $125,000 $100,000 396,000 330,000 Plant assets (net) Current liabilities Long-term liabilities 91,000 70,000 133,000 95,000 3 Common stock, $1 par 161,000 115,000 9 Retained earnings 136,000 150,000 10 11 Instructions 12 Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year. (Round percentages to one 13 decimal point. 14 NOTE: Enter a formula in cells requesting a value; also enter a formula in cells with a "?". 15 KBC INC. Condensed Balance Sheets December 31 Increase or (Decrease) Assets 2017 2016 Amount Percentage Current assets 125,000 100,000 ? ? Plant assets (net) Total assets 396,000 330,000 $521,000 $430,000 Liabilities Current liabilities Value Value Long-term liabilities Total liabilities Value Value ? ? Stockholders' equity Common stock, $1 par Value Value Retained earnings Value Value Total stockholders' equity 2 Total liabilities and stockholders' equity ? 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 2 ? ? ? ? ? ? ? ? ? H ? ? ? 2 ? ? ? 12 2 +1