Using Excel, create a personal budget (you are welcome to use false information if you prefer not to share). This budget should include a year’s worth of information broken into 12 months.
This budget should include the following:
At least two different types of income.
Add the two types of income to show a total income.
At least 5 different expenses.
Add up all the different expenses to show a total expenses.
A row that shows your income minus your expenses.
A chart that summarizes all this information in an easy-to-read format.
Note: My example includes generic titles such as Income 1 and Income 2. Your submission should not use generic titles such as those.
The grade for this assignment will be calculated as follows:
Contains 12 months of information (do not copy the numbers I used in the example). (15%)
Contains at least 2 types of income. (10%)
Contains at least 5 types of expenses. (10%)
Contains at Total Income, Total Expenses, and a Net (Income – Expenses) row. (10%)
Totals are done using calculated fields. (20%)
All components of excel sheet are appropriately labeled. (10%)
Chart shows the totals and net for each month. (15%)
Chart is appropriately labeled. (10%)
The file is saved as an xlsx file (an Excel file).
See the attached image for an example.