The following sections will outline the important financial data.
7.1 Important Assumptions
The following table details important financial assumptions for BOG.
General Assumptions
Year 1
Year 2
Year 3
Plan Month
1
2
3
Current Interest Rate
10.00%
10.00%
10.00%
Long-term Interest Rate
10.00%
10.00%
10.00%
Tax Rate
25.42%
25.00%
25.42%
Other
0
0
0
7.2 Break-even Analysis
The Break-even Analysis indicates BOG will need to sell approximately $4,900 in baskets per month to break even.
Break-even Analysis
Monthly Revenue Break-even
$4,915
Assumptions:
Average Percent Variable Cost
34%
Estimated Monthly Fixed Cost
$3,223
7.3 Projected Profit and Loss
The following table will indicate projected profit and loss.
Pro Forma Profit and Loss
Year 1
Year 2
Year 3
Sales
$43,545
$93,319
$109,910
Direct Cost of Sales
$14,989
$26,328
$34,022
Other
$0
$0
$0
Total Cost of Sales
$14,989
$26,328
$34,022
Gross Margin
$28,556
$66,991
$75,888
Gross Margin %
65.58%
71.79%
69.05%
Expenses
Payroll
$31,500
$39,000
$39,000
Sales and Marketing and Other Expenses
$1,200
$1,200
$1,200
Depreciation
$655
$672
$672
Leased Equipment
$0
$0
$0
Utilities
$0
$0
$0
Insurance
$600
$600
$600
Rent
$0
$0
$0
Payroll Taxes
$4,725
$5,850
$5,850
Other
$0
$0
$0
Total Operating Expenses
$38,680
$47,322
$47,322
Profit Before Interest and Taxes
($10,124)
$19,669
$28,566
EBITDA
($9,469)
$20,341
$29,238
Interest Expense
$0
$0
$0
Taxes Incurred
$0
$4,917
$7,261
Net Profit
($10,124)
$14,752
$21,305
Net Profit/Sales
-23.25%
15.81%
19.38%
7.4 Projected Cash Flow
The following chart and table will indicate projected cash flow.
Pro Forma Cash Flow
Year 1
Year 2
Year 3
Cash Received
Cash from Operations
Cash Sales
$43,545
$93,319
$109,910
Subtotal Cash from Operations
$43,545
$93,319
$109,910
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
$43,545
$93,319
$109,910
Expenditures
Year 1
Year 2
Year 3
Expenditures from Operations
Cash Spending
$31,500
$39,000
$39,000
Bill Payments
$18,916
$44,238
$49,978
Subtotal Spent on Operations
$50,416
$83,238
$88,978
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
$50,416
$83,238
$88,978
Net Cash Flow
($6,871)
$10,081
$20,932
Cash Balance
$15,779
$25,860
$46,792
7.5 Projected Balance Sheet
The following table will indicate the projected balance sheet.
Pro Forma Balance Sheet
Year 1
Year 2
Year 3
Assets
Current Assets
Cash
$15,779
$25,860
$46,792
Inventory
$3,507
$6,160
$7,960
Other Current Assets
$0
$0
$0
Total Current Assets
$19,286
$32,020
$54,752
Long-term Assets
Long-term Assets
$2,000
$2,000
$2,000
Accumulated Depreciation
$655
$1,327
$1,999
Total Long-term Assets
$1,345
$673
$1
Total Assets
$20,631
$32,693
$54,753
Liabilities and Capital
Year 1
Year 2
Year 3
Current Liabilities
Accounts Payable
$6,105
$3,415
$4,170
Current Borrowing
$0
$0
$0
Other Current Liabilities
$0
$0
$0
Subtotal Current Liabilities
$6,105
$3,415
$4,170
Long-term Liabilities
$0
$0
$0
Total Liabilities
$6,105
$3,415
$4,170
Paid-in Capital
$28,000
$28,000
$28,000
Retained Earnings
($3,350)
($13,474)
$1,278
Earnings
($10,124)
$14,752
$21,305
Total Capital
$14,526
$29,278
$50,584
Total Liabilities and Capital
$20,631
$32,693
$54,753
Net Worth
$14,526
$29,278
$50,584
7.6 Business Ratios
The ratios table compares BOG's estimated growth, balance and profit ratios to the industry standard for Miscellaneous personal services (Standard Industry Code #7299).
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.