Financial Statement Problem

I need help with the problem in the attacehd spreadsheet. All work needs to be shown under the answers section in the spreadsheet. Additional info pertaining to the question can be found in the PDF.