TEFconnect Financials Template for Cash Flow Projection

Recently, I wrote an article about how to upload business financials in the TEFconnect DMS portal.

However, most people argued that on the DMS Guide, they were told to upload their Business Summary Document twice.

To be clear, in the DMS Guide, there is a section that says, “You are required to upload your business summary document in the business plan and financial document type”.

Note that it doesn’t say to upload your business summary twice on both sections like some lazy entrepreneurs are already alluding.

For some clarity, your cash flow statement, balance sheet, and cash flow projections are also business summary documents, as they show a summary of how your business is doing or will do financially.

You are required to upload a business plan summary using the template provided by TEF and then a financial document showing how your business is doing financially and how you will utilize your grant if funded.

The truth is that, at this stage of the TEF grant competition, not everyone would go to the next stage. There are over 1 million entrepreneurs applying in the whole of Africa, but only less than 5,000 would get funded.

What does that tell you?

At this stage, well over 60% of entrepreneurs would be disqualified for either being too lazy to provide a basic financial summary of their business, having a poor business concept, or poor business financial planning.

The TEF grant is a competition, which means that at every stage, a number of entrepreneurs would be disqualified.

Not everyone that started the TEF application and did the course modules has access to the DMS Upload portal.

Not everyone that uploaded their due diligence forms are allowed to upload their business summary document.

Not everyone that uploaded their business summary would be contacted to pitch their business.

Not everyone that pitch their business would be shortlisted for the grant.

What am I saying?

At every stage of the TEF competition, people are being disqualified. Only the best <1% businesses would be shortlisted for the grant at the final stage.

So, stop being a lazy entrepreneur. The TEF grant competition is an opportunity to put your best foot forward. To use everything in your arsenal to convince the judges and give your business an advantage to get funded.

This is not a matter of “I too know” or doing too much. You have to put every resources you have towards convincing the judges that you and your business is worth investing in.

That means you have to provide a business plan and financial document that shows the judges that you are a serious entrepreneur and you deserve to be funded more than the other entrepreneurs that are competing with you.

There is a huge chance that if you are doing what the majority are doing, then you are not doing what the few selected are doing.

That is why I’m writing this article to help you create a financial projection for your business and show the TEF judges that you are a serious and astute entrepreneur.

To help you show that you are in control of your business and you know what your business requires to grow and move to the next level.

The Business Financials

The image below is a sample business cash flow Projection which can be edited to reflect your business financials.

Click Here to Download the Sample Financial Template

How to Update the Business Financials

No two cash flow Projections are the same, hence you have to update the above financials to reflect the realities of your business.

Top Row

On the top row, is the business financial period from startup to the end of the first year.

A cash flow Projection is always done in the short-term, preferably in a 12-month period so as to capture the current realities of the business without going too far into the future, which may be unpredictable.

First Column

On the first column of the financials table, you have all the financial activities of the business. The Income, the expenses, the cash flow and the cash balance.

Income Section

Under the income Section is where you would put all the income of your business, including your receivables.

Grant financing is any grant that you receive, such as the TEF grant. Personal funds represent any money put into the business by the owners or founders of the business. Loans represents any money coming into the business via loans or other financial pledges. Sales is any income earned from the business operations, while equity funding represents funds received by the business in exchange for a stake or equity of the business. If an investor invests 5 million Naira into your business in exchange for 20% equity of your business, the funds would be recorded under equity funding.

Total/Net Income

The total income is a sum of all the income earned by the business within a particular period. If you want to check your total Income for a particular month, you have to add up all the income earned by the business for that month.

Expenses Section

The expenses Section is where you will record all the money going out of your business in the form of expenditures. What ever you spend money on would have to be recorded on this section.

Inventory are the items you buy for sale or the raw materials purchased for use in manufacturing. Many businesses dedicate funds to this section at the start of their business period.

Machinery is any tool or equipment purchased for business operations. Most manufacturing businesses have to purchase machineries to kickstart their business.

Rent & utilities are essential for any business operations. While rent in Nigeria is mostly paid on a yearly basis, utilities can be paid for on a month-by-month basis.

Wages & Taxes are unavoidable expenses for every business. Staff must be paid as well as the government. While wages are paid on a monthly or weekly basis, taxes are paid annually. Some businesses that accrue value added taxes and service charges may record their taxes on a month-by-month basis.

Marketing & Distribution are important steps taken by a business to grow its sales and revenue. Marketing and distribution costs are recorded in the financial statement on a monthly basis.

Insurance is paid for mostly by manufacturing businesses that have a lot of product risks or personnel risk. It is important that businesses insure parts of their business that are exposed to damage, loss of business, or debt. Insurance can be paid on a yearly basis.

