Econ Excel Project $25

profileCT0752
PersonalbudgetSpring20231.xlsx
Home>Business & Finance homework help>Economics homework help>Econ Excel Project $25

Sheet1

SAMPLE MONTHLY BUDGET FOR ONE YEAR
Name:
Major:
Median Salary per year of your academic major at Coppin with a BA/BS degree: Info is in OI. $50,000.00
Ezeka, Hyacinth: Ezeka, Hyacinth:
Takehome pay per month $3,125.00
Income January February March April May June July August September October November December Total
Takehome pay per month Salary/Wages 1 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 37,500
Takehome pay per month Salary/Wages 2 0
Takehome pay per month Other 0
Total Income 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 37,500
Expenses:
Transportation:
Car payment 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Car Insurance 150 150 150 150 150 150 150 150 150 150 150 150 1,800
Fuel/Bus pass 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Others 0
subtotal 550 550 550 550 550 550 550 550 550 550 550 550 6,600
Home:
Mortgage/Rent 900 900 900 900 900 900 900 900 900 900 900 900 10,800
Groceries 350 350 350 350 350 350 350 350 350 350 350 350 4,200
Renters Insurance 25 25 25 25 25 25 25 25 25 25 25 25 300
Others 0
Sub.total 1,275 1,275 1,275 1,275 1,275 1,275 1,275 1,275 1,275 1,275 1,275 1,275 15,300
Utilities:
Phone-cell 80 80 80 80 80 80 80 80 80 80 80 80 960
Cable/internet 125 125 125 125 125 125 125 125 125 125 125 125 1,500
Gas/Electric 150 150 150 150 150 150 150 150 150 150 150 150 1,800
Other 0
Sub. Total 355 355 355 355 355 355 355 355 355 355 355 355 4,260
Health: 0
Health Insurance
Medical 0
Life Insurance 0
Sub. Total 0 0 0 0 0 0 0 0 0 0 0 0 0
Educational: 0
Tuition/Fees 0
Books 0
subtotal 0 0 0 0 0 0 0 0 0 0 0 0 0
Entertainment:
Movies 0
Dining out 50 50 50 50 50 50 50 50 50 50 50 50 600
Subtotal 50 50 50 50 50 50 50 50 50 50 50 50 600
Personal
Daycare 0
Tithes/offerings 417 417 417 417 417 417 417 417 417 417 417 417 5,000
Personal grooming 0
Vacations 0
Dry cleaning 0
Gifts (birhday, Christmas, etc) 0
Pocket money 100
tc={F41D9589-583A-4F49-92A1-B2FACE1850BE}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: SAMPLE
Ezeka, Hyacinth: Ezeka, Hyacinth: 		100 100 100 100 100 100 100 100 100 100 100 1,200
Clothing 50 50 50 50 100 300
Subtotal 567 517 517 567 517 517 567 517 517 567 517 617 6,500
Loans: 0
Student Loan pmt 0
Credit Cards pmts 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Subtotal 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Savings/Investments: 0
Retirement 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Emergency savings 50 50 50 50 50 50 50 50 50 50 50 50 600
Subtotal 250 250 250 250 250 250 250 250 250 250 250 250 3,000
Legal:
Child support 0
Attorney 0
Subtotal 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Expenses: 3,147 3,097 3,097 3,147 3,097 3,097 3,147 3,097 3,097 3,147 3,097 3,197 37,460
Excess Income/Expenses -22 28 28 -22 28 28 -22 28 28 -22 28 -72 40

Sheet2

Sheet3