1. : You must use cell referencing for the input data. You must use Excel for all calculations. You will be graded on accuracy of your calculations, Excel use in calculations, formatting, and appearance. Be sure to remove grid lines.
   1. Financial Statements: Use the data sheet tab to create the following three statements.
      1. Income Statement for Year ended 2019. *See Table 2.1 in text for example. Proper form excludes row numbers and all text is in black. See rubric for details. Check figure for Earnings Available to Common = $29,363
      2. Statement of Retained Earnings for Year ended 2019. *See Table 2.2 in text for example.
      3. Balance Sheet as of December 31, 2019. *See Table 2.4 in text for example

Check figure for Total Assets = $336,523

2. Financial Ratios: Use the 2018 and 2019 financial statements to calculate the ratios specified on the Ratio Analysis tab.