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

Réseau d'affaires €1,140 €1,140 €1,140

Evénements (participation) €765 €900 €1,400

Comptabilité €500 €1,000 €1,200

Publicité €300 €300 €300

Fournitures et matériels €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

Réseau d'affaires €95 €95 €95 €95 €95 €95 €95 €95 €95 €95 €95 €95

Evénements (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 matériels €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 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

Réseau d'affaires €1,140 €1,140 €1,140

Evénements (participation) €765 €900 €1,400

Comptabilité €500 €1,000 €1,200

Publicité €300 €300 €300

Fournitures et matériels €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

14

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

15

Balance Sheet

Balance Sheet (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

Cash (€217) €4,717 €10,885 €8,830 €16,522 €24,715 €17,610 €19,521 €25,042 €25,300 €33,849 €42,857

Accounts Receivable €4,664 €5,848 €6,710 €6,944 €8,306 €4,966 €1,840 €5,360 €6,635 €7,884 €8,415 €7,618

Inventory

Other Current Assets

Total Current Assets €4,447 €10,565 €17,595 €15,774 €24,828 €29,681 €19,450 €24,881 €31,677 €33,184 €42,264 €50,475

Long-Term Assets

Accumulated Depreciation

Total Long-Term Assets

Total Assets €4,447 €10,565 €17,595 €15,774 €24,828 €29,681 €19,450 €24,881 €31,677 €33,184 €42,264 €50,475

Accounts Payable €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0

Income Taxes Payable €1,364 €3,292 €5,508 €2,388 €5,272 €6,772 €249 €1,946 €4,074 €2,762 €5,646 €8,252

Sales Taxes Payable €1,036 €2,336 €3,827 €1,543 €3,389 €4,492 €409 €1,600 €3,075 €1,752 €3,622 €5,316

Short-Term Debt

Prepaid Revenue €0 (€1) (€2) (€2) (€2) (€2) (€2) (€3) (€3) (€3) (€3) (€3)

Total Current Liabilities €2,400 €5,627 €9,333 €3,929 €8,659 €11,262 €656 €3,543 €7,146 €4,511 €9,265 €13,565

Ling-en Hsia, EIRL

16

Long-Term Debt

Total Liabilities €2,400 €5,627 €9,333 €3,929 €8,659 €11,262 €656 €3,543 €7,146 €4,511 €9,265 €13,565

Paid-in Capital

Retained Earnings

Earnings €2,047 €4,938 €8,262 €11,845 €16,169 €18,419 €18,794 €21,338 €24,531 €28,673 €32,999 €36,910

Total Owner's Equity €2,047 €4,938 €8,262 €11,845 €16,169 €18,419 €18,794 €21,338 €24,531 €28,673 €32,999 €36,910

Total Liabilities & Equity €4,447 €10,565 €17,595 €15,774 €24,828 €29,681 €19,450 €24,881 €31,677 €33,184 €42,264 €50,475

Ling-en Hsia, EIRL

17

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

Ling-en Hsia, EIRL

18

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

Ling-en Hsia, EIRL

19

Cash Flow Statement

Cash Flow 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

Net Cash Flow from Operations

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

Depreciation and Amortization

Change in Accounts Receivable

(€4,664) (€1,184) (€862) (€234) (€1,362) €3,340 €3,126 (€3,520) (€1,275) (€1,249) (€531) €797

Change in Inventory

Change in Accounts Payable

€0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0

Change in Income Tax Payable

€1,364 €1,928 €2,216 (€3,120) €2,884 €1,500 (€6,523) €1,697 €2,128 (€1,312) €2,884 €2,606

Change in Sales Tax Payable €1,036 €1,300 €1,491 (€2,284) €1,846 €1,103 (€4,083) €1,191 €1,475 (€1,323) €1,870 €1,694

Change in Prepaid Revenue €0 (€1) (€1) €0 €0 €0 €0 (€1) €0 €0 €0 €0

Net Cash Flow from Operations (€217) €4,934 €6,168 (€2,055) €7,692 €8,193 (€7,105) €1,911 €5,521 €258 €8,549 €9,008

Investing & Financing

Assets Purchased or Sold

Ling-en Hsia, EIRL

20

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 (€217) €4,717 €10,885 €8,830 €16,522 €24,715 €17,610 €19,521 €25,042 €25,300 €33,849

Net Change in Cash (€217) €4,934 €6,168 (€2,055) €7,692 €8,193 (€7,105) €1,911 €5,521 €258 €8,549 €9,008

Cash at End of Period (€217) €4,717 €10,885 €8,830 €16,522 €24,715 €17,610 €19,521 €25,042 €25,300 €33,849 €42,857

Ling-en Hsia, EIRL

21

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