Please do 5-6 in excel

Prepare a multiple-step income statement. Prepare a retained earnings statement. Prepare a report form of balance sheet, assuming that the current portion of the note payable is $16,000. Briefly explain how multiple-step and single-step income statements differ and how report-form and account-form balance sheets differ. Selected accounts and related amounts for Gloucester Co. for the fiscal year ended August 31, 2014, are presented in Problem 5-5A. Prepare a single-step income statement in the format shown in Exhibit 9. Prepare a retained earnings statement. Prepare an account form of balance sheet, assuming that the current portion of the note payable is $16,000. Prepare closing entries as of August 31, 2014. Selected transactions for Capers Company during October of the current year are listed in Problem 5-1A. Journalize the entries to record the transactions of Capers the periodic inventory system