The World's Leading Business Plan Template Directory

, / 3667 0

Ice Cream Shop Business Plan Template [Updated 2021]

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

The revenues for [Company Name] will come from the sales of the all-natural artisanal ice cream and smoothies that will be offered to its customers.

The Company will have dine-in and take-out options for its customers. As the company grows and revenues are able to support it, the store will add a drive-thru window as another option of serving its customer base.

The major costs for the company will be sourcing the fresh ingredients and production of the ice cream. Other cost drivers will be the salaries of the staff, company overhead, and advertising costs.

Capital Requirements and Use of Funds

[Company Name] is seeking $200,000 in funding to launch its ice cream store. The capital will be used for funding capital expenditures, staffing, marketing and advertising expenses, and working capital.

The breakout of the funding may be seen below:

  • Store design/build-out: $75,000
  • Ice cream making and vending equipment: $95,000
  • Marketing and advertising: $10,000
  • Staffing costs: $10,000
  • Working capital: $10,000

Key Assumptions

The following table reflects the key revenue and cost assumptions made in the financial model:

Number of customers per dayPer location
FY 1100
FY 2105
FY 3110
FY 4116
FY 5122
Average order price$7.00
Annual increase in order price5.00%
Annual Lease ( per location)$60,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