1. Select any NZX Listed Company
2. The company needs to make an Investment case of $100 Million for investment start date of 1 April 2014
3. Use 31 March 2014 actuals as your Period 0 or opening balance
4. Assume your additional business case starts 1 April 2014, i.e. Year 1 ending 31 March 2015
Provide a business report covering the following:
1. Introduction of the business case for $100 Million
2. Do a SWOT analysis of your business case
3. Do a PESTEL analysis of your business case
4. Financial Model covering the following worksheets as a minimum:
a. Assumptions
b. Revenue
c. Cost of Goods Sold
d. Salaries
e. Other Expenses
f. Interest and Repayment Schedule
g. Fixed Assets Schedule
h. Cost of Project
i. Working Capital Requirements
j. Income Statement
k. Balance Sheet
l. Cash Flow Statement
m. Relevant ratios and analysis
5. Provide all your assumptions clearly in the Excel workbook in a separate excel sheet
6. No word limit