Replace the formula in B6 with:

Formula: copy to clipboard
=(B4*6%*900)*(1+B5)


Copy across to C6:G6

You can follow the same principle for the varying formulae in rows 7:10.