$[$Questions $1-2]$ The following are financial statement items for Lowell Inc

Use the above data and create Lowell$$s income statement and balance

sheet for $2021$ and $2020.$ Each financial statement should be

presented on the worksheets $$Q$1\_$IS$$ and $$Q$1\_$BS$,$ respectively.

Make the statements concise by displaying the numbers in thousands

$($you can $1)$ divide the numbers by $1,000$ or $2)$ right$-$click the cell and

choose format cell $$ custom $-$ #$,$##$0\mathrm{.}00,).$

Based on the income statements created in Questions $1,$ create a

forecasted income statement on the worksheet $$Q$2\_$Pro$-$forma IS$$ for

$2022.$ Assume that:

$1)$ Each income statement item remains in the same proportion as in

$2021.$

$2)$ The forecasted sales for $2022$ are $$9,000,000.$

$3)$ Fixed expenses and interest expense will not change for $2022.$

$4)$ Changes in depreciation expenses are proportional to changes in

sales for $2022.$

$5)$ The tax rate and the number of shares outstanding for $2022$ are

the same as those in $2021.$