• Author / Uploaded
• MD Rakib Mia

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 549,500 Assets 170,000 Surplus (379,500)

Year 2 Costs

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

Year 3 Net Profit

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

Market Analysis Customers Segment Adult professional Families Total

Growth 17.0% 7.0% 5.0% 9.67%

Year 1 30,000 30,000 45,000 105,000

Year 2 35,000 32,100 47,250 114,350

Year 3 40,000 34,347 49,613 123,960

Market Analysis 60,000 50,000

45,000

40,000 30,000

30,000 30,000

47,250

35,000 32,100

49,613

54,699 52,09450,000 45,000

40,000 34,347

36,751

39,324

20,000 10,000 0

Year 1

Year 2 Year 3 Year 4 Year 5 Adult professional Families

Year 4 45,000 36,751 52,094 133,845

Year 5 50,000 39,324 54,699 144,023

CAGR 14.00% 7.00% 5.00% 8.67%

Milestones 15 6/ / 4

2 5/

15 6/

1 7/

15 5/

15 3/ / 9

5 5 6 6 6 6 /1 /1 2 3 /1 /1 /1 /1 2 1 1 1 0 9 / / 2 3 2 1 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

12-Month Sales Forecast Product Kuihtiram Total

Month 1 Month 2 Month 3 10,000 20,000 30,000 10,000 20,000 30,000

Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 40,000 50,000 60,000 70,000 80,000 90,000 100,000 110,000 120,000 40,000 50,000 60,000 70,000 80,000 90,000 100,000 110,000 120,000

12-Month Sales Forecast 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 1 3 4 5 6 7 9 2 8 10 11 12 th th th th th th th th th h th th on on on on on on on on on ont n n o o M M M M M M M M M M M M

3-Year Sales Forecast 3-Year Sales Forecast

$180,000 $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0 Year 1

Year 2

Year 3

Number of Sales Kuihtiram Total

Year 1 150 150

Year 2 200 200

Year 3 350 350

Unit Price Kuihtiram Total

Year 1 $480 $480

Year 2 $480 $480

Year 3 $480 $480

Unit Cost of Sales Kuihtiram Total

Year 1 $270 $270

Year 2 $270 $270

Year 3 $270 $270

Total Sales Kuihtiram Total

Year 1 $72,000 $72,000

Year 2 Year 3 $96,000 $168,000 $96,000 $168,000

Total Costs Kuihtiram Total

Year 1 $40,500 $40,500

Year 2 $54,000 $54,000

Year 3 $94,500 $94,500

TOTAL NET SALES Kuihtiram Total

Year 1 $31,500 $31,500

Year 2 $42,000 $42,000

Year 3 $73,500 $73,500

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

Kuihtiram

1000

1020

1040

1060

1080

1100

1120

1140

1160

1180

1200

1220

13320

Unit Price Kuihtiram

Avg Unit Price $510.00

$510.00

$510.00

$510.00

$510.00

$510.00

$510.00

$510.00

$510.00

$510.00

$510.00

$510.00

0%

2%

2%

2%

2%

2%

2%

2%

2%

2%

2%

2%

Kuihtiram

$510,000

$520,200

$530,400

$540,600

$550,800

$561,000

$571,200

$581,400

$591,600

$601,800

$612,000

$622,200

$6,793,200

Total Revenue

$510,000

$520,200

$530,400

$540,600

$550,800

$561,000

$571,200

$581,400

$591,600

$601,800

$612,000

$622,200

$6,793,200

$300.00

$300.00

$300.00

$300.00

$300.00

$300.00

$300.00

$300.00

$300.00

$300.00

$300.00

$300.00

$210.00

$210.00

$210.00

$210.00

$210.00

$210.00

$210.00

$210.00

$210.00

$210.00

$210.00

$210.00

Sales Growth Rate Kuihtiram

Avg Growth Rate

Revenue

Avg COGS

Margin Per Unit Kuihtiram

2% Total Revenue

Unit COGS Kuihtiram

$510.00

$300.00 Avg Margin

Gross Profit

$210.00 Total

Kuihtiram

$210,000

$214,200

$218,400

$222,600

$226,800

$231,000

$235,200

$239,400

$243,600

$247,800

$252,000

$256,200

$2,797,200

Total Gross Profit

$210,000

$214,200

$218,400

$222,600

$226,800

$231,000

$235,200

$239,400

$243,600

$247,800

$252,000

$256,200

$2,797,200

3-Year Sales Forecast Year 1

Year 2

Year 3

13320

14000

14500

Total Units Sold

