Review: Creating Financial Proformas Lecture

Loading...

En provenance du cours de Michigan State University

Capstone - Launch Your Own Business!

note

Explore Related Videos

At Coursera, you will find the best lectures in the world. Here are some of our personalized recommendations for you

Michigan State University

Capstone - Launch Your Own Business!

note

Cours 6 sur 6 dans Specialization How to Start Your Own Business

It is a cliché, but nevertheless very true. Experience is the best teacher. It is also the best confidence builder. It is time for you to take action! The concepts and skills presented throughout the courses in the specialization are applied in this capstone course where you will launch an actual business. It will not be a business concept described on paper, but a functional business with legal status in your particular governmental jurisdiction, developed within your available resources whatever they are, and challenged to generate revenue. One of the greatest benefits of this specialization is the business development environment provided by the population of learners. At the point of the capstone course your thousands of fellow learners become consultants capable of refining and adding value to your business concept, they may also be potential customers or at the very least allow you to observe the likely reactions from potential customers. With the experience of launching this startup, and the execution capabilities and confidence gain from that experience it is our desire that you repeat the process and launch another startup or a bigger version of this startup. Hopefully going on to launch another, and another, and another, evoking another cliché, 'practice will make perfect'.

À partir de la leçon

Establish Your Financial Statements

Learners will be tasked with developing all three of their financial statements for their company. These are not financial projections but rather established templates / ledgers with defined line items for the Income Statement, Balance Sheet and Cash Flow Statement. Note: Learners may find it beneficial to review the lectures on creating financial proforma statements to refresh terminology.

Review: Financial Statements5:17

Review: Creating Financial Proformas Lecture4:36

Rencontrer les enseignants

Ken Szymusiak
Managing Director, Burgess Institute for Entrepreneurship & Innovation
Broad College of Business
Forrest S. Carter
Associate Professor, Faculty Director of Institute of Entrepreneurship and Innovation
Marketing

[MUSIC]

Welcome back to Module 1 and our discussion about financial statements.

Over the past four lessons we've covered the basics of the three financial

statements, the income statement, balance sheet, and statement of cash flows.

Our intent with the previous lessons was to get you familiar with the structure and

terminology of the statements, so that you'd be prepared to begin building out

your own financial projections, also known as pro forma financial statements.

So why do we need projections?

Due to the fact that you've taken the time to enroll in this class,

I'm going to assume that at the end of the day you're not only interested in starting

your own new business, but also seeing it succeed.

Well, for a business to succeed,

it's important to understand the road map to get you there.

In course three, you explored the business planning process with Dr. Carter.

You should consider the financial projections to be an extension of that

planning process.

One, developing financial projections, if done correctly,

it will force you to become an expert in your industry and market.

This understanding is critical to future investor or bank financing.

Not to mention it will ensure that you have realistic expectations of sales and

cost structures.

Two, it determines whether or not your venture is worth the time and risk to you.

You may uncover during your due diligence process that the financial realities

of the business are not what you anticipated.

And three, the development of financial projections allows you to define what

the expectations are for your company.

Essentially, what do you need to achieve to be considered successful in your eyes?

Having these goals can be very helpful when developing a go to market plan,

which we'll discuss in a later course.

Before you start building your projections,

I recommend considering the following words of caution.

One, be reasonable.

The downside with financial projections is they're just that, projections.

No one really knows what will happen when a business launches.

But you need to expect the unexpected.

Entrepreneurs have a tendency to think that their projections should only show

the best case scenario.

But remember that these projections, and all the planning for that matter,

should help you as the owner, not to impress someone else reading your plan, so

be reasonable.

Next, be mindful of accidentally underestimating your cost.

This is where good research can be helpful in determining that you have accounted for

all the different components necessary for you to run your business.

Be especially mindful of any upfront construction costs, fees associated with

banking or credit card processing, as well as marketing expenses.

I find that entrepreneurs often underestimate those items.

Also remember that it might take longer to generate sales than you think.

So make sure to account for a ramp up in sales volume and

make sure you have cash to handle expenses during that beginning period of time.

Additionally I've found that it's much more advantageous to build your model

from the ground up as opposed to the top down.

Meaning that instead of thinking about your revenue and

expenses occurring on a monthly basis or yearly basis, try to

build your model from the ground up on a daily basis on predicted sales volume.

This will give you a much more realistic insight into what it will take to

generate sales.

And lastly, make sure to think about seasonality.

Remember that cash is paramount, so build your model to account for

seasonality, which will play a part of your business model.

Some examples of this might be a business located in a resort or

college town, or a retailer that gets heavy volume during the holiday season but

then has very light months during January and February.

Accounting for these fluctuations now will allow you to create a cash flow plan to

ensure bills get paid in slower months.

Now, it's time to get started building your statements.

In this type of video format, it's difficult to guide you step by step.

So I've provided some guidance and tools on this slide to get you started.

One thing to remember is that the three statements are all integrated with one

another, so changes to one statement will impact the others.

A general rule of thumb is that you should project out three to five years for

your proposed business.

I personally think three years is sufficient but

that'll depend on whom you're speaking with.

I also think it's helpful to detail year one on a month by month basis.

This will force you to think more bottom up in your approach.

Some resources to get you started can be found at the United States Small Business

Administration website, which is www.sba.gov.

It's also worth exploring the many templates which can be found in Excel

and online.

In fact, a simple Google search will give you access to thousands of

templates to follow.

You could also take a look at utilizing a number of different software solutions,

Live Plan and EZ Numbers are a couple that come to mind.

I will note that I'm not endorsing the use of these products, but

some people do find them helpful.

Also, it can be very advantageous to work with your accountant on this matter,

as they'll have a wealth of knowledge on line items that need to be accounted for

in this process.

To close out this lesson,

your job will be to create a peer-reviewed one-year income statement projection.

It's time to get to work.

[MUSIC]

Explorer notre catalogue

Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.

Coursera propose un accès universel à la meilleure formation au monde, en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.

© 2019 Coursera Inc. Tous droits réservés.

Télécharger dans l'App Store

Disponible sur Google Play