Draft business plan into financial forecasts

Assignment Help Business Management

Reference no: EM133370489

"Developing Business Plan".

You are to do the Cash flow statement and Income statement only in the excel.

These questions are number 2 & 3 in the word document attached.

N.B: what you just have to do is to edit the data for cash flow statement and income statement.

The purpose of this assignment is to express all aspects of your draft business plan into financial forecasts to enable you to determine the likelihood of financial success and to determine what, if any, modifications you will need to make before finalizing the business plan.

Considerations:

1. All data expressed in Canadian dollars for a Canadian reader

2. Time frame: 3 years

3. Year 1 to be completed on a monthly basis

4. Years 2 and 3 to be completed on a monthly basis

5. Extensive footnotes required to explain how numbers were derived

6. Recommend completion of documents on excel and then cut and paste to a word file and submit all documents. These documents, once complete, will be included in the appendix of your final business plan.

7. Documents to be completed:

FIRST WEEK

1. Sales Forecast (for three years)

2. Cash flow Projections (for three years)

3. Income Statement (Profit and Loss Account) (Assume a 20% tax rate when calculating Net Income) (3 Income Statements Years 1,2,3)

4. Balance Sheet (4 balance sheets: Years 0,1,2,3)

SECOND WEEK

5. Break even Analysis (when will your business breakeven. Show calculation)

6. Estimating Financing Requirements (this may or may not be relevant depending on whether you have adequate capital)

7. Stress Testing Business Projections (+/- 10% and +/- worst case scenario)

8. Financial Controls (who and how)

9. Business Ratios relevant for your business and industry (What are the five most important ratios for your business and show calculations)

10. Sales and Marketing Controls (what could go wrong and how will you protect the company)

11. Other business controls (eg. Inventory control or fx exposure) (what could go wrong and how will you protect the company)

Attachment:- SALES FORECAST.rar

Reference no: EM133370489

Questions Cloud

How should you respond to the client feedback : How should you respond to the client's feedback? How and when should you notify the allied health professional

Corporation relationship with society : Corporation's relationship with society? How does it create value for society? How well does the company interface with its customers and suppliers?

How are common value-based contracts and alternate payment : How are common value-based contracts and alternate payment models designed?

What are the roles of the service coordinator : What was new to you in the video? What fears or concerns did the teachers voice about working with children with special needs? Damon Manning talks

Draft business plan into financial forecasts : Draft business plan into financial forecasts to enable you to determine the likelihood of financial success and to determine what, if any, modifications

What process is to be improved and for whom is the process : What process is to be improved? For whom is the process performed? What products does the process produce? What is not working with the current process?

Stewardship and stakeholder theories of corporate governance : AFIN427-Compare and contrast stewardship theory and stakeholder theories of corporate governance.

Describe the steps in the policy cycle : Describe the steps in the policy cycle. How do risk assessment and risk management inform the environmental health policy cycle? include at least one concrete

How would you apply the strategies for selecting : How would you apply the strategies for selecting or developing materials using the scenario in Community Connections Below: "Bekah works at a county health

Reviews

len3370489

3/24/2023 10:00:57 PM

Hello, this course is "Developing Business Plan". You are to do the Cash flow statement and Income statement only in the excel. These questions are number 2 & 3 in the word document attached. The excel file attached to this assignment is what what will edit. The only thing you need to do is to edit the cash flow statement and income statement on the excel, but check the sales forecast data, to make sure it matches with the others. N.B: Sales Forecast data have been edited by me already, what you just have to do is to edit the data for cash flow statement and income statement. Please let me know if you have any question, thanks.

Write a Review

Required(*) Message

User Account

All Pages