Software could be an integral cost for many businesses today, especially those that are technology inclined. However, businesses looking to automate parts of their processes such as accounting or customer acquisition can utilize software. Software costs can be paid on a monthly or yearly basis.

Consulting is a high-end business expense that businesses utilize to gain advantage. Consulting could be in the area of legal, business expansion, funding, investing, contracts or government partnerships. Consulting costs are paid per consulting terms, which are mostly on a use case basis.

Total Expenses

The total expenses of a business is the sum of all the expenses incurred by the business within a particular period. If you want to check the total business expenses for a particular month, you have to add up all the expenses incurred by the business for that month.

Cash Flow

The business cash flow is the balancing of the inflow and outflow of cash in the business. Cash flow is calculated by adding the total income of the business, and subtracting the total expenses of the business. To get the actual cash flow of your business, simply subtract your total expenses from your total income.

Cash Balance

The cash balance of a business is the actual cash that a business has on ground, or cash in the bank. The cash balance is calculated by adding the cash flow to any cash in hand. At the start of the business where the cash at hand is used to fund the business startup, the cash balance = cash flow. In the first month, cash balance = cash flow for that month + cash balance of the previous month or recorded period.

Business Startup

In the financial sample above, we assumed that the business is a new business and has received a grant funding.

Under the “start” column and “grant financing” row, we put the grant amount received, which is N2,050,000.

In the same column on the “personal funds” row, we add any personal funds invested by the owners or founders of the business. In this case, we assume that the business owner invested the sum of N500,000 into the business.

The business didn’t receive any loans or equity financing, and has not made a sale since it is still in preparation to start operations. This brings the total/net income of the business at the start to N2,550,000.

On the expenses Section, the business spends on inventory, machinery, rent, utilities, insurance, software, consulting and staff training. It doesn’t spend any money yet on wages, taxes, marketing and distribution because the business operation is yet to start. That brings the total expenses to N1,280,000.

In the cash flow section, we calculate the business cash flow by subtracting the total expenses from the total income. This gives us a cash flow of N1,270,000.

In the cash balance section, because the cash at hand at the start of the business is the same as the business total income, the cash balance is equal to the cash flow. So, the cash balance is recorded as N1,270,000.

Month 1 – Cash Flow Projection

In the first month of the business, we already have everything set up, so operations can begin proper.

In the first month, we expect the business to make a sale of N200,000. We do not expect any external funding for this month. So, the total income for January is N200,000.

In the expenses Section, we expect to make expenses for the month of January in the areas of utilities, wages, taxes, marketing and distribution, which totals to N104,000.

The cash flow of the business is then calculated by subtracting the total expenses for January(N104,000) from the total income for January (N200,000). This brings the business cash flow to N96,000.

To calculate the cash balance for the month of January, we will add the cash flow for the month of January to the cash balance of the previous period. So, the cash balance for January would be N96,000 + N1,270,000. This brings our cash balance or cash at hand for the month end of January to N1,366,000.

Month 2 – Cash Flow Projection

In the second month of operation, which is February, we plan on taking a zero-interest government-backed loan of N500,000 and expecting sales in the tune of N600,000. This brings our total income for the month of February to N1,100,000.

In the expenses Section, we expect to procure more inventory costing N200,000 while still incurring other business expenses such utilities, wages, taxes, marketing and distribution. This brings our total expenses to N532,000.

Our cash flow for the month of February would then be N1,100,000 minus N532,000. This gives us a cash flow of N568,000.

Our cash balance for the month of February would then be the summation of the current cash flow with the previous cash balance. N568,000 + N1,366,000 = N1,934,000.

Month 3 – Cash Flow Projection

In the third month, which is March, we expect to make sales in the tune of N800,000. We do not expect any further injection of funds from external sources. So, our net income for March would be N800,000.

In the expenses Section, for March, we continue to incur the normal business expenses in the areas of utilities, wages, taxes, marketing and distribution. This brings our total expenses for the month of March to N266,000.

The cash flow for March would then be N800,000 minus N266,000, which equals N534,000.

Now, to calculate the cash balance at the month end of March, we will add the cash flow for March to the previous cash at hand. Our current cash balance would then be N534,000 + 1,934,000 = N2,468,000.

Subsequent Months – Cash Flow Projection

Now, over to you.

This article has guided you on creating a simple cash flow Projection for your business.

You can download the financial template of the sample used in this article through the link provided above, and then edit the rows and columns according to your business financial projection.

Remember that no two business cash flow is the same. So, think about your business processes, the cost of delivering your products and services, and the projected income you expect to earn within the next 12 months. That would make a good financial document for your business.

Wishing you good luck.


Posted

in

by

Share This Post: