What are excel formulas to solve them? Need details for each

1 NOTES & ASSUMPTIONS 2 The tax rate is 40% 3 Cash dividend of $2,600k declared & paid 4 Part of the long-term debt was retired on Dec 31 :. Interest is based on previous year balance 5 LT Interest Rate 5% 6 Additional short-term debt was taken on Dec 31 :. Interest is based on previous year balance 7 ST Interest Rate 10% 8 During the year, $700k of common stock was issued in exchange for PP&E 9 No PP&E was sold during the year 10 11 12 13 14 Strawman Corporation Income Statement For year ended 12/31/... 15 ALL FIGURES IN $000s 2016 16 Revenue 17 COGS (Cost of Goods Sold) 18 Gross profit 19 SG&A (Selling, General & Administrative) 20 Operating income 21 Other revenues & gains 22 Gain on sale of investments 23 EBIT (Earnings before interest and taxes) 24 Interest expense, net 25 Earnings before taxes 26 Income tax expense 27 Net income 29 30 31 2333 33 34 Cash 35 Receivables 36 Inventory Strawman Corporation Balance Sheet As of 12/31/... ALL FIGURES IN $000s 2017 $ 69,000.0 47,000.0 9,300.0 800.0 950.0 NOTES from statement of cash flows 2016 $ 11,500.0 $ 2017 NOTES 13,000.0 20,500.0 17,500.0 17,500.0 37 Total current assets 38 PP&E, gross 39 Accumulated depreciation 40 Long-term investments (held-to-maturity) 41 Total Assets 42 232 43 17,000.0 19,000.0 (11,700.0) (12,000.0) 14,200.0 13,000.0