Question: Create a spreadsheet in Microsoft Excel using the following information: Create a financial spreadsheet illustrating a budget for the year. Your spreadsheet should be populated
Create a spreadsheet in Microsoft Excel using the following information: Create a financial spreadsheet illustrating a budget for the year. Your spreadsheet should be populated with formulas where applicable, as well as text formatting and colour to add to the ease of understanding the information on the document. Your spreadsheet should have a title, include all the given information and answer the questions included below. You are creating a 12-month budget for Gurpreet (beginning in January 2022)**. Gurpreet wants to find out if there will be any money left at the end of the year. Gurpreets regular monthly income is $3000. Fixed monthly expenses are: Rent ($750) Car payment ($475) Insurance ($128) 2 For the first six months of the year, Gurpreet plans to make the minimum payment required, as noted on the credit card statement ($120). Gurpreet managed to secure a part time job over the summer that pays an extra $900/month. It begins in May and ends in August. In July, Gurpreet will put the entire amount from the extra summer job income from June, in addition to the regular payment. For the last five months, the credit card payments are lowered by $35. Gurpreet plans to spend less on utilities through the summer months. For those four months, the cost should be $45. For the rest of the year, $60. Gurpreet will save money on food while working the extra job in the summer. During those months, food costs will be $60 less than the rest of the year, which is $150 per month. Each month, Gurpreet will allot $135 for entertainment and another $100 for cell phone costs. In November and December, entertainment costs rise to $185. Gurpreet plans to spend a little more money on clothes in between seasons. In these four months, $275 will be budgeted, for the other months, $125. Gurpreet plans to put 3% of her gross paycheque into a savings account each month. While Gurpreet works the second job, gas costs will be more. A reasonable estimate for those months is $120. For the rest of the year, $80. There are a few miscellaneous expenses Gurpreet is planning for and should be included in the budget. A passport renewal is due in March at a cost of $100. There is a class Gurpreet wants to take in September. The cost is $275. A subscription comes due in February ($80) Gurpreets birthday is in May which means a license plate sticker renewal ($125).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
