Categories
Guides Resources

Student budget spreadsheet: how to make your loan last

It can be tricky to get a clear picture of your finances when you’re living away from home for the first time. This student budget spreadsheet will help you to make your student loan last and see where the money goes. It will help you for life…

I’ve spent the past few weeks talking to several hundred students on creative courses from locations all around the UK on the topic of how to make your loan last.

During the workshops, several students made the comment that they wish loans were paid-out in a more piecemeal fashion – a regular drip-feed on a weekly or monthly basis.

I think this is a fairly savvy point, which probably would help more students avoid the (inevitably) bad financial decisions we all make at some point during study. However, part of the point of higher-education is equipping you with the skills for life and, chief among them, critical thought and self-reflection.

In this sense, the loan is one of many, sometimes painful, learning curves that are part of that experience. It also strikes me that it’s not a bad rehearsal for life in the creative industries.

A dry run

Most creative workers are freelancers and most of us get paid in occasional lump sums, rather than the more steady incomes that would enable us to emulate a salary.

In this sense, making the three payments of a student loan last across the year, while topping it up with other forms of income (drawing on savings, part-time work, frantically selling your things etc.) is a pretty good emulation of the cash-flow peaks and troughs we encounter in creative work.

I’ve been using a student budget spreadsheet to illustrate to students how they might spread their loan out and get some clarity on their financial position throughout the year. I thought I would share it on here, too, along with a few pointers on how to use it, which is really the important bit.

Get the Creative Money student budget spreadsheet

(Opens as a Google spreadsheet)

Please note: You won’t be able to edit the master sheet on this link, so it’s important that you save a copy to your own Google account or download it for use with Excel before you try to edit it.

You’ll note there are three tabs: Spreading your loan, What have I got? and What do I need?

Step 1: Enter your annual maintenance loan

Start on the first tab (Spreading your loan) and enter your annual loan amount where indicated.

Student budget spreadsheet: your maintenance loan

When you enter this figure, the sheet does a very simple calculation to split the payment into three, indicating how much you will receive in payment each term.

It also divides your annual figure equally across either 9 or 12 months (depending on your selection in Box B7).

Choose 9 months if you expect to be relatively ‘bill-less’ over the summer period – for instance, you know you’re heading home and won’t need to supplement your income at that point.

If you’re planning on renting throughout summer, then go for 12.

The amount you have to contribute towards your living costs each month is then displayed in row 8: ‘Maintanence loan for term time (Oct-June)’.

This will prove useful later.

Step 2: Figure out what you have

Next, head to the What have I got? tab. This is where you take a snapshot of your financial position. This is best done once a month at the same time each month, e.g. the first of the month.

Student budget spreadsheet: your assets

Log anything you’re holding in your savings accounts, in cash, or other investments and things that hold some worth and could be converted to cash.

(As a rule, avoid listing your ‘stuff’, as selling your guitar etc. is usually a last resort).

Below you can list any debts you might hold, perhaps your overdraft, credit card and store credit.

Student budget spreadsheet: your debts

The sheet then deducts your assets (what you have) from your liabilities (debts/what you owe) and tells you what’s left.

This figure is known as your net worth, but is probably best thought of as ‘What have I got?’ hence the title…

Step 3: Enter your income and expenses (predict then review)

Now move to the What do I need? tab. This is where you capture the movement of your money in and out of your accounts for the month: your cash-flow.

Do not comb your statements line-by-line to do this. Use a budgeting app, which does the legwork for you and will automate the monthly totals for expense categories.

Your fixed expenses
Your Fixed Expenses won’t change much month-to-month.
Your variable expenses
Your Variable Expenses can be easily grouped and tracked using a budgeting app.

Once a month, open it up, drop the expense total from each of your main app categories into the relevant column on the ‘What do I need?’ tab and you’ll start to get a very clear picture of where your money is going (and how much of it is going there!) each month.

(You can of course use the apps themselves to compare monthly spending, but I find it’s clearer if you drop them on the sheet.)

Do the same thing with your income.

Your income

This is where that student loan calculation from Step 1 comes back in. The sheet pulls through your student loan portion for the month (calculated on the ‘Spreading your loan’ tab) and adds it at the top of the income column.

It’s not strictly ‘income’ but it can be thought of as such while you’re a student…

The sheet will tot up the categories to tell you your total expenses (Row 40: What do I need?) and then deduct your expenses from your income to show you your cashflow for the month (Row 43).

Your cashflow

If the figure is positive, you’re spending less than you’re bringing in, great!

If it’s negative (which it may well be during study) and continues to be, you’ll need to do something to either lower your expenses or raise your income, so take action!

Step 4: Tracking is the key to success

