Here is my table table name is "loan"

```
ID(int)        Loan Amount(Decimal)        Initial Amount(decimal)            Interest(Decimal)

1                   100000                       0                               5

2                   230000                       0                               10

3                   150000                       0                               2

```

I want to update all the value in "Initial Amount" column. I will add the result of (loan amount x interest rate)

Example Computation

```
100,000 x .05% = 5,000

```

then the value of 5,000 will update to "inital amount"