E$9-1$a Revenue and expense data for Tribal Technologies Co$.$ are as follows: Prepare a properly structured $($row labels, sub$-$totals and total$)$ income statement in comparative form, stating each item for both $20$ Y $8$ and $20$ Y $7$ as a percent of sales $($referred to as a Common Sized Income Statement$).$ Round to one decimal place. The Income Statement and Common$-$Sized Analysis should be prepared in one tab of your excel file. The entire excel file used for this homework assignment should be uploaded to this question. E$9-3$a

Revenue and expense data for the current calendar year for Dawg Electronics Company and for the electronics industry are shown below. Dawg Electronics Company data are expressed in dollars. The electronics industry averages are expressed in percentages.

Prepare a common$-$sized income statement comparing the results of operations for Dawg Electronics Company with the industry average.

The analysis should be prepared in your excel file, using a tab labeled with the question number, and the file is uploaded only to question E$9-1$a$.$Dawg Electronics CompanyElectronifs Industry Average E$9-4$

Balance sheet data for a company for the years ended December $31,20$ Y $2$ and $20$Y$1,$ are shown below. Prepare a properly constructed $($row labels, sub$-$totals and totals$)$ comparative balance sheet for $20$ Y $2$ and $20$Y$1,$ stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. Round to one decimal place.

The analysis should be prepared in your excel file, using a tab labeled with the question number, and the file is uploaded only to question E$9-1$a$.$Property, plant, and equipment E$9-6$a

The following data were taken from the comparative balance sheet of Icon Living, Inc., for the years ended December $31,20$ Y $9$ and December $31,20$ Y $8.$

Determine for each year:

$-20$ Y $8$ working capital $($enter as a dollar amount$)$

$-20$ Y $9$ working capital $($enter as a dollar amount$)$

$-20$ Y $8$ current ratio $($enter amount with one decimal place$)$

$-20$Y$9$ current ratio $($enter amount with one decimal place$)$

$-20$ Y $8$ quick ratio $($enter amount with one decimal place$)$

$-20$ Y $9$ quick ratio $($enter amount with one decimal place$)$