The company is seeking first round financing for the purpose of acquiring starting inventory of raw materials, purchasing land, building construction, utility hook-up and site improvement, machinery and equipment, working capital, legal and accounting, and miscellaneous start-up expenses. The company will require additional investment or loans for Phase II, set to begin during the fourth year of operation.
7.1 Important Assumptions
The following table outlines important assumptions for Fiberglass World.
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
39.17%
40.00%
39.17%
Other
0
0
0
7.2 Break-even Analysis
Break-even Analysis
Monthly Revenue Break-even
$275,977
Assumptions:
Average Percent Variable Cost
56%
Estimated Monthly Fixed Cost
$121,670
7.3 Projected Profit and Loss
The following table presents year-end profit and loss projections for Fiberglass World. For a monthly analysis, please see the appendix at the end of the plan.
Pro Forma Profit and Loss
Year 1
Year 2
Year 3
Sales
$5,952,000
$13,633,000
$13,633,000
Direct Cost of Sales
$3,327,942
$7,802,670
$7,617,112
Royalties
$0
$0
$2,044,800
Total Cost of Sales
$3,327,942
$7,802,670
$9,661,912
Gross Margin
$2,624,058
$5,830,330
$3,971,088
Gross Margin %
44.09%
42.77%
29.13%
Expenses
Payroll
$300,000
$380,000
$545,000
Sales and Marketing and Other Expenses
$857,541
$1,371,697
$1,605,710
Depreciation
$55,000
$55,000
$55,000
Leased Equipment
$15,000
$16,500
$18,150
Utilities
$50,000
$157,000
$180,550
Insurance
$109,500
$257,200
$422,920
Rent
$28,000
$35,000
$36,750
Payroll Taxes
$45,000
$57,000
$81,750
Other
$0
$0
$0
Total Operating Expenses
$1,460,041
$2,329,397
$2,945,830
Profit Before Interest and Taxes
$1,164,017
$3,500,933
$1,025,258
EBITDA
$1,219,017
$3,555,933
$1,080,258
Interest Expense
$53,413
$68,990
$82,250
Taxes Incurred
$431,700
$1,372,777
$369,345
Net Profit
$678,904
$2,059,166
$573,663
Net Profit/Sales
11.41%
15.10%
4.21%
7.4 Projected Cash Flow
The cash flow projections for Fiberglass World are outlined in the following table and chart.
Pro Forma Cash Flow
Year 1
Year 2
Year 3
Cash Received
Cash from Operations
Cash Sales
$5,952,000
$13,633,000
$13,633,000
Cash from Receivables
$0
$0
$0
Subtotal Cash from Operations
$5,952,000
$13,633,000
$13,633,000
Additional Cash Received
Sales Tax, VAT, HST/GST Received
$0
$0
$0
New Current Borrowing
$50,000
$85,000
$85,000
New Other Liabilities (interest-free)
$0
$0
$0
New Long-term Liabilities
$47,600
$47,600
$47,600
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
$6,049,600
$13,765,600
$13,765,600
Expenditures
Year 1
Year 2
Year 3
Expenditures from Operations
Cash Spending
$300,000
$380,000
$545,000
Bill Payments
$4,728,411
$11,048,606
$12,369,809
Subtotal Spent on Operations
$5,028,411
$11,428,606
$12,914,809
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
$17,000
$17,000
$17,000
Subtotal Cash Spent
$5,045,411
$11,445,606
$12,931,809
Net Cash Flow
$1,004,189
$2,319,994
$833,791
Cash Balance
$1,039,189
$3,359,183
$4,192,973
7.5 Projected Balance Sheet
The table below shows our projected balance sheet for three years. Monthly figures for the first year are included in the appendices.
Pro Forma Balance Sheet
Year 1
Year 2
Year 3
Assets
Current Assets
Cash
$1,039,189
$3,359,183
$4,192,973
Accounts Receivable
$0
$0
$0
Inventory
$320,314
$751,007
$733,147
Other Current Assets
$0
$0
$0
Total Current Assets
$1,359,503
$4,110,190
$4,926,120
Long-term Assets
Long-term Assets
$300,000
$300,000
$300,000
Accumulated Depreciation
$55,000
$110,000
$165,000
Total Long-term Assets
$245,000
$190,000
$135,000
Total Assets
$1,604,503
$4,300,190
$5,061,120
Liabilities and Capital
Year 1
Year 2
Year 3
Current Liabilities
Accounts Payable
$429,999
$950,920
$1,022,587
Current Borrowing
$100,000
$185,000
$270,000
Other Current Liabilities
$0
$0
$0
Subtotal Current Liabilities
$529,999
$1,135,920
$1,292,587
Long-term Liabilities
$523,600
$571,200
$618,800
Total Liabilities
$1,053,599
$1,707,120
$1,911,387
Paid-in Capital
$321,000
$321,000
$321,000
Retained Earnings
($449,000)
$212,904
$2,255,070
Earnings
$678,904
$2,059,166
$573,663
Total Capital
$550,904
$2,593,070
$3,149,733
Total Liabilities and Capital
$1,604,503
$4,300,190
$5,061,120
Net Worth
$550,904
$2,593,070
$3,149,733
7.6 Business Ratios
The following table outlines important ratios from the roofing, siding and insulation industry, as determined by the Standard Industry Classification (SIC) Index #5033, Roofing, Siding, and Insulation.
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.