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:
511
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

Related docs
Budget Sample
Views: 203  |  Downloads: 18
Sample Household Budget Forms
Views: 870  |  Downloads: 6
Monthly Budget
Views: 1838  |  Downloads: 62
free home budget
Views: 51  |  Downloads: 3
Home Improvement Budget
Views: 107  |  Downloads: 16
Sample Monthly Budget
Views: 20  |  Downloads: 0
Sample summary budget
Views: 9  |  Downloads: 0
Sample Budget Worksheet - NAFSA Home
Views: 0  |  Downloads: 0
home budget freeware
Views: 46  |  Downloads: 0
Sample-Budget-and-Expense-Form
Views: 12  |  Downloads: 0
sample budget form
Views: 209  |  Downloads: 3
premium docs
Other docs by crisologa lapu...
Amortization Formula Excel
Views: 1969  |  Downloads: 48
Are Mortgage Rates Going Up
Views: 357  |  Downloads: 0
What are the Different Types of Mutual Funds
Views: 472  |  Downloads: 15
Military Pay Charts
Views: 3294  |  Downloads: 9
How Do I Calculate Interest
Views: 797  |  Downloads: 16
Income Properties
Views: 225  |  Downloads: 0
Credit Card Application
Views: 381  |  Downloads: 7
Full Color Business Card
Views: 351  |  Downloads: 5
Check Status of Tax Refund
Views: 428  |  Downloads: 0
Indiana State Tax Forms
Views: 1074  |  Downloads: 4
Mortgage Rate
Views: 95  |  Downloads: 1
Free Investment Advice
Views: 91  |  Downloads: 5
Free Fax Cover Sheets
Views: 2421  |  Downloads: 5
Advertising Slogans
Views: 1278  |  Downloads: 16
Compound Interest Calculators
Views: 153  |  Downloads: 20