Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Safety Auditing A Management Tool

Authors: Donald W. Kase

1st Edition

0471289035, 978-0471289036

More Books

Students also viewed these Accounting questions

Question

Types of Interpersonal Relationships?

Answered: 1 week ago

Question

Self-Disclosure and Interpersonal Relationships?

Answered: 1 week ago