Question: Please Help! For this deliverable, you will be creating a single Excel file containing 5 sheets that project your company's performance over the next year,
For this deliverable, you will be creating a single Excel file containing 5 sheets that project your company's performance over the next year, using the techniques we covered in mini-case 2. The file should meet the following requirements 1. It should be called as "D2 - yourBusiness Nome Income Expense Report". 2. It should contain 4 quarterly sheets and an annual sheet that contains the annual income expense report. 3. The income and expense categories should be appropriate to your business. You can use mini-case 2 as an example but you should remove the categories that do not apply to your business and add ones that do. Figures should vary between the quarterly sheets. The requirement is worth 2 points. 4. Add formulas to calculate the various totals on the quarterly sheets (e.g. Total Expenses, Taxes at 23%. Total Income, etc). The requirement is worth 2 points. 5. The annual figures should be based on the quarterly figures and should be calculated using the Excel SUM function. The requirement is worth 2 points. There are detalled instructions at Deliverable 2.5 Instructions - 1 Point, consultation of which will lesd to a loss of 1 point: 6. Your company logo should appear on each sheet and there should be a title for the report below the iogo. The title should be in bold and 14 pt size. The requirement is worth 2 points. 7. The text columns should be left aligned, while mumeric columns should be right alligned and formatted as currency columns. So, only the top cell and the total cells should have the currency symbol in front of them. The requirement is worth 2 points. There are detailed instructions at Deliverable 2.7 Instructions - 1 Point, consultation of which lead to a loss of 1 . point Once you have completed the assignment, submit the Excel file to the assignment bax below but keep a copy of the file as it will become part of the business portfolio at the end of the semester. For this deliverable, you will be creating a single Excel file containing 5 sheets that project your company's performance over the next year, using the techniques we covered in mini-case 2. The file should meet the following requirements 1. It should be called as "D2 - yourBusiness Nome Income Expense Report". 2. It should contain 4 quarterly sheets and an annual sheet that contains the annual income expense report. 3. The income and expense categories should be appropriate to your business. You can use mini-case 2 as an example but you should remove the categories that do not apply to your business and add ones that do. Figures should vary between the quarterly sheets. The requirement is worth 2 points. 4. Add formulas to calculate the various totals on the quarterly sheets (e.g. Total Expenses, Taxes at 23%. Total Income, etc). The requirement is worth 2 points. 5. The annual figures should be based on the quarterly figures and should be calculated using the Excel SUM function. The requirement is worth 2 points. There are detalled instructions at Deliverable 2.5 Instructions - 1 Point, consultation of which will lesd to a loss of 1 point: 6. Your company logo should appear on each sheet and there should be a title for the report below the iogo. The title should be in bold and 14 pt size. The requirement is worth 2 points. 7. The text columns should be left aligned, while mumeric columns should be right alligned and formatted as currency columns. So, only the top cell and the total cells should have the currency symbol in front of them. The requirement is worth 2 points. There are detailed instructions at Deliverable 2.7 Instructions - 1 Point, consultation of which lead to a loss of 1 . point Once you have completed the assignment, submit the Excel file to the assignment bax below but keep a copy of the file as it will become part of the business portfolio at the end of the semester
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
