The following sections will outline important financial assumptions.
7.1 Important Assumptions
The current economic climate in the U.S. appears to be on the brink of recession. However, we do not believe that if the country does enter a recession that our business will be unduly affected. Since our products are ones that help contribute to and maintain good health, we believe that people will continue to buy our products over traditional wheat bread. We are operating in a niche market, and in addition, the price of our breads and sweets although slightly higher than traditional bakeries they are not positioned as expensive, luxury items.
General Assumptions
Year 1
Year 2
Year 3
Plan Month
1
2
3
Current Interest Rate
9.00%
9.00%
9.00%
Long-term Interest Rate
8.50%
8.50%
8.50%
Tax Rate
25.42%
25.00%
25.42%
Other
0
0
0
7.2 Break-even Analysis
Our Break-Even Analysis includes running costs of production. These are fairly low since we manufacture all of our goods at a low cost to us. Here are the items included in the average percent variable cost:
Manufacturing ingredients, i.e. flour, sugar, yeast and butter.
Payroll.
Mortgage.
Utilities.
Advertising.
The Break-Even Analysis as it appears below indicates that the break-even point will be attainable each month.
Break-even Analysis
Monthly Revenue Break-even
$19,036
Assumptions:
Average Percent Variable Cost
36%
Estimated Monthly Fixed Cost
$12,271
7.3 Projected Profit and Loss
The following table shows the projected profit and loss for Morningstar Bakery.
Pro Forma Profit and Loss
Year 1
Year 2
Year 3
Sales
$251,700
$324,000
$400,000
Direct Cost of Sales
$89,450
$115,200
$142,000
Other
$0
$0
$0
Total Cost of Sales
$89,450
$115,200
$142,000
Gross Margin
$162,250
$208,800
$258,000
Gross Margin %
64.46%
64.44%
64.50%
Expenses
Payroll
$105,000
$115,500
$127,050
Sales and Marketing and Other Expenses
$13,040
$14,640
$16,640
Depreciation
$3,492
$3,492
$3,492
Utilities
$519
$600
$800
Insurance
$1,800
$2,400
$2,800
Mortgage
$10,800
$15,096
$15,096
Payroll Taxes
$12,600
$13,860
$15,246
Other
$0
$0
$0
Total Operating Expenses
$147,251
$165,588
$181,124
Profit Before Interest and Taxes
$14,999
$43,212
$76,876
EBITDA
$18,491
$46,704
$80,368
Interest Expense
$14,705
$14,705
$14,705
Taxes Incurred
($473)
$7,127
$15,802
Net Profit
$767
$21,380
$46,369
Net Profit/Sales
0.30%
6.60%
11.59%
7.4 Projected Cash Flow
The following chart illustrates a healthy cash balance for the first three years, enabling the company to grow through reinvestment.
Pro Forma Cash Flow
Year 1
Year 2
Year 3
Cash Received
Cash from Operations
Cash Sales
$251,700
$324,000
$400,000
Subtotal Cash from Operations
$251,700
$324,000
$400,000
Additional Cash Received
Sales Tax, VAT, HST/GST Received
$0
$0
$0
New Current Borrowing
$0
$0
$0
New Other Liabilities (interest-free)
$0
$0
$0
New Long-term Liabilities
$0
$0
$0
Sales of Other Current Assets
$0
$0
$0
Sales of Long-term Assets
$0
$0
$0
New Investment Received
$0
$0
$0
Subtotal Cash Received
$251,700
$324,000
$400,000
Expenditures
Year 1
Year 2
Year 3
Expenditures from Operations
Cash Spending
$105,000
$115,500
$127,050
Bill Payments
$128,199
$182,776
$219,845
Subtotal Spent on Operations
$233,199
$298,276
$346,895
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out
$0
$0
$0
Principal Repayment of Current Borrowing
$0
$0
$0
Other Liabilities Principal Repayment
$0
$0
$0
Long-term Liabilities Principal Repayment
$0
$0
$0
Purchase Other Current Assets
$0
$0
$0
Purchase Long-term Assets
$0
$0
$0
Dividends
$0
$0
$0
Subtotal Cash Spent
$233,199
$298,276
$346,895
Net Cash Flow
$18,501
$25,724
$53,105
Cash Balance
$30,593
$56,316
$109,421
7.5 Projected Balance Sheet
The following table represents the financial position of the Morningstar Bakery at the end of each of the three upcoming fiscal years.
Pro Forma Balance Sheet
Year 1
Year 2
Year 3
Assets
Current Assets
Cash
$30,593
$56,316
$109,421
Other Current Assets
$0
$0
$0
Total Current Assets
$30,593
$56,316
$109,421
Long-term Assets
Long-term Assets
$175,000
$175,000
$175,000
Accumulated Depreciation
$3,492
$6,984
$10,476
Total Long-term Assets
$171,508
$168,016
$164,524
Total Assets
$202,101
$224,332
$273,945
Liabilities and Capital
Year 1
Year 2
Year 3
Current Liabilities
Accounts Payable
$14,241
$15,093
$18,336
Current Borrowing
$0
$0
$0
Other Current Liabilities
$12,000
$12,000
$12,000
Subtotal Current Liabilities
$26,241
$27,093
$30,336
Long-term Liabilities
$173,000
$173,000
$173,000
Total Liabilities
$199,241
$200,093
$203,336
Paid-in Capital
$7,500
$7,500
$7,500
Retained Earnings
($5,408)
($4,641)
$16,740
Earnings
$767
$21,380
$46,369
Total Capital
$2,859
$24,240
$70,609
Total Liabilities and Capital
$202,101
$224,332
$273,945
Net Worth
$2,859
$24,240
$70,609
7.6 Business Ratios
Business ratios for the years of this plan are shown below. Industry profile ratios based on the Standard Industrial Classification (SIC) code 5461, Retail Bakeries, are shown for comparison.
Business planning has never been easier. With 500 complete sample plans, easy financials, and access anywhere, LivePlan turns your great idea into a great plan for success.