• Author / Uploaded
• avinashr139

Citation preview

Business Plan Workbook https://www.vertex42.com/WordTemplates/business-plan-template.html

© 2016 Vertex42 LLC

About This Template The purpose of this workbook is to provide examples of tables, charts, and financial statements that can and should be customized. For comments and questions about this template, you may contact Vertex42.com via email. See the link above to return to the web page that describes this template. Using This Template In most cases, cells with white backgrounds and/or gray borders are for manual entry. Gray and blue filled cells are calculated for you. Pasting Tables and Charts into Word Pasting tables from Excel to Word Use Copy/Paste to copy a table from Excel to Word. This will typically paste the data as a formatted and editable table in Word, though none of the formulas will be functional within Word (and the table will not be linked to Excel). If you don't want the table to be editable in Word, you can "Paste as a Picture" using Paste Special or by choosing the "Picture" option when you right-click in the document to paste the table.

Pasting charts from Excel to Word When you paste a chart object into your business plan, make sure to "Paste as a Picture" because pasting the chart as an embedded object means that the entire spreadsheet becomes embedded in your Word document (even though what you see is only the chart). Additional Resources Each worksheet includes a resources section with helpful templates, links and references. Terms of Use By Vertex42.com https://www.vertex42.com/WordTemplates/business-plan.html

© 2016 Vertex42 LLC This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws. Do not submit copies or modifications of this template to any website or online template gallery. Please review the following license agreement to learn how you may or may not use this template. Thank you. License Agreement https://www.vertex42.com/licensing/EULA_privateuse.html

Highlight Charts

Highlights

$350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 Year 1

Sales

X-Axis Label Year 1 Year 2 Year 3

Sales $100,000 $200,000 $300,000

Startup Requirements Expenses 117,000 Assets 100,000 Surplus (17,000)

Year 2 Costs

Costs $75,000 $145,000 $175,000

Year 3 Net Profit

Net Profit $25,000 $55,000 $125,000

Start-up Requirements Start-up Expenses Fixed Costs Legal and Permits Stationery and Supplies Insurance Rent Office Equipment Website Development Print Advertisements Brochures Total Fixed Costs Average Monthly Costs Rent Utilities Salaries / Wages Total Average Monthly Costs x Number of Months: Total Monthly Costs Total Startup Expenses Start-up Assets Owner Funding Owner 1 Cash Owner 2 Cash Other Total Owner Funding Loans Bank Loan 1 Bank Loan 2 Other Total Loans Other Grant 1 Grant 2 Other Total Other Funding Total Start-up Assets

$5,000 $3,000 $10,000 $2,000 $5,000 $5,000 $10,000 $5,000 $45,000 $2,000 $5,000 $5,000 $12,000 6 $72,000 $117,000

$50,000 $50,000 $100,000 $0 $0 $0 $0 $0 $0 $100,000

3-Year Profit and Loss INCOME Operating Income Category 1 Category 2 Category 3 Category 4 Total Operating Income (OI) Non-Operating Income Interest Income Rental Income Gifts Received Donations Total Non-Operating Income

2012 % of OI

2013 % of OI -

$0

$0

-

$0

-

$0

-

$0

-

$0

-

$0

-

$0

-

Total EXPENSES

$0

-

$0

-

$0

-

Net Income Before Taxes Income Tax Expense

$0

$0

$0

NET INCOME

$0

$0

$0

Owner Distributions / Dividends Adjustment to Retained Earnings

$0

$0

$0

Total INCOME EXPENSES Operating Expenses Accounting and Legal Advertising Depreciation Dues and Subscriptions Insurance Interest Expense Maintenance and Repairs Office Supplies Payroll Expenses Postage Rent Research and Development Salaries and Wages Taxes and Licenses Telephone Travel Utilities Web Hosting and Domains Total Operating Expenses Non-Recurring Expenses Furniture, Equipment & Software Gifts Given Total Non-Recurring Expenses

-

$0

$0

-

$0

-

2014 % of OI

$0

$0

$0

-

$0

