de Center Conditional Format Cell Cele Form 543 Chaar - C 1 Financial information for Truman, Inc. is presented below P Operasi data fortunan, ne is presentes em December 31, 2017 December 31, 2016 Current assets 5150,000 $125.000 Plantsuse 387.000 320 000 Currentibus 94,000 72.000 Long-term labios 136.000 97.000 Common Stock $1 par 163.000 118.000 Retained earnings 144.000 107.000 10 11 Instructions 12 Prepare a schedule showing a horontal analysis for 2017 using 2016 abase year. Netsalet Costeloods sold Seligenses Adminive expenses Income tax expense 2017 $775.000 450.000 103.000 58.000 36.000 25 000 365.000 64.000 62.000 27.000 Instructions Prepare a schedule showing a vertical analysis for 2017 and 2016 Truman, Inc. Condensed Balance Sheets December 31 Page 1 Page 2 page 3 2017 2016 Andant Assets Current asse Plantasses into Total asset Cell Reference Croce Formula Cell Reference Cell Reference Formula Formula Formula Formula Form Formu Formula Truman, the Condensed Income Statements For the Year Ended De 2017 Amount Cell Reference Formula Call Reference Fom Fomula Call Reference Formula Call Reference Fom Formula For Formula Formula Cance Formula Formula Formula Net Sales Cost of goods sold Gross Pro Selling expenses Administrative expenses Total operating expenses home before income Income pense Net income 23 Amunt Percent Cell Reference Cell Reference For Formu Fomu Cell Reference Fom Celine tanca Fora For Formula Fom Cell Perences Forma Trom 25 Formula Liabis Current liabilis Long-term abilities Total liabides Cell Reference Centralarence Formu Call Reference Call Reference Formula Formula Formula Formula 28 29 30 31 22 Call Reference Cell Reference Stockholders Common stock, 1 par Retained eaming Total stockholders equity Total and stockholders Fom Fomu Formula Formula From Formule Formula Formula 35 96