For this part of the assignment browse through all worksheets before attempting the question. Using the Microsoft excel workbook assgt_mgmt1000_open_s1_22.xls complete the questions below to provide solutions for the directors and board members of DPH Group of Companies, regarding their financial reporting requirements:

Using the 2019 Quarterly Revenue worksheet provide the relevant formulas to complete the worksheet.

Using the Income Statement worksheet, center the financial statement titles across the data below and bold and italicize the company name.

Complete the formulas in cells provided for revenues* for 2020. 2020 revenues have Increased by 1/4% over 2019 values.

Complete the formulas in cells provided for expenses for 2020. 2020 expenses have decreased by 1/2% over 2019 values

. Using the correct function or formula calculate the total expenses and losses in the cells provided.

. Using all relevant cells calculate the income tax expenses for each year.

. Using the correct function or formula calculate the net income.