there are 2 parts, please provide answer in excel

Part 1: fill in the table for the 3 years of construction (calcate revenue and gross profit)

Part 2: make the necessary journal emtries for vadar for the YEAR 666

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 mililon Dollars. The stadium was completed in the yeary 668 . Informaiton related to the construction of the stadium is as follows: Vader recognizes revenue using the percentage of completion method PART 2: MAKE THE NECESSARY IOURNAL ENTRIES FOR VADAR FOR THE YEAR 666 For each of the following transactions, fill in the table showine its impact on the components of the financial statements 1) sold $4000 of merchandise on account 2) collected $600 of the receivables from n1 3) estimated bad debts to be 5% of credit sales 4) wrote off the $24 receivable of Batman 5) collected the $24 from Batman 6) What is the ending balance in accounts recelvable? 7) what is the endins balance in the allowance for bad debts (uncollectible accounts)? 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 million Dollars. The stadium was completed in the yeary 668 . Informsiton related to the construction of the stadium is as follows: Vadar recognizes revenue using the percentage of completion method REQUAED. Part 1: Fil in the table for the 3 vears of construction for Vadar revenue eross profit 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 million Dollars. The stadium was completed in the yeary 668 . Informsiton related to the construction of the stadium is as follows: Vadar recognizes revenue using the percentage of completion method REQUIRED. Part 1: FIl in the table for the 3 vears of construction for Vadar 666 667 668 revenue aross profit