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