Budget INCOME Operating Income Category 1 Category 2 Category 3 Category 4

Actual

Total Operating Income Non-Operating Income Interest Income Rental Income Gifts Received Donations Total Non-Operating Income Total INCOME EXPENSES Operating Expenses Accounting and Legal Advertising Depreciation Dues and Subscriptions Insurance Interest Expense Maintenance and Repairs Office Supplies Payroll Expenses Postage Rent Research and Development Salaries and Wages Taxes and Licenses Telephone Travel Utilities Web Hosting and Domains Total Operating Expenses Non-Recurring Expenses Furniture, Equipment and Software Gifts Given Total Non-Recurring Expenses Total EXPENSES Net Income Before Taxes Income Tax Expense NET INCOME

Budget

$0

$0 $0

$0

Difference

$0

$0 $0 $0 $0 $0

$0 $0

$0 $0 $0 $0 $0 $0

$0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0

$0 $0 $0

$0

$0

$0 $0 $0 $0 $0 $0 $0

Market Analysis Customers Segment Young Couples Older Couples Families Total

Growth 5.0% 7.0% 5.0% 5.67%

Year 1 25,000 30,000 45,000 100,000

Year 2 26,250 32,100 47,250 105,600

Year 3 27,563 34,347 49,613 111,523

Year 4 28,941 36,751 52,094 117,786

Year 5 30,388 39,324 54,699 124,411

Market Analysis 60,000 50,000 40,000

Young Couples Older Couples Families

30,000 20,000 10,000 0 Year 1

Year 2

Year 3

Year 4

Year 5

CAGR 5.00% 7.00% 5.00% 5.67%

12-Month Sales Forecast Product Product 1 Product 2 Product 3 Product 4 Total

Month 1 Month 2 Month 3 10,000 10,000 10,000 18,000 18,000 18,000 10,000 10,000 10,000 2,000 2,000 2,000 40,000 40,000 40,000

Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 10,000 10,000 8,000 8,000 8,000 9,000 10,000 10,000 10,000 18,000 18,000 18,000 20,000 20,000 20,000 25,000 25,000 25,000 10,000 10,000 10,000 15,000 15,000 15,000 20,000 20,000 20,000 2,000 2,000 2,000 2,000 2,000 3,000 3,000 3,000 3,000 40,000 40,000 38,000 45,000 45,000 47,000 58,000 58,000 58,000

12-Month Sales Forecast 70,000 60,000 50,000 40,000 30,000 20,000 10,000 0 1 2 5 6 8 9 3 4 7 10 12 11 th th th th th th th th th h h h n n n n n n n n t t n t o o o o o o o o o on on on M M M M M M M M M M M M

Product 4 Product 3 Product 2 Product 1

3-Year Sales Forecast 3-Year Sales Forecast

$700,000 $600,000 $500,000

Product 4 Product 3 Product 2 Product 1

$400,000 $300,000 $200,000 $100,000 $0 Year 1

Year 2

Year 3

Number of Sales Product 1 Product 2 Product 3 Product 4 Total

Year 1 326 194 140 48 708

Year 2 360 229 168 61 818

Year 3 400 253 187 74 914

Unit Price Product 1 Product 2 Product 3 Product 4 Total

Year 1 $379 $824 $1,145 $675 $3,023

Year 2 $417 $828 $1,185 $677 $3,107

Year 3 $399 $825 $1,202 $713 $3,139

Unit Cost of Sales Product 1 Product 2 Product 3 Product 4 Total

Year 1 $235 $432 $519 $301 $1,487

Year 2 $230 $403 $492 $273 $1,398

Year 3 $195 $389 $465 $288 $1,337

Total Sales Product 1 Product 2 Product 3 Product 4 Total

Year 1 $123,554 $159,856 $160,300 $32,400 $476,110

Year 2 $150,120 $189,612 $199,080 $41,297 $580,109

Year 3 $159,600 $208,725 $224,774 $52,762 $645,861

Total Costs Product 1 Product 2 Product 3 Product 4 Total

