basis of calculation increase progressively

Dear Stata users,

I want to forecast demand of labor from 2019 to 2050. The basic formula is E_t = E_t-1*(1 + elastic*gdpgr/100), here E_t is employment total number, E_t-1 is employment total number of last year, elastic is empoyment elastic, gdpgr is GDP growth rate. So ΔE_t=E_t - E_t-1. For example, demand of labor in 2019 is E₂₀₁₉ = 6180.6*(1+0.093*0.068) = 6219.686, and incoming employment is ΔE₂₀₁₉ = 6219.686 - 6180.6 = 39.086. Now I want to apply this formula up to 2050 automatically. Can anyone provide me a solution. Thank you.

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input int year float(employment elastic gdpgr)
2018 6180.6 .093 6.8
2019      . .093 6.8
2020      . .093 6.8
2021      . .093 6.8
2022      . .093 6.8
2023      . .093 6.8
2024      . .093 6.8
2025      . .093 6.5
2026      . .093 6.5
2027      . .093 6.5
2028      . .093 6.5
2029      . .093 6.5
2030      . .093 6.3
2031      . .093 6.3
2032      . .093 6.3
2033      . .093 6.3
2034      . .093 6.3
2035      . .093   6
2036      . .093   6
2037      . .093   6
2038      . .093   6
2039      . .093   6
2040      . .093   6
2041      . .093   6
2042      . .093   6
2043      . .093   6
2044      . .093   6
2045      . .093   6
2046      . .093   6
2047      . .093   6
2048      . .093   6
2049      . .093   6
2050      . .093   6
end

Share on FacebookPlus on Google+