build a cash flow (both write-up and spreadsheet) for a project/investment in assets based on real case/observed case/own case. Write-up must be cut and paste to excel. The following are the requirements:

1. Please ensure the figures are as real as possible based on research. You can provide evidence of your research (if possible)

2. Initial cost/ Investment (CF0)

3. Net working capital (year 0 and recovery period only)

4. Inflation - cost analysis (VC and FC)

5. Depreciation on asset(s) - straight line to zero or straight line to salvage value method

6. Salvage Value and tax gain/loss

7. Estimation of cost of capital - Pure play method is acceptable but with evidence

8. Estimate NPV and IRR

9. Conduct NPV sensitivity analysis - Select on two variables with high uncertainty. Run sensitivity analysis one at a time and through the analysis, establish which variables are more critical and most likely affect the final decision on this project.