Excel Online Structured Activity: ROE and ROIC

Baker Industries' net income is $25000, its interest expense is $6000, and its tax rate is 35%. Its notes payable equals $24000, long $75000, and common equity equals $255000. The firm finances with only debt and common equity, so it has no preferred stock. The collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

What are the firm's ROE and ROIC? Round your answers to two decimal places. Do not round intermediate calculations.

ROE 9.80 %

ROIC ? %

Search (Option + Q) Formulas Data Review View Help fx 10 \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & C & D & E & F & G & H \\ \hline 1 & ROE and ROIC & & + & & x1 & . & & \\ \hline 2 & & & & & 1 & & & \\ \hline 3 & Net income & $25,000 & & 4 & & & & \\ \hline 4 & Interest expense & $6,000 & & & & . & = & \\ \hline 5 & Tax rate & 35.00% & & x2 & & & & \\ \hline 6 & Notes payable & $24,000 & & & & & & \\ \hline 7 & Long-term debt & $75,000 & & & & & & \\ \hline 8 & Common equity & $255,000 & & & +1 & & & \\ \hline 9 & & & & Formulas & & & & \\ \hline 10 & ROE & & & \#N/A & & & & \\ \hline 11 & & & & & & & & \\ \hline 12 & Partial Income Statement: & & & & & & & \\ \hline 13 & EBIT & & & #N/A & & & & \\ \hline 14 & Interest & $6,000.00 & & & & & & \\ \hline 15 & EBT & & & #N/A & & & & \\ \hline 16 & Taxes & & & \#N/A & & & & \\ \hline 17 & Net income & $25,000,00 & & & & & & \\ \hline 18 & & & & & & & & \\ \hline 19 & Capital Summary: & & & & & & & \\ \hline 20 & Notes payable & $24,000.00 & & & & + & & \\ \hline 21 & Long-term debt & $75,000.00 & & + & & & & \\ \hline 22 & Common equity & $255,000.00 & & & & & & \\ \hline 23 & Total invested capital & & & #N/A & & & & \\ \hline 24 & & & & & & & & \\ \hline 25 & ROIC & & & \#N/A & & & & \\ \hline 2627 & & & & & & & & \\ \hline 2728 & & & & & & & & \\ \hline 29 & & & & & & & & \\ \hline 30 & & & & & & & & \\ \hline 31 & & & & & & & & \\ \hline 32 & & & & & 2 & 3 & & \\ \hline 3334 & & & & & & & & \\ \hline \end{tabular}