Prepare your financial data
How to complete the next 12 months worksheet
This video describes how to complete the second worksheet using forecasted data for your social venture. To complete this worksheet you will need to have a realistic idea of how your social venture will perform in the next 12 months, adding in the UnLtd grant so we can see how our funding would help.
TranscriptLink to this section
"Hello. In the last video, we showed you how to complete the historical financial data for the last 12 months. We'll now look at the next worksheet on tab two [video is displaying the ‘next 12 months’ tab which is the second tab in the worksheet]. This is your financial forecast. That's the income you expect to generate and how much you'll spend over the next 12 months. This should be based on realistic assumptions, which we'll talk more about in the next video.
In this example, we ended the last 12 months with August 2025, so we'll begin this worksheet with September 2025 [video navigates to the cell where month one should be added]. This is so we have a complete picture of your finances with no gaps.
When it comes to the data entry, you can use the same categories as before and add any new sources of income or expenditure and amend the monthly amounts as applicable. Be sure to include any expected grants, including the UnLtd grant [video shows the UnLtd grant of £18,000 split into two instalments of £9,000 added into the other income section]. This is important as it'll give us a clear picture how our funding fits in with your growth plans.
Again, as before, totals are calculated automatically. Your total turnover for the next 12 months must match the figure you've given in your application form [video navigates to the cell displaying the total turnover].
In the next video, we'll talk about the assumptions."