Blackwell-Life Budget Project

xlsx

School

Thomas Nelson Community College *

*We aren’t endorsed by this school

Course

154

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

28

Uploaded by ProfBookChimpanzee36

Report
Monthly Budget $2,793.17 Pie graph of expenses with percentages and Food $ 605.72 Clothing $ 126.19 Entertainment $ 285.31 Education $ 164.00 Transportation $ 267.03 Housing $1,341.62 Total Expenses $ 2,789.87 Monthly surplus amount $3.30 Income (Monthly net on Occupation tab) EXPENSES (linked to individual tabs) This Photo by Unknown Author is
d labels. Paragraph 1: What do your graphs and tables show y Where do you need to make changes? Was it hard t This project taught me that i spend too much money. pockets. I need to make changes on unneccessary spe eating out. It was a bit hard but not too bad to balanc Paragraph 2: What did you learn from this process o something from the real world? How accurate do yo your successes and struggles in doing this project. I loved this spreadsheet! I thought it was very helpful using this in the future. I think my budget is pretty acc formulas but i found it to be a bit of a stuggle to find w and deleting a sheet). s licensed under CC BY
you about your financial habits? to balance your budget? I have bigger ambitions than my ending habits, like shopiing and ce my budget. of creating a spreadsheet to model ou think this budget is? Discuss and easy to use. I will definitely be curate! It was easy figuring out the where everything was (hyperlink
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Weekly Grocery List Item Price Quantity Total Price coffee $10.48 1 $ 10.48 bagel $ 1.98 1 $ 1.98 cream cheese $ 2.86 1 $ 2.86 potatoes $ 0.99 5 $ 4.95 Chicken wrap $ 6.99 1 $ 6.99 ramen noodles $ 0.30 3 $ 0.90 bread $ 3.42 1 $ 3.42 cheese $ 2.22 1 $ 2.22 eggs $ 1.80 1 $ 1.80 peanut butter $ 2.18 1 $ 2.18 jelly $ 2.48 1 $ 2.48 canned tuna $ 0.96 5 $ 4.80 crackers $ 2.72 1 $ 2.72 chips $ 9.88 1 $ 9.88 granola bars $ 2.52 1 $ 2.52 popcorn $ 4.82 1 $ 4.82 mixed nuts $ 8.94 1 $ 8.94 yogurt $ 1.96 1 $ 1.96 grilled chicken salad $ 7.19 1 $ 7.19 pound cake slice $ 3.85 1 $ 3.85 pancake mix $ 1.98 1 $ 1.98 oats $ 3.98 1 $ 3.98 bacon $ 4.97 1 $ 4.97 coffee creamer $ 3.88 1 $ 3.88 mayo $ 3.34 1 $ 3.34 Subtotal $105.09
Sales Tax (2.5%) $2.63 Weekly Grocery Tota $107.72
Place Walmart Walmart Walmart Walmart Walmart Walmart Walmart Walmart Walmart Walmart Walmart Tota Walmart Walmart Walmart Walmart Walmart Walmart Walmart Kroger Walmart Walmart Walmart Walmart Walmart Walmart
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Eating-Out Cost (includin Item Price Chick fil a $ 9.35 Chinese food $ 8.99 Little Ceasars pizza $ 6.99 7/11 breakfast bite $ 1.99 Subto Sales Tax Weekly Eating Total Weekly Grocery Cost $ 107.72 Total Weekly Eating-Out Cost $ 43.71 al Weekly Food Cost (grocery & eating-o $ 151.43 Monthly Food Budget (weekly *52/12) $ 605.72 This Photo by Unknown Author is licensed under CC BY
ng tax and tip) Quantity Total PricePlace 1 $ 9.35 1 $ 8.99 1 $ 6.99 1 $ 1.99 otal $27.32 x (6%) $ 1.64 g-Out Cos $28.96
Additional Clothing For One Season (3 mo Item QuantityUnit Price Price Scrub Shirt/Pants 5 $ 23.99 $ 119.95 Crocs 3 $ 37.49 $ 187.45 Socks- 10 pair set 1 $ 9.95 $ 49.75 Subtotal $ 357.15 Sales Tax (6%) $ 21.43 othing total for one season ( or 3 month $ 378.58 $ 126.19 season/3)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
onths) At Your New Job Retailer's Website Picture of some clothes here. Highest priced item (use MAX function) Lowest priced item (use MIN function) 312432502244&hvpos=&hvnetw=g&hvrand=14336431008894355248&hvpone=&hvptwo=&hvqmt=&hvdev=c& om/p/bistro-work-clog/10075.html?cgid=nurse-shoes&cid=001 09748512671&hvpos=&hvnetw=g&hvrand=13748838504616178319&hvpone=&hvptwo=&hvqmt=&hvdev=c&
119.95 49.75 &hvdvcmdl=&hvlocint=&hvlocphy=9008582&hvtargid=pla-599998849164&th=1&psc=1 hvdvcmdl=&hvlocint=&hvlocphy=9008582&hvtargid=pla-569779926890&psc=1
Fun for a Month! (don't forget tv & in Monthly Cost Internet/Wifi $ 50.00 Netflix $ 15.49 Hulu $ 17.99 Eating out $ 100.00 Gym membership $ 24.99 Beach $ - Hiking $ - Library $ - Total $ 208.47 Cell Phone & Plan per Month Monthly Cost Cell Phone (if you don't have one) N/A Cell Plan (include taxes/fees) $ 76.84 Total Monthly Cost of Cell Phone & Pl $ 76.84 Monthly Entertainment Budg $ 285.31 (including "For Fun" and "Cell Phone")
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
If you share your tv/internet or cell plan expenses with others in your household, feel free to prorate it and enter the portion of the bill that you would pay.
Occupation Occupation Radiology Tech Yearly Salary (gross - before deducti $ 65,601.00 Monthly Salary (gross - before deduc $ 5,466.75 Don't forget to enter equations in all dark gray cells.
Taxes Yearly Gross Salary minus standard deduction of $12,550 $ 53,051.00 Yearly Federal Income Tax (use link to find tax brack $ 11,671.22 Monthly Federal Income Tax $ 972.60 Yearly Gross Salary minus standard deduction of $4500 $ 61,101.00 Yearly State Income Tax (use link to find tax bracket $ 3,513.31 Monthly State Income Tax $ 292.78 Yearly Social Security Tax (6.2% of gross salary) $ 4,067.26 Monthly Social Security Tax $ 338.94 Yearly Medicare Tax (1.45% of gross salary) $ 951.21 Monthly Medicare Tax $ 79.27 TOTAL YEARLY TAXES $ 26,143.00 TOTAL MONTHLY TAXES $ 2,178.58 Yearly Medical Insurance Cost $ 5,940.00 Monthly Medical Insurance Cost $ 495.00 Yearly Net Income (deduct taxes and medical $ 33,518.00 Monthly Net Income $ 2,793.17
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
View this video for he https://vccs.instructuremedia.com/embed/d7e5b408-6ed1-4b95-9 Also see the Chapter 3A/3E PowerPoint in Canvas for examples https://www.nerdwallet.com/article/taxes/federal-income-tax-brackets https://www.nerdwallet.com/article/taxes/virginia-state-tax
9d98-eb8d8e033d45
Education Details and Expenses Education needed (degree/major) Number of years to complete degree Where will you get your degree? Yearly Tuition Books & Other Supplies Overall Yearly Cost TOTAL EDUCATION COST (for all the years) Paying for Education The total education cost in B8 must be split among the follow Total amount paid-out-of-pocket Total amount of student loan Monthly Student Loan bill (online calculator - click link below) Scholarships/Financial Aid Grants (anything you don't pay back) https://smartasset.com/student-loans/student-loan-calculator#SeQTCwyO00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Special Training (if app Associate's Special Training Needed 2.5 Where you get this training Riverside Total cost of training $ 10,760.00 Loan amount (if needed) $ 1,610.00 Monthly Loan bill (use online calculator) $ 12,370.00 $ 30,925.00 wing 3 categories: $ 15,000.00 $ 200.00 $ 15,725.00 $ 164.00 Total monthly education cost (include initial degree loan and special tr If you don't pay for the training with a loan, how will you pay This project represents your budget 5 years from now, once you and have a new job or promotion. At that time, you would only make, so include those from your regular education and specia education cost. That said, some students would like to show th education payments in this budget. If you would like to do that by the total number of months that you will be in school.
plicable) N/A $ 164.00 raining loan) for it? u have finished your education y have student loan payments to al training in this Total monthly heir out-of-pocket monthly t, divide by out-of-pocket amount
Transportation - your own car Make Mazda Model 3 Year 2010 Cost (what is your current car worth right now) $ 3,425.00 Car Payment (if you have one, otherwise $0) $ - Monthly Maintenance Cost (new $25, 3-6yrs $50, $ 75.00 Monthly Insurance Cost $ 135.00 Annual Registration/Tax Fees (4.15% of car's wort $ 142.14 Monthly Registration/Tax Fees $ 11.84 Cost of Gas Miles to Work (one way) 30 Weekly Work Miles 120 Estimated Recreational Miles per Week 50 Total Miles per Week 170 Miles per Month (weekly *52/12) 680 Miles per Gallon for your car 45 Current Price of Gas (per Gallon) $ 2.99 Cost of Gas Each Month $ 45.18 (miles per month*price of gas/miles per gallon of the car) If you use your own maintenance costs, insurance costs, or registration/tax fees, just put a * in column C next to that category.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Monthly Transportation Budget ### (include car payment, maintenance, insurance, registration/tax fees, gasoline) Link to website for value of used Picture of a car like yours here. https://www.kbb.com/mazda/mazda3/201
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
) 10/s-grand-touring-hatchback-4d/?condition=good&extcolor=burgundy&intent=trade-in-sell&m
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
mileage=190415&modalview=false&offeroptions=true&options=6349993%7ctrue&pricetype=pri
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ivate-party&vehicleid=249069
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Housing Cost - Rentin Square Footage 1,089 Number o Total Rent Monthly Rent ### Number of People sharing the rent ex 2 Your share of the monthly rent $ 984.00 Total Yearly Rent ### ### Monthly utility costs ($0.14 per s $ 7.62 Yearly utility costs $ 91.48 Will you save Monthly a Yearly Am Total Save Total Monthly Housing Budge (include rent, utilities, down paym Does this see YESSSS, an with my m buy...
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ng of Years to Rent 5 t $59,497.38 Apartment Link: Picture of apartment h e for a house while renting Yes amount to save? $ 350.00 mount Saved for House $ 4,200.00 ed During Renting ### ### ment savings) https://www. em to be a lot of money? Why or why not? n insane amount of money. I'm living mom forever. It would be cheaper to
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
here. .zillow.com/apartments/hampton-va/lumen/BnkZH5/#unit-2064120274
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help