Question
Assignment 3: Business plan Draft Financials For this assignment you will gather and assemble the financial information that will be included in your formal business
Assignment 3: Business plan Draft Financials For this assignment you will gather and assemble the financial information that will be included in your formal business plan. You will use the financial spreadsheets Excel workbook to complete this task. Using the spreadsheets contained in the workbook file, you will input the numbers and financial figures required to create various financial statements and schedules. The workbook file includes the formulas used to calculate various figures and totals. Your task is to complete all of the spreadsheets in the workbook by inputting the required information. Step-by-step instructions on where to input required information and numbers are provided in the workbook file. Please remember that the numbers that you enter on the spreadsheets should be real, that is obtained from reference source (e.g. the price of a piece of office furniture that you found on a website that sells office furniture). Any estimates you include should be realistic in that you should be able to justify them or demonstrate that they are reasonable. To get started: Proceed to the Draft Financial Plan section below, which describes the tasks you will undertake to assemble the financial information necessary to complete the Financial Plan section of your formal business plan, which you will submit for Assignment 4. Open the Business plan Word document. Review the Financial Plan section and List of Tables to familiarize yourself with the kinds of financial information that you will include in your completed formal Business Plan (Assignment 4). Open the Financial Spreadsheets Excel workbook (your working copy). Go to the ControlPanel worksheet and read the instructions provided. Next, review all of the spreadsheets contained in the workbook to familiarize yourself with the structure of the workbook and the content of the different spreadsheets, including the kinds of information and numbers you will be inputting. Now you are ready to start inputting information. Research (look up) current prices and costs of various items and services included on the spreadsheets. Keep track of the source of this information. An example of a table tool you can use to keep track of this information is provided in the Operations Plan Section of the Business plan Word document (page 9). For Assignment 3 submit: 1. your completed Financial Spreadsheets Excel workbook 2. a separate Excel workbook or Word document that includes that includes the source information for prices/costs included in your spreadsheets. You can present this information in the form of a table, following the example tables included in the Business plan Word document (for example, see page 9).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started