Charts & Tables

Charts & Tables

Module 11: Charts & Tables

Share on Facebook or LinkedIn

🎯 Our goal in this module is to create the charts and tables that you’ll use in your Business Plan to help present and summarize your Financials. 

Okay, so you have created your detailed financial projections. 👏

📍

Now, we’ll summarize the results to fit into your overall Business Plan narrative. 

This will help your readers (especially, potential investors or lenders) see how you envision launching and growing your business.

Here’s what you’ll be creating in this module:

  • Timeline of Milestones
  • Summary of Assumptions
  • Profit & Loss Summary and Graph
  • Cash Flow Summary
  • Break-Even Summary and Graph
  • Sources & Uses of Funds Table
  • Ask & Deal (for potential investors or lenders)

⚡Action Step 1

Create your Milestones Timeline.

This is where you can identify and highlight the significant events that need to happen before, during, and after you launch your business as well as your projected dates for their completion.

🔎

For example, you may have startup costs before you actually launch and open for business.  In this case, some of your “milestone events” may include:

  1. Obtain startup funding.
  2. Hire initial team.
  3. Beta-test product/service.
  4. Acquire and furnish office space.
  5. Launch/open for business.

There may also be some key events after launch, such as:

  1. Initiate online marketing campaign.
  2. Reach break-even sales point.
  3. Hire accounting and administrative manager.
  4. Expand into additional markets.
  5. Sign up 1,000 clients.
  6. Reach one million dollars in sales.

It can be helpful here to create a visual with your milestone dates and events highlighted.

We are currently creating additional instructions and tutorial videos demonstrating how to create your Milestones Timeline. Stay on the lookout.

⚡Action Step 2

Create your Assumptions Summary.

Assumptions are the key facts/estimates/ideas that your Financial Projections are based on.

For example, if your Financials show that it will take three months after you launch your business to make your first sale, then you should explain why in your Assumptions Summary narrative. 

What are you going to be doing during those first three months?

🔎

Here are some other examples of things that you might include in your Assumptions Summary:

  • I am planning to add five new clients per month and retain 80% of them as long-term customers.
  • I will launch on my own, but when I have acquired 100 customers, I plan to hire my first employee to help with customer service.
  • I plan to outsource payroll when my team reaches 10 employees.
  • I plan to introduce a new or follow-on product/service when sales of my initial product/service reach $1 million.

Just identify key events for your business that you feel would help you (and anyone else reading through your Business Plan) to better understand your Financial Projections.

💡

Important: Make sure that whatever you include in your Assumptions Summary is directly reflected in your Financial Projections.

We are currently creating additional instructions and tutorial videos demonstrating how to create your Assumptions Summary. Stay on the lookout.

⚡Action Step 3

Create your 5-Year Income Summary Table.

Using the numbers from your detailed Profit & Loss Statement, create a simple table that shows your projected annual profit for the first five years.

Something like this will be fine:

(Scroll left-right over table to view all columns)

5-Year Income Summary at-a-Glance

Year 1
Year 2
Year 3
Year 4
Year 5
Total
Revenue
50,000
100,000
250,000
500,000
1,000,000
1,900,000
Expenses
40,000
70,000
170,000
330,000
640,000
1,250,000
Profit
$10,000
$30,000
$80,000
$170,000
$360,000
$650,000

Write a sentence or two of explanation to accompany your Table.  For example, if there are any major events that affect your Profit & Loss in any given year, they will deserve brief mention here.

If you are using our Financial Projections template, the 5-Year Income Summary will be automatically created for you, based on the projections that you have already done.

We are currently creating additional instructions and tutorial videos demonstrating how to create your 5-Year Income Summary Table. Stay on the lookout.

⚡Action Step 4

Create your Cash Flow Summary.

Using the numbers from your detailed Cash Flow Projections, create a simple table summarizing your annual cash flow. 

Something like this will be fine:

(Scroll left-right over table to view all columns)

5-Year Cash Flow Summary at-a-Glance

Year 1
Year 2
Year 3
Year 4
Year 5
Beginning Cash Balance
$0
$20,000
$40,000
$150,000
$550,000
Cash In
Equity Investment
100,000
0
0
0
0
Loans
50,000
0
50,000
0
0
Sales
50,000
400,000
950,000
2,000,000
3,200,000
Other
0
0
0
0
0
Total Cash Available
$200,000
$420,000
$1,040,000
$2,150,000
$3,750,000
Cash Out
Disbursements
$180,000
$380,000
$890,000
$1,600,000
$2,500,000
Ending Cash Balance
$20,000
$40,000
$150,000
$550,000
$1,250,000