Kuihtiram

5%

4%

Difference $510.00

$520.00

$520.00

Avg Sales Growth Rate Kuihtiram

Yr 3 vs Yr 2

% Change

Avg Unit Price Kuihtiram

Yr 2 vs Yr 1

$10.00

$0.00

Difference 2%

6%

6%

Total Revenue

4%

0%

Difference

Kuihtiram

$6,793,200

$7,280,000

$7,540,000

$486,800

$260,000

Total Revenue

$6,793,200

$7,280,000

$7,540,000

$486,800

$260,000

Avg Unit COGS Kuihtiram

Difference $300.00

$320.00

$320.00

$210.00

$200.00

$200.00

Avg Margin Per Unit Kuihtiram

$20.00

$0.00

Difference

Total Gross Profit

($10.00)

$0.00

Difference

Kuihtiram

$2,797,200

$2,800,000

$2,900,000

$2,800

$100,000

Total Gross Profit

$2,797,200

$2,800,000

$2,900,000

$2,800

$100,000

Start-up Requirements Start-up Expenses Fixed Costs Legal and Permits Stationery and Supplies Insurance Rent Office Equipment Website Development Facebook boosting Advertisements 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৳ 500৳ 36,000৳ 8,000৳ 45,000৳ 15,000৳ 20,000৳ 129,500৳ 10,000৳ 15,000৳ 10,000৳ 35,000৳ 12৳ 420,000৳ 549,500৳

120,000৳ - ৳ 120,000৳ 50,000৳ - ৳ - ৳ 50,000৳ - ৳ - ৳ - ৳ - ৳ 170,000৳

3-Year Profit and Loss INCOME 2012 % of OI Operating Income Kuihtiram $6,793,200 100.0% Total Operating Income (OI) $6,793,200 100.0% Non-Operating Income Interest Income $0 Rental Income $0 Gifts Received $0 Donations $0 Total Non-Operating Income $0

Total INCOME

$6,793,200

EXPENSES Operating Expenses Accounting and Legal $100,000 Advertising $300,000 Depreciation $50,080 Dues and Subscriptions $100,000 Insurance $0 Interest Expense $110,000 Maintenance and Repairs $800,000 Office Supplies $1,000,000 Payroll Expenses $110,000 Postage $200,000 Rent $150,000 Research and Development $100,000 Salaries and Wages $500,000 Taxes and Licenses $200,000 Telephone $100,000 Travel $650,000 Utilities $1,500,000 Web Hosting and Domains $300,000 Total Operating Expenses $6,270,080 Non-Recurring Expenses Furniture, Equipment & Software $0 Gifts Given $0 Total Non-Recurring Expenses $0

Total EXPENSES Net Income Before Taxes Income Tax Expense

NET INCOME Owner Distributions / Dividends Adjustment to Retained Earnings

$6,270,080

2013 % of OI $7,280,000 $7,280,000

2014 % of OI

100.0% 100.0%

$0 $0 $0 $0 $0

$7,540,000 $7,540,000

100.0% 100.0%

$0 $0 $0 $0 $0

100.0%

$7,280,000

100.0%

$7,540,000

100.0%

1.5% 4.4% 0.7% 1.5% 1.6% 11.8% 14.7% 1.6% 2.9% 2.2% 1.5% 7.4% 2.9% 1.5% 9.6% 22.1% 4.4% 92.3%

$100,000 $400,000 $55,000 $69,000 $0 $55,000 $700,000 $1,200,000 $100,000 $5,850 $160,000 $120,000 $700,000 $250,000 $120,000 $700,000 $1,690,000 $400,000 $6,824,850

1.4% 5.5% 0.8% 0.9% 0.8% 9.6% 16.5% 1.4% 0.1% 2.2% 1.6% 9.6% 3.4% 1.6% 9.6% 23.2% 5.5% 93.7%

$90,000 $450,000 $60,000 $72,000 $0 $60,000 $750,000 $1,500,000 $150,000 $0 $170,000 $150,000 $750,000 $60,000 $150,000 $900,000 $1,700,000 $350,000 $7,362,000

1.2% 6.0% 0.8% 1.0% 0.8% 9.9% 19.9% 2.0% 2.3% 2.0% 9.9% 0.8% 2.0% 11.9% 22.5% 4.6% 97.6%

-

$0 $0 $0

-

$0 $0 $0

-

92.3%

$6,824,850

93.7%

$7,362,000

97.6%

$523,120

$455,150

$178,000

$523,120

$455,150

$178,000

$10,000 $513,120

