File uploads

Section 6. Question 14

You can use this template:

Download template Recommended for Microsoft Excel

Submit all your financial data, which includes:

  • historical financial data (last 12 months)
  • a financial forecast (next 12 months), and
  • financial assumptions.

Historical financial data

Start by providing us with your venture’s historical data.

Click on the “Last 12 months” tab.

When you see instructions in italics (like this) complete the relevant task using the template provided. Sometimes you will also need to use a calculator and a notebook or the notes app on your computer.

Tabs are found at the bottom of the spreadsheet.

Detail of tab navigation at the bottom of the spreadsheet. An arrow indicates the place to click to navigate to 'Last 12 months'

Collect your historical data by using your records to determine the income you have received and the costs you have incurred.

Use your receipts and bank statements for an accurate record of your income and expenditures for each of the last 12 months.

List each expenditure separately and break down your income into different sources (such as grants and donations) as well as the different types of products and services you sell.

Note

Create more spreadsheet rows if you need them for all the different types of income sources or expenditures. Right-click on the last row, move your cursor over “Insert” on the pop-up menu, and click on “Sheet Rows”.

Detail showing the navigation to add sheet rows as explained above.

The amount in the field “Total Income - Expenditure” for the most recent month should match the current figure in your bank account.

If these figures do not match, you will need to check your income and expenditure figures to find the error. You may have forgotten to include an item.

After completing your historical data, you are ready to make a forecast of your venture’s financial future.

What is a financial forecast (and why does it matter)?

A financial forecast is a plan that sets out two things:

  • how you expect your venture to gain income, and
  • what you expect your venture to spend money on (called “expenditures”). Preparing a financial forecast gives you an opportunity to consider the future of the venture.

List your financial assumptions

Start your forecast by listing assumptions about the future performance of your venture in the tab labelled “Assumptions”.

Use your business plan to generate a list of expected income and expenditures in the provided tables.

Assumptions about your income and expenditures should be detailed and realistic. Tell us what your assumptions are based on (for example, the previous performance of your venture, market research, or data insights).

Income

Describe the income source and the amount you expect it to generate. Income may come from sales of products and services, as well as grants and donations.

Expenditures

Also called “costs”. Describe the type and amount of expenditures you expect your venture to involve. Expenditures may include rent, salaries, equipment, material, and legal costs.

Now that you have a list of assumptions about your venture’s income sources and costs, you can use theme to produce a financial forecast.

Use the tab labelled “Next 12 months”.

Sales budget

Start your forecast by using a sales budget to calculate the income you will generate from sales of products and services.

A sales budget lists every type of product or service you offer.

It then calculates how much income you can expect by multiplying the number of items of each type by the price you will charge for each item.

Sales budget formula: Number of items you expect to sell X Price you will charge for each item = Income you will generate from that item

For example, if your venture offers group training sessions for £120, and you expect to sell 6 group training sessions in Month 1, then your income from all training sessions for that month will total £720.

Here is how to complete a sales budget.

Start with an item you will sell and write its name in the income section of the financial forecast.

Detail indicating where to input the names of each product. Write the name of the first product in the cell below “income”

Next, use a piece of paper or a notes app to write down the price you will charge for each item and the number of items you expect to sell next month.

Example showing how to work out a sales budget on scrap paper. The example shows this calculation: Cappuccinos at 1.75 (price per unit) x 65 (units to sell) = 113.75 total sales (for that item).

After that, use a calculator to multiply the price per unit by the number of units you expect to sell.

Record your total for each item type in the appropriate field.

Detail showing how to enter the total sales for each item in the cell corresponding to the correct item and month.

If you expect to sell the same number of units at the same price in the month after next, just copy the same number into the next field to the right. Otherwise, perform the sales calculation again using the new numbers for price per unit and units sold for that month.

Note

Use the income part of your spreadsheet to record income from grants as well.

Costs

Next, calculate the costs your venture will involve.

There are a few different types of costs to consider:

  • variable costs
  • fixed costs, and
  • one-time costs.

Variable costs

Variable costs are costs that increase with the amount of sales. They include things like materials or ingredients.

For example, if you run a coffee shop that sells sandwiches, the cost of your bread, cheese, and ham will vary depending on how many ham and cheese sandwiches you sell.

You can work these costs out by identifying the cost per unit of each ingredient and multiplying that by the number of units you expect to sell. This will indicate the total cost for that ingredient.

Example showing how to work out variable costs on scrap paper. The example shows this calculation: Cheese at a cost of 20p per unit (for sandwiches) x 120 (units to sell) = £24 total costs (for that item).

If the same variable cost is used in multiple items, then you will need to perform the above calculation for each item type and then add them together.

For example, if the cost of cheese per sandwich is 20p but cheese is also used for jacket potatoes at a cost of 40p per unit, then you can work out your total cost for cheese through the following three-stage process.

First, multiply the cost of cheese per sandwich by the number of sandwiches you expect to sell. Second, multiply the cost of cheese per jacket potato by the number of jacket potatoes you expect to sell. Third, add the product of both multiplications together.

Fixed costs

Fixed costs are costs that remain the same no matter how much your venture sells. They include things like rent and insurance.

For example, if you run a coffee shop, rent and insurance will probably cost you the same amount whether you sell 50 sandwiches or 500.

You do not need a formula to calculate fixed costs.

Simply record the cost in the column of the month you expect to incur it.

Many fixed costs, such as rent, will not vary from month to month.

You can copy and paste the amount of a fixed cost from one month to the next, as long as you do not expect it to change.

One-time costs

One-time costs are costs that do not occur regularly. They include things like computers, machinery, or tools.

Record each one-time cost in the appropriate field for the month during which you expect to incur it.

Finishing

Check that you have:

  • filled in your assumptions tab
  • provided your historical data, and
  • completed your financial forecast.
  • Then you are ready to upload the spreadsheet to your portal account.