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:
157
downloads:
10
rating:
not rated
reviews:
0
posted:
10/6/2008
language:
0
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
Sample Home Budget
Views: 157  |  Downloads: 10
Sample Budget Worksheet
Views: 1  |  Downloads: 0
Sample Budget Worksheet.XLS
Views: 3  |  Downloads: 0
Sample Household Budget Forms
Views: 225  |  Downloads: 2
Sample Business Budget
Views: 649  |  Downloads: 32
Making a Budget
Views: 548  |  Downloads: 13
Making a Budget
Views: 294  |  Downloads: 6
Sample Budget Plans
Views: 340  |  Downloads: 5
Sample Business Budget
Views: 467  |  Downloads: 19
Sample Budget Request Template
Views: 8  |  Downloads: 0
Sample Budget Request Template
Views: 8  |  Downloads: 0
Sample Budget Detail Worksheet
Views: 5  |  Downloads: 2
Sample Event Budget Worksheet
Views: 4  |  Downloads: 0
Sample Budget Format Worksheet
Views: 1  |  Downloads: 0
Sample Budget Planning Worksheet
Views: 0  |  Downloads: 0
Sample TBRA Budget Worksheet
Views: 0  |  Downloads: 0
Other docs by crisologa lapu...
Federal Gambling Law
Views: 103  |  Downloads: 0
Amortization Formula Excel
Views: 240  |  Downloads: 15
Are Mortgage Rates Going Up
Views: 147  |  Downloads: 0
What are the Different Types of Mutual Funds
Views: 99  |  Downloads: 5
Military Pay Charts
Views: 921  |  Downloads: 2
How Do I Calculate Interest
Views: 163  |  Downloads: 6
Income Properties
Views: 108  |  Downloads: 0
Credit Card Application
Views: 146  |  Downloads: 6
Full Color Business Card
Views: 109  |  Downloads: 2
Check Status of Tax Refund
Views: 53  |  Downloads: 0