This discussion is now closed.

Check out other Related discussions

Budget spreadsheet

Just wondering if anyone has been clever enough to set up a spreadsheet to help budget money for uni? Yes, I'm being a bit of a geek, but I'm worried about actually having enough for everything and thought if it was laid out in black and white I could work out exactly what I'll need. It would be MUCH appreciated if anyone could attach a spreadsheet they've made :smile:

Scroll to see replies

Reply 1

loopymeg

I already have a spreadsheet to record my finances, although at the moment it's just detailed bank transactions.

Reply 2

Dez

Adapted this from an old Business Studies coursework in about five minutes, do with it what you will. Plug some values in and it'll do the monthly/yearly calculations automatically.

cashflow.xls21.5KB

Reply 3

sunscreen

waste of time... all u need to do is add up all ur outgoings uni wise...

so like

total loan + grant

- accommodation + tuition fees (if applicable)

divided by how many weeks your there

= spending money

if you have a job you can add on your job money

i use my job money to pay my phone contract... so after ^^^^ that calculation i do

wages

-

phone bill

= more spending money

more spending money + spending money

= £x per week

then i stick a big post it up with how much money per week i can spend...

Reply 4

Dez

Oh well, I wasted five minutes. :P

Reply 5

loopymeg

Dez

Oh well, I wasted five minutes. :P

No you haven't, you've saved me from having to make my own, so thank you very much :smile:

Reply 6

pete42

Dez

Adapted this from an old Business Studies coursework in about five minutes, do with it what you will. Plug some values in and it'll do the monthly/yearly calculations automatically.

that is great :biggrin:

it's helping me a lot, so thanks!

Reply 7

SianyLou

that spreadsheet was ace - i was really up sh*t creek finance-wise (or so i thought), being £1000 overdrawn before i even start year 2...and having put all the loan payments into that, and my outgoings for accommodation i've actually got more money than i ever thought was possible.......

THANK YOU THANK YOU THANK YOU !!!! +ve rep coming your way Dez!

Reply 8

LFC_Girl

Dez

Adapted this from an old Business Studies coursework in about five minutes, do with it what you will. Plug some values in and it'll do the monthly/yearly calculations automatically.

Thank's for that not a waste of 5 mins at all :smile:

Reply 9

dooby

Thankyou that's exactly what I've been looking for too :smile:

Reply 10

dooby

Okay quick question, just been filling in the planner, and in the 'inflows' section at the top, it isn't adding on any of my input from the 'parental contributions' row or the 'savings' row ...... so the inflow total just comes up as the data i put in the loan row. This is obviously meaning that its not taking into account the extra income i've put into the other sections so all the calculations are wrong....is there something i need to do in order for it to add all the inflow section together? Wow soz v. confusing post, i apologise for both my lack of computer knowledge and clarity of writing!!

Reply 11

Dez

Apologies, I mucked up the calculations on it when altering the rows. Re-uploaded, I've also added employment and other inflows to the sheet now.

cashflow.xls22.0KB

Reply 12

dontmesswithme

Thank you for that Dez.

I would like to add some more options on inflows and outflows.

can you tell me what to do in Excel ?

thanks

Reply 13

dooby

I think if you click on the cell below where you want to add a row, then click Add, row, on the menu at the top, you should be sorted....?

Reply 14

dontmesswithme

let me have it please.

also let me modify it too.

Reply 15

Dez

To unlock the sheet, go to the Tools menu => Protection => Unprotect sheet. It's designed to prevent accidental editing. If you want to add rows, make sure to update the calculations to reflect it.

Reply 16

blissy

Can I nick that for the wiki and stickies?

Reply 17

Dez

If you credit me for it, sure.

Reply 18

blissy

This is how I set mine out. I have an annual projection with all my incomings and outgoings and then I have a week by week thing that I can fill in as and when I want to. :smile:

I put a couple of rough figures in. I work better annually and weekly than monthly cause I always get paid termly and don't have much need for a monthly projectio.

Reply 19

samba

wow, blissys looks quite complex!

One thing I can't stress enough, is that when doing these spreadsheets leave a LOT of leeway.

Unless you're really strict with yourself they won't be accurate.

eg. My balance should be 2.5k higher than it is atm :frown:

edit: I'll add mine up tomorrowish for those that are interested

Latest

Trending

Articles for you

Student survival guide: electricity and gas bills

What to do if you’re worried about the cost of university

Starting university: what you need to know

Try out the app

Continue on web