You interview with a financial services firm on Wall Street and you are offered a management training position which pays $40,000 annually. You eagerly accept the offer!
You find out from your prospective employer that you will be paid twice each month and that after taxes and deductions your biweekly paycheck will total $1241.59.
Your task at hand is to now find an apartment and budget how much your monthly expenditures will be. You also will need to budget in some money to start paying off your student loans.
Here are your monthly expenses:
Rent: $850.00
Utilities: $150.00
Food: $500.00
Transportation: $100.00
Personal Care: $250.00
Entertainment $200.00
Loans $200.00
Savings ??
Using formulas create a Budget Spreadsheet that will keep track of your monthly income and monthly expenses for one year. Then total all income and expenses. Determine how much you will be able to save in one year? Create a pie chart comparing the annual totals for all expenditures. Include data labels showing amount and percentage. Place the chart into a new worksheet.
Format the budget spreadsheet using your own discretion.
Rename the worksheet tab “budget”.
Attach the completed file to Week 4 assignments in blackboard. Please do not hit submit until you have attached all files for week 4!
2 answers
1 answer