A lot of people will tell you that budgeting is the key to keeping your finances in shape as a student and beyond. But this is only true if you accept the reality of your expenses – and most people don’t.

More often than not we create a budget from numbers we’ve plucked from the sky. Our perception of these costs is often very different from the reality, which means we inevitably ‘break the budget’, tell ourselves off and then get demotivated and give up on it.

via GIPHY

Budgets should change. Don’t feel bad about it.

The secret to budgets (that is often not discussed) is this: Success with this stuff depends more on reflection than prediction. It is the tracking that makes the difference.

Budgets should change. It is not about chucking some numbers on a spreadsheet and hoping they’re right, it is accepting that it is a guide and it won’t ever be 100% right, then periodically checking and correcting your assumptions.

If you use an app to track your expenses and update the sheet once a month, you’ll have a much better sense of your real expenses. You can then use that information to make more realistic decisions about what to budget for the next month – and so on.

You don’t have to wait until the end of the month either. The apps often allow you to setup running totals.

For instance, you might set a limit of £100 a month for food shopping. Every time you check in on the app, it will tell you how far through that figure you are for the month – and you can adjust your spending accordingly.

Step 5: Repeat this once a month. Don’t spend ages on it.

via GIPHY

I always tell people not to spend a long time doing this.

It should be just a case of nipping through and dropping any totals from the 10 or so spending categories on your app into your sheet. Then the balances from the accounts on your ‘What have I got?’ tab.

If you’ve kept things tagged-up on the app throughout the month, this should take you a maximum of 10 minutes.

It doesn’t need to take a long time. In fact, it is much better if it doesn’t. You want this habit to stick, not become a chore.

Talking to yourself

Once you’ve pulled the info together, give yourself a moment to look over things on the sheet. Ask yourself the following questions:

  • Is there anything unexpected or surprising about the month’s spending? Why is that?
  • What was worth the money? (It made you genuinely happier, or had some considerable or lasting benefit)
  • What really wasn’t worth the money? (It was a waste, or had very short-lived benefits)
  • How does my spending compare to the previous month?
  • Is my ‘What have I got?’ number (Net worth) going up or down?

This should take you about another 10 minutes. But to be on the safe-side, let’s say the whole process should take you 30 minutes a month.

That’s just 30 minutes a month to get clarity on how much you have, where the money is going and whether you’re on a good course, or need to make some changes.

Don’t waste time agonising over decisions you’ve already made or getting forensic in your analysis of micro transactions. We’re looking at trends and overall direction here.

Spend just a little time putting these habits in place now and you’ll reap the benefits for the rest of your life.

Categories
Guides

How to manage your money on a variable income

Are you self-employed, freelance, or a contractor with a variable income? Here’s how to cope with the financial peaks and troughs

Nearly half of creative workers (47%) are freelance or self-employed (source: ONS, 2017). Chief among those are writers, producers, artists and directors – it’s a large and significant part of almost all creative industries. One of the key challenges for this group is managing money on an irregular or variable income. So what can we do to smooth-out the financial ups and downs that we will inevitably face in a given year?

The key is learning to syphon-off your income in normal and higher-earning months into a ‘top-up fund’, so you can top things up from your savings when needed.

This would be easy if humans were calm, logical creatures, but we’re not – so we need a way to tell whether or not we should save or withdraw (and by how much) in a given month.

Turning a problem into a question

If we put a little effort in upfront, we can save ourselves from guesswork down the line.

In order to do this, we’re going to answer these five questions…

  1. How much do I earn?
  2. How much do I spend?
  3. How much am I normally left with?
  4. How can I create a more consistent income?
  5. How much do I need?

Why? Well, if you know how much you earn and how much you spend in a given month, you can figure out what you are left with. This is your personal cash flow.

All businesses ultimately survive or perish based on their cash flow (overall, is there more money flowing in than flowing out?) and it’s the same in your personal finances.

Once you have a predicted cash flow figure for the month, you know whether you will likely need to pay in or out from your savings (your ‘top-up fund’) for that period. This will help smooth-out that variable income over the longer term.

Answering the final question (‘How much do I need?’), gives you the comfort of knowing the minimum amount you’ll need to live on in a given month. The bigger the gap you can create between your income and this essential spending, the more you can potentially save into your top-up fund – and the bigger cushion you’ll have to smooth-out the financial ups and downs.

This is quite a lot of information to pull together initially, so I’ve put together a spreadsheet to help you keep track and – if it all goes to plan – to do some of the calculations for you.

Free spreadsheet!

The sheet is designed to be used to log your answers to some of these questions and calculate your cash flow for a typical month.

You can then stop there, or you can use it to keep track over the longer term. Keep it up-to-date and the sheet will help you figure out how to spread your variable income more evenly throughout the year. We do this using a ‘top-up fund’.

