Query on developing table and chart automatically

Hello,
Please guide me how to develop a table & chart automatically based on the below input data.

I am able to develop table and chart manually for the set value , but incase user changes the input value then table and chart should also change as per
the set number of years.

INPUT DATA:

A B

1 years 10

2 starting value 1000$

3 Interest rate 10%

I am looking for output as per below screenshot , kindly guide.




excel file https://files.fm/u/qqdbg58b