Excel Spreadsheet

Sample Home Budget

You must be logged in to download this document
Description

This is an example of home budget. This document is useful for creating home budget.

Reviews
Shared by: crisologa lapuz
Categories
Stats
views:
408
downloads:
23
rating:
not rated
reviews:
0
posted:
10/6/2008
language:
English
pages:
0
Monthly Home Finance Portfolio Sample Summary Totals Income Expenses Income less Expenses Income Income Source Salary 1 Salary 2 Investment Stocks and bonds Other Total income Outlays Withholdings Taxable income Federal income tax State income tax FICA Medical Dental Total withholdings Percent of expenses Finance Payments Credit card 1 Credit card 2 Credit card 3 Credit card 4 Student loan Auto loan Home mortgage Personal loan Total finance payments Percent of expenses Fixed Expenses Property taxes Other taxes Charitable donations Monthly 2,312.50 2,302.56 9.94 Monthly 2,312.50 Annual 27,750.00 27,630.73 119.27 Annual 27,750.00 2,312.50 27,750.00 Monthly 198.33 119.67 176.91 40.00 0.00 534.91 23.23% Monthly 50.00 Annual 2,380.00 1,436.00 2,122.88 480.00 0.00 6,418.88 23.23% Annual 600.00 118.62 0.00 524.59 693.21 30.11% Monthly 37.50 15.00 1,423.43 0.00 6,295.12 8,318.55 30.11% Annual 450.00 180.00 Auto insurance Home insurance Life insurance Medical insurance Cable TV Telephone Utilities Total fixed expenses Percent of expenses Variable Expenses Household Groceries Auto upkeep and gas Other travel expenses Furniture Clothing School Medical/prescriptions Entertainment Memberships Dining out Gifts Vacation Pet care Other Total variable expenses Percent of expenses 75.00 28.63 15.00 5.00 36.00 45.65 112.00 369.78 16.06% Monthly 40.00 197.00 50.00 24.00 25.00 50.00 0.00 1.67 75.00 24.00 30.00 50.00 100.00 38.00 704.67 30.60% 900.00 343.50 180.00 60.00 432.00 547.80 1,344.00 4,437.30 16.06% Annual 480.00 2,364.00 600.00 288.00 300.00 600.00 0.00 20.00 900.00 288.00 360.00 600.00 1,200.00 456.00 8,456.00 30.60% Monthly Home Budget Notes 27630.72573 Notes Notes 27750-3050-6500(mort.interest) =18200 (taxable income, ap .10*7000+.15*(18200-7000) = 2380 due in federal taxes .05*(3800)+.07*(6300-3800)+.09*(18200-6300)=1436 due in .0765*27750 = 2122.83 due in FICA taxes job pays most of medical, my obligation is $40/month job pays all of dental, no copay. Notes I will use credit card for gifts and pay it off over the year. To pay off loans of $15,000 at 5% over 15 years: P=15000*( I will keep the car I already own, no payments need to be ma Loan of 95000 at 5.25% for 30 years: P=95000*(.0525/12)/(1 Notes Information from house ad (see narrative) No local taxes Based on what I contribute now Based on internet estimate for Bend, OR and a 1999 Camry Found at homeinsurance.com, average of low and high estim Based on internet estimate (see narrative) Possible $5 co-pay per month for 1 prescription Based on internet info (see narrative) Based on internet info (see narrative) Based on internet info (see narrative) Notes Based on my estimates (see narrative and appendix A) Based on my estimates (see narrative and appendix B) Based on my estimates (see narrative and appendix C) Based on my estimates (see narrative and appendix C) Based on my estimates (see narrative and appendix D) Based on my estimates (see narrative and appendix D) no school expenses anticipated Based on estimated 4 prescriptions/year with $5 copay each Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix F) Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix G) none anticiapted hly Home Budget Notes 27630.72573 Notes Notes 27750-3050-6500(mort.interest) =18200 (taxable income, approximately) .10*7000+.15*(18200-7000) = 2380 due in federal taxes .05*(3800)+.07*(6300-3800)+.09*(18200-6300)=1436 due in state (OR) taxes .0765*27750 = 2122.83 due in FICA taxes job pays most of medical, my obligation is $40/month job pays all of dental, no copay. Notes I will use credit card for gifts and pay it off over the year. To pay off loans of $15,000 at 5% over 15 years: P=15000*(.05/12)/(1-(1+.05/12)^-180) I will keep the car I already own, no payments need to be made on a loan Loan of 95000 at 5.25% for 30 years: P=95000*(.0525/12)/(1-(1+.0525/12)^-360) Notes Information from house ad (see narrative) No local taxes Based on what I contribute now Based on internet estimate for Bend, OR and a 1999 Camry sedan (see narrative) Found at homeinsurance.com, average of low and high estimates: 283 low, 404 high per year Based on internet estimate (see narrative) Possible $5 co-pay per month for 1 prescription Based on internet info (see narrative) Based on internet info (see narrative) Based on internet info (see narrative) Notes Based on my estimates (see narrative and appendix A) Based on my estimates (see narrative and appendix B) Based on my estimates (see narrative and appendix C) Based on my estimates (see narrative and appendix C) Based on my estimates (see narrative and appendix D) Based on my estimates (see narrative and appendix D) no school expenses anticipated Based on estimated 4 prescriptions/year with $5 copay each PER year Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix F) Based on my estimates (see narrative and appendix E) Based on my estimates (see narrative and appendix G) none anticiapted

Post this Doc to Twitter
Embed on any Website or Blog
Related docs
sample
Views: 195  |  Downloads: 1
Movie Budget List
Views: 1939  |  Downloads: 150
CA AGING Home-Delivered Nutrition Program
Views: 53  |  Downloads: 1
Home Schooling
Views: 187  |  Downloads: 2
List of Work From Home Jobs
Views: 2045  |  Downloads: 107
Sample Local Government Document c35 budget 05
Views: 58  |  Downloads: 0
California Govenors Proposed Full Budget Summary
Views: 959  |  Downloads: 2
data entry resume sample
Views: 1246  |  Downloads: 13
Sample Household Budget Forms
Views: 677  |  Downloads: 5
Sample Business Budget
Views: 1747  |  Downloads: 105
Learn to Budget Money
Views: 221  |  Downloads: 10
Monthly Household Budget
Views: 1947  |  Downloads: 31
Sample Interrogatories
Views: 5458  |  Downloads: 164
Free Budget Worksheets
Views: 4101  |  Downloads: 237
Free Sample Business Plans
Views: 2584  |  Downloads: 153
Other docs by crisologa lapu...
Federal Gambling Law
Views: 285  |  Downloads: 0
Amortization Formula Excel
Views: 1121  |  Downloads: 41
Are Mortgage Rates Going Up
Views: 290  |  Downloads: 0
What are the Different Types of Mutual Funds
Views: 293  |  Downloads: 12
Military Pay Charts
Views: 2394  |  Downloads: 7
How Do I Calculate Interest
Views: 492  |  Downloads: 15
Income Properties
Views: 178  |  Downloads: 0
Credit Card Application
Views: 236  |  Downloads: 6
Full Color Business Card
Views: 251  |  Downloads: 4
Check Status of Tax Refund
Views: 307  |  Downloads: 0
Indiana State Tax Forms
Views: 855  |  Downloads: 4
Mortgage Rate
Views: 61  |  Downloads: 0
Free Investment Advice
Views: 51  |  Downloads: 5
Free Fax Cover Sheets
Views: 1806  |  Downloads: 5
Advertising Slogans
Views: 618  |  Downloads: 11