Business
blacjak
Assignment Instructions
For this exercise we are going to create a simple budget, and track our budget compliance over the course of a 12 month period. Although it is possible (and common) to track budget compliance on a month to month basis, to keep things simple for this exercise we are going to only examine the year end result.
Start by creating a budget in Excel in the following format.
For the starting budget $ amounts you use the following logic. Determine the yearly values and enter them into your budget. Don’t forget to add the totals, and to determine the amount you are short/extra.
Salary = $4,000 a month
Rent = $1200 a month
Car payment = $650 a month
Phone = $95 a month
Health Insurance = $250 a month
Food = $500 a month
We are now going to add the following data for the monthly amounts in out spreadsheet
Salary: Your starting salary for the year is $4,000 a month. In June you get a 3% pay increase.
Additionally you get a one-time bonus payout of $500 in October.
Rent: Your monthly rent per your lease is $1,200 a month, with a 5% increase in November.
Car: Your car is under lease at a rate of $650 a month.
Phone: Your month rate for your phone is $95 a month, but you incurred overage charges of $25 each in the months of April, August, and December.
Health Insurance: Your monthly installments for health insurance are $250 a month.
Food: Food expense tends to be more varied than the other expenses be captured. Use the follow table to enter your food expenses.
Other: In the month of March you have a car repair bill of $750 and in August you took a $125 flight to visit your parents.
- 5 years ago
- 48
Purchase the answer to view it
- BUDGET1.xlsx
- Week5BudgetAssignment1.docx
- Need help now
- the physical effect of a gene pair is called it's A - homologue B - appearance C-phenotype D-genotype
- Explain how a clothes dryer works in speeding up evaporation (3 reasons or ways)
- classify each pair of angles shown in the figure. <2 and <4
- mizzy wakes up at 7:00 a.m.each moring .shes spends 1/10 hour her bed 1/5 hour earing breafast and 1/2 hour...
- log(8)(x+1)=2-log (1/8)(x)
- Linear Programming and logical thinking
- Steps to patient care flow
- What step is more important when drawing conclusions?
- do you think kanyes actions or claras actions were most inspiring?