02-09-2019, 05:46 PM
Hi Antti,
The COST/LEVCOST labels issue was my misunderstanding – I didn’t realise the information was included only in TIME_NPV.
I think I understand the results output now. 2012 is defined as a single-year period so the 2012 vintage all takes place in 2012. The final year is 2023, which does not cover the milestone year of the 2023–2027.
2015, on the other hand, is the milestone year of a 5-year period from 2013–2017. Investment follows case 1.a so takes place over 5 years from 2011 to 2015. In 2025, the milestone year of the 2023–2027 period, 40% of the original investment is repaid, which I think is why the Cost_Fom output is 40% of the Cost_Fom outputs in the previous periods.
I've attached an updated workbook with a few fixes to avoid confusion, in case people are interested in the calculation.
The COST/LEVCOST labels issue was my misunderstanding – I didn’t realise the information was included only in TIME_NPV.
I think I understand the results output now. 2012 is defined as a single-year period so the 2012 vintage all takes place in 2012. The final year is 2023, which does not cover the milestone year of the 2023–2027.
2015, on the other hand, is the milestone year of a 5-year period from 2013–2017. Investment follows case 1.a so takes place over 5 years from 2011 to 2015. In 2025, the milestone year of the 2023–2027 period, 40% of the original investment is repaid, which I think is why the Cost_Fom output is 40% of the Cost_Fom outputs in the previous periods.
I've attached an updated workbook with a few fixes to avoid confusion, in case people are interested in the calculation.