Prévisionnel au 06/01/2017

Embed Size (px)

Text of Prévisionnel au 06/01/2017

  • Ling-en Hsia, EIRL

    Business PlanPrepared January 2017

    Contact InformationLing-en Hsia

    lingen@solopreneur.fr

    http://solopreneur.fr

  • Ling-en Hsia, EIRL

    i

    Table of ContentsExecutive Summary ...............................................................................................................1

    Opportunity ....................................................................................................................1

    Expectations ....................................................................................................................1

    Opportunity.............................................................................................................................2

    Problem & Solution.......................................................................................................2

    Target Market .................................................................................................................2

    Competition ....................................................................................................................2

    Execution..................................................................................................................................3

    Marketing & Sales .........................................................................................................3

    Operations .......................................................................................................................3

    Milestones & Metrics ....................................................................................................3

    Company..................................................................................................................................4

    Overview .........................................................................................................................4

    Team .................................................................................................................................4

    Financial Plan..........................................................................................................................5

    Forecast.............................................................................................................................5

    Financing .........................................................................................................................7

    Statements .......................................................................................................................7

  • Ling-en Hsia, EIRL

    ii

    Appendix................................................................................................................................11

    Profit and Loss Statement ..........................................................................................11

    Balance Sheet ................................................................................................................15

    Cash Flow Statement...................................................................................................19

  • Ling-en Hsia, EIRL

    1

    Executive Summary

    Opportunity

    Problem

    Solution

    Market

    Competition

    Why Us?

    Expectations

    Forecast

    Financial Highlights by Year

    Financing Needed

  • Ling-en Hsia, EIRL

    2

    Opportunity

    Problem & Solution

    Problem Worth Solving

    Our Solution

    Target Market

    Competition

    Current Alternatives

    Our Advantages

  • Ling-en Hsia, EIRL

    3

    Execution

    Marketing & Sales

    Marketing Plan

    Sales Plan

    Operations

    Locations & Facilities

    Technology

    Equipment & Tools

    Milestones & Metrics

    Milestones Table

    Milestone Due Date Who's Responsible

    Rendre le manuscrit January 31, 2017

    Recrutement d'une assistante February 01, 2017 Ling-en

    Publication du livre May 31, 2017 Ling-en

    Key Metrics

  • Ling-en Hsia, EIRL

    4

    Company

    Overview

    Ownership & Structure

    Company History

    Team

    Management Team

    Advisors

  • Ling-en Hsia, EIRL

    5

    Financial Plan

    Forecast

    Key Assumptions

    Revenue by Month

    Expenses by Month

  • Ling-en Hsia, EIRL

    6

    Net Profit (or Loss) by Year

  • Ling-en Hsia, EIRL

    7

    Financing

    Use of Funds

    Sources of Funds

    Statements

    Projected Profit & Loss

    2017 2018 2019

    Revenue 83,549 109,251 126,597

    Direct Costs 3,238 6,732 7,724

    Gross Margin 80,311 102,519 118,873

    Gross Margin % 96% 94% 94%

    Operating Expenses

    Salary 3,000 300 400

    Employee Related Expenses

    Frais bancaires et administratifs 360 400 420

    Espace de Coworking 2,530 3,000 3,500

    Services internet + outils 5,400 5,400 5,400

    Transport et Restauration 1,800 1,800 1,800

    Prestataires 1,200 1,200 1,200

    Education (formation + livre) 1,200 1,200 1,200

    Rseau d'affaires 1,140 1,140 1,140

    Evnements (participation) 765 900 1,400

    Comptabilit 500 1,000 1,200

    Publicit 300 300 300

    Fournitures et matriels 600 600 600

    Assurance 0 500 1,000

    Total Operating Expenses 18,795 17,740 19,560

    Operating Income 61,516 84,779 99,313

    Interest Incurred

  • Ling-en Hsia, EIRL

    8

    Depreciation and Amortization

    Income Taxes 24,606 33,912 39,725

    Total Expenses 46,639 58,384 67,009

    Net Profit 36,910 50,867 59,588

    Net Profit / Sales 44% 47% 47%

  • Ling-en Hsia, EIRL

    9

    Projected Balance Sheet

    2017 2018 2019

    Cash 42,861 93,716 154,020

    Accounts Receivable 7,615 8,117 9,663

    Inventory

    Other Current Assets

    Total Current Assets 50,476 101,833 163,683

    Long-Term Assets

    Accumulated Depreciation

    Total Long-Term Assets

    Total Assets 50,476 101,833 163,683

    Accounts Payable 0 0 0

    Income Taxes Payable 8,252 8,557 9,972

    Sales Taxes Payable 5,316 5,503 6,351

    Short-Term Debt

    Prepaid Revenue (2) (4) (5)

    Total Current Liabilities 13,566 14,056 16,318

    Long-Term Debt

    Total Liabilities 13,566 14,056 16,318

    Paid-in Capital

    Retained Earnings 36,910 87,777

    Earnings 36,910 50,867 59,588

    Total Owner's Equity 36,910 87,777 147,365

    Total Liabilities & Equity 50,476 101,833 163,683

  • Ling-en Hsia, EIRL

    10

    Projected Cash Flow Statement

    2017 2018 2019

    Net Cash Flow from Operations

    Net Profit 36,910 50,867 59,588

    Depreciation and Amortization

    Change in Accounts Receivable (7,615) (502) (1,546)

    Change in Inventory

    Change in Accounts Payable 0 0 0

    Change in Income Tax Payable 8,252 305 1,415

    Change in Sales Tax Payable 5,316 187 848

    Change in Prepaid Revenue (2) (2) (1)

    Net Cash Flow from Operations 42,861 50,855 60,304

    Investing & Financing

    Assets Purchased or Sold

    Investments Received

    Change in Long-Term Debt

    Change in Short-Term Debt

    Dividends & Distributions

    Net Cash Flow from Investing & Financing

    Cash at Beginning of Period 0 42,861 93,716

    Net Change in Cash 42,861 50,855 60,304

    Cash at End of Period 42,861 93,716 154,020

  • Ling-en Hsia, EIRL

    11

    Appendix

    Profit and Loss Statement

    Profit and Loss Statement (With Monthly Detail)

    2017 Jan '17 Feb '17 Mar '17 Apr '17 May '17 Jun '17 Jul '17 Aug '17 Sep '17 Oct '17 Nov '17 Dec '17

    Revenue 5,182 6,498 7,456 7,715 9,228 5,518 2,044 5,956 7,371 8,761 9,353 8,467

    Direct Costs 81 134 321 149 425 258 140 155 455 262 548 310

    Gross Margin 5,101 6,364 7,135 7,566 8,803 5,260 1,904 5,801 6,916 8,499 8,805 8,157

    Gross Margin % 98% 98% 96% 98% 95% 95% 93% 97% 94% 97% 94% 96%

    Operating Expenses

    Salary 200 250 250 250 250 250 250 250 250 250 250 300

    Employee Related Expenses

    Frais bancaires et administratifs 250 10 10 10 10 10 10 10 10 10 10 10

    Espace de Coworking 230 230 230 230 230 230 0 230 230 230 230 230

    Services internet + outils 450 450 450 450 450 450 450 450 450 450 450 450

    Transport et Restauration 150 150 150 150 150 150 150 150 150 150 150 150

    Prestataires 100 100 100 100 100 100 100 100 100 100 100 100

  • Ling-en Hsia, EIRL

    12

    Education (formation + livre)

    100 100 100 100 100 100 100 100 100 100 100 100

    Rseau d'affaires 95 95 95 95 95 95 95 95 95 95 95 95

    Evnements (participation) 40 85 85 85 85 0 0 50 85 85 85 80

    Comptabilit 0 0 50 50 50 50 50 50 50 50 50 50

    Publicit 25 25 25 25 25 25 25 25 25 25 25 25

    Fournitures et matriels 50 50 50 50 50 50 50 50 50 50 50 50

    Assurance 0 0 0 0 0 0 0 0 0 0 0 0

    Total Operating Expenses 1,690 1,545 1,595 1,595 1,595 1,510 1,280 1,560 1,595 1,595 1,595 1,640

    Operating Income 3,411 4,819 5,540 5,971 7,208 3,750 624 4,241 5,321 6,904 7,210 6,517

    Interest Incurred

    Depreciation and Amortization

    Income Taxes 1,364 1,928 2,216 2,388 2,884 1,500 249 1,697 2,128 2,762 2,884 2,606

    Total Expenses 3,135 3,607 4,132 4,132 4,904 3,268 1,669 3,412 4,178 4,619 5,027 4,556

    Net Profit 2,047 2,891 3,324 3,583 4,324 2,250 375 2,544 3,193 4,142 4,326 3,911

    Net Profit / Sales 40% 44% 45% 46% 47% 41% 18% 43% 43% 47% 46% 46%

  • Ling-en Hsia, EIRL

    13

    2017 2018 2019

    Revenue 83,549 109,251 126,597

    Direct Costs 3,238 6,732 7,724

    Gross Marg