The objective is to complete the predicted values of Asset A$,$ B$,$ and C over $10$ years. Each asset has its own growth rate measured in percentages $($shown in red$).$ The starting balance of each asset is shown in blue. The value of an asset for each year is calculated as below:

Value$\_$Year$1=$ Starting Balance $*(1+$ Growth Rate$)$

Value$\_$Year$2=$ Value$\_$Year$1*(1+$ Growth Rate$)$

$...$

Value$\_$Year$10=$ Value$\_$Year$9*(1+$ Growth Rate$)$

Using appropriate reference type$($s$)($relative$,$ absolute$,$ and mixed$),$ calculate the values of each asset for all $10$ years. Note that you should write only one formula, which will be in cell D$5,$ then, by extrapolating that formula to the right and down, all values will be calculated automatically.