Please answer the following on excel sheet.

1: Prepare an income statement for the year ended December 31.

2: Prepare a statement of owner's equity for the year ended December 31. No additional investments were made during the year.

3: Prepare a balance sheet as of December 31.

4: Based upon the end-of-period spreadsheet, journalize the closing entries.

5: Prepare a post-closing trial balance.

PR 4-1A Financial statements and closing entries Obj. 1, 2, 3 Beacon Signals Company maintains and repairs warning lights, such as those found on radio towers an lighthouses. Beacon Signals Company prepared the following end-of-period spreadshee at December 31, 2019, the end of the fiscal year