2000 words REFLECTION PAPER OVERVIEW based on worksheets and assignment that already have been done & letter of last instruction
usf1414
Worksheet_073.xlsSheet: Sheet1
Sheet: Sheet2
Sheet: Sheet3
Budget Tracker: Personal Income Statement Worksheet
Directions: Fill in the green cells with your data. Be careful not to modify the red cells.
Column B to be filled in for Homework 1 and Column C to be filled in for Homework 4.
Blanks are considered not completed (fill in 0).
Month
Budget
Actual
Income
Income
Difference
Income
Wages and salaries
Wage Earner 1
0.0
Wage Earner 2
0.0
=Total Wages and salaries
3166.0
3166.0
0.0
+ Interest and Dividends
0.0
+ Royalties, Commissions and Rents
0.0
+Other Income
0.0
=A. Total Income
3166.0
3166.0
0.0
Taxes
Federal Income and Social Security
0.0
+State Income
0.0
0.0
=B. Total Income Taxes
210.0
210.0
0.0
C. After-Tax Income Available for Living Expenditures
2956.0
2956.0
0.0
or Take-Home Pay (line A minus line B)
Budget
Actual
Amount
Spencing
Difference
Living Expenses
Housing
0.0
Rent
0.0
+Mortgage Payments
0.0
+Utilities
4.0
+Maintainance
0.0
+Reas Eastate and Property Taxes
0.0
+Fixed Assets-furniture, appliances, televisions, etc.
0.0
+Other Living Expenses
0.0
0.0
=D. Total Housing Expenditures
1549.0
1545.0
4.0
Food
Food and Supplies
11.0
+Restaurant Expenses
90.0
Did not go to resturent like what I thought
=E. Total Food Expenditures
500.0
399.0
101.0
Clothing and Personal Care
New Clothes
3.0
+Cleaning
0.0
+Tailoring
0.0
+Personal Care-hair Care
4.009999999999998
+Other Clothing and Personal Care Expenses
0.0
=F. Total Clothing and Personal Care Expenditures
210.0
202.99
7.009999999999998
Transportation
Automobile Purchase
0.0
+Payments
0.0
+Gas, Tolls, Parking
0.0
+Automobile Registration/Tags/Stickers
0.0
+Repairs
0.0
+Other Transportation Expenses
0.0
=G. Total Transportation Expenditures
150.0
150.0
0.0
Recreation
Movies, Theater, Sporting Events
0.0
1917 & Badboys movies each was 11
+Club Memberships
0.0
+Vacations
0.0
+Hobbies
0.0
+Sporting Goods
0.0
+Gifts
0.0
+Reading Materials (books, newspapers, magazines)
0.0
+Other Recreation Expenses
0.0
=H. Total Recreation Expenditures
22.0
22.0
0.0
Medical Expenditures
Doctor
0.0
+ Dental
0.0
+Prescription Drugs and Medicines
0.0
=I. Total Medical Expenditures
241.0
241.0
0.0
Insurance Expenditures
Health
0.0
+Life
0.0
+Automobile
0.0
+Disability
0.0
+Liability
0.0
+Other Insurance Expenses
0.0
=J. Total Insurance Expenditures
0.0
0.0
0.0
Other Expenditures
Educational Expenditures (college loan payment)
0.0
+Child Care
0.0
+ Other Expenses
0.0
=K. Total Other Expenditures
0.0
0.0
0.0
L. Total Living Expenditures (add lines D-K)
2672.0
2559.99
112.01000000000022
M. Income Available for Savings and Investment
284.0
396.0100000000002
-112.01000000000022
Did not go to resturent like what I thought and it make much diffrernces
Is your income greater than your expenses, if not why?
No, it is not. I am planing for everything that I am paying for before the bigining of the month
