2023 This Assignment has two sections The Excel document and the written portion of the financials sources and use of funds | Assignments Online

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:

 

(ALL EXCEL WORKSHEETS MUST BE COMPLETED WITH RELEVANT DATA FOR UpTown Swirl) ****You will complete the remaining of the Excel Worksheets****

SECTION I: THE BUSINESS PLAN FINANCIALS (EXCEL DOCUMENT)

Using your NAB Company Portfolio and the first year of your business plan for the company, YOU WILL COMPLETE ALL THE WORKSHEETS IN THE EXCEL DOCUMENT IN ORDER, so that you can complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the Business Plan Financials spreadsheet. 

 

The setup and marketing worksheet should already be completed from Assignment 2. (see excel worksheet attachment)

Use the instructions provided in the Business Plan Financials Guide to help you complete this document, as well as the NAB Portfolio (pages 4-8). (see attachment of completed worksheet)

SECTION II: FINANCIAL SECTION OF THE BUSINESS PLAN (COMPOSE AS A WORD DOCUMENT AND PASTE IN THE DISCUSSION WINDOW) 

Your response should have three headings, each focusing on an aspect of the Sources and Use of Funds, Plans Assumptions, and Break-Even Analysis.

You will have 3 headings as outlined below:

1.Sources and use of funds: Outline the funds you have currently (see portfolio pages 4 and 8) 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).

Sources and Use of Funds section on page 312 of your textbook-Sample plan on page 325 for an idea on how to address this section. (see attachment page 325)

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. (see attachment page 326)

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.

Remark: Write clearly, concisely, use proper grammar and writing mechanics. You must use APA format and cite (3) references.