Year 1 Year 2 Year 3 $76,610 $82,800 $78,000 $83,808 $92,287 $98,417 $72,660 $82,656 $86,955 $14,448 $16,653 $21,312 $247,526 $274,396 $284,684

TOTAL NET SALES Product 1 Product 2 Product 3 Product 4 Total

Year 1 Year 2 Year 3 $46,944 $67,320 $81,600 $76,048 $97,325 $110,308 $87,640 $116,424 $137,819 $17,952 $24,644 $31,450 $228,584 $305,713 $361,177

1-Year Monthly Sales Forecast - 2 Products First Month:

1/16/2016

Year 1 Units Sold

Jan-16

Feb-16

Mar-16

Apr-16

May-16

Jun-16

Jul-16

Aug-16

Sep-16

Oct-16

Nov-16

Dec-16

Total Units Sold

Product/Service A

500

525

550

575

550

525

525

550

575

600

650

650

6775

Product/Service B

1500

1000

1000

1250

1250

1500

1500

1750

2000

2500

3000

3000

21250

Unit Price

Avg Unit Price

Product/Service A

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

Product/Service B

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

Product/Service A

0%

5%

5%

5%

-4%

-5%

0%

5%

5%

4%

8%

0%

2%

Product/Service B

0%

-33%

0%

25%

0%

20%

0%

17%

14%

25%

20%

0%

8%

Product/Service A

$9,995

$10,495

$10,995

$11,494

$10,995

$10,495

$10,495

$10,995

$11,494

$11,994

$12,994

$12,994

$135,432

Product/Service B

$22,485

$14,990

$14,990

$18,738

$18,738

$22,485

$22,485

$26,233

$29,980

$37,475

$44,970

$44,970

$318,538

Total Revenue

$32,480

$25,485

$25,985

$30,232

$29,732

$32,980

$32,980

$37,227

$41,474

$49,469

$57,964

$57,964

$453,970

Product/Service A

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.00

$4.00

$4.00

$4.38

Product/Service B

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

Product/Service A

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.99

$15.99

$15.99

$15.62

Product/Service B

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

Product/Service A

$7,745

$8,132

$8,520

$8,907

$8,520

$8,132

$8,132

$8,520

$8,907

$9,594

$10,394

$10,394

$105,895

Product/Service B

$17,835

$11,890

$11,890

$14,863

$14,863

$17,835

$17,835

$20,808

$23,780

$29,725

$35,670

$35,670

$252,663

Total Gross Profit

$25,580

$20,022

$20,410

$23,769

$23,382

$25,967

$25,967

$29,327

$32,687

$39,319

$46,064

$46,064

$358,557

Sales Growth Rate

Avg Growth Rate

Revenue

Total Revenue

Unit COGS

Avg COGS

Margin Per Unit

Avg Margin

Gross Profit

Total

1-Year Monthly Sales Forecast - 3 Products First Month:

1/16/2016

Year 1 Units Sold

Jan-16

Feb-16

Mar-16

Apr-16

May-16

Jun-16

Jul-16

Aug-16

Sep-16

Oct-16

Nov-16

Dec-16

Total Units Sold

Product/Service A

500

525

550

575

550

525

525

550

575

600

650

650

6775

Product/Service B

1500

1000

1000

1250

1250

1500

1500

1750

2000

2500

3000

3000

21250

Product/Service C

150

200

250

300

350

400

400

350

350

300

300

300

3650

Product/Service A

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

$19.99

Product/Service B

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

$14.99

Product/Service C

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

$49.99

Product/Service A

0%

5%

5%

5%

-4%

-5%

0%

5%

5%

4%

8%

0%

2%

Product/Service B

0%

-33%

0%

25%

0%

20%

0%

17%

14%

25%

20%

0%

8%

Product/Service C

0%

33%

25%

20%

17%

14%

0%

-13%

0%

-14%

0%

0%

7%

Product/Service A

$9,995

$10,495

$10,995

$11,494

$10,995

$10,495

$10,495

$10,995

$11,494

$11,994

$12,994

$12,994

$135,432

Product/Service B

$22,485

$14,990

$14,990

$18,738

$18,738

