The World's Leading Business Plan Template Directory

, / 34481 0

Bar Business Plan Template [2020 Updated]

SHARE

IX. Financial Plan


You can download the Bar 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 alcohol and food to its customers.

The major costs for the company will be food production costs 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 $406,645 to launch its bar. The capital will be used for funding capital expenditures, manpower costs, marketing expenses and working capital.

Specifically, these funds will be used as follows:

  • Bar design/build: $262,200
  • Working capital: $144,445 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 1100
Year 2105
Year 3110
Year 4116
Year 5122
Average tab$45.00
Annual Lease ( per location)$70,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 the Bar business plan template (including a full, customizable financial model) to your computer here.

 

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