solve the question on excel.

Pettijohn Inc. Balance Sheet (Millions of \$) 2017 2016 Assets Cash and securities Accounts receivable 244 390 Inventories 7,530 6,940 \begin{tabular}{lrr} \hline Total current assets & 10,980 & 9,570 \\ \hline Net plant and equipment & 18,754 & 16,900 \\ \hline Total assets & 17,990 & 18,230 \\ \hline \end{tabular} Liabilities and Equity Accounts payable 6,9906,850 Notes payable 5,3205,900 Accruals \begin{tabular}{lrr} \hline Total current liabilities & 16,430 & 16,650 \\ Long-term bonds & 10,920 & 10,920 \\ \hline Total debt & 27,350 & 27,570 \end{tabular} Commonstock3,3603,360 \begin{tabular}{lrr} Retained earnings & 6,034 & 4,200 \\ \hline Total common equity & 9,394 & 7,560 \\ \hline Total liabilities and equity & 36,744 & 35,130 \\ \hline \end{tabular} Income Statement (Millions of \$) 2017 Net sales 51,561 Operating costs except depr'n 47,252 Depreciation Earnings before interest and taxes (EBIT) 3,329 \begin{tabular}{lr} Less interest & 508 \\ \hline Earnings before taxes (EBT) & 2,821 \\ Taxes & 987 \\ \hline Net income & 1,834 \\ \hline \end{tabular} Other data: Shares outstanding (millions) 175.00 Common dividends (millions) 825.15 Interest rate on notes payable \& L-T bonds 6.25% Federal plus state income tax rate 0.35 Year-end stock price 55.00 Tax rate 35.00% WACC 10.00% \begin{tabular}{|l|l|l|l|} \hline 13 & What is the firm's debt ratio? & & 0.40 \\ \hline 14 & What is the firm's EPS? & & \\ \hline 15 & What is the firm's total assets turnover? & & \\ \hline 16 & What is the firm's dividends per share? & \\ \hline 17 & What is the firm's book value per share? & & \\ \hline 18 & What is the firm's current ratio? & 1.80 \\ \hline & & & \end{tabular}