$22,485

$22,485

$26,233

$29,980

$37,475

$44,970

$44,970

$318,538

Product/Service C

$7,499

$9,998

$12,498

$14,997

$17,497

$19,996

$19,996

$17,497

$17,497

$14,997

$14,997

$14,997

$182,464

Total Revenue

$39,979

$35,483

$38,482

$45,229

$47,229

$52,976

$52,976

$54,724

$58,971

$64,466

$72,961

$72,961

$636,433

Product/Service A

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.50

$4.00

$4.00

$4.00

$4.38

Product/Service B

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

$3.10

Product/Service C

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

$1.55

Product/Service A

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.49

$15.99

$15.99

$15.99

$15.62

Product/Service B

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

$11.89

Product/Service C

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

$48.44

Product/Service A

$7,745

$8,132

$8,520

$8,907

$8,520

$8,132

$8,132

$8,520

$8,907

$9,594

$10,394

$10,394

$105,895

Product/Service B

$17,835

$11,890

$11,890

$14,863

$14,863

$17,835

$17,835

$20,808

$23,780

$29,725

$35,670

$35,670

$252,663

Product/Service C

$7,266

$9,688

$12,110

$14,532

$16,954

$19,376

$19,376

$16,954

$16,954

$14,532

$14,532

$14,532

$176,806

Total Gross Profit

$32,846

$29,710

$32,520

$38,301

$40,336

$45,343

$45,343

$46,281

$49,641

$53,851

$60,596

$60,596

$535,363

Unit Price

Avg Unit Price

Sales Growth Rate

Avg Growth Rate

Revenue

Total Revenue

Unit COGS

Avg COGS

Margin Per Unit

Avg Margin

Gross Profit

Total

Milestones 15 6/ / 4

2 5/

15 6/

1 7/

15 5/

15 3/ / 9

5 5 6 6 6 6 /1 /1 3 2 /1 /1 /1 /1 2 1 1 1 0 9 / / 2 3 1 2 10 12 1/ 3/ 5/ 6/

Milestone #1 Milestone #2 Milestone #3 Milestone #4 Milestone #5 Milestone #6

Milestone Milestone #1 Milestone #2 Milestone #3 Milestone #4 Milestone #5 Milestone #6 Total

Start Date 9/15/2015 10/15/2015 11/14/2015 12/14/2015 1/13/2016 2/12/2016

Duration 60 60 60 120 120 30

End Date 11/14/2015 12/14/2015 1/13/2016 4/12/2016 5/12/2016 3/13/2016

Budget $10,000 $20,000 $30,000 $20,000 $10,000 $20,000 $110,000

Invisible 0 42,292 42,322 42,352 42,382 42,412

3-Year Sales Forecast Year 1

Year 2

Year 3

Product/Service A

6775

7500

8850

11%

18%

Product/Service B

21250

27250

33750

28%

24%

Product/Service C

3650

4375

5500

20%

26%

Total Units Sold

Yr 2 vs Yr 1

Yr 3 vs Yr 2

% Change

Avg Unit Price

Difference

Product/Service A

$19.99

$19.99

$19.99

$0.00

$0.00

Product/Service B

$14.99

$14.99

$14.99

$0.00

$0.00

Product/Service C

$49.99

$54.99

$59.99

$5.00

$5.00

Avg Sales Growth Rate

Difference

Product/Service A

2%

1%

2%

-1%

1%

Product/Service B

8%

6%

4%

-2%

-2%

Product/Service C

8%

2%

3%

-6%

1%

Total Revenue

Difference

Product/Service A

$135,432

$149,925

$176,912

$14,493

$26,987

Product/Service B

$318,538

$408,478

$505,913

$89,940

$97,435

Product/Service C

$182,464

$240,581

$329,945

$58,117

$89,364

Total Revenue

$636,434

$798,984

$1,012,770

$162,550

$213,786

Avg Unit COGS

Difference

Product/Service A

$4.38

$4.08

$3.75

($0.30)

($0.33)

Product/Service B

$3.10

$3.05

$3.01

($0.05)

