purpose the purpose of this assignment is for students to demonstrate proficiency in microsoft excel by creating a spreadsheet that will be used to manage their own personal budget. please note that you do not have to include actual values for your income and expenses; you can make up values, but they should be realistic. before attempting to design the spreadsheet in microsoft excel, students should search the web for sample personal budgets to learn how they might be organized in a spreadsheet. we will not provide samples of what the finished product will look like. a main objective of this assignment is to demonstrate how to properly organize data in an excel spreadsheet. microsoft office help, online resources, and your instructors can help to provide proper guidance. content requirements the spreadsheet should contain, in a logical format, the following information. 1. the first part of the spreadsheet should show your income each month, for a 12-month period, that comes from all income sources. an example is below: income jan feb mar apr may june july aug sept oct nov dec interest $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 parental assistance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 2. you may add more rows. then in a new row at the bottom of your income information, include a row that will display the total income per month. follow the rubric for instructions. 3. in a new column on the right side of your income information, include a column that will display the total income per category. next create a second table below to show the following: 1. your estimated mandatory expenses each month, for a 12-month period. there should be some varying values, so you do not end up with all the same values for every month, in every category. mandatory expenses might include rent or house payments, grocery bills, utilities, and car payments, but not necessarily anything related to entertainment. an example is below: expenses jan feb mar apr may june july aug sept oct nov dec rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 car pymt. $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 utilities $60 $60 $60 $60 $60 $90 $90 $90 $90 $60 $60 $60 phone $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 groceries $50 $60 $45 $50 $65 $50 $45 $50 $85 $90 $100 $200 valencia college microsoft excel project professor hassanali 2 2. in a new row at the bottom of your expense information, include a row that displays the total expenses per month. to receive credit for this step, you must use an excel formula or function to calculate the total, which should automatically recalculate if the values in the cells are modified. 3. in a new column on the right side of you expense information, include a column that will display the total expense per category. the third area/table on your spreadsheet should consist of two rows: 1. the first row will show your 12-month period, the second row will later use a formula to calculate, for each month, how much extra money you will have, or how much money you are short. this is your net income after your mandatory expenses the fourth area/table to your excel spreadsheet, which will look like your area showing your mandatory expenses. this table shows the following optional expenses categories such as but is not limited to: 1. entertainment, 2. dining out 3. contributions to your savings and/or other investments. 4. there should be some varying values, so you do not end up with all the same values for every month, in every category. include a total row and total column, like what you did for your income and expenses.
