Data Window Help Excel File Edit View Insert Format Tools AutoSave OFF BESU Home Insert Draw Page Layout Formulas Data X Arial V 11 ' Review View Tell me Wrap Text v NIB Paste B I y Merge & Center E78 B C D F G 2019 Base 2018 164 Retained Earnings 165 Total common equity 166 Total liabilities and equity 167 168 169 Percent Change Income Statements 170 Sales 171 COGS except excluding depr. and amort. 172 Depreciation and Amortization 173 Other operating expenses 174 EBIT 175 interest Expense 176 EBT 177 Taxes (25%) 178 Net Income 179 180 181 162 183 184 185 186 187 188 189 190 191) 192 193 194 195 196 197 190 199 200 201 202 203 Build a Model Ready no 12 Arial A Wrap Text X ID ul Paste B I I Merge & Center A1 fx Build a Model G H F D B A 11/26/18 1 Build a Modhl 2 Chapter: 3 3 Problem: 15 4 5 Joshua & White Technologies: December 31 Balance Sheets 6 (Thousands of Dolars) 7 B Assets 2019 2018 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 55.000 13 Total current assets $161,259 $127,240 14 Netfaced assets 223.097 200.000 15 Total assets $384246 $327240 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 abilities $66,129 $50,480 22 Long-term debt 67,662 58.320 23 Total liabilities $133.791 $108.800 24 Common stock 178 440 178.400 25 Retained Earnings 724125 26 Total common equity $250.565 $218.440 27 Totallables and equity 3984356 $927240 28 29 Joshua & White Technologies December 31 Income Statements 30 (Thousands of Dolars) 31 2010 2018 32 Sales $420,000 $400.000 33 COGS except excluding dep and amort 300.000 298.000 34 Depreciation and Amortization 19.660 18.000 Build a Model MacBook esc Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial 12 ~ A == Wrap Text . Paste Av Merge & Cen A1 fx 'Build a Model A C D E H 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 223.007 200.000 15 Total assets $384.356 $327 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 $66,129 $50,480 22 Long-term debt 67.662 58.320 23 Total liabilities $133,791 $108,800 24 Common stock 178,440 178,440 25 Retained Earnings 72.125 40,000 26 Total common equity $250 565 $218.440 27 Total liabilities and equity $384256 $827 240 28 29 Joshua & White Technologies December 31 Income Statements 30 (Thousands of Dollars) 31 2019 2018 32 Sales $420,000 $400,000 33 COGS except excluding depr. and amort. 300,000 298,000 34 Depreciation and Amortization 19,660 18,000 35 Other operating expenses 27,600 22.000 36 EBIT $72,740 $62,000 37 Interest Expense 5.740 4.460 38 EBT $67,000 $57,540 39 Taxes (25%). 16.750 14385 40 Net Income $40.250 $34.524 41 42 Common dividends $18,125 $17,262 43 Addition to retained earnings $32,125 $17,262 45 Other Data 2019 2018 46 Year-end Stock Price $90.00 $96.00 47 # of shares (Thousands) 4,052 4,000 AA Amthousandro Del $20.00 $20.00 Build a Model ... 18 10