($0.04)

Product/Service C

$1.55

$1.51

$1.36

($0.04)

($0.15)

Avg Margin Per Unit

Difference

Product/Service A

$15.62

$15.91

$16.24

$0.29

$0.33

Product/Service B

$11.89

$11.94

$11.98

$0.05

$0.04

Product/Service C

$48.44

$53.48

$58.63

$5.04

$5.15

Total Gross Profit

Difference

Product/Service A

$105,895

$119,431

$143,868

$13,536

$24,437

Product/Service B

$252,663

$326,003

$405,188

$73,340

$79,185

Product/Service C

$176,806

$234,025

$322,613

$57,219

$88,588

Total Gross Profit

$535,364

$679,459

$871,669

$144,095

$192,210

Balance Sheet Assets Current Assets Cash Accounts receivable Inventory Prepaid expenses Short-term investments

2017

2016

$11,874

Total current assets Fixed (Long-Term) Assets Long-term investments Property, plant, and equipment (Less accumulated depreciation) Intangible assets

$11,874

$0

$1,208 $15,340 -$2,200 Total fixed assets

$14,348

$0

Total Other Assets

$0 $26,222

$0 $0

Other Assets Deferred income tax Other Total Assets Liabilities and Owner's Equity Current Liabilities Accounts payable Short-term loans Income taxes payable Accrued salaries and wages Unearned revenue Current portion of long-term debt

$8,060 $3,145

Total current liabilities Long-Term Liabilities Long-term debt Deferred income tax

$11,205

$0

$3,450 Total long-term liabilities

Owner's Equity Owner's investment Retained earnings Total owner's equity Total Liabilities and Owner's Equity Common Financial Ratios Debt Ratio (Total Liabilities / Total Assets) Current Ratio (Current Assets / Current Liabilities) Working Capital (Current Assets - Current Liabilities) Assets-to-Equity Ratio (Total Assets / Owner's Equity) Debt-to-Equity Ratio (Total Liabilities / Owner's Equity)

$3,450 $7,178 $4,389 $11,567 $26,222

0.56 1.06 669 2.27 1.27

$0

$0 $0 {42}

-

Cash Flow Projection CASH BALANCE Date Ending Cash at Beginning of Period Cash at End of Period

2015 9/3/2015 $5,000 $5,000

2016 9/3/2016 $5,000 $5,000

2017 9/3/2017 $5,000 $5,000

CASH INFLOWS Cash from Operations Receipts from Customers Gross Rents Total Cash from Operations Cash from Financing Issuance of Stock Borrowing Total Cash from Financing Cash from Investing Sale of Property and Equipment Collection of Principal on Loans Sale of Investment Securities Total Cash from Investing Total Cash Inflows

2015

2016

2017

$0

$0

$0

$0

$0

$0

$0 $0

$0 $0

$0 $0

CASH OUTFLOWS Operations Wages Inventory Purchases General Operating Expenses Interest Income Taxes Total Outflows from Operations Financing Repayment of Loans Repurchase of Stocks Dividends Paid Total Outflows from Financing Investing Purchase of Property and Equipment Making Loans to Other Entities Purchase of Investment Securities Total Outflows from Investing Total Cash Outflows

2015

2016

2017

$0

$0

$0

$0

$0

$0

$0 $0

$0 $0

$0 $0

$0

$0

$0

NET CASH FLOW

Break-Even Analysis Selling Price (per unit) FIXED COSTS Advertising Accounting Insurance Manufacturing Payroll Rent Supplies Taxes Utilities Other (specify) Total Fixed Costs VARIABLE COSTS Variable Costs based on dollar amount per unit Cost of Goods Sold Direct Labor Overhead Other (specify) Total Variable Costs based on percentage per unit Commissions Other (specify) Total Total Variable Cost per Unit Contribution Margin per Unit Contribution Margin Ratio Break-Even Point Break-Even Units Break-Even Sales

$12.00

$1,000.00

$1,000.00 Per Unit $1.00

$1.00

7.50% 0 $1.90 $10.10 84.17%

100 units $1,188.12