I need help with the problem in the screenshot below done in excel. Can someone please assist?

Instructions: Company V acquired a start-up (CoolCo) on 1/1/19. The date is now 4/1/19 and we need to produce the following documents: (1) a YTD19 PL for NewCo, through Mar19 (2) an ending balance sheet at 3/31/19 (3) subledger support for any balance sheet accounts at 3/31/19. Please show the monthly activity in these schedules. Materials: Below you will find a schedule of the 13 payments made on behalf of CoolCo in 2019. Assume this entity generates $2,000,000 revenue per month You should start with no opening balance sheet balances at 1/1/19. On 1/1/19 CoolCo received a $3,000,000 loan from a bank (assume 0.00% interest.) Notes: There's no right answer, feel free to make additional assumptions about anything not stated explicitly. Please make it a point to "show your work." We will want to review this in person next week. Accounting Period Posted to GL Vendor Name Service Period Payment Coded to Payment Amount Jan-19 Amazon Hosting Services 1/1/19-1/31/19 Hosting Expense (COSs) $425,000 Jan-19 Amazon Hosting Services 2/1/19-2/28/19 Hosting Expense (COSs) $450,000 Jan-19 Google Adwords Marketing 1/1/19-1/31/19 Marketing Expense $120,000 Jan-19 UPS Shipping 1/1/19 -1/31/19 Office Expense (OPEX) $1,000 Feb-19 Amazon Hosting Services 3/1/19-3/31/19 Hosting Expense (COSs) $500,000 Feb-19 Company Party Expense 2/1/19-2/28/19 Employee Morale Expense (OPEX) $50,000 Feb-19 Google Adwords Marketing 2/1/19-2/28/19 Marketing Expense $90,000 Feb-19 Looker (BI Tool) 1/1/9 - 12/31/19 Tehcnology Expense (OPEX) $144,000 Feb-19 Product Development Project Consultant 3/1/19-2/28/20 Consultant Expense (OPEX) $60,000 Mar-19 Amazon Hosting Services 4/1/19-4/30/19 Hosting Expense (COSs) $600,000 Mar-19 UPS Shipping 2/1/19-2/28/19 Office Expense (OPEX) $800 Apr-19 UPS Shipping 3/1/19-3/31/19 Office Expense (OPEX) $900 Mar-19 Dell Hardware Maintenance 12/1/18 -11/30/19 Hardware Maintenance Expense (OPEX) $240,000