please show what you pluged in on xl

n

It says to perform a percentage change analysis to the folowing data.

If you do not understand the question, please tell me whats not to understand because it seems like these comments are just telling me you dont know what to do.

Clipboard Font Alignment 1107 fx B D E F 1 2/1/2011 3 Module 8. Student Ch08 P 8-15 Build a Model 4 5 6 (Thousands of Dollars) 7 8 Assets 2012 2011 9 Cash and cash equivalents $21,000 $20,000 10 Short-term investments 3,759 3,240 11 Accounts Receivable 52,500 48,000 12 Inventories 84.000 56,000 13 Total current assets $161,259 $127,240 14 Net fixed assets 218.400 $127.240 15 Total assets $379,659 $127.240 16 17 Liabilities and equity 18 Accounts payable $33,600 $32,000 19 Accruals 12,600 12,000 20 Notes payable 19.929 6.480 21 Total current liabilities 566,129 $50,480 22 Long-term debt 67 662 58,320 23 Total liabilities $133,791 $108,800 24 Common stock 183.793 178,440 25 Retained Earnings 62 075 40.000 26 Total common equity $245,868 $218.440 27 Total liabilities and equity $379,659 $327 240 28 29 Joshua & White Technologies December 31 Income Statements 30 (Thousands of Dollars) 31 2012 2011 32 Sales $420,000 $400,000 33 Expenses excluding depr. and amort. 327,600 320,000 34 EBITDA $92,400 35 Denreciation and Amortization $80,000 9 Build a Model 18 00 Sheet2 Sheet Ready File Home Insert Draw Page Layout Formulas Data Review View H Times New Roma 10 "A ' ' == Gen a Wrap Text ES E Merge & Center Paste BIU.aA $ $ Clipboard Font Alignment Kl 1107 fx F G B D 25 Retained Earnings 62,075 40,000 26 Total common equity $245,868 $218.440 27 Total liabilities and equity $379,659 $327.240 28 29 Joshua & White Technologies December 31 Income Statements 30 (Thousands of Dollars) 31 2012 2011 32 Sales $420,000 $400,000 33 Expenses excluding depr. and amort. 327,600 320,000 34 EBITDA $92,400 $80,000 35 Depreciation and Amortization 19.660 18,000 36 EBIT $72,740 $62,000 37 Interest Expense 5,740 4.460 38 EBT $67,000 $57,540 39 Taxes (40%) 26.800 23.016 40 Net Income $40,200 $34.524 41 42 Common dividends $18,125 $17,262 43 Addition to retained earnings $22,075 $17,262 44 45 Other Data 2012 2011 46 Year-end Stock Price $90.00 $96.00 47 # of shares (Thousands) 4,052 4,000 48 Lease payment (Thousands of Dollars) $20,000 49 Sinking fund payment (Thousands of Dollar $20,000 $0 $0 50 AutoSave 011 H = FIN 432 module 8 ss Search File Home Insert Draw Page Layout Formulas Data Review View Help X Times New Roma 10 ' ' General a Wrap Text Merge & Center Paste BIU OA $ Clipboard Font Alignment Nu 1107 fx A B D F 1 G 139 f. Perform a percent change analysis. What does this tell you about the change in profitability 140 and asset utilization? 141 142 Percent Change Balance Sheets Base 143 Assets 2012 2011 144 Cash and cash equivalents 145 Short-term investments 146 Accounts Receivable 147 Inventories 148 Total current assets 149 Net fixed assets 150 Total assets 151 152 Base 153 Liabilities and equity 2012 2011 154 Accounts payable 155 Accruals 156 Notes payable 157 Total current liabilities 158 Long-term debt 159 Total liabilities 160 Common stock 161 Retained Earnings 162 Total common equity 163 Total liabilities and equity 164 165 Base 166 Percent Change Income Statements 2012 2011 167 Sales 168 Expenses excluding depr. and amort 169 EBITDA 170 Depreciation and Amortization 171 EBIT 172 Interest Expense 173 FRT Build a Model Sheet2 Sheet AutoSave OM FIN 432 module 8 ss Search File Home Insert Draw Page Layout Formulas Data Review View Help General Times New Roma - 10 AA == BI U vrau A. Past Wrap Text Merge & Center $ % 8 Clipboard Font Alignment Number 1107 fx D E F G H 2012 Base 2011 B 157 Total current liabilities 158 Long-term debt 159 Total liabilities 160 Common stock 161 Retained Earnings 162 Total common equity 163 Total liabilities and equity 164 165 166 Percent Change Income Statements 167 Sales 168 Expenses excluding depr. and amort 169 EBITDA 170 Depreciation and Amortization 171 EBIT 172 Interest Expense 173 EBT 174 Taxes (40%) 175 Net Income 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 Build a Model Sheet2 Sheets Type here to search