Please help with formatting the sheets required in $1-4$ based on the given info and the blank ratios page.

Download the MS$-$Excel file posted in this module. Using the balance sheet and income statement information provided, prepare and analyze the following $($using the tabs provided in the Excel file$)$:

$(1)$ Common Sized $($Vertical$)$ Balance Sheet and Income Statement

$(2)$ Year$-$over$-$Year $($Horizontal$)$ Balance Sheet and Income Statement

$(3)$ Indexed $($Horizontal$)$ Balance Sheet and Income Statement $($using the earliest year presented as the "base period"$)$

$(4)$ Calculate the specified Ratios for each year $($remember to include the ROA $[$NI $/$ Assets$]$ and ROE $[$NI $/$ Total Equity$])$

Make sure you use Excel cell references for all calculations. Upload your completed Excel file here upon completion $($due date specified in Moodle$).$

$\backslash$table$[[,,{2020}_{?},{2021}_{?},2022],[$Sales$,2,316,834,1,413,581,1,572,134$