Description
choose one template and fill it up
Unformatted Attachment Preview
Budget
% of Income Spent
Summary
Total Monthly Income
$3,750
Total Monthly Expenses
$2,058
Total Monthly Savings
% of income spent pie chart. The
percent value can be found in cell
below
$550
Cash Balance
$1,142
55%
Monthly Income
Item
Amount
Income Source 1
$2,500.00
Income Source 2
$1,000.00
Other
$250.00
Budget
Monthly Savings
Date
Amount
Date
$200.00
Date
$250.00
Date
$100.00
Page 2 of 3
Budget
Monthly Expenses
Item
Amount
Rent/mortgage
$800.00
Electric
$120.00
Gas
$50.00
Cell phone
$45.00
Groceries
$500.00
Car payment
$273.00
Credit cards
$120.00
Auto insurance
$50.00
Miscellaneous
$100.00
Page 3 of 3
Personal Monthly Budget
PROJECTED MONTHLY INCOME
ACTUAL MONTHLY INCOME
HOUSING
Income 1
$2,500
TOTAL PROJECTED EXPENSE
(Projected income minus expenses)
$2,060
Extra income
$500
TOTAL ACTUAL EXPENSE
(Actual income minus expenses)
$2,040
Total monthly income
$3,000
Income 1
$2,500
PROJECTED BALANCE
(Projected income minus expenses)
$940
Extra income
$500
ACTUAL BALANCE
(Actual income minus expenses)
$960
Total monthly income
$3,000
BALANCE DIFFERENCE (Actual minus projected)
$20
Total Expense Difference
Projected Cost
Actual Cost
Difference
$1,500
$1,400
$100
Video/DVD
Phone
$60
$100
-$40
Streaming
$0
Electricity
$50
$60
-$10
Movies
$0
Gas
$200
$180
$20
Concerts
$0
Water and sewer
$0
Sporting events
$0
Cable
$0
Live theater
$0
Waste removal
$0
Other
$0
Maintenance or repairs
$0
Other
$0
Supplies
$0
Other
Other
$0
Total
Mortgage or rent
Total
$1,810
$1,740
$70
Projected Cost
Actual Cost
Difference
ENTERTAINMENT
$20
LOANS
TRANSPORTATION
Projected Cost
Actual Cost
Difference
$0
$50
-$50
$0
$0
$50
-$50
Projected Cost
Actual Cost
Difference
Personal
$0
$0
Student
$0
Bus/taxi fare
$0
Credit card
$0
Insurance
$0
Credit card
$0
Licensing
$0
Credit card
$0
Fuel
$0
Other
Maintenance
$0
Total
Vehicle payment
$250
$250
Other
Total
INSURANCE
Projected Cost
$250
Actual Cost
$0
Difference
TAXES
$0
Actual Cost
Difference
$0
State
$0
$0
Local
Health
$0
Other
Life
$0
Total
Other
Projected Cost
Federal
$0
$0
$0
$0
$0
$0
Total
$0
Projected Cost
$0
Actual Cost
$0
Difference
SAVINGS OR INVESTMENTS
Actual Cost
Difference
$0
Investment account
$0
$0
Other
Dining out
$0
Total
Other
Projected Cost
Retirement account
Groceries
$0
$0
$0
$0
$0
Total
PETS
$0
$0
$250
Home
FOOD
$0
$0
$0
Projected Cost
$0
Actual Cost
$0
Difference
GIFTS AND DONATIONS
Projected Cost
Actual Cost
Difference
Charity 1
$0
Charity 2
$0
Food
$0
Charity 3
Medical
$0
Total
Grooming
$0
Toys
$0
LEGAL
Other
$0
Attorney
$0
$0
Alimony
$0
Payments on lien or judgment
$0
Total
PERSONAL CARE
$0
Projected Cost
$0
Actual Cost
Difference
$0
Hair/nails
$0
Clothing
$0
Dry cleaning
$0
Health club
$0
Organization dues or fees
$0
Total
$0
$0
$0
Projected Cost
$0
Actual Cost
$0
Total
$0
Difference
Other
Medical
Other
$0
$0
$0
$0
$0
$0
Monthly Budget Summary
MONTH
Under/Over: $928.00
Budget summary
Category
Total
Income
4.500,00
Housing
1.410,00
Utilities
73,00
Groceries
220,00
Insurance
180,00
Phone
104,00
Credit Cards
315,00
School
1.063,00
Savings
100,00
Entertainment
107,00
Other
0,00
Monthly Budget Summary
Income and expenses
Category
Description
Amount
Notes
Income
Pat’s Paycheck
School
School Registration
$225,00
Utilities
City Power & Light
$73,00
School
School supplies
$38,00
Groceries
Grocery Store
$40,00
Entertainment
Southridge Video
$7,00
Phone
The Phone Company
$24,00
Income
John’s Paycheck
$2.000,00
Housing
Woodgrove Bank
$1.000,00
Housing
Humongous Insurance
$210,00
Home insurance
School
School of Fine Art
$800,00
Tuition
Credit Cards
Woodgrove Bank
$75,00
Pat’s card
Savings
Woodgrove Bank
$100,00
Phone
Consolidated Messenger
$80,00
Income
Pat’s Paycheck
$1.250,00
Housing
Woodgrove Bank
$200,00
Property taxes
Insurance
Humongous Insurance
$180,00
Auto insurance
Groceries
Grocery Store
$180,00
Credit Cards
Woodgrove Bank
$240,00
Entertainment
Dinner & Movie
$100,00
$1.250,00
Page 2 of 2
Jesse’s cell phone
Mortgage
Pat’s cell phone
Jesse’s Card
MGMT 29500: Career Readiness & Exploration
Week 11 Assignment: Adulting with Money
Total Points: 5 points
Objective: In this week’s lectures we discussed how to identify your salary range, and overview of benefits, and tips for
negotiation when considering full-time jobs.
Assignment: Complete a Monthly Budget using the templates in the Week 11 Content. There are three templates for
your monthly budget, feel free to use one of these or create your own.
Purchase answer to see full
attachment
