Before you get started on this exercise, you will need the textbook (Chapter 16- The Financials), the Business Plan Financials Guide and Excel document, and NAB Company Portfolio.
This Assignment has two sections:
Section I: The Business Plan financials (Excel document)- complete this first
Using your NAB Company Portfolio and the first year of your business plan for the company, you will complete all the worksheets in the entire 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.
Notes:
The setup and marketing worksheet should already be completed from assignment 2.
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).
VIDEO GUIDE TO COMPLETING THE EXCEL DOCUMENT
To submit: Attach the completed Excel worksheet to the discussion thread (click on the Add Content button under the Post button to access the attachment option when you are ready to submit, attach your document and then click submit)
Section II: Financial section of the business plan (type in a Word document and paste in the discussion window). 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 do you plan to use the funds (a clear plan on how you will use the money)
Notes: Before addressing this section please review:
-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.
-The Cap Invest (Capital Investments and loans worksheet) in the Excel document
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.
Notes: Before addressing this section please review:
Article about the 5 key assumptions of your business plan. https://www.thebalancesmb.com/question-key-assumptions-in-your-business-plan-1200853
Sample plan in your textbook page 326
Assumption sheet in your textbook page 313.
3.Break-even analysis
The break-even point is where you make enough money in revenue to pay your expenses but you do not make money nor you do not lose money. In this section, you need to determine what this break-even point is.
Notes: Before addressing this section please review:
-Page 314 in the textbook about break-even analysis
-The BrkEvn (Break-Even) worksheet in your Excel document. You would have calculated this there.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. My Essay Gram is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download