$12,000 $443,150

$12,500 $165,500

Balance Sheet Assets Current Assets Cash Accounts receivable Inventory Prepaid expenses others

2017

2016

$15,990 $7,200 $9,720 $0 $450,000 $482,910

$48,810 $9,600 $12,960 $0 $500,000 $571,370

$0 $70,000 -$12,000

$75,000 -$13,500

Total fixed assets

$58,000

$61,500

Total Other Assets

$549,500 $549,500 $1,090,410

$0 $632,870

Total current liabilities

$7,290 $340,000 $0 $347,290

$9,720 $120,000 $0 $129,720

Total long-term liabilities

$50,000 $0 $50,000

$0 $0 $0

Total current assets Fixed (Long-Term) Assets Long-term investments Property, plant, and equipment (Less accumulated depreciation) Intangible assets Other Assets Deferred income tax Other Total Assets Liabilities and Owner's Equity Current Liabilities Accounts payable Short-term loans Current portion of long-term debt Long-Term Liabilities Long-term debt Deferred income tax Owner's Equity Owner's investment paid up capital 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)

$120,000 $60,000 $513,120 $693,120 $1,090,410

0.36 1.39 135,620 1.57 0.57

$60,000 $443,150 $503,150 $632,870 {42} 0.20 4.40 441,650 1.26 0.26

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

2015 9/3/2015 $170,000 $15,990

2016 9/3/2016 $15,990 $48,810

2017 9/3/2017 $48,810 $48,120

CASH INFLOWS 2015 Cash from Operations Receipts from Customers $64,800 others $600,000 Total Cash from Operations $664,800 Cash from Financing Preliminary loans $50,000 short term loans $340,000 Total Cash from Financing $390,000 Cash from Investing Sale of Property and Equipment $0 Additional investment $60,000 Total Cash from Investing $60,000 Total Cash Inflows $1,114,800

2016

2017

$86,400 $650,000 $736,400

$151,200 $700,000 $851,200

$0 $120,000 $120,000

$0 $0 $0

$0 $60,000 $60,000 $916,400

$0 $67,000 $67,000 $918,200

2016

2017

$700,000 $55,080 $0 $55,000

$750,000 $96,390 $0 $60,000

$810,080

$906,390

$12,000 $12,000

$12,500 $12,500

$61,500

$0

$0 $61,500 $883,580

$0 $0 $918,890

$32,820

-$690

CASH OUTFLOWS 2015 Operations Wages $500,000 Inventory Purchases (85%) $41,310 General Operating Expenses $0 Interest $110,000 Income Taxes Total Outflows from Operations $651,310 Financing Repayment of Loans Repurchase of Stocks Dividends Paid $10,000 Total Outflows from Financing $10,000 Investing Purchase of Property and Equipment $58,000 Making Loans to Other Entities Purchase of other preliminary assets $549,500 Total Outflows from Investing $607,500 Total Cash Outflows $1,268,810 NET CASH FLOW

-$154,010

Budget INCOME Operating Income Kuihtiram 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

Actual

Budget $6,793,200 $6,793,200

Difference $7,000,000 $7,000,000

-$206,800 -$206,800

$0 $6,793,200

$0 $7,000,000

$0 $0 $0 $0 $0 -$206,800

$100,000 $300,000 $50,080 $100,000 $0 $110,000 $800,000 $1,000,000 $110,000 $200,000 $150,000 $100,000 $500,000 $200,000 $100,000 $650,000 $1,500,000 $300,000 $6,270,080

$100,000 $500,000 $50,000 $100,000 $50,000 $200,000 $1,000,000 $500,000 $100,000 $100,000 $200,000 $150,000 $100,000 $250,000 $200,000 $1,000,000 $2,000,000 $50,000 $6,650,000

$0 -$200,000 $80 $0 -$50,000 -$90,000 -$200,000 $500,000 $10,000 $100,000 -$50,000 -$50,000 $400,000 -$50,000 -$100,000 -$350,000 -$500,000 $250,000 -$379,920

$0 $6,270,080 $523,120

$50,000 $10,000 $60,000 $6,710,000 $290,000

$523,120

$290,000

-$50,000 -$10,000 -$60,000 -$439,920 $233,120 $0 $233,120

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

$510.00

$300,000.00

$10,000.00 $110,000.00 $150,000.00 $1,000,000.00 $1,500,000.00 $3,070,000.00 Per Unit $300.00 $0.00 $0.00 $300.00

8.00% 0 $340.80 $169.20 33.18%

18,145 units $9,253,546.10