You can download the sheet above and there are links and tips (in bold, with the lightbulb icon) throughout this piece to help you understand where to enter the relevant information.

Even with the whizzy spreadsheet above, this stuff can take time, so don’t stress if you find you have to do it in instalments. The clarity is worth the effort.

1. How much do I earn?

First, let’s figure out what you have coming in normally.

If you have any salaried work (or state benefit) that pays a regular, fixed amount, use your bank statements or pay cheque to find out your monthly income.

Make a note, or add this into the top ‘Salary income’ box for your ‘Typical Month’ on the supplied spreadsheet.

But I’m freelance and my income is a nightmare…

It’s a bit messy, but finding a past average is probably the simplest and most helpful place to start. We’re looking to smooth-out future dips and bumps in income, so a figure that represents the middle of your ‘normal’ range is useful here.

Ideally, you want to represent a long period with the average – a year or more – but you can hone this and update down-the-line. Right now, settle for making a start.

So… add up your income for your chosen period and divide the figure by the amount of months it covers.

Total income for period ÷ Number of months in period = Average monthly income

For instance, if you earned £12,000 in freelance income over 12 months, your average would be £1,000 a month.

Some ideas about where to find this information:
  • Banking apps (you may be able to just filter income only transactions)
  • Your income statement (where you track invoices etc.)
  • Your tax returns (dig out that Self Assessment login)
  • Ask your accountant

If you’re setup as a company, make sure you factor in your dividend income for the year here, too.

Once you’ve found it, make a note.

You can drop your average freelance income figure in the ‘Freelance income’ box of your ‘Typical Month’ on the spreadsheet. This will then be added to any salaried income or benefits you specified, in order to tell you your average total income.

Then take a break…

Want to make sure you never miss a post? 
Sign up to the Creative Money newsletter!
Let me read it first >

2. How much do I spend?

Now let’s figure out your spending for a typical month.

Sit down with your banking app or statements and go through your spending for the last month (or one you feel is truly representative of your typical expenses – if in doubt, be pessimistic).

Split the month’s spending into categories of fixed and variable expenses.

Fixed expenses

Your fixed expenses will be recurring bills and spending (e.g. rent or mortgage, insurance, gas/electric and other direct debits), which do not usually vary month-to-month.

You can enter your fixed expenses on the sheet, under – you guessed it – the ‘Fixed Expenses’ heading. Add the corresponding figures in the ‘Typical Month’ column.

Variable expenses

Variable expenses are things that may might vary month-to-month, for instance: travel costs, food shopping, eating out, or gifts and entertainment.

It’s a good idea to make groups under your variable expenses to reflect your spending priorities and help you to see where your money is going. There are some examples on the sheet above already. Keep it simple, though – no more than 10 groups.

If you just can’t face doing all of this immediately, settle for totting up any expenses not covered in your fixed category and lump them all in one ‘other expenses’ group.

(This sort of thing makes accountants reach for the smelling salts, but you can always come back and split this out out at a later date.)

Make a note of the totals.

You can enter your groups on the first column of the sheet under the ‘Variable Expenses’ heading and add the corresponding figures in the ‘Typical Month’ column.

Can I make a robot do this for me?

Yes! Or at least, sort of… There are several apps out there that will help to automate the process of grouping expenses. Some of the fancier bank apps do this and there’s also the likes of MoneyHub and Money Dashboard, which allow you to connect and monitor multiple accounts/banks.

You can set your own groups or categories for expenses, but you will have to check-in and tag/correct your transactions. However, it does ‘gameify’ it somewhat, so if you’re a phone addict, it could work for you.

Adding it up

Now add the total of your fixed expenses and variable expenses together. Hello, monthly spending!

Fixed monthly expenses + Variable monthly expenses = Monthly spending

Again, on the spreadsheet, it will do this for you and give you a figure for total expenses, as well as factoring in any savings you specify.

That’s the hardest bit done. Congratulations! Again, this is a good point to take a break.

3. How much am I normally left with (i.e. what’s my typical cash flow)?

If you’ve been using the sheet, just scroll down and look at the ‘cash flow for the month’ total to see what’s left in a typical month.

If you don’t want to use the sheet, you’re simply doing the following calculation for your example month:

Total income for month – total spending for month = cash flow for month

What does this mean?

If you have a positive number, this is an amount you can save to supplement leaner months, using a ‘top-up fund’.

Bear in mind, too, that this ‘Typical Month’ cash flow figure might look small, but you are using an averaged income at this point, so even a small surplus is a good thing. It suggests an overall trend of more cash flowing in than flowing out.

If you get a negative number at this point, it means that on average you are likely spending more than you earn (a negative cash flow), or are on course to do so in the near future.

