The World's Leading Business Plan Template Directory

, / 35245 0

Ecommerce Business Plan Template [2020 Updated]

SHARE

IX. Financial Plan


You can download our Business Plan Template (including a full, customizable financial model) to your computer here.

Revenue and Cost Drivers

[Company Name]’s revenues will come from the sale of baby and feminine products.

The major costs for the company will be cost of goods, internet connection fees,and salaries of the staff. In the initial years, the company’s marketing spend will be high, as it establishes itself in the market.

Capital Requirements and Use of Funds

[Company Name is seeking a total funding of $430,000 to launch its business. The capital will be used for funding capital expenditures, manpower costs, marketing expenses and working capital.

Specifically, these funds will be used as follows:

  • Website design/build and startup business expenses: approximately $120,000
  • Working capital: approximately $310,000 to pay for Marketing, salaries, and lease costs until [Company Name] reaches break-even

Key Assumptions & Forecasts

Below please find the key assumptions that went into the financial forecast and a summary of the financial projections over the next five years.

Number of customers per dayPer location
Year 14
Year 24
Year 35
Year 45
Year 55
Average order price$32
Annual increase in order price6.00%
Annual Lease ( per location)$25,000
Yearly Lease Increase %2.50%

 
5 Year Annual Income Statement

  Year 1Year 2Year 3Year 4Year 5
Revenues
Product/Service A$151,200 $333,396 $367,569 $405,245 $446,783
Product/Service B$100,800 $222,264 $245,046 $270,163 $297,855
Total Revenues$252,000 $555,660 $612,615 $675,408 $744,638
Expenses & Costs
Cost of goods sold$57,960 $122,245 $122,523 $128,328 $134,035
Lease$60,000 $61,500 $63,038 $64,613 $66,229
Marketing$20,000 $25,000 $25,000 $25,000 $25,000
Salaries$133,890 $204,030 $224,943 $236,190 $248,000
Other Expenses$3,500 $4,000 $4,500 $5,000 $5,500
Total Expenses & Costs$271,850 $412,775 $435,504 $454,131 $473,263
EBITDA($19,850)$142,885 $177,112 $221,277 $271,374
Depreciation$36,960 $36,960 $36,960 $36,960 $36,960
EBIT($56,810)$105,925 $140,152 $184,317 $234,414
Interest$23,621 $20,668 $17,716 $14,763 $11,810
PRETAX INCOME($80,431)$85,257 $122,436 $169,554 $222,604
Net Operating Loss($80,431)($80,431)$0$0$0
Income Tax Expense$0$1,689 $42,853 $59,344 $77,911
NET INCOME($80,431)$83,568 $79,583 $110,210 $144,693
Net Profit Margin (%)-15.00%13.00%16.30%19.40%

 
5 Year Annual Balance Sheet

  Year 1Year 2Year 3Year 4Year 5
ASSETS
Cash$16,710 $90,188 $158,957 $258,570 $392,389
Accounts receivable$0$0$0$0$0
Inventory$21,000 $23,153 $25,526 $28,142 $31,027
Total Current Assets$37,710 $113,340 $184,482 $286,712 $423,416
Fixed assets$246,450 $246,450 $246,450 $246,450 $246,450
Depreciation$36,960 $73,920 $110,880 $147,840 $184,800
Net fixed assets$209,490 $172,530 $135,570 $98,610 $61,650
TOTAL ASSETS$247,200 $285,870 $320,052 $385,322 $485,066
LIABILITIES & EQUITY
Debt$317,971 $272,546 $227,122 $181,698 $136,273
Accounts payable$9,660 $10,187 $10,210 $10,694 $11,170
Total Liabilities$327,631 $282,733 $237,332 $192,391 $147,443
Share Capital$0$0$0$0$0
Retained earnings($80,431)$3,137 $82,720 $192,930 $337,623
Total Equity($80,431)$3,137 $82,720 $192,930 $337,623
TOTAL LIABILITIES & EQUITY$247,200 $285,870 $320,052 $385,322 $485,066

 
5 Year Annual Cash Flow Statement

 Year 1Year 2Year 3Year 4Year 5
CASH FLOW FROM OPERATIONS
Net Income (Loss)($80,431)$83,568 $79,583 $110,210 $144,693
Change in working capital($11,340)($1,625)($2,350)($2,133)($2,409)
Depreciation$36,960 $36,960 $36,960 $36,960 $36,960
Net Cash Flow from Operations($54,811)$118,902 $114,193 $145,037 $179,244
CASH FLOW FROM INVESTMENTS
Investment($246,450)$0$0$0$0
Net Cash Flow from Investments($246,450)$0$0$0$0
CASH FLOW FROM FINANCING
Cash from equity$0$0$0$0$0
Cash from debt$317,971 ($45,424)($45,424)($45,424)($45,424)
Net Cash Flow from Financing$317,971 ($45,424)($45,424)($45,424)($45,424)
SUMMARY
Net Cash Flow$16,710 $73,478 $68,769 $99,613 $133,819
Cash at Beginning of Period$0$16,710 $90,188 $158,957 $258,570
Cash at End of Period$16,710 $90,188 $158,957 $258,570 $392,389

 

You can download our Business Plan Template (including a full, customizable financial model) to your computer here.

 

Pages : 1 2 3 4 5 6 7 8 9 10