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$).$