You are here

Monthly Budget Worksheet

This worksheet will help you prepare a monthly budget to estimate how much rent you can afford. First, list money that you earn or have available each month (income). Then, list all of the things you commonly pay for each month (expenses). The balance between your income and expenses represents how money you have available each month. As a general rule, rental housing is considered affordable if it costs less than 30% of your before-tax household income.

Fill out this worksheet on screen, download it electronically, or print it and complete it by hand.

ACTUAL MONTHLY INCOME Main Income
Extra income
Total monthly income $0
Housing Cost
Rent
Electricity/ Gas
Cable
Phone
Total ${{Rent*1+Electricity*1+Cable*1+Phone*1+hother1*1+hother2*1+hother3*1}}
Food & Drink Cost
Groceries
Eating Out
Total ${{Home*1+Out*1+FOther1*1+FOther2*1+FOther3*1+FOther4*1+FOther5*1}}
Transportation Cost
Vehicle
Transit
Total ${{Vehicle*1+Transit*1+TOther1*1+TOther2*1+TOther3*1}}
Personal Expenses Cost
Health/ Fitness
Clothes
Entertainment
Total ${{Health*1+Clothes*1+Entertainment*1+POther1*1+POther2*1}}
Financial Cost
Insurance
Savings
Debts
Total ${{Insurance*1+Savings*1+Debts*1+FiOther1*1+FiOther2*1}}
Dependents Cost
Children
Pets
Total ${{Children*1+Pets*1+DOther1*1+DOther2*1+DOther3*1}}
Others Cost
Total ${{OOther1*1+OOther2*1++OOther3*1+OOther4*1+OOther5*1}}
Others Cost
Total ${{OOther6*1+OOther7*1++OOther8*1+OOther9*1+OOther10*1}}
Balance ${{pincome1*1+pextraincome*1-(Rent*1+Electricity*1+Cable*1+Phone*1+hother1*1+hother2*1+hother3*1+Home*1+Out*1+FOther1*1+FOther2*1+FOther3*1+FOther4*1+FOther5*1+Vehicle*1+Transit*1+TOther1*1+TOther2*1+TOther3*1+Health*1+Clothes*1+Entertainment*1+POther1*1+POther2*1+Insurance*1+Savings*1+Debts*1+FiOther1*1+FiOther2*1+Children*1+Pets*1+DOther1*1+DOther2*1+DOther3*1+OOther1*1+OOther2*1++OOther3*1+OOther4*1+OOther5*1+OOther6*1+OOther7*1+OOther8*1+OOther9*1+OOther10*1)}}
 
1.6 Monthly Budget Worksheet