there are 2 parts, please provide answer in excel spreadsheet !

In the Year 666 the Vadar Construction Company entered into a contract with the Township of Tatooine to build a Pod-Racing Stadium for 10 miflion Dollars. The stadium was completed in the yeary 668 . Informaiton related to the construction of the stadium is as follows: Vadis PAIT 2: MAKE THE NECESSAIY IOURNAL ENTHIFS FOA VADAR FOA THE YEAA 666 PART Z. MAKE IHE NECESSARY JOURNAL ENTRIES FOR VADAR FOR THE YEAR 666 For each of the following transactions, fill in the table showing its impact on the components of the financial statements 1) sold $4000 of merchandise on account 2) collected $600 of the recelvables from ti1 3) estimated bad debts to be 5% of credit sales 4) wrote off the $24 recelvable of Batman 5) collected the $24 from Batman 6) what is the ending balance in accounts receivable? 7) what is the ending balance in the allowance for bad debts (uncollectible accounts)