Project values using CAGR in time intervals

[viltxes14]

Hi, 

I wonder if anybody can help with me this one. I´m trying to obtain a table of projected values using the last available value by country and multiplying it by a CAGR I have in another table by region with intervals of time. My tables look like this: 

Table 1: 

Country: USA, Spain, ...

Year: 2010, 2011,...

Value: 100, 200, ...

Table 2: 

Region: America, Europe, ...

CAGR: 2%, 1%, ...

CAGR start date: 01/01/2020, 01/01/2026,...

CAGR end date: 31/12/2025, 31/12/2030,...

The result I need is a table country and year that uses last value available from the other table and the CAGR in the intervals and projects a yearly value for the future and keeps the available for the past years. 

Seems quite tough for me! any hints?

thanks a lot!!!

[viltxes14]

Nobody can help? thanks!