Prévisionnel au 06/01/2017

  • Published on
    21-Jan-2017

  • View
    141

  • Download
    1

Embed Size (px)

Transcript

<ul><li><p>Ling-en Hsia, EIRL</p><p>Business PlanPrepared January 2017</p><p>Contact InformationLing-en Hsia</p><p>lingen@solopreneur.fr</p><p>http://solopreneur.fr</p></li><li><p>Ling-en Hsia, EIRL</p><p>i</p><p>Table of ContentsExecutive Summary ...............................................................................................................1</p><p>Opportunity ....................................................................................................................1</p><p>Expectations ....................................................................................................................1</p><p>Opportunity.............................................................................................................................2</p><p>Problem &amp; Solution.......................................................................................................2</p><p>Target Market .................................................................................................................2</p><p>Competition ....................................................................................................................2</p><p>Execution..................................................................................................................................3</p><p>Marketing &amp; Sales .........................................................................................................3</p><p>Operations .......................................................................................................................3</p><p>Milestones &amp; Metrics ....................................................................................................3</p><p>Company..................................................................................................................................4</p><p>Overview .........................................................................................................................4</p><p>Team .................................................................................................................................4</p><p>Financial Plan..........................................................................................................................5</p><p>Forecast.............................................................................................................................5</p><p>Financing .........................................................................................................................7</p><p>Statements .......................................................................................................................7</p></li><li><p>Ling-en Hsia, EIRL</p><p>ii</p><p>Appendix................................................................................................................................11</p><p>Profit and Loss Statement ..........................................................................................11</p><p>Balance Sheet ................................................................................................................15</p><p>Cash Flow Statement...................................................................................................19</p></li><li><p>Ling-en Hsia, EIRL</p><p>1</p><p>Executive Summary</p><p>Opportunity</p><p>Problem</p><p>Solution</p><p>Market</p><p>Competition</p><p>Why Us?</p><p>Expectations</p><p>Forecast</p><p>Financial Highlights by Year</p><p>Financing Needed</p></li><li><p>Ling-en Hsia, EIRL</p><p>2</p><p>Opportunity</p><p>Problem &amp; Solution</p><p>Problem Worth Solving</p><p>Our Solution</p><p>Target Market</p><p>Competition</p><p>Current Alternatives</p><p>Our Advantages</p></li><li><p>Ling-en Hsia, EIRL</p><p>3</p><p>Execution</p><p>Marketing &amp; Sales</p><p>Marketing Plan</p><p>Sales Plan</p><p>Operations</p><p>Locations &amp; Facilities</p><p>Technology</p><p>Equipment &amp; Tools</p><p>Milestones &amp; Metrics</p><p>Milestones Table</p><p>Milestone Due Date Who's Responsible</p><p>Rendre le manuscrit January 31, 2017</p><p>Recrutement d'une assistante February 01, 2017 Ling-en</p><p>Publication du livre May 31, 2017 Ling-en</p><p>Key Metrics</p></li><li><p>Ling-en Hsia, EIRL</p><p>4</p><p>Company</p><p>Overview</p><p>Ownership &amp; Structure</p><p>Company History</p><p>Team</p><p>Management Team</p><p>Advisors</p></li><li><p>Ling-en Hsia, EIRL</p><p>5</p><p>Financial Plan</p><p>Forecast</p><p>Key Assumptions</p><p>Revenue by Month</p><p>Expenses by Month</p></li><li><p>Ling-en Hsia, EIRL</p><p>6</p><p>Net Profit (or Loss) by Year</p></li><li><p>Ling-en Hsia, EIRL</p><p>7</p><p>Financing</p><p>Use of Funds</p><p>Sources of Funds</p><p>Statements</p><p>Projected Profit &amp; Loss</p><p>2017 2018 2019</p><p>Revenue 83,549 109,251 126,597</p><p>Direct Costs 3,238 6,732 7,724</p><p>Gross Margin 80,311 102,519 118,873</p><p>Gross Margin % 96% 94% 94%</p><p>Operating Expenses</p><p>Salary 3,000 300 400</p><p>Employee Related Expenses</p><p>Frais bancaires et administratifs 360 400 420</p><p>Espace de Coworking 2,530 3,000 3,500</p><p>Services internet + outils 5,400 5,400 5,400</p><p>Transport et Restauration 1,800 1,800 1,800</p><p>Prestataires 1,200 1,200 1,200</p><p>Education (formation + livre) 1,200 1,200 1,200</p><p>Rseau d'affaires 1,140 1,140 1,140</p><p>Evnements (participation) 765 900 1,400</p><p>Comptabilit 500 1,000 1,200</p><p>Publicit 300 300 300</p><p>Fournitures et matriels 600 600 600</p><p>Assurance 0 500 1,000</p><p>Total Operating Expenses 18,795 17,740 19,560</p><p>Operating Income 61,516 84,779 99,313</p><p>Interest Incurred</p></li><li><p>Ling-en Hsia, EIRL</p><p>8</p><p>Depreciation and Amortization</p><p>Income Taxes 24,606 33,912 39,725</p><p>Total Expenses 46,639 58,384 67,009</p><p>Net Profit 36,910 50,867 59,588</p><p>Net Profit / Sales 44% 47% 47%</p></li><li><p>Ling-en Hsia, EIRL</p><p>9</p><p>Projected Balance Sheet</p><p>2017 2018 2019</p><p>Cash 42,861 93,716 154,020</p><p>Accounts Receivable 7,615 8,117 9,663</p><p>Inventory</p><p>Other Current Assets</p><p>Total Current Assets 50,476 101,833 163,683</p><p>Long-Term Assets</p><p>Accumulated Depreciation</p><p>Total Long-Term Assets</p><p>Total Assets 50,476 101,833 163,683</p><p>Accounts Payable 0 0 0</p><p>Income Taxes Payable 8,252 8,557 9,972</p><p>Sales Taxes Payable 5,316 5,503 6,351</p><p>Short-Term Debt</p><p>Prepaid Revenue (2) (4) (5)</p><p>Total Current Liabilities 13,566 14,056 16,318</p><p>Long-Term Debt</p><p>Total Liabilities 13,566 14,056 16,318</p><p>Paid-in Capital</p><p>Retained Earnings 36,910 87,777</p><p>Earnings 36,910 50,867 59,588</p><p>Total Owner's Equity 36,910 87,777 147,365</p><p>Total Liabilities &amp; Equity 50,476 101,833 163,683</p></li><li><p>Ling-en Hsia, EIRL</p><p>10</p><p>Projected Cash Flow Statement</p><p>2017 2018 2019</p><p>Net Cash Flow from Operations</p><p>Net Profit 36,910 50,867 59,588</p><p>Depreciation and Amortization</p><p>Change in Accounts Receivable (7,615) (502) (1,546)</p><p>Change in Inventory</p><p>Change in Accounts Payable 0 0 0</p><p>Change in Income Tax Payable 8,252 305 1,415</p><p>Change in Sales Tax Payable 5,316 187 848</p><p>Change in Prepaid Revenue (2) (2) (1)</p><p>Net Cash Flow from Operations 42,861 50,855 60,304</p><p>Investing &amp; Financing</p><p>Assets Purchased or Sold</p><p>Investments Received</p><p>Change in Long-Term Debt</p><p>Change in Short-Term Debt</p><p>Dividends &amp; Distributions</p><p>Net Cash Flow from Investing &amp; Financing</p><p>Cash at Beginning of Period 0 42,861 93,716</p><p>Net Change in Cash 42,861 50,855 60,304</p><p>Cash at End of Period 42,861 93,716 154,020</p></li><li><p>Ling-en Hsia, EIRL</p><p>11</p><p>Appendix</p><p>Profit and Loss Statement</p><p>Profit and Loss Statement (With Monthly Detail)</p><p>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</p><p>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</p><p>Direct Costs 81 134 321 149 425 258 140 155 455 262 548 310</p><p>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</p><p>Gross Margin % 98% 98% 96% 98% 95% 95% 93% 97% 94% 97% 94% 96%</p><p>Operating Expenses</p><p>Salary 200 250 250 250 250 250 250 250 250 250 250 300</p><p>Employee Related Expenses</p><p>Frais bancaires et administratifs 250 10 10 10 10 10 10 10 10 10 10 10</p><p>Espace de Coworking 230 230 230 230 230 230 0 230 230 230 230 230</p><p>Services internet + outils 450 450 450 450 450 450 450 450 450 450 450 450</p><p>Transport et Restauration 150 150 150 150 150 150 150 150 150 150 150 150</p><p>Prestataires 100 100 100 100 100 100 100 100 100 100 100 100</p></li><li><p>Ling-en Hsia, EIRL</p><p>12</p><p>Education (formation + livre)</p><p>100 100 100 100 100 100 100 100 100 100 100 100</p><p>Rseau d'affaires 95 95 95 95 95 95 95 95 95 95 95 95</p><p>Evnements (participation) 40 85 85 85 85 0 0 50 85 85 85 80</p><p>Comptabilit 0 0 50 50 50 50 50 50 50 50 50 50</p><p>Publicit 25 25 25 25 25 25 25 25 25 25 25 25</p><p>Fournitures et matriels 50 50 50 50 50 50 50 50 50 50 50 50</p><p>Assurance 0 0 0 0 0 0 0 0 0 0 0 0</p><p>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</p><p>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</p><p>Interest Incurred</p><p>Depreciation and Amortization</p><p>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</p><p>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</p><p>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</p><p>Net Profit / Sales 40% 44% 45% 46% 47% 41% 18% 43% 43% 47% 46% 46%</p></li><li><p>Ling-en Hsia, EIRL</p><p>13</p><p>2017 2018 2019</p><p>Revenue 83,549 109,251 126,597</p><p>Direct Costs 3,238 6,732 7,724</p><p>Gross Margin 80,311 102,519 118,873</p><p>Gross Margin % 96% 94% 94%</p><p>Operating Expenses</p><p>Salary 3,000 300 400</p><p>Employee Related Expenses</p><p>Frais bancaires et administratifs 360 400 420</p><p>Espace de Coworking 2,530 3,000 3,500</p><p>Services internet + outils 5,400 5,400 5,400</p><p>Transport et Restauration 1,800 1,800 1,800</p><p>Prestataires 1,200 1,200 1,200</p><p>Education (formation + livre) 1,200 1,200 1,200</p><p>Rseau d'affaires 1,140 1,140 1,140</p><p>Evnements (participation) 765 900 1,400</p><p>Comptabilit 500 1,000 1,200</p><p>Publicit 300 300 300</p><p>Fournitures et matriels 600 600 600</p><p>Assurance 0 500 1,000</p><p>Total Operating Expenses 18,795 17,740 19,560</p><p>Operating Income 61,516 84,779 99,313</p><p>Interest Incurred</p></li><li><p>Ling-en Hsia, EIRL</p><p>14</p><p>Depreciation and Amortization</p><p>Income Taxes 24,606 33,912 39,725</p><p>Total Expenses 46,639 58,384 67,009</p><p>Net Profit 36,910 50,867 59,588</p><p>Net Profit / Sales 44% 47% 47%</p></li><li><p>Ling-en Hsia, EIRL</p><p>15</p><p>Balance Sheet</p><p>Balance Sheet (With Monthly Detail)</p><p>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</p><p>Cash (217) 4,717 10,885 8,830 16,522 24,715 17,610 19,521 25,042 25,300 33,849 42,857</p><p>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</p><p>Inventory</p><p>Other Current Assets</p><p>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</p><p>Long-Term Assets</p><p>Accumulated Depreciation</p><p>Total Long-Term Assets</p><p>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</p><p>Accounts Payable 0 0 0 0 0 0 0 0 0 0 0 0</p><p>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</p><p>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</p><p>Short-Term Debt</p><p>Prepaid Revenue 0 (1) (2) (2) (2) (2) (2) (3) (3) (3) (3) (3)</p><p>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</p></li><li><p>Ling-en Hsia, EIRL</p><p>16</p><p>Long-Term Debt</p><p>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</p><p>Paid-in Capital</p><p>Retained Earnings</p><p>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</p><p>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</p><p>Total Liabilities &amp; 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</p></li><li><p>Ling-en Hsia, EIRL</p><p>17</p><p>2017 2018 2019</p><p>Cash 42,861 93,716 154,020</p><p>Accounts Receivable 7,615 8,117 9,663</p><p>Inventory</p><p>Other Current Assets</p><p>Total Current Assets 50,476 101,833 163,683</p><p>Long-Term Assets</p><p>Accumulated Depreciation</p><p>Total Long-Term Assets</p><p>Total Assets 50,476 101,833 163,683</p><p>Accounts Payable 0 0 0</p><p>Income Taxes Payable 8,252 8,557 9,972</p><p>Sales Taxes Payable 5,316 5,503 6,351</p><p>Short-Term Debt</p><p>Prepaid Revenue (2) (4) (5)</p><p>Total Current Liabilities 13,566 14,056 16,318</p><p>Long-Term Debt</p><p>Total Liabilities 13,566 14,056 16,318</p><p>Paid-in Capital</p><p>Retained Earnings 36,910 87,777</p><p>Earnings 36,910 50,867 59,588</p><p>Total Owner's Equity 36,910 87,777 147,365</p></li><li><p>Ling-en Hsia, EIRL</p><p>18</p><p>Total Liabilities &amp; Equity 50,476 101,833 163,683</p></li><li><p>Ling-en Hsia, EIRL</p><p>19</p><p>Cash Flow Statement</p><p>Cash Flow Statement (With Monthly Detail)</p><p>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</p><p>Net Cash Flow from Operations</p><p>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</p><p>Depreciation and Amortization</p><p>Change in Accounts Receivable</p><p>(4,664) (1,184) (862) (234) (1,362) 3,340 3,126 (3,520) (1,275) (1,249) (531) 797</p><p>Change in Inventory</p><p>Change in Accounts Payable</p><p>0 0 0 0 0 0 0 0 0 0 0 0</p><p>Change in Income Tax Payable</p><p>1,364 1,928 2,216 (3,120) 2,884 1,500 (6,523) 1,697 2,128 (1,312) 2,884 2,606</p><p>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</p><p>Change in Prepaid Revenue 0 (1) (1) 0 0 0 0 (1) 0 0 0 0</p><p>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</p><p>Investing &amp; Financing</p><p>Assets Purchased or Sold</p></li><li><p>Ling-en Hsia, EIRL</p><p>20</p><p>Investments Received</p><p>Change in Long-Term Debt</p><p>Change in Short-Term Debt</p><p>Dividends &amp; Distributions</p><p>Net Cash Flow from Investing &amp; Financing</p><p>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</p><p>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</p><p>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</p></li><li><p>Ling-en Hsia, EIRL</p><p>21</p><p>2017 2018 2019</p><p>Net Cash Flow from Operations</p><p>Net Profit 36,910 50,867 59,588</p><p>Depreciation and Amortization</p><p>Change in Accounts Receivable (7,615) (502) (1,546)</p><p>Change in Inventory</p><p>Change in Accounts Payable 0 0 0</p><p>Change in Income Tax Payable 8,252 305 1,415</p><p>Change in Sales Tax Payable 5,316 187 848</p><p>Change in Prepaid Revenue (2) (2) (1)</p><p>Net Cash Flow from Operations 42,861 50,855 60,304</p><p>Investing &amp; Financing</p><p>Assets Purchased or Sold</p><p>Investments Received</p><p>Change in Long-Term Debt</p><p>Change in Short-Term Debt</p><p>Dividends &amp; Distributions</p><p>Net Cash Flow from Investing &amp; Financing</p><p>Cash at Beginning of Period 0 42,861 93,716</p><p>Net Change in Cash 42,861 50,855 60,304</p><p>Cash at End of Period 42,861 93,716 154,020</p><p>Executive Summary Opportunity Problem Solution Market Competition Why Us? </p><p>Expectations Forecast Financial Highlights by Year Financing Needed </p><p> Opportunity Problem &amp; Solution Problem Worth Solving Our Solution </p><p>Target Market Competition Current Alternatives Our Advantages </p><p> Execution Marketing &amp; Sales Marketing Plan Sales Plan </p><p>Operations Locations &amp; Facilities Technology Equipment &amp; Tools </p><p>Milestones &amp; Metrics Milestones Table Key Metrics </p><p> Company Overview Ownership &amp; Structure Company History </p><p>Team Management Team Advisors </p><p> Financial Plan Forecast Key Assumptions Revenue by Month Expenses by Month Net Profit (or Loss) by Year </p><p>Financing Use of Funds Sources of Funds </p><p>Statements Projected Profit &amp; Loss Projected Balance Sheet Projected Cash Flow Statement </p><p>Appendix Profit and Loss Statement Profit and Loss Statement (With Monthly Detail) </p><p>Balance Sheet Balance Sheet (With Monthly Detail) </p><p>Cash Flow Statement Cash Flow Statement (With Monthly Detail) </p><p>LastPageBookmark</p></li></ul>