Your boss has come to you for advice on the current finances of the company and needs you to create an extended DuPont analysis, common size analysis, and percentage change analysis. Your boss wants you to fill out the attached Excel file because he/she has no idea what she is talking about and is going to use your report as her work. . .

I need to finish filling out all empty yellow Squares, including question E and F. Please help. Thanks in advance!! . .

2 Joshua & White Technologies: December 31 Balance Sheets 3 Thousands of Dollars) 2016 21,000 3,759 52,500 Assets 6 Cash and cash equivalents Short-term investments 8 Accounts Receivable g Inventories 10 Total current assets 11 Net fixed assets 12 Total assets 2015 20,000 3,240 48,000 84000 56.000 $161,259 $127,240 218400 200,000 $379,659 $327 240 4 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current liabilities 19 Long-term debt 20 Total liabilities 21 Common stock 22 Retained Eamings 23 Total common equity 24 Total liabilities and equity 25 26 Joshua & White Technologies December 31 Income Statements 27 (Thousands of Dollars) 28 29 Sales 30 COGS except excluding depr. and amort.300,000 298,000 31 Depreciation and Amortization 32 Other operating expenses 33 EBIT 34 Interest Expense 35 EBT 36 Taxes (40%) 37 Net Incon 38 39 Common dividends 40 Addition to retained earnings $33,600$32.000 12,000 12,600 $66,129$50.480 6766258320 $133,791 $108,800 183,793 178.440 $245,868 $218,440 5379*659327,240 2016 2015 $420,000 $400,000 19,660 27,600 18,000 $72,740 $62.000 5,740 $67,000 $57,540 26,800 23,016 $40 200 $34524 $18,125 $17,262 $22,075 $17.262 42 Other Data 43 Year-end Stock Price 44 # of shares ( 1 housands) 45 Lease payment (Thousands of Dollars) 46 Sinking fund payment (Thousands of Do 2016 $90.00 4,052 2015 $96.00 4,000 0.000 $20,000 $5,000 $%2 $5,000