Creating a spreadsheet, accounting homework help

You are a part- time assistant in the accounting department at Aficionado Guitar Parts,a Chicago-based supplier of custom guitar parts. You have been asked to use Excel tocreate formulas and functions in order to generate a report that summarizes themonthly accounts receivable balance (see below). A chart of the balances also isdesired