This was created off of a template created by someone else. I did some tweaking and adjusting of the formulas when I did our budget sheet and thought it might be helpful for anyone who needs to include a budget in their application.
You can download it here:
http://www.us2uk.net/files/samplebudgetsheet.xlsAnd I'll run down the basics -
This is for a monthly budget.
"Gross Income After Tax (sponsor's wages)" is pretty self-explanatory and you should have your sponsor's p60 and payslips to corroborate the amount. If your sponsor's wages can be variable from month-to-month, I would take the total on the p60 and divide by 12.
"Other Income After Taxes" - if your sponsor has any additional income or if you have any income you will be contributing (like if you already have a job offer, or plan on pulling £x out of your savings each month). I would edit the line to specify where that money comes from, or delete the line if it isn't applicable.
"Monthly expenses" are self-explanatory. Again, delete off lines you don't need and add (right click on the row below where you want the new row and click "add". The formula will automatically adjust itself) any additional line you need. These are your Utilities/important expenses ONLY. Tim has mortgage insurance which will pay off the mortgage in the event of his death before it is paid off, so I added that line, but most people can delete it off I immagine.
The number at the "Total income minus subtotal 1" should be greater than or at least £100.95/wk for a couple (
please note, this figure is as of 12/2009 and if you have children the amount is higher)
The second half is optional and you can omit it if you'd like.
Again, all the lines are self explanatory. If you put something in "other expenses", just make sure you specify what it is, such as union dues, a charity contribution, money that gets transferred into a savings account each month, etc.
I did not include any of our savings in our budget because we met the requirements on salary alone, but we did mention savings on the application and included the most recent bank statement for any.
Hope this helps!