This Assignment has two sections: The Excel document and the written portion of the financials (sources and use of funds, plan assumption, and break-even analysis) as described below. I will attached the background information on the Zerocol company, the required excel spreadsheet that needs to be completed, and the “portfolio” for reference.
Section I: The Business Plan financials (Excel document)
Using Zerocol info attached, you will complete all the worksheets in the Excel document (atatched)in order, so that you can complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the Business Plan Financials spreadsheet. (Parts of this worksheet are already filled out, so the rest will need to be filled out according to those)
Section II: Financial section of the business plan
You will have 3 headings as outlined below:
1.Sources and use of funds: Outline the funds you have currently (see “portfolio” pages 4-8, attached) and the ones you intend to raise (you need to raise funds per the “portfolio” page 4). Explain how you plan to use the funds (a clear plan for how you will use the money).
2. Plan assumptions: The Financial plan must be based on decisions and facts. Investors want to know if this plan is realistic. In this section you will outline your plan assumptions.
3. Break-even analysis: The break-even point is the point at which you make enough money in revenue to pay your expenses, but no profit (or loss). In this section, clarify what the break-even number is for year one (average). You will extract this information from the Break-even tab in the Excel document.