Column headers are to be year numbers beginning at Project commitment to SUT. Spreadsheet cash flows over any year can be modeled as being at the end of the year. All costs are to be shown in $x1000 and with zero decimal places. All Costs in these instructions are in $ millions ($m). The land for the facility is owned by the company, is immediately available, and valued at $0.8m. It is estimated that the project for design, procurement, construction and commissioning will cost $8.0 million and take three years. Cashflow for the Project is 20% in year 1, 60% year 2 & 20% in year 3. There will be an additional payment of $0.4m to SUT for the patents, payable at the start of the project plus 2% of the revenue from e-waste sales. The operation of the plant will cost $0.24m per year. A preventative maintenance program will cost $0.12m per year and every 4 years the facility will require a major refurbishment costing $1.3m. The facility is expected to operate for 12 years, after which new technology will make the facility obsolete and it will be recycled and the land remediated and returned to the company at a net valuation of $0.5m. The facility will generate a revenue of $3.5m pa except for the first year at 80% of a full year. All values given here are at current costings in $ million and the financial model is to be by year number The company's current standards for LCC analysis are as follows: Escalation of construction and refurbishment costs for this facility, 4.5% pa Escalation of Operating and maintenance costs (including land value), 3% pa Escalation of Revenue from this facility, 2% pa Nominal weighted average cost of company financing and shareholder returns, 16.8% pa. . Column headers are to be year numbers beginning at Project commitment to SUT. Spreadsheet cash flows over any year can be modeled as being at the end of the year. All costs are to be shown in $x1000 and with zero decimal places. All Costs in these instructions are in $ millions ($m). The land for the facility is owned by the company, is immediately available, and valued at $0.8m. It is estimated that the project for design, procurement, construction and commissioning will cost $8.0 million and take three years. Cashflow for the Project is 20% in year 1, 60% year 2 & 20% in year 3. There will be an additional payment of $0.4m to SUT for the patents, payable at the start of the project plus 2% of the revenue from e-waste sales. The operation of the plant will cost $0.24m per year. A preventative maintenance program will cost $0.12m per year and every 4 years the facility will require a major refurbishment costing $1.3m. The facility is expected to operate for 12 years, after which new technology will make the facility obsolete and it will be recycled and the land remediated and returned to the company at a net valuation of $0.5m. The facility will generate a revenue of $3.5m pa except for the first year at 80% of a full year. All values given here are at current costings in $ million and the financial model is to be by year number The company's current standards for LCC analysis are as follows: Escalation of construction and refurbishment costs for this facility, 4.5% pa Escalation of Operating and maintenance costs (including land value), 3% pa Escalation of Revenue from this facility, 2% pa Nominal weighted average cost of company financing and shareholder returns, 16.8% pa