Don’t panic – this is good information to have, but you will need to cut expenses or raise your income to sustain yourself over the longer term. Figuring out your essential expenses (Q5. ‘How much do I need?’) will help here.

4. How can I create a more consistent income?

The answer is to create your own overdraft, using a ‘top-up fund’.

As soon as you are earning more than you spend, set-up an easy-access savings account to set this remaining cash aside. This is your ‘top-up fund’. So how do we do use it?

One method is to simply use your average income (as logged under your ‘Typical Month’) as a guide, as follows:

Earn more than your average income?

Pay the difference into the top-up fund.

Earn less than your average income?

Withdraw the difference from your top-up fund.

Of course expenses vary as much as income and most of us will need to keep a closer eye on things.

If you want to keep a better track on your finances and expenses, update the sheet monthly with your income and predicted spending and it will tell you whether to save or withdraw the ‘cash flow for the month’ figure.

* Updating requires much less effort than finding the initial figures, particularly if you set up your expense groups using an app – you’ve done the hard work already.

My mind won’t let me do this. It needs shiny things.

I hear you. Some things that might help you:

  • Make the ‘top-up fund’ deposit/withdrawal early – as soon as you can once payments have cleared.
  • Keep your ‘top-up fund’ with a different bank. You still want easy access, but for some reason the mental difference of having to login to a different platform can make you less inclined to dip-in to those savings.
  • Use separate accounts for bills (fixed expenses) and variable spending. Direct your earnings to a bills account and then transfer a regular amount (your variable expense total) over to your spending account and spend according to your priorities that month, knowing your bills are covered. Once you run out of cash in your spending account, that’s your lot for the month.
  • Don’t think of your ‘top-up fund’ as spare money. It is essentially your future income. ‘Borrowing’ too much from it now is like a salaried worker asking for an advance.

5. How much do I need?

Need to create a bigger gap between your earnings and spending? First, find out your essential expenses…

Look over your spreadsheet/notes/crumpled napkin with your expense totals and consider which items could be cancelled or easily and quickly reduced, if necessary.

For instance, rent is still considered compulsory by most landlords, but you may be able to avoid the posh shops for a bit and spend less on food.

If you’re using the spreadsheet, simply duplicate your ‘Typical Month’ column expenses to the ‘Essential Expenses’ column and remove/reduce, accordingly.

Add it all up. Now you know your essential spending – the bare minimum amount you could exist on from either your income, or savings.

Are you asking me to remove all joy from my life?

No, but this figure is really useful to bear in mind for a number of reasons, for instance…

  • If you’re making an effort to boost your ‘top-up fund’ or other savings (because income – essential expenses = your maximum current saving rate).
  • If you want a minimum earnings goal, particularly if you are risk averse and keen to always avoid spending more than you earn (creating negative cash flow) within a month.
  • If you’re assessing whether or not you can afford to pass on that boring work you’ve been offered, or start that new thing.

Found it hard to save in the past, or looking for a way to get started? Check out our tips on How to start saving (when you don’t think you can)


I’m doing it! It’s worked! What next?

Keeping one eye on your cash flow is key to avoiding nasty surprises. If you keep the sheet up-to-date, it can help you do this.

It has columns for ‘Year Total’ and ‘Year Average’, too, which can be really helpful in showing whether your overall cash flow is positive or negative for the year, as well as your average income etc. The year average can then me imported to the next year to form the basis of your ‘typical month’ column and the cycle starts over.

As you get more confident, it’s a good idea to start to increase your top-up fund savings (by cutting costs, or boosting income) until you have at least a month’s ‘salary’ on-hand.

A final note…

This approach should be regarded as a useful rule-of-thumb. It is a collection of various techniques that have worked for me, but it is not 100% foolproof.

For instance, it initially relies on your past income and predicted spending trends prevailing to keep your top-up fund savings balanced, which (particularly in the current climate) will not always prove to be the case.

In addition, the more dramatically your income fluctuates (say, you have three or four ‘big’ paydays, which sustain you through the year), the more you will need to set aside before you start using this technique regularly. In this case, build the ‘top-up fund’ as much as you can for time being and implement the system following your next big payday.

Nonetheless, the above represents my best effort to date. As we gather more ideas and resources on Creative Money, I will endeavour to update this guide and the spreadsheet.

Ultimately, the minimum you’ll get out of it is a better knowledge of your earnings, spending and the importance of cash flow, all of which can be really useful. Give it a go and let me know how you get on!

Photo by Fabian Blank on Unsplash

How can we help you?

What issues are you facing? What questions do you have about managing your money in the creative industries? What would be most helpful to you?

We don’t have all the answers, but maybe we can find someone that does.

Send your questions and suggestions to creativemoneycontact@gmail.com.
We want to hear from you.