This discussion is worth 80 points and it is part of your Course Project. You will earn 70 points for the PIN (written section+Excel – only if you submit both) and 10 points for each substantive comment.
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: The Excel document and the written portion of the financials (sources and use of funds, plan assumption, break-even analysis) as described below.
Section I: The Business Plan financials (Excel document)- complete this first
To help you address this section see the attached tutorial (pdf)
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).
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:
To help you address this section:
Video explaining how to complete the written portion of your Financials
https://cdnapisec.kaltura.com/index.php/extwidget/preview/partner_id/956951/uiconf_id/38285871/entry_id/1_4wqh9n6r/embed/dynamic
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.
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:
The setup and assumptions sheet in your Excel document.
Sample plan in your textbook page 326
Assumption sheet in your textbook page 313.
Article about the 5 key assumptions of your business plan. https://www.thebalancesmb.com/question-key-assumptions-in-your-business-plan-1200853
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.
Final notes:
You will use the Excel document in Assignment 3 and 5.
You will use the written portion of your Financials in Assignment 5.
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
