Question: please provide excel spreadsheet Income Statement Exercise: Prepare both consolidated income statement and common-size income statement for JACOB for years 2018 through 2021 based on


Income Statement Exercise: Prepare both consolidated income statement and common-size income statement for JACOB for years 2018 through 2021 based on the following scrambled information. Use the format provided on the following page. (All figures in millions except the tax rate) Earnings per share (EPS) = Net Income/Common Shares Outstanding Dividends per share (DPS) = Common Dividends/Common Shares Outstanding 3.26PM Wed Aug 24 Kack File Details FIN 120(40)-Prin of Finance Income Statement Spreadsheet Example ASSIGNMENT # NAME: LAB TIME: JACOB CORPORATION INCOME STATEMENT 20182021 Sales Cost Of Goods Sold Gross Profits Selling \& Administrative Expenses Depreciation Other Operating Expenses Total Operating Expense Eamings Before Interest \& Taxes (EB Operating Profits Interest Expense Earnings Before Taxes (EBT) Taxes @40% Net lncome Common Dividends Addition to Retained Earnings Common Shares Outstanding Eamings Per Share (EPS) Dividends Per Share (DPS) \begin{tabular}{cccc} formula & formula & formula & formula \\ # & # & # & # \\ \hline formula & formula & formula & formula \\ formula & formula & formula & formula \\ formula & formula & formula & formula \\ \hline \end{tabular} \begin{tabular}{cccc} # & # & # & # \\ \hline formula formula & formula & formula \\ \hline \end{tabular} 4 Previous Notifieations Inbex JACOB CORPORATION COMMON-SIZE INCOME STATEMENT 2018-2021
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
