| year | | | | | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| relevant benefits | | | | | | | | (millions) |
| Reduced costs of capital | | | | | $0 | $2 | $2 | $3 | $3 | $4 | $5 |
| Improved productivity | | | | | $0 | $1 | $3 | $3 | $7 | $10 | $11 |
| Reduced insurance | | | | | $0 | $1 | $2 | $3 | $4 | $5 | $6 |
| Total improvements from BYOD (A) | | | | | $0 | $4 | $7 | $9 | $14 | $19 | $22 |
| Relevant costs |
| | policy development and maintenance | | | | $0 | $6 | $6 | $6 | $6 | $6 | $7 |
| | software acquisition | | | | $5 | $2 | $2 | $1 | $1 | $1 | $1 |
| | BYOD support team | | | | $5 | $1 | $1 | $1 | $1 | $1 | $1 |
| | incremental maintenance | | | | $0 | $0 | $1 | $1 | $1 | $1 | $1 |
| | training | | | | $0 | $0 | $1 | $0 | $0 | $0 | $0 |
| Total costs (B) | | | | | $10 | $9 | $10 | $8 | $8 | $8 | $9 |
| cash flow | | | | | -$10 | -$5 | -$3 | $1 | $6 | $11 | $13 |
| use the cost and benefit items to compute the NPV, ROI etc. and (b) identify the “three specific scenarios” for the sensitivity analysis. |
desg
global_excel_spreadsheet_samples.xlsx
