5. Which of the following is the correct formula for cell B5 to calculate the earnings per share? a) -B2-B3*B2/B4 b) -(B2-B3)yB4 c) B2*(1-B3)/B4 d) -(B2+B3 B2)/B4 e) B2+B3)/B4 1 2 Earnings Before Taxes 3 Tax Rate 4 Shares Outstanding 5 Earnings per Share 2017 $520,ooO 3096 70,00O 2017 62,000 348,000 728,OOO 629,000 149,000 157,000 263,000 166,OO0 423,000 414,000 195,000 1 2 Cash 3 Accounts Receivable 4 Inventory 5 Plant & Equipment 6. What should be the formula in B13? a) -SUM(B2:B4)/(B7+B9) b) -SU(B2:B4)/SUM(B7:B9) c) -(B4-B4) (B6+B7+B8) d) -SUM(B2:B5)/(B6+B8+B9) e)(B+B2)/ B6+B7+B8) 6 Accumulated Depreciation 7 Accounts Payable 8 Notes Payable 9 Other Current Liabilities 10 Long-term Debt 11 Common Stock 12 Retained Earnings 13 Current Ratio 7. What is the correct formula for cell B7? a) -B3/(B2-B5) b) -(B2+B3+B5)/B4 c) (B2-B5)y/B4 d) -(B2-B3)/(B5-B4) e) -B4/(B2-B5) 1 2 Total Assets 3 Fixed Assets 4 Long-term Debt 5 Total Liabilities 6 Inventory 7 LTD to Equity Ratio 2017 750,000 450,000 315,000 600,000 118,000