Question

2. Using the trial balances data on the following page complete the following in Excel using two worksheets (Total 345 points): a. For worksheet 1: i. Enter the data as provided (36 pts) ii. Use the SUMO function to check your data entry, (12 pts) iii. Format the columns using appropriate formats ($ signs in first and last numbers in a column; numbers line up, commas for 000's, underlining of numbers only (not entire cell) before/after totals) (48 pts) b. For worksheet 2 you will be performing a financial statement analysis: i. Create a comparative Income Statement and Balance Sheet for the three years using formulas to refer to your original data in worksheet 1. 66 pts) Format the financial statements using appropriate formats. (40 pts) ii. Prepare a common sized income statement and balance sheet for the current year (Use the column to the left of the most recent income statement and balance sheet). (25 pts) iii. Prepare a trend analysis (use the columns immediately to the right of each year's financial statements) to show a year over year change and a year over year percentage change. (50 pts) Format appropriately. (50 pts)

I'm stuck on 2b(ii) and 2b(iii). Please do those in Excel and take screenshots.

Answer 1