I want to ask what is the formula of the simple value index? (2016)
Year Net Asset Value (NAV)
2016: 8.73
2017: 9.01
2018: 7.85
2019: 8.55
2020: 9.52
2021: 9.94
(By using year 2016 as the base period, calculate the simple value index of NAV for years 2016 to 2021.)
This article answers your question, and gives examples.
www.mssqltips.com/sqlservertip/6753/simple-index-weight-index-examples-r/
Thank you!
To calculate the simple value index for NAV from 2016 to 2021, you will use the following formula:
Simple Value Index = (NAV of specific year / Base period NAV) * 100
In this case, the base period is the year 2016, and the NAV for 2016 is given as 8.73.
To calculate the simple value index for each year from 2016 to 2021, follow these steps:
1. Calculate the simple value index for each year using the formula above.
- For 2016: (8.73 / 8.73) * 100 = 100
- For 2017: (9.01 / 8.73) * 100 = 103.20
- For 2018: (7.85 / 8.73) * 100 = 89.82
- For 2019: (8.55 / 8.73) * 100 = 97.94
- For 2020: (9.52 / 8.73) * 100 = 109.12
- For 2021: (9.94 / 8.73) * 100 = 113.84
So, the simple value index for each year from 2016 to 2021 would be:
2016: 100
2017: 103.20
2018: 89.82
2019: 97.94
2020: 109.12
2021: 113.84