Write a sentence or two of explanation to accompany your Table.

For example, if you are receiving equity or debt funding in Year 1, just explain briefly what that’s about. If your Sales are quite low in Year 1 (or any other year), then mention the reasons why that is.

If you are using our Financial Projections template, the 5-Year Cash Flow Summary will be automatically created for you, based on the projections that you have already done.

We are currently creating additional instructions and tutorial videos demonstrating how to create your 5-Year Cash Flow Summary. Stay on the lookout.

⚡Action Step 5

Create your Break-Even Table/Graph.

Using the numbers from your Break-Even Analysis, create a simple table and/or graph summarizing this information and clearly identifying your Break-Even Point for each year.

You’ll include this table/graph as a visual in your Business Plan along with 1-2 sentences of explanation.

We are currently creating additional instructions and tutorial videos demonstrating how to create your Break-Even Table/Graph. Stay on the lookout.

⚡Action Step 6

Create your Sources & Uses of Funds Summary.

From the Cash Flow Projections that you have made, it should be clear how much money you will need to launch your business and enable you to operate until you start making enough profit to pay all of your expenses.

A Sources & Uses of Funds Table is where you can match the amount of startup funding that you will need with where you expect to find that money—bank (loan), investor(equity), friends and family, or from your own funds.

Keep it very simple and straightforward. Something like this will be fine:

(Scroll left-right over table to view all columns)

Sources & Uses of Funds

Sources of Funds
Uses of Funds
Personal Funds
5,000
Salaries
20,000
Family Investment
5,000
Renovations
10,000
Bank Loan
10,000
Equipment
10,000
Equity Investment
50,000
Operating Expenses
30,000
Total
$70,000
Total
$70,000

Write a sentence or two of explanation. 

🔎

For example, in order to launch your business and become profitable you might be projecting that you will need:

  • Salaries for your early employees
  • Money to furnish and modify your workspace
  • Computers and other equipment
  • Money to operate your business with for the first five months until you expect to break-even

You and your family are investing some personal funds, plus you expect to get a loan from your bank. But, you will still need $50,000, which you plan to acquire as equity investment.

If you are using our Financial Projections template, you can quickly and easily create your Sources & Uses of Funds Summary directly inside the template, based on the projections that you have done.

We are currently creating additional instructions and tutorial videos demonstrating how to create your Sources & Uses of Funds Summary. Stay on the lookout.

⚡Action Step 7

Write your Financials Narrative.

Now, go to the Financials section in our Business Plan Core Template and write out the full narrative for this section.

📍

Include the Following:

  • Narrative for Milestones with visual timeline
  • Narrative for summary of Assumptions
  • Narrative for Profit & Loss Statement with of 5-Year Income Summary table or chart
  • Narrative for Break-Even Analysis with a table or chart
  • Narrative for Cash Flow Projections with of 5-Year Cash Flow Summary table or chart
  • Narrative for Sources & Uses of Funds with a table

Sounds like a lot of “Narrative”, I know, but you have already written it all down (or most of it), so it’s just a matter of weaving these “mini narratives” together.

💡

What you’re really looking for here is a walk-through of your Financial Projections where you reference your Milestones, Assumptions, and each of the Summary Tables/Charts/Graphs that you have created.

We are currently creating additional instructions and tutorial videos demonstrating how to create your Financials Sections. Stay on the lookout.

🗂️ Resources

💡

Scroll left-to-right across the table below to view all columns. Click on any item in the leftmost column to open that specific resource page.

ItemTagsURLPriceDescription
Business Plan Core Template
Business PlanBizActually
Free
A no-frills Business Plan template in Google Sheets. (Created by our Team)
Financial Projections
FinancialsCash FlowProfit & LossBalance SheetBreak-EvenBizActually
Free
A Google Sheet to organize and calculate your financial projections. (Created by our Team)

Give Us Feedback

❇️

Help us improve this module. Use the form below to tell us what content you’d like us to add or modify. (If you can’t see the form below, try refreshing the page)

← Previous

Next →

💠

https://startup.bizactually.com/

© 2022 Terry Cornelison | DIY Startup Bootcamp is a BizActually.com initiative.