hello can u do this quetion on Excel please

Using your knowledge of spreadsheet software, using formulas and functions where appropriate, make a spreadsheet for the following Band. You are the manager of a famous band. It is up to you to manage your band's income as well as account for its expenses. Create a budget for your band over two years: 2022 and 2023 - Your revenues every month should include at least 4 sources of income: ticket sales, concessions, clothing royalties and one or more that you think up. - Sports and Entertainment Taxes must be subtracted from your Gross Income ( 12% for income up to $20,000,000 and 15% for income over $20,000,000 ) Create 2 charts indicating where your money is being spent (expenses). - One will be for the year 2022 Expenses using a pie chart (in percentages). - One will be comparing the year 2022 Expenses and the year 2023 Expenses using a line graph (in dollars). Criteria: - Your income needs to add up to $110,000,000 for year 2022. - Your expenses are $75,000,000 for year 2022. You may divide the expenses the way you like but be realistic! - All expenses will go up 6\% for the year 2023. But your income will only go up 4% for the year 2023. - Revenue section should have a subtotal. - Expenses section should have a subtotal. - There should be a Gross Income, Taxes and Net Income displayed - Each yearly budget should have a separate column for each month. - You should have 3 work sheets labelled: "2022 Budget", "2023 Budget" and "Reports" (which will contain the 2 charts). - Using a function, determine the minimum and maximum monthly expenses. - Using a function, determine the average monthly income and expenses. - Under the year column, total up each items amount. Your spreadsheet might look something like this: 20 Using your knowledge of spreadsheet software, using formulas and functions where appropriate, make a spreadsheet for the following Band. You are the manager of a famous band. It is up to you to manage your band's income as well as account for its expenses. Create a budget for your band over two years: 2022 and 2023 - Your revenues every month should include at least 4 sources of income: ticket sales, concessions, clothing royalties and one or more that you think up. - Sports and Entertainment Taxes must be subtracted from your Gross Income ( 12% for income up to $20,000,000 and 15% for income over $20,000,000 ) Create 2 charts indicating where your money is being spent (expenses). - One will be for the year 2022 Expenses using a pie chart (in percentages). - One will be comparing the year 2022 Expenses and the year 2023 Expenses using a line graph (in dollars). Criteria: - Your income needs to add up to $110,000,000 for year 2022. - Your expenses are $75,000,000 for year 2022. You may divide the expenses the way you like but be realistic! - All expenses will go up 6\% for the year 2023. But your income will only go up 4% for the year 2023. - Revenue section should have a subtotal. - Expenses section should have a subtotal. - There should be a Gross Income, Taxes and Net Income displayed - Each yearly budget should have a separate column for each month. - You should have 3 work sheets labelled: "2022 Budget", "2023 Budget" and "Reports" (which will contain the 2 charts). - Using a function, determine the minimum and maximum monthly expenses. - Using a function, determine the average monthly income and expenses. - Under the year column, total up each items amount. Your spreadsheet might look something like this: 20